Oracle_MySQL_SQLServer_JDBC分页

create procedure insert_user (out pid int,pname varchar(25))
begin
insert into user values(pid, name);
select max(id) into pid from user;
end;

Oracle:分页
select user.* from (select user.*, rownum t where t<10) where t > 5;

Sql分页
select top pageSize * from user where id not in (select top(pageNo-1) * pageSize  id from user order by id ) order by id;

Mysql分页
select * from user limit 2, 2;

jdbc分页
if(cn.getMetaData().supportsResultSet(TypResultSet.TYPE_SCROLL_INSENSITIVE))//判断该数据产品是否支持动态游标
{
rs.absolute(pageSize* pageNo); //设置从第几个开始
}else
{
for(i=0;i<pageSize* pageNo;i++) rs.next();//不支持，就一个一个的向下移动游标
}
for(int i=0;i<5 && rs.next();i++)
{
rs.getString("a");//获所要取得的分页数据
}