mapper.xml文件:
<update id="batchUpdate" parameterType="java.util.List">
<foreach collection="list" item="item" index="index" separator=";">
UPDATE mytable SET field1 = #{item.field1}
WHERE field2 = #{item.field2} AND field3 = #{item.field3}
</foreach>
</update>
mapper.java文件:
Integer batchUpdate(@Param("list") List<MyData> list);
application.yml文件:
spring:
datasource:
db1:
name:
url: jdbc:mysql://127.0.0.1:3306/myDatabase?allowMultiQueries=true&characterEncoding=utf8&useSSL=false&serverTimezone=GMT%2B8
(需配上:allowMultiQueries=true)