JavaでOracleのストアドプロシージャを実行
ソース抜粋
Connection con = null;
CallableStatement cs = null;
Class.forName ("oracle.jdbc.driver.OracleDriver");
try {
con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.20.22:1521:kokusei", "watanabe", "watanabe");
cs = con.prepareCall("call BOOKS_LEARNING.CALC_BOOKS_PRICE(?, ?, ?)");
cs.setString(1, "000000");
cs.registerOutParameter(2, java.sql.Types.INTEGER);
cs.registerOutParameter(3, java.sql.Types.INTEGER);
cs.execute();
sum = cs.getInt(2);
result = cs.getInt(3);
System.out.println(id + ":" + sum + "\t" + result);
cs.close();
con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}