关于 多个值不同的处理 比如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]

最后

以上就是冷艳香水为你收集整理的关于 多个值不同的处理 比如channelid 为空和非空的处理的全部内容，希望文章能够帮你解决关于 多个值不同的处理 比如channelid 为空和非空的处理所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。