CallableStatement cstmt = null;
String sqlStr = "begin FunctionName( :1, :2,:3,:4, :5,:6 );end;";
cstmt = con.prepareCall(sqlStr);
cstmt.setInt(1,12);
cstmt.setInt(2,4);
cstmt.registerOutParameter(3,java.sql.Types.INTEGER);
cstmt.registerOutParameter(4,java.sql.Types.INTEGER);
cstmt.registerOutParameter(5,java.sql.Types.INTEGER);
cstmt.registerOutParameter(6,java.sql.Types.INTEGER);
cstmt.execute();
int a = cstmt.getInt(3);
int b = cstmt.getInt(4);
int a = cstmt.getInt(5);
int d = cstmt.getInt(6);
查一下帮助吧
String sqlStr = "begin FunctionName( :1, :2,:3,:4, :5,:6 );end;";
cstmt = con.prepareCall(sqlStr);
cstmt.setInt(1,12);
cstmt.setInt(2,4);
cstmt.registerOutParameter(3,java.sql.Types.INTEGER);
cstmt.registerOutParameter(4,java.sql.Types.INTEGER);
cstmt.registerOutParameter(5,java.sql.Types.INTEGER);
cstmt.registerOutParameter(6,java.sql.Types.INTEGER);
cstmt.execute();
int a = cstmt.getInt(3);
int b = cstmt.getInt(4);
int a = cstmt.getInt(5);
int d = cstmt.getInt(6);
查一下帮助吧
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货