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