jpa
是JavaEE定义的一种规范,常用的实现一般是Hibernate
,而spring-data-jpa
则是对jpa
的又一层封装,提供了更多便捷的方法。
这里不会深入讲解spring-data-jpa的使用,只是讲解怎么快速的整合使用,目的是帮助那些想学,但是在整合上老是翻车的同学
导入依赖
<dependency> <groupId>com.zaxxer</groupId> <artifactId>HikariCP</artifactId> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-data-jpa</artifactId> </dependency>
配置
spring: data: jpa: repositories: # 开启jpa enabled: true bootstrap-mode: default jpa: # 数据库方言 database-platform: org.hibernate.dialect.MySQL57Dialect open-in-view: false # 打印SQL show-sql: false properties: # 格式化输出的SQL语句 hibernate.format_sql: false hibernate: # 自动建表策略 ddl-auto: update
这里忽略了数据源的配置
关于自动建表策略
# 枚举值 spring.jpa.hibernate.ddl-auto create 不管表是否存在, 每次启动都会重新建表(会导致数据丢失) create-drop 启动的时候创建表, 程序退出(SessionFactory关闭)的时候删除表 none 不进行任何操作 update 如果数据表不存在则创建, 在实体对象被修改后,下次启动重新修改表结构(不会删除已经存在的数据) validate 启动的时候验证数据表的结构,
相关的配置类
这里仅仅列出了部分常用的配置,如果需要了解所有的配置信息,可以参考配置类
JpaProperties SpringDataWebProperties HibernateProperties
相关配置的文档docs.spring.io/spring-boot…
定义实体类User
import java.io.Serializable; import java.time.LocalDateTime; import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.Enumerated; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.Index; import javax.persistence.Table; // 指定表名称 @Table(name = "user", indexes = { // 定义索引 @Index(columnList = "account", unique = true) }) // 标识实体类 @Entity // 设置表注释 @org.hibernate.annotations.Table(appliesTo = "user", comment = "用户") public c<b>本文来源gao@dai!ma.com搞$代^码!网7</b>lass User implements Serializable { /** * */ private static final long serialVersionUID = 4953012795378725917L; @Id // id 字段 @Column(columnDefinition = "INT(11) UNSIGNED COMMENT 'id'") @GeneratedValue(strategy = GenerationType.IDENTITY) // 自增 private Integer id; // 账户 @Column(columnDefinition = "VARCHAR(50) COMMENT '登录账户'", nullable = false) private String account; // 密码 @Column(columnDefinition = "VARCHAR(255) COMMENT '登录密码'", nullable = false) private String password; // 性别 @Column(columnDefinition = "TINYINT(1) COMMENT '性别。0:男,1:女'", nullable = false) @Enumerated private Gender gender; // 创建时间 @Column(name = "created_date", columnDefinition = "timestamp DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间'", nullable = false) private LocalDateTime createdDate; // 最后修改时间 @Column(name = "last_modified_date", columnDefinition = "timestamp NULL DEFAULT NULL COMMENT '最后一次修改时间'") private LocalDateTime lastModifiedDate; // 记录状态 @Column(columnDefinition = "TINYINT(1) unsigned COMMENT '是否启用'", nullable = false) private Boolean enabled; public Integer getId() { return id; } public void setId(Integer id) { this.id = id; } public String getAccount() { return account; } public void setAccount(String account) { this.account = account; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public Gender getGender() { return gender; } public void setGender(Gender gender) { this.gender = gender; } public LocalDateTime getCreatedDate() { return createdDate; } public void setCreatedDate(LocalDateTime createdDate) { this.createdDate = createdDate; } public LocalDateTime getLastModifiedDate() { return lastModifiedDate; } public void setLastModifiedDate(LocalDateTime lastModifiedDate) { this.lastModifiedDate = lastModifiedDate; } public Boolean getEnabled() { return enabled; } public void setEnabled(Boolean enabled) { this.enabled = enabled; } @Override public String toString() { return "User [id=" + id + ", account=" + account + ", password=" + password + ", gender=" + gender + ", createdDate=" + createdDate + ", lastModifiedDate=" + lastModifiedDate + ", enabled=" + enabled + "]"; } public static enum Gender { BOY, GIRL } }