执行Batch批处理遇到的问题
1.务必关掉自动提交
增强执行效率
conn.setAutoCommit(false);
2.executeBatch失效问题
<1>务必将语句pstmt = conn.prepareStatement(sql);放到循环体外,否则只能插入一条语句
int size = ipAdressList.size(); try { conn = JdbcUtil.getConnection(); conn.setAutoCommit(false); pstmt = conn.prepareStatement(sql); for (int i = 0; i < size; i++) { // pstmt = conn.prepareStatement(sql);只能插入最后一条 ipAd = ipAdressList.get(i); int index = 1; pstmt.setObject(index++, ipAd.getadress()); pstmt.setObject(index++, ipAd.getPort()); pstmt.setObject(index++, ipAd.getSpeed()); pstmt.setObject(index++, ipAd.getCountry()); pstmt.setObject(index++, ipAd.getProvince()); pstmt.setObject(index++, ipAd.getCity()); pstmt.setObject(index++, ipAd.getIsp()); pstmt.setObject(index++, ipAd.isDomestic()); pstmt.setObject(index++, ipAd.isAlive()); pstmt.addBatch(); } pstmt.executeBatch(); conn.commit(); } catch (Exception e) { e.printStackTrace(); }finally { JdbcUtil.close(rs, stmt, pstmt, conn); }
<2>务必最后提交
conn.commit();