CREATE procedure p_generation
@testname char,@age smallint
as
declare @several bigint,@random_count int,@i int ,@random_number bigint
--declare @random_count int
-- declare @i int
--declare @random_number bigint
set @i=0
set @random_count=1
set @several=1000000
--set @random_count=1
begin
while(@i<@random_count)
begin
set @random_number=cast(rand()*@several as bigint)
if not exists(select 1 from ttest where code=@random_number)
begin
insert into ttest values(@random_number,@testname,@age)
set @i=@i+1
end
end
end
GO
以上是存储过存!!
Connection cn = DBHelp.getConnection();
CallableStatement st=cn.prepareCall("{call p_generation(?,?)}");//?代表参数
// st.setString(1,"test");//传参数。
//st.setInt(1,100000);
st.setString(1, "kemin");
st.setInt(2, 25);
st.execute();
System.out.print("ok");
select * from ttest
id code name age
5 304226 k 25
6 409070 k 25
7 426551 k 28只能插入一个字付怎么回事
@testname char,@age smallint
as
declare @several bigint,@random_count int,@i int ,@random_number bigint
--declare @random_count int
-- declare @i int
--declare @random_number bigint
set @i=0
set @random_count=1
set @several=1000000
--set @random_count=1
begin
while(@i<@random_count)
begin
set @random_number=cast(rand()*@several as bigint)
if not exists(select 1 from ttest where code=@random_number)
begin
insert into ttest values(@random_number,@testname,@age)
set @i=@i+1
end
end
end
GO
以上是存储过存!!
Connection cn = DBHelp.getConnection();
CallableStatement st=cn.prepareCall("{call p_generation(?,?)}");//?代表参数
// st.setString(1,"test");//传参数。
//st.setInt(1,100000);
st.setString(1, "kemin");
st.setInt(2, 25);
st.execute();
System.out.print("ok");
select * from ttest
id code name age
5 304226 k 25
6 409070 k 25
7 426551 k 28只能插入一个字付怎么回事
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货