比如操作一条数据需要记录操作时间，而接口文档规定传递的参数并没有时间，该怎么做呢？不需要后台传递过来，那么也可以直接在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