Use hql statements

1. the query result is part of the table field, not all

• Ad is a couponad object
• Coupon is an attribute of AD and also an entity class.

Select ad. Coupon from couponad ad where ad. Deleted = false order by createddate DESC

2. Like Fuzzy search

Here, the variable key is of the string type.

        String hql = "from Coupon coupon  where coupon.deleted=false and  coupon.name like :key";        Map<String, Object> map = new HashMap<>();        map.put("key", ‘%‘ + key + ‘%‘);        List<T> list = list(hql, firstResult, maxResults, map);

3. Total number of queries

    public int getTotalCountByStore(int storeid) {        Map<String, Object> map = new HashMap<>();        map.put("storeid", storeid);        return getTotalCount(                "select count(*) from Coupon coupon where coupon.store.id=:storeid",                map);    }

 

Done!