jdbc批量更新

 

 

        Class.forName("com.mysql.jdbc.Driver");
        conn = DriverManager.getConnection(
                "jdbc:mysql://localhost:3306/db", "root", "root");
        conn.setAutoCommit(false);
        pstmt = (PreparedStatement) conn
                .prepareStatement(sql);
        for (int i = 0; i < terms.length -1; i++) {
            //此处注意setInt(1, i), 字段名称和栏目数必须匹配
            pstmt.setInt(1, i);
            pstmt.setString(2, terms[i]);
            pstmt.addBatch();

        }

        //增加到批量工作任务中
        pstmt.executeBatch();
        System.out.println(new Date());
        //提交执行
        conn.commit();
        pstmt.close();
        conn.close();