mybatis根据批量更新多个字段

最新推荐文章于 2024-05-21 18:07:54 发布

清晨细雨~

最新推荐文章于 2024-05-21 18:07:54 发布

阅读量517

点赞数 2

文章标签： mybatis java 服务器

本文链接：https://blog.csdn.net/dream_snow2012/article/details/137499505

版权

一、根据id更新多个字段

    <update id="batchUpdate">
        update food
        <trim prefix="set" suffixOverrides=",">
            <trim prefix="open_id =case" suffix="end,">
                <foreach collection="list" item="item" index="index">
                    when id=#{item.id} then #{item.openId}
                </foreach>
            </trim>
            <trim prefix="create_by =case" suffix="end,">
                <foreach collection="list" item="item" index="index">
                    when id=#{item.id} then #{item.createBy}
                </foreach>
            </trim>
        </trim>
        where id in
        <foreach collection="list" index="index" item="item"
                 separator="," open="(" close=")">
            #{item.id}
        </foreach>
    </update>