批量更新
要在配置文件开启 &allowMultiQueries=true 才有用 不然报语法错误！！
<update id="batchUpdate" parameterType="java.util.List">
<foreach collection="list" item="item" index="index" separator=";">
UPDATE cart_item SET count = #{item.count,jdbcType=INTEGER},
oper_time =NOW()
WHERE id = #{item.id,jdbcType=BIGINT};
</foreach>
</update>
批量插入
<insert id="insertList" parameterType="java.util.List"useGeneratedKeys="false">
insert into group_config(store_id,switch_type, oper_id, create_time) values
<foreach collection="list" item="item" separator="," close=";">
(#{item.storeId},#{item.switchType}, #{item.operId}, #{item.createTime}) </foreach>
</insert>
批量修改
Updategroup_config set name = ‘zhangsan’,age = 1 where id in(2,3,4)
