调用带出参的存储过程:
CallableStatement call = conn.prepareCall("{ ?=Call dbname..sp_name(?,?,?) }");
call.registerOutParameter(1, java.sql.Types.INTEGER);
call.setString(2, custId);
call.setString(3, "");
call.setString(4, "");
call.execute();
int result = call.getInt(1);
调用带参数的存储过程:
CallableStatement call = conn.prepareCall("{Call dbname..sp_name(?,?)}");
call.setString(1,limitTime);
call.setString(2,"");
call.execute();
rows = call.getInt(2);