String sql = "{ ?=call Pro_Test(?) }";
Connection conn = getConnection();
CallableStatement call = conn.prepareCall(sql);
call.registerOutParameter(1, java.sql.Types.INTEGER);
call.setObject(2, "参数");
call.execute();
// 获取结果集
ResultSet resultSet = call.getResultSet();
// 获取返回值
call.getMoreResults();
int returnValue = call.getInt(1);
JDBC调用有返回值和结果集的mssql存储过程
最新推荐文章于 2024-09-14 18:46:05 发布