mybatis 批量修改

  <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>