RT
------------------------------
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;
}
}
希望高手可以给出java核心代码