Java 调用存储过程 返回结果集

1、不带参数的存储过程，并且返回结果集
CallableStatement stmt = conn.prepareCall("{call test1}");
stmt.execute();
ResultSet rs = stmt.getResultSet();
while (rs.next()) {
for(int i=1;i<=rs.getMetaData().getColumnCount();i++)
{
System.out.println(rs.getString(i));
}
}

test1 的存储过程如下：
CREATE PROCEDURE test1
AS
select * from jobs
GO

2、带参数的存储过程，并且返回值
stmt = conn.prepareCall("{call test2(?,?)}");
stmt.registerOutParameter(1, Types.INTEGER);
stmt.registerOutParameter(2, Types.INTEGER);
stmt.setInt(1, 10);
stmt.setInt(2, 10);
stmt.execute();
System.out.println(stmt.getString(1));
System.out.println(stmt.getString(2));

test2的存储过程如下：
CREATE PROCEDURE test2 (@max int output,@min int output)
AS
select @max=@max+1
select @min=@min-1
GO

3、带参数的存储过程，并且返回结果集
stmt = conn.prepareCall("{call test3(?)}");
stmt.setInt(1, 14);
stmt.execute();
rs = stmt.getResultSet();
while (rs.next()) {
for(int i=1;i<=rs.getMetaData().getColumnCount();i++)
{
System.out.println(rs.getString(i));
}
}

test3的存储过程如下：
CREATE PROCEDURE test3(@id int)
AS
select * from jobs where job_id=@id
GO