Question

java中怎么调用oracle存储过程

Answer 1

楼主您好
建议百度搜索“CallableStatement的用法”
贴个demo代码

Connection connection =
DriverManager.getConnection(url,username,password);
String procedure = “{ ? = call myProc(?,?)}”;
CallableStatement statement =
connection.prepareCall(procedure);
statement.setString(2,×××);
statement.setFloat(3,×××);
statement.registerOutParameter(1,Types.INTEGER);
statement.execute();
int row = statement.getInt(1);