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");//获所要取得的分页数据
}
Oracle_MySQL_SQLServer_JDBC分页
最新推荐文章于 2021-03-28 02:41:49 发布