MYSQL使用的是limit
语句为:String sql = "SELECT * FROM student LIMIT "+(currentPage-1)*pageSize+", "+pageSize;
SQL Sever使用的是 not in
String sql=select top (@pagesize) * from student
where id
not in(
select top
(@pagesize*(@currentPage-1))
id
from student )
其中id 不必是自增序列的