SQL SERVERストアド・プロシージャが返す複数の結果セットをJAVAで取得する方法



------------------------------
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;
}
}