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

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