MySql数据库高效率批量插入

 ResourceBundle p = ResourceBundle.getBundle("db");
    public int addUser(List<String> params) {
        int j = 0;
        Connection conn = null;
        PreparedStatement pstmt = null;
        
        try {
            Class.forName(p.getString("forname"));
            conn = DriverManager.getConnection(p.getString("driver"), p.getString("user"), p.getString("pwd"));
            System.out.println(conn);
            String sql = "";
            conn.setAutoCommit(false);
            pstmt = conn.prepareStatement(sql);
            for (int i = 0; i < params.size(); i++) {
                /**
                 * 这样至少节省2分钟
                 */
                // 批量插入
                pstmt.addBatch();
            }
            // 批量提交
            pstmt.executeBatch();
            conn.commit();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                conn.setAutoCommit(true);
            } catch (SQLException e1) {
                e1.printStackTrace();
            }
            if (conn != null) {
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if (pstmt != null) {
                try {
                    pstmt.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }
        return j;
    }