java 批量插入

public static void batchInsertion(List<dataSynchronizationEntity> list){
        String url="jdbc:mysql://127.0.0.1:3306/test?rewriteBatchedStatements=true&useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8";
        String sql="insert into test values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
        //1.加载驱动
        PreparedStatement pstm = null;
        try {
            String className = "com.mysql.jdbc.Driver";
            Class clazz = Class.forName(className);
            Driver driver = (Driver) clazz.newInstance();
            try {
                Properties info = new Properties();
                info.setProperty("user", "a");
                info.setProperty("password", "123456");
                //2.创建连接
                Connection connection= driver.connect(url,info);
                connection.setAutoCommit(false);
                //3.创建命令窗口
                Statement statement = connection.createStatement();
                //4.执行命令窗口里的语句
                statement.executeUpdate("delete from test");
                pstm = connection.prepareStatement(sql);
                //5.处理返回的结果集
                for(dataSynchronizationEntity dataSynchronizationEntity : list){
                    pstm.setString(1,dataSynchronizationEntity.getEtpsId());
                    pstm.setString(2,dataSynchronizationEntity.getPripid());
                    pstm.setString(3,dataSynchronizationEntity.getUniscid());
                    pstm.setString(4,dataSynchronizationEntity.getEntname());
                    pstm.setString(5,dataSynchronizationEntity.getRegno());
                    pstm.setString(6,dataSynchronizationEntity.getEnttype());
                    pstm.setString(7,dataSynchronizationEntity.getEnttypeCn());
                    pstm.setString(8,dataSynchronizationEntity.getIndustryphy());
                    pstm.setString(9,dataSynchronizationEntity.getIndustryco());
                    pstm.setDate(10,dataSynchronizationEntity.getEstdate());
                    pstm.setString(11,dataSynchronizationEntity.getRegorg());
                    pstm.setString(12,dataSynchronizationEntity.getRegorgCn());
                    pstm.setString(13,dataSynchronizationEntity.getOpscotype());
                    pstm.setString(14,dataSynchronizationEntity.getOpscotypeCn());
                    pstm.setString(15,dataSynchronizationEntity.getOpscope());
                    pstm.setDate(16,dataSynchronizationEntity.getOpfrom());
                    pstm.setDate(17,dataSynchronizationEntity.getOpto());
                    pstm.setString(18,dataSynchronizationEntity.getRegstate());
                    pstm.setString(19,dataSynchronizationEntity.getRegstateCn());
                    pstm.setString(20,dataSynchronizationEntity.getDomdistrict());
                    pstm.setString(21,dataSynchronizationEntity.getDom());
                    pstm.setInt(22,dataSynchronizationEntity.getRegcap());
                    pstm.setString(23,dataSynchronizationEntity.getRegcapcur());
                    pstm.setString(24,dataSynchronizationEntity.getRegcapcurCn());
                    pstm.setInt(25,dataSynchronizationEntity.getRegcapusd());
                    pstm.setInt(26,dataSynchronizationEntity.getReccap());
                    pstm.setInt(27,dataSynchronizationEntity.getReccapusd());
                    pstm.setString(28,dataSynchronizationEntity.getCountry());
                    pstm.setInt(29,dataSynchronizationEntity.getEmpnum());
                    pstm.setString(30,dataSynchronizationEntity.getTown());
                    pstm.setString(31,dataSynchronizationEntity.getName());
                    pstm.setString(32,dataSynchronizationEntity.getReporttype());
                    pstm.setDate(33,dataSynchronizationEntity.getApprdate());
                    pstm.setDate(34,dataSynchronizationEntity.getsExtDatatime());
                    pstm.setDate(35,dataSynchronizationEntity.getsExtTimestamp());
                    pstm.addBatch();
                }
                pstm.executeBatch();
                connection.commit();
                //6.关闭资源
                pstm.close();
                statement.close();
                connection.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        } catch (ClassNotFoundException | InstantiationException | IllegalAccessException e) {
            e.printStackTrace();
        }
    }