sql 、 hibernate分页

拿来主义

sql:

引用

1.Oracle: 
select * from ( select row_.*, rownum rownum_ from ( query_SQL ); row_ where 

rownum =< max); where rownum_ >= min 

2.SQL Server: 
select top @pagesize * from tablename where id not in 
(select top @pagesize*(@page-1); id 
from tablename order by id); order by id 

3.MySQL 
select * from tablename limit position, counter 

4.DB2 
select * from (select *,rownumber(); as ROW_NEXT from tablename); where 

ROW_NEXT between min and max 

hibernate:

http://forum.hibernate.org.cn/viewtopic.php?t=14657&postdays=0&postorder=asc&start=0