hibernate mysql 倒序排列 并分页(取前n条记录)

在User表中找出最后五条记录

sql正序排列:

select * from user order by id;

sql倒序排列:

select * from user order by id desc;

sql正序排列并取前五条:

select * from user order by id limit 0,5;

其中limit 0，5代表从第1条开始，共取5条。

sql倒序排列并取前五条:

select * from user order by desc id limit 0,5;

其中limit 0，5代表从第1条开始，共取5条。

hql正序排列:

from User order by id;

hql倒序排列:

from User order by id desc;

hql倒序排列并取前五条:

Query query = session.createQuery("from User order by id desc");

query.setFirstResult(0);

query.setMaxResults(5);

List list = query.list();