关于多个值不同的处理比如channelid 为空和非空的处理-优快云博客

本文详细解析了一个使用MyBatis实现的更新语句，该语句通过多个条件判断来决定是否更新指定字段，并展示了如何根据不同参数进行灵活的数据更新操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[quote]

<update id="update" parameterType="com.zyd.orders.placeorder.model.SalesmanDO">
update
salesman
<set>
<if test="salesmanName != null and salesmanName != ''"> salesman_name = #{salesmanName}, </if>
<if test="idNo != null"> id_no = #{idNo}, </if>
<if test="idType != null"> id_type = #{idType}, </if>
<if test="status != null and status != ''"> status = #{status}, </if>
<if test="phoneNo != null and phoneNo != ''"> phone_no = #{phoneNo}, </if>
<if test="channelId != null "> channel_id = #{channelId}, </if>
<if test="channelId == null "> channel_id = null, </if>
<if test="profession != null and profession != ''"> profession = #{profession}, </if>
<if test="contactAddress != null and contactAddress != ''"> contact_address = #{contactAddress}, </if>
<if test="email != null and email != ''"> email = #{email}, </if>
<if test="memo != null and memo != ''"> memo = #{memo}, </if>
<if test="registerDate != null "> register_date = #{registerDate}, </if>
<if test="updateBy != null"> update_by = #{updateBy}, </if>
<if test="password != null"> password = #{password}, </if>
<if test="loginTotalTimes != null"> login_total_times = #{loginTotalTimes}, </if>
update_time = CURRENT_TIMESTAMP
</set>
where
salesman_id = #{salesmanId}

</update>

[/quote]