<!--批量更新报表 --> <update id="updateIssueByBatch" parameterType="java.util.List"> <foreach collection="issueList" item="item" index="index" separator=";"> update sys_issue <set> <if test="item.first != null and item.first != ''">first_class = #{item.first}, </if> <if test="item.second != null and item.second != ''">second_class = #{item.second}, </if> updated_time = now() </set> where id = #{item.Id} </foreach> </update> <!--批量插入报表 --> <insert id="insertBatch"> insert into tb_test( id, create_by, create_time, update_by, update_time, del_flag, remark ) VALUES <foreach collection='list' item='item' separator=','> ( #{item.id}, #{item.createBy}, #{item.createTime}, #{item.updateBy}, #{item.updateTime}, #{item.delFlag}, #{item.remark} ) </foreach> </insert>报错
The error occurred while setting parameters
报错原因为配置mysql的时候没有开启批量插入，需要在mysql的jdbc连接加入allowMultiQueries=true；
如下：
jdbc.url=jdbc:mysql://XXX/abc?useUnicode=true&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true来源地址：https://blog.csdn.net/god_sword_/article/details/129289779
