新增数据时自动添加时间

1、MySql

• 将create_time的类型改为datetime，左下角勾选根据当前时间戳更新，默认值填写为CURRENT_TIMESTAMP

2、SpringBoot Jpa(以userinfo表为例)

@CreatedDate
@Column(name = "createtime",updatable = false,nullable = false)
@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")
private Date createtime;   //添加记录时间

• 并且在XXXApplication中添加@EnableJpaAuditing

@SpringBootApplication
@EnableJpaAuditing
public class XXXApplication {

    public static void main(String[] args) {
        SpringApplication.run(XXXApplication.class, args);
    }

}