Hibernate只查询前8条记录

来源:互联网 发布:惰性求值 js 编辑:程序博客网 时间:2024/05/21 07:54
final String hql = "select mail from Mail mail where mail.sjr=:sjr order by mail.beginTime desc";
List<Mail> list = this.getHibernateTemplate().executeFind(
new HibernateCallback() {
@Override
public Object doInHibernate(Session session)
throws HibernateException, SQLException {
Query query = session.createQuery(hql);
query.setString("sjr", sjr);
query.setFirstResult(0);
query.setMaxResults(8);
List<Mail> list = query.list();
return list;
}

});
return list;
0 0