批量上传方法（saveBatch）的伪批量处理建议

mybatis的批量保存方法saveBatch实际上是通过for循环进行批量增加，会有多次的访问数据，这会影响性能处理意见是在连接mysql连接里面添加选项

rewriteBatchedStatements=true

jdbc:mysql://localhost:3306/lilishop_distribution?useUnicode=true&characterEncoding=utf-8&rewriteBatchedStatements=true&useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai

这个方法会将批量增加转化成一条语句，减少数据库访问

或者在xml里面写原生sql

    <insert id="savePersonnelPlacementBatch" parameterType="java.util.List">
        insert into li_personnel_placement
            (id,
             create_time,
             update_time,
             create_name,
             update_name)
        values
        <foreach collection="list" item="item" index="index" separator=",">
            (#{item.id},
             #{item.createTime},
             #{item.updateTime},
             #{item.createName},
             #{item.updateName})
        </foreach>

    </insert>