今天用hibernate做了个分页查询,放到博客上,就只当是备忘录吧! :arrow:
final String hql = "select t FROM Table t order by t.saveTime desc";
//pageIndex 当前页,pageSize页显示大小
final int items = (pageIndex-1) * pageSize;
List<Object[]> list = getHibernateTemplate().executeFind(new HibernateCallback() {
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
org.hibernate.Query query = (org.hibernate.Query) session.createQuery(hql);
query.setFirstResult(items);//定义从第几条开始查询
query.setMaxResults(pageSize);//定义返回的记录数
List list = query.list();
return list;
}
});