mysql:
String sql = "select * from students 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<=" + pagesizepagenumber +”) as t" +
“where t>” +pageSize(pageNumber-1);*