mybatis批量更新update

• 数据库连接配置需修改成支持批量操作
  增加： &allowMultiQueries=true

spring.datasource.url=jdbc:mysql://xxx:3306/fm_hedge?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true

• mapper.xml中sql示例

    <update id="updateInfo">
         <foreach collection="infoList" item="item" index="index"  separator=";">
             update test_table
            <set>
                state = #{item.state}
            </set>
            where id =#{item.id}
         </foreach>
    </update>