mybatis中获取当前时间_mybatis的xml中,时间怎么直接在xml中获取

本文介绍了一种在不改变接口参数的情况下,通过在SQL语句中直接使用now()函数来自动记录操作时间的方法。适用于更新和插入语句,确保了时间戳的准确性和实时性。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

比如操作一条数据需要记录操作时间,而接口文档规定传递的参数并没有时间,该怎么做呢?不需要后台传递过来,那么也可以直接在xml中获取,使用now()。

先看update更新语句

update t_follow_business

OPERATE_TIME = now(),

BUSI_CATEGORY = #{busiCategory,jdbcType=VARCHAR},

BUSI_BRAND = #{busiBrand,jdbcType=VARCHAR},

REG_CAPITAL = #{regCapital,jdbcType=DECIMAL},

AGEN_LEVEL = #{agenLevel,jdbcType=VARCHAR},

CON_PERSON = #{conPerson,jdbcType=VARCHAR},

CON_PHONE = #{conPhone,jdbcType=VARCHAR},

AREA_POS = #{areaPos,jdbcType=VARCHAR},

ENTER_DATE = #{enterDate,jdbcType=DATE},

FOLLOW_PERSON = #{followPerson,jdbcType=VARCHAR},

FOLLOW_CASE = #{followCase,jdbcType=VARCHAR},

STATUS = #{status,jdbcType=INTEGER},

OPERATOR = #{operator,jdbcType=VARCHAR},

where BUSINESS_ID = #{businessId,jdbcType=VARCHAR} AND STATUS=101001;

update t_follow_business

set BUSI_CATEGORY = #{busiCategory,jdbcType=VARCHAR},

BUSI_BRAND = #{busiBrand,jdbcType=VARCHAR},

REG_CAPITAL = #{regCapital,jdbcType=DECIMAL},

AGEN_LEVEL = #{agenLevel,jdbcType=VARCHAR},

CON_PERSON = #{conPerson,jdbcType=VARCHAR},

CON_PHONE = #{conPhone,jdbcType=VARCHAR},

AREA_POS = #{areaPos,jdbcType=VARCHAR},

ENTER_DATE = #{enterDate,jdbcType=DATE},

FOLLOW_PERSON = #{followPerson,jdbcType=VARCHAR},

FOLLOW_CASE = #{followCase,jdbcType=VARCHAR},

STATUS = #{status,jdbcType=INTEGER},

OPERATOR = #{operator,jdbcType=VARCHAR},

OPERATE_TIME = now()

where BUSINESS_ID = #{businessId,jdbcType=VARCHAR} AND STATUS=101001;

插入语句

insert into t_follow_business

BUSINESS_ID,

BUSI_CATEGORY,

BUSI_BRAND,

REG_CAPITAL,

AGEN_LEVEL,

CON_PERSON,

CON_PHONE,

AREA_POS,

ENTER_DATE,

FOLLOW_PERSON,

FOLLOW_CASE,

STATUS,

OPERATOR,

OPERATE_TIME

#{businessId,jdbcType=VARCHAR},

#{busiCategory,jdbcType=VARCHAR},

#{busiBrand,jdbcType=VARCHAR},

#{regCapital,jdbcType=DECIMAL},

#{agenLevel,jdbcType=VARCHAR},

#{conPerson,jdbcType=VARCHAR},

#{conPhone,jdbcType=VARCHAR},

#{areaPos,jdbcType=VARCHAR},

#{enterDate,jdbcType=DATE},

#{followPerson,jdbcType=VARCHAR},

#{followCase,jdbcType=VARCHAR},

#{status,jdbcType=INTEGER},

#{operator,jdbcType=VARCHAR},

now()

思考:这条sql语句是查询表里符合条件的记录数

select count(*)

from t_follow_business

status=101001

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值