高手帮忙用java调用这个随机数存储过程

[Jake6420285]

请给我个完整的程序代码 谢谢
表：
create table test(number int,fangweima bigint,regtime datetime default getdate())

存储过程

create proc test_proc1
@chang bigint,
@ziding bigint,
@number bigint
as
declare @i bigint
declare @random bigint
select @i=1

while(@i<@number)
begin
select @random=convert(bigint,@chang*100000000000000+@ziding*100000000+rand()*10000000)
-- select @random=convert(bigint,rand()*1000000000000+1000000000000)

if not exists (select fangweima from test where fangweima=@random)
insert into test(number,fangweima) values(@chang,@random)

select @i=@i+1
end

[ruanjiantaotao]

oracle or db 9

[Jake6420285]

数据库是SQL