<update id="updateGoodsShelf" parameterType="java.lang.String">
update
integral_goods
set
<if test='shelfFlag == "1"'>
shelf_flag = ${@com.pisen.cloud.luna.ms.jifen.base.domain.IntegralGoods@SHELF_ON}
</if>
<if test='shelfFlag == "0"'>
shelf_flag = ${@com.pisen.cloud.luna.ms.jifen.base.domain.IntegralGoods@SHELF_OFF}
</if>
where
uid
IN
<foreach collection="list" item="item" index="index" open="(" separator="," close=")">
#{item}
</foreach>
</update>
动态sql 用标签if test
最新推荐文章于 2023-04-16 23:16:27 发布