62,614
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE `simpleproc`(out param1 int)
begin
select count(*) into param1 from user;
end;--用于统计user表的记录数
CallableStatement call=conn.prepareCall("call simpleproc(?)");
call.registerOutParameter(1, java.sql.Types.INTEGER);
call.executeQuery();
System.out.println(call.getInt(1));