sqlserver 存储过程 返回多个select 结果集

sql server 数据库的存储过程

 

ALTER PROCEDURE [prc_******] 
    @obligateFour Varchar(50),
    @obligateFive Varchar(50)
AS
BEGIN

select  * from  a

select * from  b

end

 

 

java jdbc 调用方法:

   public String getInsureDetail(String obligateFour, String obligateFive) throws UnsupportedEncodingException, Exception {
        Connection conn = null;
        ResultSet rs1 = null;
        ResultSet rs = null;
        CallableStatement proc = null;

    try{

           conn = new MSConnection().getConnection();
         
            proc = conn.prepareCall("{call prc_bzdbbx_getinsuredetail(?,?)}");
            proc.setString(1, obligateFour);
            proc.setString(2, obligateFive);
            rs1=proc.executeQuery();

            while  (rs1!=null&&rs1.