MySQL MyBatis 默认插入当前时间

最新推荐文章于 2024-07-07 18:54:40 发布

在奋斗的大道

最新推荐文章于 2024-07-07 18:54:40 发布

阅读量4.7w

点赞数 3

分类专栏： MyBaties(基础篇)

本文链接：https://blog.csdn.net/zhouzhiwengang/article/details/90176444

版权

MyBaties(基础篇) 专栏收录该内容

70 篇文章 11 订阅

订阅专栏

<!--单表动态更新语句 -->
  <update id="update" parameterType="com.zzg.entity.ColumnValidate">
  		update ucas_bus_column_validate
  		<set>
			<if test="updateBy != null and updateBy != ''">
				  update_by = #{updateBy,jdbcType=VARCHAR},
			</if>
      		<if test="state != null and state != ''">
        		`state` = #{state,jdbcType=VARCHAR},
      		</if>
      		<if test="deleteFlag != null and deleteFlag != ''">
        		delete_flag = #{deleteFlag,jdbcType=VARCHAR},
      		</if>
      		<if test="validateName != null and validateName != ''">
      			 validate_name =  #{validateName,jdbcType=VARCHAR},
      		</if>
      		<if test="validateContent != null and validateContent != ''">
      			 validate_content = #{validateContent,jdbcType=VARCHAR},
      		</if>
      		version = version + 1,
      		update_dt = now()
      	</set>
       	where sid = #{sid,jdbcType=VARCHAR} and version = #{version, jdbcType=INTEGER}
  </update>

重点代码：update_dt = now()