JAvaはoracleストレージ・プロシージャを呼び出し、結果セットを返します.
3837 ワード
package com.srie.db.pro;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
public class CallPro {
public static void main(String[] args) {
Connection conn = null;
try {
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url = "jdbc:oracle:thin:@aaa";
String user = "a";
String password = "a";
conn = DriverManager.getConnection(url, user, password);
String sql = "{call pro_getchart(?)}";
CallableStatement statement = conn.prepareCall(sql);
statement.registerOutParameter(1, oracle.jdbc.OracleTypes.CURSOR);
statement.execute();
ResultSet rs = null;
// 1:
//rs = ((oracle.jdbc.OracleCallableStatement) statement).getCursor(1);
// 2:
rs = (ResultSet) statement.getObject(1);
while (rs.next()) {
System.out.println(rs.getString(1));
}
conn.close();
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (conn != null && !conn.isClosed()) {
conn.close();
}
} catch (Exception e2) {
e2.printStackTrace();
}
}
}
}
方法1:
http://www.2cto.com/kf/201109/105741.html
方法2:
http://www.cnblogs.com/icerainsoft/archive/2011/08/24/2152381.html
コンテンツが検証されていません:
http://blog.csdn.net/baykermr/article/details/4664268