在进行更新于插入操作时一般需要用到一些公共字段的自动填充,例如updateTime,在使用mybatis时一般我们是通过AOP技术来实现的,在mybatisplus中我们通过自定义一个实现了MetaObjectHandler类相关方法的类比如MyMetaObjectHandler并配合@TableField来实现公共字段的自动填充
首先对应的实体类中的队友字段要加上@TableField注解
这个是自定义的MyMetaObjectHandler
package com.sky.handler;
import com.baomidou.mybatisplus.core.handlers.MetaObjectHandler;
import com.sky.context.BaseContext;
import org.apache.ibatis.reflection.MetaObject;
import org.springframework.stereotype.Component;
import java.time.LocalDateTime;
@Component
public class MyMetaObjectHandler implements MetaObjectHandler {
@Override
public void insertFill(MetaObject metaObject) {
// 在插入操作时,自动填充 createTime 和createUser
this.strictInsertFill(metaObject, "createTime", LocalDateTime.class, LocalDateTime.now());
this.strictInsertFill(metaObject,"createUser",Long.class, BaseContext.getCurrentId());
}
@Override
public void updateFill(MetaObject metaObject) {
// 在更新操作时,自动填充 updateTime 字段和updateUser字段
this.strictUpdateFill(metaObject, "updateTime", LocalDateTime.class, LocalDateTime.now());
this.strictUpdateFill(metaObject,"updateUser",Long.class, BaseContext.getCurrentId());
}
}
最后mybatisplus就能进行自动填充了,但是得注意更新的方法中得多一个实体类型的参数,不然自动填充将会失效
@ApiOperation("新增员工")
@PostMapping()
public Result addEmployee(@RequestBody EmployeeDTO employeeDTO){
log.info("新增员工,{}",employeeDTO);
Employee employee = new Employee();
// 每一个员工会有一个默认的初始密码 123456 进行MD5加密后存入数据库
BeanUtils.copyProperties(employeeDTO,employee);
String password = "123456";
password = DigestUtils.md5DigestAsHex(password.getBytes());
employee.setPassword(password);
DigestUtils.md5DigestAsHex(employee.getPassword().getBytes());
iEmployeeService.save(employee);
return Result.success();
}
@ApiOperation("编辑员工信息")
@PutMapping()
public Result updateEmployee(@RequestBody EmployeeDTO employeeDTO){
log.info("编辑员工信息,{}",employeeDTO);
Employee employee = new Employee();
BeanUtils.copyProperties(employeeDTO,employee);
UpdateWrapper<Employee> wrapper = new UpdateWrapper<Employee>()
.eq("id",employee.getId())
.set("id_number",employee.getIdNumber())
.set("name",employee.getName())
.set("phone",employee.getPhone())
.set("sex",employee.getSex())
.set("username",employee.getUsername());
// 注意这里得多一个employee实体参数,不然自动填充将会失效
iEmployeeService.update(employee,wrapper);
return Result.success();
}