JDBC调用有返回值和结果集的mssql存储过程
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);