MyBatis 批量新增及批量修改SQL拼接

最新推荐文章于 2023-12-07 17:17:55 发布

Mr.杨先森

最新推荐文章于 2023-12-07 17:17:55 发布

阅读量873

点赞数

分类专栏： java基础文章标签： mybatis sql 数据库

本文链接：https://blog.csdn.net/gracexiao168/article/details/127675406

版权

java基础专栏收录该内容

11 篇文章 0 订阅

订阅专栏

批量新增

    <insert id="saveBatch">
        INSERT INTO log
        (
        Age,Name,CreateBy,CreateTime,UpdateBy,UpdateTime
        )
        VALUES
        <foreach collection ="list" item="item" separator =",">
            (
            #{item.age}
            , #{item.name}
            , #{item.createBy}
            , #{item.createTime}
            , #{item.updateBy}
            , #{item.updateTime}
            )
        </foreach>
    </insert>

批量修改

<update id="updateBatch">
        UPDATE log SET
        DeleteFlag =
        <foreach collection="list" item="item" index="index" separator=" " open="case Id"
                       close="end">
        when #{item.id} then 1
        </foreach>
        ,UpdateBy =
        <foreach collection="list" item="item" index="index" separator=" " open="case Id"
                 close="end">
            when #{item.Id} then #{item.updateBy}
        </foreach>
        ,UpdateTime =
        <foreach collection="list" item="item" index="index" separator=" " open="case Id"
                 close="end">
            when #{item.Id} then #{item.updateTime}
        </foreach>
        WHERE PO IN
        <foreach collection="list" item="item" index="index" separator="," open="("
                 close=")">
            #{item.Id}
        </foreach>
        AND
        DeleteFlag = 0
    </update>