<update id="updateUsermainInvcode" parameterType="java.util.List">
<if test="list!=null">
UPDATE usermain
<trim prefix="set" suffixOverrides=",">
<trim prefix="code =case" suffix="end,">
<foreach collection="list" item="data" index="index">
<if test="data.userid != null">
when userid=#{data.userid} then #{data.code}
</if>
</foreach>
</trim>
</trim>
where
<foreach collection="list" separator="or" item="data" index="index" > userid=#{data.userid} </foreach>
</if>
</update>
mybatis批量更新list
最新推荐文章于 2022-08-18 16:25:49 发布