方案一
<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>