Mybatis一次执行多条sql，一个标签多个Insert、update、delete操作

方案一
<insert id="addPurchase" parameterType="com.zhao.vo.PurchaseVoOne">
    insert into enters_sells_saves.purchase ( amount, price, purchase_time)
    values (#{amount},#{price},#{purchaseTime});
    insert into enters_sells_saves.goods (goods_name)
    values (#{goodsName});
    insert into enters_sells_saves.supplier (supplier_name)
    values (#{supplierName});
</insert>
需要我们在数据库连接配置中加入：allowMultiQueries=true
示例：jdbc:mysql://localhost:3306/enters_sells_saves?useSSL=true&useUnicode=true&characterEncoding=utf8&serverTimezone=GMT&allowMultiQueries=true

方案二
<!-- 批量插入用户 -->
<insert id="batchInsert">
    <foreach collection="list" item="item" index="index"  separator=";" >
        insert into user(username,password,isadmin) 
        values(#{item.userName}, #{item.password}, #{item.isAdmin})
    </foreach>    
</insert>
<!-- 批量 更新用户 -->
<update id="batchUpdate">
    update user set password = #{password} where id = #{id} ;
    update user_info set user_name = #{user_name}, addr = #{addr} where where id = #{id}
</update>