java读取oracle的存储过程
来源:互联网 发布:金融大数据服务平台 编辑:程序博客网 时间:2024/05/16 06:06
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();
}
}
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();
}
}
- java读取oracle的存储过程
- java读取oracle的存储过程
- java读取oracle的存储过程
- java读取oracle的存储过程
- 用oracle的java存储过程实现BLOB字段的字符串读取
- mybatis调用oracle存储过程返回游标 读取到java的List<Map>
- 使用存储过程读取Oracle中的clob字段的数据
- 通过游标读取oracle存储过程返回的结果集
- oracle java存储过程
- Java调用Oracle的存储过程(实例)
- java 调用oracle的存储过程
- java调用oracle存储过程的方法
- java调用oracle的存储过程
- java调用oracle的存储过程
- JAVA调用oracle的存储过程
- Java调用Oracle的分页存储过程
- java调用oracle的存储过程
- java调用Oracle数据库的存储过程
- C#基础技巧--字符串处理函数
- POJ 1032 数字分析
- 如何调用远程web service
- 由.Net类库提供的农历计算(C#农历)
- 分享一下学习Oracle的经验
- java读取oracle的存储过程
- C 二进制输出 移位 改变某个位为0
- 毕业感想
- GCC使用指南
- 用curl就能知道当前的天气情况
- 收件箱里创建一条新的未读短信的操作
- datagridview (三)DataGridViewComboBoxColumn 列或者DataGridViewComboBoxCell 赋值绑定数据的方法
- cuil:吹牛营销大师
- 兰德公司认为中国的教育是失败的[zt]