大家帮我看看批量处理怎么不行呢?
程序代码如下:
CallableStatement cstmt = con.prepareCall("{call P_CONSTRACT_ACC_ADD(?,?,?,?)}");
for (int i=0;i<count;i++)
{
cstmt.setString(1,xmId);
cstmt.setString(2,upCategoryFlag);
cstmt.setString(3,fileName);
cstmt.registerOutParameter(4,java.sql.Types.INTEGER);
cstmt.addBatch();//这句执行不了
}
int[] result = cstmt.executeBatch();