Oracle 存储过程调用 返回结果集 实现分页

java 代码

/*参数：1-返回总条数，2-返回查询结果集，3-开始位置，4-结束位置*/
CallableStatement pc = conn.prepareCall("{call userpro(?,?,?,?)}");
			
pc.registerOutParameter(1, Types.INTEGER);
pc.registerOutParameter(2, OracleTypes.CURSOR);
pc.setInt(4, 5);
pc.setInt(3, 10);
pc.execute();
			
System.out.println(pc.getInt(1));
			
ResultSet rs = (ResultSet)pc.getObject(2);
while(rs.next()) {
	do something...
}

存储过程

create or replace package FuxjPackage is type FuxjResultSet is ref cursor;
end;

create or replace procedure userpro(allpage out number,alluser out FuxjPackage.FuxjResultSet,startNO in number,stopNO in number)
as
begin
select count(*) into allpage from usermess;
open alluser for
select * from (select rownum rn, usermess.* from usermess where rownum<=stopNO) where rn>startNO;
end userpro;