81,092
社区成员
发帖
与我相关
我的任务
分享
try {
conn = getDba().getConnection();
conn.setAutoCommit(false);
for (TblMmsImpPhone importNum:numList) {
String sql = "insert into tbl_mms_importphone (id,phonenum,flag,temid) values(SEQ_TBL_IMPORTPHONE.nextval,'"+ importNum.getPhonenum()+ "',0,"+ importNum.getTemId() + ")";
ps = conn.prepareStatement(sql);
count += ps.executeUpdate();
if ((count % 100) == 0) {
conn.commit();
}
}
conn.commit();
conn.setAutoCommit(true);
} catch (Exception e) {
success = false;
try {
conn.rollback();
} catch (SQLException e1) {
e1.printStackTrace();
}
e.printStackTrace();
} finally {
close(ps, conn);
}