Java调用Oracle的分页存储过程

create or replace procedure pro(      v_in_table_name in varchar2,--表名      v_in_page_size in number,--每页大小      v_in_page_now in number,--当前页      v_out_page_count out number,--页数      v_out_row_count out number,--记录数      v_out_result_set out pkg.page_cursor--结果集    ) is      v_sql_stmt varchar2(2000);      v_start_index number :=v_in_page_size*(v_in_page_now-1)+1;--起始位置      v_end_index number :=v_in_page_size*v_in_page_now;--结束位置    begin      v_sql_stmt:='select * from (select t.*, rownum rn from (select * from '||v_in_table_name||') t where rownum<='||v_end_index||') where rn>='||v_start_index;      open v_out_result_set for v_sql_stmt;--打开游标      v_sql_stmt:='select count(*) from '||v_in_table_name;      execute immediate v_sql_stmt into v_out_row_count;--查询出记录数      --计算页数      if mod(v_out_row_count,v_in_page_size)=0 then        v_out_page_count:=v_out_row_count/v_in_page_size;      else        v_out_page_count:=v_out_row_count/v_in_page_size+1;      end if;  end;

package com.wujilin.procedure;    import java.sql.CallableStatement;  import java.sql.Connection;  import java.sql.DriverManager;  import java.sql.ResultSet;  import java.sql.ResultSetMetaData;    public class ProcedureTest {   public static void main(String[] args) {    String url = "jdbc:oracle:thin:@127.0.0.1:1521:orcl";    String username = "scott";    String password = "tiger";    String driver = "oracle.jdbc.driver.OracleDriver";        try {     Class.forName(driver);     Connection conn = DriverManager.getConnection(url, username, password);     String sql = "{call pro(?,?,?,?,?,?)}";     CallableStatement cstmt = conn.prepareCall(sql);     // 设置表名     cstmt.setString(1, "emp");     // 设置每一页的记录数     cstmt.setInt(2, 4);     // 设置当前页     cstmt.setInt(3, 2);     // 注册总共的页数     cstmt.registerOutParameter(4, oracle.jdbc.OracleTypes.INTEGER);     // 注册总共的记录数     cstmt.registerOutParameter(5, oracle.jdbc.OracleTypes.INTEGER);     // 注册结果集     cstmt.registerOutParameter(6, oracle.jdbc.OracleTypes.CURSOR);     // 直接执行：execute()方法即可。     cstmt.execute();     // 将游标强制转换成ResultSet类型。     ResultSet rs = (ResultSet) cstmt.getObject(6);     int pageCount = cstmt.getInt(4);     System.out.println("页数：" + pageCount);     int rowCount = cstmt.getInt(5);     System.out.println("记录数：" + rowCount);     ResultSetMetaData rsmd = rs.getMetaData();     while (rs.next()) {      for (int i = 0; i < rsmd.getColumnCount(); i++) {       System.out.print(rsmd.getColumnLabel(i + 1) + ":" + rs.getObject(i + 1) + ", ");      }      System.out.println();     }    } catch (Exception e) {         }   }  }