Java调用Oracle存储过程实现分页功能

–java调用jdbc:oracle链接Oracle数据库存储过程实现分页 功能–建立一个包create or replace package testpackage astype test_cursor is ref cursor;end testpackage;
–建立一个分页的存储过程create or replace procedure fenye(tableName in varchar2,Pagesize in number, –一页显示记录数pageNow in number, –当前显示第几页myrows out number, –总记录数myPageCount out number, –总页数p_cursor out testpackage.test_cursor –游标) is–定义部分v_sql varchar2(1000);v_begin number:= (pageNow-1)*Pagesize+1;v_end number := pageNow * Pagesize;begin–执行部分v_sql := 'select * from (select t1.*,rownum rn from (select * from '||tableName||') t1 where rownum<='||v_end||') where="" rn="">='||v_begin;–把游标和sql关联open p_cursor for v_sql;–计算机myrows和myPageCount–组织一个sqlv_sql := 'select count(*) from '|| tableName;–执行sql，把返回值赋值给myrows;execute immediate v_sql into myrows;
–计算myPageCountif mod(myrows,Pagesize) =0 thenmyPageCount:= myrows /pageSize;elsemyPageCount:= myrows/pageSize+1;end if;–关闭游标– close p_cursorend;