<update id="updateAgentOpt" parameterType="java.util.List">
UPDATE gt_agent_day_corr_optstatus
<trim prefix="set" suffixOverrides=",">
<trim prefix="data_source_open =case" suffix="end,">
<foreach collection="list" item="i" index="index">
<if test="i.dataSourceOpen!=null">
when id=#{i.id} then #{i.dataSourceOpen}
</if>
</foreach>
</trim>
<trim prefix="data_source_agent =case" suffix="end,">
<foreach collection="list" item="i" index="index">
<if test="i.dataSourceAgent!=null">
when id=#{i.id} then #{i.dataSourceAgent}
</if>
</foreach>
</trim>
<trim prefix="remark =case" suffix="end,">
<foreach collection="list" item="i" index="index">
<if test="i.remark!=null">
when id=#{i.id} then #{i.remark}
</if>
</foreach>
</trim>
<trim prefix="update_user =case" suffix="end,">
<foreach collection="list" item="i" index="index">
<if test="i.updateUser!=null">
when id=#{i.id} then #{i.updateUser}
</if>
</foreach>
</trim>
<trim prefix="update_time =case" suffix="end,">
<foreach collection="list" item="i" index="index">
<if test="i.updateTime!=null">
when id=#{i.id} then #{i.updateTime}
</if>
</foreach>
</trim>
</trim>
where
<foreach collection="list" separator="or" item="i" index="index" >
id=#{i.id}
</foreach>
</update>
mybatis 进行批量更新操作
最新推荐文章于 2024-08-23 17:37:30 发布