在开发中当添加数据的时候就需要获取到添加多少条数据来打印日志
例如
主键是自增主键
自增ID
<insert id="insertSelective" useGeneratedKeys="true" keyProperty="pojo.id">
INSERT INTO psxt_trial_doc
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="pojo.id!=null"> `id`,</if>
<if test="pojo.caseId!=null"> `case_id`,</if>
<if test="pojo.name!=null"> `name`,</if>
<if test="pojo.suffix!=null"> `suffix`,</if>
<if test="pojo.status!=null"> `status`,</if>
<if test="pojo.sourceFile!=null"> `source_file`,</if>
<if test="pojo.signFile!=null"> `sign_file`,</if>
<if test="pojo.operator!=null"> `operator`,</if>
<if test="pojo.operatorTime!=null"> `operator_time`,</if>
<if test="pojo.createBy!=null"> `create_by`,</if>
<if test="pojo.gmtCreate!=null"> `gmt_create`,</if>
<if test="pojo.updateBy!=null"> `update_by`,</if>
<if test="pojo.gmtUpdate!=null"> `gmt_update`,</if>
<if test="pojo.tenantId!=null"> `tenant_id`,</if>
<if test="pojo.jzCallbackWsXh!=null"> `jz_callback_ws_xh`,</if>
<if test="pojo.jzPublicWsXh!=null"> `jz_public_ws_xh`,</if>
<if test="pojo.isCallback!=null">`is_callback`</if>
</trim>
VALUES
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="pojo.id!=null"> #{pojo.id},</if>
<if test="pojo.caseId!=null"> #{pojo.caseId},</if>
<if test="pojo.name!=null"> #{pojo.name},</if>
<if test="pojo.suffix!=null"> #{pojo.suffix},</if>
<if test="pojo.status!=null"> #{pojo.status},</if>
<if test="pojo.sourceFile!=null"> #{pojo.sourceFile},</if>
<if test="pojo.signFile!=null"> #{pojo.signFile},</if>
<if test="pojo.operator!=null"> #{pojo.operator},</if>
<if test="pojo.operatorTime!=null"> #{pojo.operatorTime},</if>
<if test="pojo.createBy!=null"> #{pojo.createBy},</if>
<if test="pojo.gmtCreate!=null"> #{pojo.gmtCreate},</if>
<if test="pojo.updateBy!=null"> #{pojo.updateBy},</if>
<if test="pojo.gmtUpdate!=null"> #{pojo.gmtUpdate},</if>
<if test="pojo.tenantId!=null"> #{pojo.tenantId},</if>
<if test="pojo.jzCallbackWsXh!=null"> #{pojo.jzCallbackWsXh},</if>
<if test="pojo.jzPublicWsXh!=null"> #{pojo.jzPublicWsXh},</if>
<if test="pojo.isCallback!=null">#{pojo.isCallback}</if>
</trim>
</insert>
控制层代码:
@PostMapping("/create")
public CommonResult create(Payment payment) {
int result = paymentService.create(payment);
log.info("插入数据的ID:\t" + payment.getId());
log.info("***插入结果:" + result);
if (result > 0) {
return new CommonResult(200, "插入数据成功", result);
} else {
return new CommonResult(444, "插入数据失败", null);
}
}
log信息:
插入数据的ID:4
插入结果:1