mybatis-- 批量更新,批量修改

最新推荐文章于 2024-08-31 18:44:22 发布

别浪呀

最新推荐文章于 2024-08-31 18:44:22 发布

阅读量609

点赞数 1

分类专栏： mybatis 文章标签： mybatis

本文链接：https://blog.csdn.net/adminBfl/article/details/87884338

版权

mybatis 专栏收录该内容

4 篇文章 0 订阅

订阅专栏

<update id="updateNotificationRecording" parameterType="java.util.List">
    <foreach collection="notificationRecordings" item="item" index="index" open="" close="" separator=";">
        update wa_notificationrecording
        <set>
            <if test="item.company_name !=null">
                company_name = #{item.company_name},
            </if>
            <if test="item.company_status !=null">
                company_status = #{item.company_status},
            </if>
            <if test="item.create_time !=null">
                create_time = #{item.create_time},
            </if>
            <if test="item.current_status !=null">
                current_status = #{item.current_status},
            </if>
            <if test="item.feedback_status !=null">
                feedback_status = #{item.feedback_status},
            </if>
            <if test="item.file_status !=null">
                file_status = #{item.file_status},
            </if>
            <if test="item.industry_id !=null">
                industry_id = #{item.industry_id},
            </if>
            <if test="item.notify_status !=null">
                notify_status = #{item.notify_status},
            </if>
            <if test="item.notify_time !=null">
                notify_time = #{item.notify_time},
            </if>
            <if test="item.super_company_id !=null">
                super_company_id = #{item.super_company_id},
            </if>
            <if test="item.update_time !=null">
                update_time = #{item.update_time}
            </if>
        </set>
        <where>
            company_id = #{item.company_id}
        </where>

    </foreach>


</update>
    <insert id="insertNotificationRecording" parameterType="java.util.List">
        INSERT INTO wa_notificationrecording (
        company_id,
        company_name,
        company_status,
        create_time,
        current_status,
        feedback_status,
        file_status,
        industry_id,
        notify_status,
        notify_time,
        super_company_id,
        update_time
        )
        VALUES
        <foreach collection="list" item="NotificationRecording" index="index" separator=",">

            (
            #{NotificationRecording.company_id},
            #{NotificationRecording.company_name},
            #{NotificationRecording.company_status},
            #{NotificationRecording.create_time},
            #{NotificationRecording.current_status},
            #{NotificationRecording.feedback_status},
            #{NotificationRecording.file_status},
            #{NotificationRecording.industry_id},
            #{NotificationRecording.notify_status},
            #{NotificationRecording.notify_time},
            #{NotificationRecording.super_company_id},
            #{NotificationRecording.update_time}

            )
        </foreach>
    </insert>

需要注意

批量修改是需要修改数据库url

添加

&allowMultiQueries=true

代码

 /**
      * 批量修改
      * @param notificationRecordings
      */
     void updateNotificationRecording(@Param("notificationRecordings") List<NotificationRecording> notificationRecordings);



     /**
      * 批量保存 
      * @param notificationrecording
      */
     void insertNotificationRecording(List<NotificationRecording> notificationrecording);