//mysql:
String sql = "select * from students order by id limit " + pageSize*(pageNumber-1) + "," + pageSize;
//oracle:
String sql ="select * from " +
“ (select * from (select * from students order by postime desc) where rownum<=" + pagesize*pagenumber + ") as t" +
"where rownum>" + pageSize*(pageNumber-1);
pageSize:每页总数
pageNumber:当前页数