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
