存储过程如下
CREATE PROCEDURE AAA @CurYear int,@CurMonth int AS
insert into 临时表 (...) select * from WHERE YEAR(日期)=@CurYear AND MONTH(日期)=@CurMonth
再JAVA中如何调用。给段代码。
...全文
1132打赏收藏
JDBC中如何调用带参数的存储过程!!急!
存储过程如下 CREATE PROCEDURE AAA @CurYear int,@CurMonth int AS insert into 临时表 (...) select * from WHERE YEAR(日期)=@CurYear AND MONTH(日期)=@CurMonth 再JAVA中如何调用。给段代码。