@Override public int queryTotal(List<RetailStore> rsList) { if (NullCheck.notNullList(rsList)) { List<Integer> l = new ArrayList<Integer>(); for (RetailStore r : rsList) { l.add(r.getId()); } String hql = "select count(*) from " + clazz.getSimpleName() + " where belongs_id in :bid"; return Integer.valueOf( getSession().createQuery(hql).setParameterList("bid", l).list().get(0).toString()); } return 0; }
@Override public List<T> queryDatasList(List<RetailStore> rsList, int current, int nums) { if (NullCheck.notNullList(rsList)) { List<Integer> l = new ArrayList<Integer>(); for (RetailStore r : rsList) { l.add(r.getId()); } String hql = "from " + clazz.getSimpleName() + " where belongs_id in :bid and stat<>8"; return getSession() .createQuery(hql) .setParameterList("bid", l) .setFirstResult((current - 1) * nums) .setMaxResults(nums) .list(); } return null; }