本文深入探讨了数据库分页在MySQL、Oracle和Hibernate中的实现方式，包括如何使用LIMIT、ROWNUM和分页Query进行高效数据检索。
1. 数据库分页：
mysql:
select * from A limit startRow,endRow
oracle:
select b.* from (select a.*,rownum as linenum from (select * from A) a where rownum<= endRow) b where linenum >= startRow
Hibernate分页
Query q = session.createQuery("from Cat as c");;
q.setFirstResult(20000);;
q.setMaxResults(100);;
List l = q.list();;
mysql:
select * from A limit startRow,endRow
oracle:
select b.* from (select a.*,rownum as linenum from (select * from A) a where rownum<= endRow) b where linenum >= startRow
Hibernate分页
Query q = session.createQuery("from Cat as c");;
q.setFirstResult(20000);;
q.setMaxResults(100);;
List l = q.list();;
扫一扫
5999
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
