CallableStatement

--JDBC调存储过程

stmt = conn.prepareCall("{call usp_a_insert(['f'])}");

 

--申明存储过程

alter procedure usp_a_insert
@a nvarchar(4),
@b bit output
as
--select * from employee

insert into a(a)
values(@a)
set @b = 1

 

--管理平台中执行有返回值的存储过程
declare @result bit
exec usp_a_insert '',@result output
select @result

 

--JDBC 调有返回值的存储过程

   stmt = conn.prepareCall("{call usp_a_insert(['f'],?)}");
           stmt.registerOutParameter(1, java.sql.Types.BIT);
         stmt.execute();
         System.out.println( stmt.getString(1));