分 页

Oracle分页
处理当前页的开始记录数字和结束记录数字
curPage:当前页
pageSize:每页几条数据
String begin = pageSize*(curPage-1)+1;
String end = pageSize*curPage;
String sql = "select * from table order by time desc";
SELECT * FROM (SELECT A.*, rownum r FROM (sql) A WHERE rownum <= end) B WHERE r >begin


MySql分页
从第1条往后数5条
第一个参数为从第几条开始,第二个参数为每页显示每页的条数
select * from dept order by deptno desc limit 0,5;