1 Connection conn; 2 Class.forName("com.mysql.jdbc.Driver"); 3 conn = DriverManager.getConnection( 4 "jdbc:mysql://88.88.88.88:3306/zmm?useUnicode=true&characterEncoding=UTF-8", "root", "root"); 5 conn.setAutoCommit(false); 6 // 保存当前自动提交模式 7 boolean autoCommit = conn.getAutoCommit(); 8 // 关闭自动提交 9 conn.setAutoCommit(false);10 Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);11 12  for (String key : map.keySet()) {13 14 //编辑15 16 stmt.addBatch("update zmm set id= '" + zmm+ "',zmm = '" + zmm+ "',status = 0 where id ='"+id+"'");17 18 //插入19 20 //stmt.addBatch("insert into zmm set id = '"+id+"', create_date = '"+sdf.format(date)+"', cut_off_date = null, zmm= '" + zmm+ "',status = 0");21 22 //list.size()或者map.size()都可以点size方法23 24 if (i % 1000 == 0 || i == list.size()) {25 try {26 stmt.executeBatch();27 stmt.clearBatch();28 conn.commit();29 } catch (Exception e) {30 conn.close();31 e.printStackTrace();32 }33 34 i = i + 1;35 36 }37 38 //关闭事件39 40 conn.close();41