mybatis 批量update运用case-when语句

最新推荐文章于 2024-09-29 22:38:03 发布

jushisi

最新推荐文章于 2024-09-29 22:38:03 发布

阅读量4k

点赞数 1

分类专栏： MyBatis

本文链接：https://blog.csdn.net/jushisi/article/details/102566905

版权

MyBatis 专栏收录该内容

7 篇文章 0 订阅

订阅专栏

<update id="batchUpdate" parameterType="java.util.List">
		update t_scte_goods
		<trim prefix="set" suffixOverrides=",">
			update_time=current_timestamp,
		  	<trim prefix="sell_state =case" suffix="end,">
                <foreach collection="list" item="item" index="index">
                    <if test="item.sellState !=null">
                        when goods_id = #{item.goodsId} then #{item.sellState}
                    </if>
                    <if test="item.sellState == null">
                        when goods_id = #{item.goodsId} then t_scte_goods.sell_state
                    </if>
                </foreach>
            </trim>
            <trim prefix="update_time =case" suffix="end,">
                 <foreach collection="list" item="item" index="index">
                         when goods_id=#{item.goodsId} then #{item.updateTime}
                 </foreach>
            </trim>
            <trim prefix="price =case" suffix="end,">
                <foreach collection="list" item="item" index="index">
                    <if test="item.price !=null">
                        when goods_id = #{item.goodsId} then #{item.price}
                    </if>
                    <if test="item.price == null">
                        when goods_id = #{item.goodsId} then t_scte_goods.price
                    </if>
                </foreach>
            </trim>
		</trim>
		where goods_id in 
			<foreach collection="list" item="item" index="index" separator="," open="(" close=")">
				#{item.goodsId}
			</foreach> 
	</update>