Posted on 2010-09-26 17:18
asdtiang 閱讀(475)
評論(0) 編輯 收藏 所屬分類:
數(shù)據(jù)庫
create or replace procedure s_get_all_point
(
ref_cursor out sys_refcursor
)as
begin
open ref_cursor for
select * from gwxx_t;
end;
try {
DriverManager.registerDriver (new oracle.jdbc.OracleDriver());
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "@@@@", "@@@@");
// CallableStatement stmt = conn.prepareCall("BEGIN s_get_all_point(?); END;");
CallableStatement stmt = conn.prepareCall("{ call s_get_all_point(?) }");////這名執(zhí)行速度要快點
stmt.registerOutParameter(1, oracle.jdbc.OracleTypes.CURSOR); //REF CURSOR(OracleTypes.CURSOR==-10)
stmt.execute();
ResultSet rs = (ResultSet) stmt.getObject(1);
while (rs.next()) {
System.out.println(rs.getString("gwbh"));
}
rs.close();
rs = null;
stmt.close();
stmt = null;
conn.close();
conn = null;
}
catch (SQLException e) {
System.out.println(e.getLocalizedMessage());
}
天蒼蒼，野茫茫，風(fēng)吹草底見牛羊