3.0.6版本无效,重点:写xml的sql处理即可!!
https://jiuaidu.com/it/1940569/
https://www.likecs.com/show-205098899.html
```sql
<update id="updateAreaOne">
update tab_lmdm_sys_area
<set>
<!-- <if test="sysArea.id != null">-->
<!-- ID = #{sysArea.id,jdbcType=DECIMAL},-->
<!-- </if>-->
<if test="sysArea.parentId == null">
PARENT_ID = null,
</if>
<if test="sysArea.parentId != null">
PARENT_ID = #{sysArea.parentId,jdbcType=DECIMAL},
</if>
<if test="sysArea.countryId != null">
COUNTRY_ID = #{sysArea.countryId,jdbcType=DECIMAL},
</if>
<if test="sysArea.code != null">
CODE = #{sysArea.code,jdbcType=VARCHAR},
</if>
<if test="sysArea.internationalCode != null">
INTERNATIONAL_CODE = #{sysArea.internationalCode,jdbcType=VARCHAR},
</if>
<if test="sysArea.threeCode != null">
THREE_CODE = #{sysArea.threeCode,jdbcType=VARCHAR},
</if>
<if test="sysArea.type != null">
"TYPE" = #{sysArea.type,jdbcType=DECIMAL},
</if>
<if test="sysArea.cnName != null">
CN_NAME = #{sysArea.cnName,jdbcType=VARCHAR},
</if>
<if test="sysArea.enName != null">
EN_NAME = #{sysArea.enName,jdbcType=VARCHAR},
</if>
<if test="sysArea.abbreviation != null">
ABBREVIATION = #{sysArea.abbreviation,jdbcType=VARCHAR},
</if>
<if test="sysArea.nativeName != null">
NATIVE_NAME = #{sysArea.nativeName,jdbcType=VARCHAR},
</if>
<if test="sysArea.areaNo != null">
AREA_NO = #{sysArea.areaNo,jdbcType=VARCHAR},
</if>
<if test="sysArea.zipcode != null">
ZIPCODE = #{sysArea.zipcode,jdbcType=VARCHAR},
</if>
<if test="sysArea.longitude != null">
LONGITUDE = #{sysArea.longitude,jdbcType=VARCHAR},
</if>
<if test="sysArea.latitude != null">
LATITUDE = #{sysArea.latitude,jdbcType=VARCHAR},
</if>
<if test="sysArea.isEnable != null">
IS_ENABLE = #{sysArea.isEnable,jdbcType=DECIMAL},
</if>
<if test="sysArea.isDelete != null">
IS_DELETE = #{sysArea.isDelete,jdbcType=DECIMAL},
</if>
<if test="sysArea.createBy != null">
CREATE_BY = #{sysArea.createBy,jdbcType=DECIMAL},
</if>
<if test="sysArea.updateBy != null">
UPDATE_BY = #{sysArea.updateBy,jdbcType=DECIMAL},
</if>
<if test="sysArea.createByName != null">
CREATE_BY_NAME = #{sysArea.createByName,jdbcType=VARCHAR},
</if>
<if test="sysArea.updateByName != null">
UPDATE_BY_NAME = #{sysArea.updateByName,jdbcType=VARCHAR},
</if>
<if test="sysArea.createTime != null">
CREATE_TIME = #{sysArea.createTime,jdbcType=TIMESTAMP},
</if>
<if test="sysArea.updateTime != null">
UPDATE_TIME = #{sysArea.updateTime,jdbcType=TIMESTAMP},
</if>
<if test="sysArea.version != null">
VERSION = #{sysArea.version,jdbcType=VARCHAR},
</if>
<if test="sysArea.sort != null">
SORT = #{sysArea.sort,jdbcType=DECIMAL},
</if>
<if test="sysArea.dtbName != null">
DTB_NAME = #{sysArea.dtbName,jdbcType=VARCHAR},
</if>
<if test="sysArea.adCode != null">
AD_CODE = #{sysArea.adCode,jdbcType=VARCHAR},
</if>
<if test="sysArea.noDistrictFlag != null">
NO_DISTRICT_FLAG = #{sysArea.noDistrictFlag,jdbcType=DECIMAL},
</if>
<!-- <if test="sysArea.islandCode != null">-->
<!-- ISLAND_CODE = #{sysArea.islandCode,jdbcType=VARCHAR},-->
<!-- </if>-->
<if test="sysArea.secondCode != null">
SECOND_CODE = #{sysArea.secondCode,jdbcType=VARCHAR},
</if>
<if test="sysArea.isRemote != null">
IS_REMOTE = #{sysArea.isRemote,jdbcType=DECIMAL},
</if>
<if test="sysArea.dataSource != null">
DATA_SOURCE = #{sysArea.dataSource,jdbcType=VARCHAR},
</if>
<if test="sysArea.remark != null">
REMARK = #{sysArea.remark,jdbcType=VARCHAR},
</if>
<!-- <if test="sysArea.nativeNameCapital != null">-->
<!-- NATIVE_NAME_CAPITAL = #{sysArea.nativeNameCapital,jdbcType=VARCHAR},-->
<!-- </if>-->
</set>
where ID = #{sysArea.id,jdbcType=DECIMAL}
and UPDATE_TIME <![CDATA[ <= ]]> #{sysArea.updateTime,jdbcType=TIMESTAMP}
</update>