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);