来源：网络/责编：编程入门 作者：不详
<script src="http://www.bianceng.cn/js1/468.js"></script>
| <script src="http://www.bianceng.cn/js1/300.js"></script> <script type="text/javascript"><!-- google_ad_client = "pub-1762970342420142"; /* 300x250 */ google_ad_slot = "2904782163"; google_ad_width = 300; google_ad_height = 250; //--> </script> <script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type="text/javascript"> </script> <script src="http://pagead2.googlesyndication.com/pagead/expansion_embed.js"></script> <script src="http://googleads.g.doubleclick.net/pagead/test_domain.js"></script> <script>window.google_render_ad();</script> |
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();
}
}