connection url
添加参数
&allowMultiQueries=true&rewriteBatchedStatements=true
example xml:
<update id="batchUpdate" parameterType="java.util.List">
<foreach collection="list" item="item" index="index" separator=";">
UPDATE table
<set>
<if test="item.updateTime != null>
updateTime = #{item.updateTime ,jdbcType=TIMESTAMP},
</if>
<if test="item.isDel != null>
is_del= #{item.isDel,jdbcType=INTEGER}
</if>
</set>
WHERE id = #{item.id}
</foreach>
</update>