有些时候需要批量执行sql
<foreach collection="list" item="item" separator=";">
UPDATE employee SET commission_workflow = #{workflow} WHERE commission_period_id = #{item.commissionPeriodId} AND employee_id = #{item.employeeId}
</foreach>
需要在
jdbc:mysql://127.0.0.1:3306/demp?serverTimezone=UTC&useUnicode=true&characterEncoding=utf8&useSSL=false&allowMultiQueries=true
数据库url中拼接上
allowMultiQueries=true
即可