mybatis 批量更新模板(自用)

最新推荐文章于 2024-09-26 11:01:02 发布

lstingou

最新推荐文章于 2024-09-26 11:01:02 发布

阅读量236

点赞数

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

本文链接：https://blog.csdn.net/csdn_tingou/article/details/115542204

版权

Mybatis 专栏收录该内容

3 篇文章

订阅专栏

根据case批量更新

<update id="batchUpdateUserInfoByIdAndUserName">
        UPDATE user
        SET
        age =
        <foreach collection="list" item="item" open="case " close=" end,">
            when id=#{item.id}
            and username=#{item.username}
            then #{item.age}
        </foreach>

        sex =
        <foreach collection="list" item="item" open="case " close=" end,">
            when id=#{item.id}
            and username=#{item.username}
            then #{item.sex}
        </foreach>

        where id in
        <foreach collection="list" item="item" index="index" open="(" separator="," close=")">
            #{item.id}
        </foreach>

        AND username in
        <foreach collection="list" item="item" index="index" open="(" separator="," close=")">
            #{item.username}
        </foreach>

    </update>