分页技术:
需要用到四个变量,它们有各自的用处:
Int pageSize: 每页显示多少条记录
Int pageNow:希望显示每几页
Int pageCount: 一共有多少页
Int rowCount: 一共有多少条记录
说明:
pageSize 是指定的pageNew用户选择的; rowCount是从表中查询得到的;
if(rowCount%pageSize==0)
pageCount=rowCount/pageSize;
else
pageCount=rowCount/pageSize+1;
针对前面的问题可以用:
Mysql:
SELECT * FROM table WHERE id NOT IN (
SELECT t.id FROM (
SELECT * FROM table LIMIT pageSize*(pageNow-1)
) AS t
)
LIMIT pageSize
// select * from table where id in (select t.id from (select * from table limit 10)as t)
或者Oracle:
Select top pageSize * from table where id not in (select top pageSize*(pageNow-1) id from table);