JDBC中如何调用带参数的存储过程!!急！

[blp]

存储过程如下
CREATE PROCEDURE AAA @CurYear int,@CurMonth int AS
insert into 临时表 (...) select * from WHERE YEAR(日期)=@CurYear AND MONTH(日期)=@CurMonth

再JAVA中如何调用。给段代码。

[ChDw]

CallableStatement call = conn.preparedCall("{call AAA(?,?) }");
如果参数是返回值
call.registerOutParameter（1,Types.INTEGER);
如果是参数
call.setInt(2,123);
call.execute();

[reagle]

关注