hibernate hql分页查询语句
- 作者: 浪荡子17752709
- 来源: 51数据库
- 2020-10-22
差不多就这样
/** 分页装载指定类的所有持久化对象 */
public List listAll(String clazz, int pageNo, int pageSize) {
final int pNo = pageNo;
final int pSize = pageSize;
final String hql = "from "+clazz+ " as a order by a.id desc";
List list = getHibernateTemplate().executeFind(new HibernateCallback(){
public Object doInHibernate(Session session) throws HibernateException{
Query query = session.createQuery(hql);
query.setMaxResults(pSize);
query.setFirstResult((pNo-1)*pSize);
List result = query.list();
if (!Hibernate.isInitialized(result))Hibernate.initialize(result);
return result;
}
});
return list;
}
/** 分页装载指定类的所有持久化对象 */
public List listAll(String clazz, int pageNo, int pageSize) {
final int pNo = pageNo;
final int pSize = pageSize;
final String hql = "from "+clazz+ " as a order by a.id desc";
List list = getHibernateTemplate().executeFind(new HibernateCallback(){
public Object doInHibernate(Session session) throws HibernateException{
Query query = session.createQuery(hql);
query.setMaxResults(pSize);
query.setFirstResult((pNo-1)*pSize);
List result = query.list();
if (!Hibernate.isInitialized(result))Hibernate.initialize(result);
return result;
}
});
return list;
}
推荐阅读
