Question

hibernate 分页

怎样实现hibernate 分页

Answer 1

public class Test extends HibernateDaoSupport
{
public List listByID(final String id) {
return getHibernateTemplate().executeFind(new HibernateCallback() {
public Object doInHibernate(Session s) throws HibernateException, SQLException {
Query query = s.createQuery(“from TScheduleTemplate where id = ?”);

query.setString(0, id);
return query.list();
}
});
}

}

加个回调方法

Answer 2

我写个大概给你仅供参考：
int page=1; //显示的页数
int pageSize =5；//每页显示的个数
Transaction ts = session.beginTransaction();
Query query =session.createQuery("from user order by id");
query.setFirstResult(（page*pageSize-pageSize））；
query.setMaxResults(page);
List list=query.list();
ts.commit();