} catch (Exception ex2) {
  String password = "xmgl";
   Class.forName(driver);
   int pageCount = cs.getInt(5);
import java.sql.DriverManager;
     }
   System.out.println("rowNum="+rowNum);
      conn.close();
     if (stmt != null) {
  String username = "xmgl";
   //取出总记录数 /这里要注意，getInt(4)中4，是由该参数的位置决定的
   }
   cs.setInt(3, 1);//第几页

import java.sql.Statement;

   int rowNum=cs.getInt(4);//获得输出参数
   ex2.printStackTrace();
  try {
   } catch (SQLException ex1) {
     if (conn != null) {
      stmt.close();
   cs.registerOutParameter(4,oracle.jdbc.OracleTypes.INTEGER);
import java.sql.SQLException;
public class TestPage {
 }
   try {
   System.out.println("总页数="+pageCount);

  } catch (SQLException ex2) {
   //注册总记录数,声明输出参数是什么类型的
   cs.registerOutParameter(6,oracle.jdbc.OracleTypes.CURSOR);
    }
  Statement stmt = null;
   }
import java.sql.CallableStatement;
}
    System.out.println("编号："+rs.getInt(1)+" 名字："+rs.getString(2)+" 密码："+rs.getString(3));
   cs.registerOutParameter(5,oracle.jdbc.OracleTypes.INTEGER);
import java.sql.ResultSet;
   conn = DriverManager.getConnection(strUrl, username, password);
  }
   //创建CallableStatement
   CallableStatement cs = null;

复制代码 代码如下:

    if (rs != null) {
   cs.setString(1, "mytest");//表名
   //注册返回的结果集
 public static void main(String[] args) {
   rs=(ResultSet)cs.getObject(6);
     }

  ResultSet rs = null;
   cs.execute();
   //注册总页数
   cs = conn.prepareCall("{call page.fenye(?,?,?,?,?,?)}");
 }
   while (rs.next()) {
  } finally {
   System.out.println("ok");
import java.sql.Connection;
  Connection conn = null;
   ex2.printStackTrace();
 public TestPage() {
     rs.close();
  String driver = "oracle.jdbc.driver.OracleDriver";
  String strUrl = "jdbc:oracle:thin:@localhost:1521:xmgl";
   cs.setInt(2, 3);//显示几条记录