关于 多个值不同的处理 比如channelid 为空和非空的处理

引用

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