gisterOutParameter(1,java.sql.Types.INTEGER);
proc.execute();
// 取出存储过程的返回值
id = proc.getInt(1);
System.out.println(“人员ID为:”+id);
connection.close();
}catch (SQLException e){
e.printStackTrace();
}
// 以下为存储过程的定义
// create proc test_default_proc
// @username varchar(20)=’silas’,@pid int output
// as
// declare @uid int
// set @uid = 0
// select @uid=userid from users where username=@username
// if @uid<>0
// set @pid = @uid
// else
// set @pid = 0
}
例子4:调用返回两个以上结果集的存储过程（重点）
import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
public class TestProcMulResultSet {
private static Connection connection = null;
public static Connection getConnection(){
try {
Class.forName(“com.microsoft.jdbc.sqlserver.SQLServerDriver”);
connection = DriverManager.getConnection(“jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb”,”sa”,”sa”);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return connection;
}
public static void main(String[] args) {
Connection connection = TestProc.getConnection();
try{
ResultSet rs = null;
// 设置调用的存储过程名及参数情况,注意的是存储过程不可以有输出参数
CallableStatement proc = connection.prepareCall(“{ call test_proc_mulresultset( )}”);
// 设置输入参数
proc.setInt(1, 11);
// 调入存储过程
proc.execute();
// 取出存储过程的结果集
boolean hasResult = true;
while (hasResult) {
rs = proc.getResultSet();
while(rs.next()) {
System.out.println(“第一条记录第二个字段值为:”+rs.getString(2));
break;
}
hasResult = proc.getMoreResults();
}
connection.close();
}catch (SQLException e){
e.printStackTrace();
}
// create proc test_proc_mulresultset
// @id int
// as
// select * from users where userid=@id
// select * from users order by userid desc
}
}