java读取oracle的存储过程
来源:互联网 发布:淘宝活动报名表格 编辑:程序博客网 时间:2024/05/29 17:07
- SQL代码
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;
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;
2. 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();
}
}
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数据库的存储过程
- 使窗体尺寸最小
- Windows XP 下使用IIS5.1
- 制作没有边框的窗体,并可移动
- How to use XY chart of JFreeChart? Or any other choice?!
- 子窗体TChild嵌入应用
- java读取oracle的存储过程
- window下用命令创建共享连接
- 什么是CDN,大型门户网站的cdn部署
- 读取txt.sql
- 需求分析的20条法则 (ZT)
- ASP.NET-GridView的分页功能
- 安全应急响应流程
- 岁月悠悠
- sql server 2000 复制