<update id="updateCodingTraceCodeBatch" parameterType="java.util.List" >
<foreach item="item" index="index" collection="list" separator=",">
update coding_trace_code
<trim prefix="SET" suffixOverrides=",">
<if test="item.segmentId!= null ">segment_id= #{item.segmentId},</if>
<if test="item.enterpriseId!= null">enterprise_id= #{item.enterpriseId},</if>
<if test="item.updateTime!= null">update_time= #{item.updateTime},</if>
</trim>
where enterprise_id = #{item.enterpriseId}
</foreach>
</update>
mybatis 批量修改
最新推荐文章于 2024-07-23 17:11:44 发布