萬盛學電腦網

 萬盛學電腦網 >> 數據庫 >> oracle教程 >> java讀取oracle的存儲過程

java讀取oracle的存儲過程

oracle的PLSQL

CREATE OR REPLACE package chapter_13 as
TYPE rs IS REF CURSOR ;
procedure founder(oFields out rs);
end;
CREATE OR REPLACE package body chapter_13 as
PROCEDURE founder(oFields out rs) IS
BEGIN
 open oFields for
  select * from person;
END founder;
end;
java代碼
package jdbc;
import java.io.*;
import java.sql.*;
import java.text.*;
import oracle.jdbc.OracleTypes;
public class TestStoredProcedures {
  Connection conn;
  public TestStoredProcedures() {
    try {
      DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
      conn = DriverManager.getConnection(
          "jdbc:oracle:thin:@localhost:1521:orcl", "jola", "jola");
    } catch (SQLException e) {
      System.err.println(e.getMessage());
      e.printStackTrace();
    }
  }
  public static void main(String[] args) throws Exception {
    new TestStoredProcedures().process();
  }
  public void process() throws SQLException {
   
    long start = 0;
    long end = 0;
    CallableStatement cstmt = null;
    try {
      start = System.currentTimeMillis();
      // *** SQL92 escape syntax ***
     
      cstmt = conn.prepareCall(
          "{call chapter_13.founder(?)}");
      cstmt.registerOutParameter(1, OracleTypes.CURSOR);
      ResultSet rs = null;
      cstmt.execute();
       rs = (ResultSet)cstmt.getObject(1);
      while (rs.next()) {
        System.out.println(rs.getString("NAME"));
      }
      rs.close();
      end = System.currentTimeMillis();
      System.out.println("Average elapsed time = " +
                (end - start) / 8 + " milliseconds");
    } catch (SQLException e) {
      System.err.println("SQL Error: " + e.getMessage());
    } finally {
      if (cstmt != null) {
        try {
          cstmt.close();
        } catch (SQLException ignore) {}
      }
    }
  }
  protected void finalize() throws Throwable {
    if (conn != null) {
      try {
        conn.close();
      } catch (SQLException ignore) {}
    }
    super.finalize();
  }
}

copyright © 萬盛學電腦網 all rights reserved