mybatis xml 中的批量操作

#mybatis 批量更新update foreach

注意：需要在连接mysql的时候在application.yml中加上 &allowMultiQueries=true
spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&allowMultiQueries=true

#注解版本
@Update({"<script>" +
            "<foreach collection='grouopByTagId' item='item' index='index' open='(' close=')'  separator=',' > " +
            " update " +
            TABLE_NAME +
            " SET status = 2, del_reason = #{item.delReason} " +
            " where id = #{item.id} " +
            "</foreach>" +
            "</script>"})

#方式2：
    <update id="batchUpdateQuestion" parameterType="java.util.List">
        <foreach collection="xuanZeBean" item="item" index="index">
            update choose_question_management set
            title = #{item.title},
            title_id = #{item.titleId},
            video_id = #{item.videoId},
            option_type = #{item.optionType},
            a_option_url = #{item.optionUrlA},
            b_option_url = #{item.optionUrlB},
            c_option_url = #{item.optionUrlC},
            a_content_word = #{item.contentWordA},
            answer = #{item.answer}
            where 1=1 and id =#{item.id};
        </foreach>
    </update>

 #mybatis 批量新增操作 insert foreach

    <insert id="batchInsert" parameterType="List">
        insert into
        user(user_name,phone,child_name,open_courses,open_date,expire_date,purchase_times,share_times,
        purchase_timed,number_reports,accumulated_amount) VALUES
        <foreach collection="users" item="user" index="index" separator=",">
            (#{user.userName},#{user.phone},#{user.childName},#{user.openCourses},#{user.openDate},#{user.expireDate}
            ,#{user.purchaseTimes},#{user.shareTimes},#{user.purchaseTimed},#{user.numberReports},#{user.accumulatedAmount})
        </foreach>
    </insert>

#mybatis 批量删除 delete foreach

#dao层：
    void deleteMoreEmp(@Param("array") List array);
#mybatis代码：
    <!-- 批量删除 -->
    <delete id="deleteMoreEmp" parameterType="int[]">
        <!-- delete from emp where empno in(7789,7790) -->
        <!-- forEach : 用来循环 collection : 用来指定循环的数据的类型 可以填的值有：array,list,map item
            : 循环中为每个循环的数据指定一个别名 index : 循环中循环的下标 open : 开始 close : 结束 separator : 数组中元素之间的分隔符 -->
        delete from token_management where id in
        <foreach collection="array" item="arr" index="no" open="("
                 separator="," close=")">
            #{arr}
        </foreach>
    </delete>

#参考 https://blog.csdn.net/benxiaohai888/article/details/78564751