Spring Jpa 自动建表——时间字段设置

时间类型

• 推荐使用：
  • 在数据库设置时间类型时，有的使用timestamp ，有的使用datetime，个人推荐使用datetime
  • Java8后，使用LocalDateTime初始化时间，配合注解@JsonFormat格式化时间返回前端使用
• 代码如下

@Entity
@Table(name = "m_test")
@DynamicInsert
@DynamicUpdate
public class TestTable implements Serializable {

    private static final long serialVersionUID = 1L;

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "id", columnDefinition = "BIGINT")
    private Long id;

    @Column(name = "user_name", columnDefinition = "varchar(50) NOT NULL COMMENT '用户名称'")
    private String userName;
    
    @Column(name = "address", columnDefinition = "varchar(50) NOT NULL COMMENT '用户地址'")
    private String address;
    
    @Column(name = "sex", columnDefinition = "tinyint NOT NULL'")
    private Integer sex = 0;

    @JsonFormat
    @Column(name = "cdate", columnDefinition = "DATETIME DEFAULT CURRENT_TIMESTAMP ")
    private LocalDateTime cdate = LocalDateTime.now();

    @JsonFormat
    @Column(name = "mdate", columnDefinition = "DATETIME DEFAULT CURRENT_TIMESTAMP ")
    private LocalDateTime mdate = LocalDateTime.now();

}