springboot mybatis plus 创建、更新时间戳

---

mybatis plus 创建、更新时间戳

 

 

************************

示例

 

数据库添加字段

create_time：类型为timestamp，默认值current_timestamp

update_time：类型为timestamp，默认值为current_timestamp，且设为自动更新

 

******************

pojo 层

 

User

@Data
public class User extends Model<User> {

    private static final long serialVersionUID=1L;

    @TableId(value = "id", type = IdType.AUTO)
    private Integer id;

    private String name;

    private Integer age;

    private Sex sex;

    private LocalDateTime createTime;

    private LocalDateTime updateTime;

}

 

******************

controller层 

 

UserController

@RestController
@RequestMapping("/user")
public class UserController {

    @Autowired
    private UserService userService;

    @RequestMapping("/save")
    public User save(){
        User user=new User();
        user.setName("瓜田李下");
        user.setAge(23);
        user.setSex(Sex.Female);

        userService.save(user);

        return userService.getById(user.getId());
    }

    @RequestMapping("/update")
    public User update(){
        User user=userService.getById(4);
        user.setName("海贼王");

        userService.updateById(user);

        return userService.getById(user.getId());
    }
}

 

 

************************

插入更新测试