mybaties-plus-3.0.6版本设置值null不生效问题

生命几十年3万天

已于 2023-03-11 10:04:32 修改

阅读量196

点赞数

分类专栏：日常记录 mybaties-plus 文章标签： mybaties-plus

于 2023-03-11 00:09:49 首次发布

本文链接：https://blog.csdn.net/qq_25881443/article/details/129457141

版权

日常记录同时被 2 个专栏收录

45 篇文章 0 订阅

订阅专栏

mybaties-plus

1 篇文章 0 订阅

订阅专栏

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>