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

最新推荐文章于 2025-03-21 17:16:29 发布

wb1987115

最新推荐文章于 2025-03-21 17:16:29 发布

阅读量577

点赞数

本文介绍了一个SQL脚本实例，包括两个表(person和address)的创建及数据插入，并通过存储过程proc1来查询这两个表的数据。此外，还提供了一个简单的Java框架代码示例，用于测试存储过程的调用。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >


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