如何用JAVA获取SQL SERVER存储过程返回的多个结果集

偷瓜的贼

------------------------------
create table person
(
pid int identity primary key,
name nvarchar(30) not null,
age int default 0,
city nvarchar(30)
)
go

insert into person values('x7700',20,'NJ')
insert into person values('x7711',21,'SH')
insert into person values('x7733',23,'SZ')
insert into person values('x7755',25,'ZJ')
insert into person values('x7701',26,'NJ')
insert into person values('x7703',23,'NJ')
insert into person values('x7705',27,'DL')
insert into person values('x7707',30,'GD')

create table address
(
aid int identity primary key,
address nvarchar(200),
pid int references person(pid)
)
go

insert into address values('1皇后大道1',1)
insert into address values('2皇后大道2',2)
insert into address values('3皇后大道3',3)
insert into address values('4皇后大道4',4)
insert into address values('5皇后大道5',5)
insert into address values('6皇后大道6',6)
insert into address values('7皇后大道7',7)
insert into address values('8皇后大道8',8)

create proc proc1
as
select * from person
select * from address
go
---------------------------



//JAVA 框架代码

@Test
public void testProcedure()throws Exception{
try {
String queryString="{Call proc1}";
CallableStatement cstmt=DBHelper.getConnection().prepareCall(queryString);

} catch (Exception e) {
e.printStackTrace();
throw e;
}
}