mybatis:
<set> <if test="obj.buyerId != null"> buyerId = #{obj.buyerId}, </if> <if test="obj.country != null and obj.country.length() > 0"> country = #{obj.country}, </if> <if test="obj.province != null and obj.province.length() > 0"> province = #{province}, </if> <if test="obj.city != null and obj.city.length() > 0"> city = #{obj.city}, </if> <if test="obj.district != null and obj.district.length() > 0"> district = #{obj.district}, </if> <if test="obj.detailAddress != null and obj.detailAddress.length() > 0"> detail_address = #{obj.detailAddress}, </if> <if test="obj.country != null and obj.country.length() > 0"> country = #{obj.country}, </if> <if test="obj.isDefault != null and obj.isDefault.length() > 0"> isDefault = #{obj.isDefault} </if> </set>
ibatis:
<dynamic prepend="SET"> <isNotEmpty prepend="," property="obj.name"> name = #obj.name# </isNotEmpty> <isNotEmpty prepend="," property="obj.nick"> nick = #obj.nick# </isNotEmpty> <isNotEmpty prepend="," property="obj.lastLoginDate"> last_login_date = #obj.lastLoginDate# </isNotEmpty> <isNotEmpty prepend="," property="obj.weixinUnionId"> weixin_union_id = #obj.weixinUnionId# </isNotEmpty> <isNotEmpty prepend="," property="obj.email"> email = #obj.email# </isNotEmpty> <isNotEmpty prepend="," property="obj.qq"> qq = #obj.qq# </isNotEmpty> <isNotEmpty prepend="," property="obj.weixinOpenId"> weixin_open_id = #obj.weixinOpenId# </isNotEmpty> <isNotEmpty prepend="," property="obj.weixinId"> weixin_id = #obj.weixinId# </isNotEmpty> <isNotEmpty prepend="," property="obj.sessionKey"> session_key = #obj.sessionKey# </isNotEmpty> <isNotEmpty prepend="," property="obj.mobile"> mobile = #obj.mobile# </isNotEmpty> <isNotNull prepend="," property="obj.sex"> sex = #obj.sex# </isNotNull> <isNotEmpty prepend="," property="obj.avatar"> avatar = #obj.avatar# </isNotEmpty> <isNotEmpty prepend="," property="obj.sellerId"> seller_id = #obj.sellerId# </isNotEmpty> <isNotEmpty prepend="," property="obj.shopId"> shop_id = #obj.shopId# </isNotEmpty> <isNotEmpty prepend="," property="obj.mpId"> mp_id = #obj.mpId# </isNotEmpty> <isNotEmpty prepend="," property="obj.city"> city = #obj.city# </isNotEmpty> <isNotEmpty prepend="," property="obj.province"> province = #obj.province# </isNotEmpty> <isNotEmpty prepend="," property="obj.language"> language = #obj.language# </isNotEmpty> <isNotEmpty prepend="," property="obj.country"> country = #obj.country# </isNotEmpty> <isNotEmpty prepend="," property="obj.phoneNumber"> phone_number = #obj.phoneNumber# </isNotEmpty> <isNotEmpty prepend="," property="obj.countryCode"> country_code = #obj.countryCode# </isNotEmpty> <isNotEmpty prepend="," property="obj.memberType"> member_type = #obj.memberType# </isNotEmpty> <isNotEmpty prepend="," property="obj.remark"> remark = #obj.remark# </isNotEmpty> </dynamic>