<if test="REGIS_DATE != null and REGIS_DATE != '' ">
REGIS_DATE = #{REGIS_DATE,jdbcType=DATE},
</if>
<if test>标签中的and 不能大写,否则会报错。当将上述代码改为:
<if test="REGIS_DATE != null AND REGIS_DATE != '' ">
REGIS_DATE = #{REGIS_DATE,jdbcType=DATE},
</if>
会报错,参考下面博客。https://blog.csdn.net/GYF211/article/details/88661980