刚开始我是这样写的:
- List all = null;
- String hql = "From Announce AS an ORDER BY an.antime DESC LIMIT 5";
- Query q = super.getSession().createQuery(hql);
- all = q.list();
- return all;
发现不行,后来在csdn上查了以下,改用以下方法:
- public List queryOrderByTime() throws Exception {
- List all = null;
- String hql = "From Announce AS an ORDER BY an.antime DESC";
- Query q = super.getSession().createQuery(hql);
- q.setFirstResult(1);
- q.setMaxResults(4);
- all = q.list();
- return all;
- }
可以了,呵呵!