java读取oracle的存储过程_Oracle数据库_黑客防线网安服务器维护基地--Powered by WWW.RONGSEN.COM.CN

java读取oracle的存储过程

作者:黑客防线网安Oracle维护基地 来源:黑客防线网安Oracle维护基地 浏览次数:0

黑客防线网安网讯:oracle的PLSQLCREATE OR REPLACE package chapter_13 asTYPE rs IS REF CURSOR ;procedure founder(oFields out rs);end;CREATE OR REPLACE package body chapter_13 asPROCEDURE founder(o...

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();
  }
}

    黑客防线网安服务器维护方案本篇连接:http://www.rongsen.com.cn/show-12805-1.html
网站维护教程更新时间:2012-03-23 00:46:13  【打印此页】  【关闭
我要申请本站N点 | 黑客防线官网 |  
专业服务器维护及网站维护手工安全搭建环境,网站安全加固服务。黑客防线网安服务器维护基地招商进行中!QQ:29769479

footer  footer  footer  footer