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;