大数据量下的分页解决办法

mysql:

String sql = "select * fromstudents order by id limit " + pageSize*(pageNumber-1) + ","
+pageSize;

oracle:

String sql = "select * from " +
(select *,rownum rid from (select * fromstudents order by postime desc) where
rid<=" + pagesize*pagenumber +") as t" +
"where t>" +pageSize*(pageNumber-1);