Spring|Spring Data JPA实现持久化存储数据到数据库的示例代码 SpringDataJPA实现持久化存储数据

1.SpringBoot项目整合JPA

1.1 pom.xml依赖
1.2 application配置文件

2.创建实体类

3.启动项目，测试验证

1.SpringBoot项目整合JPA
1.1 pom.xml依赖

1.8UTF-8UTF-82.3.7.RELEASEorg.springframework.bootspring-boot-starter-data-jpaorg.springframework.bootspring-boot-starter-webmysqlmysql-connector-javaruntimeorg.projectlomboklombokorg.springframework.bootspring-boot-starter-testtestorg.junit.vintagejunit-vintage-engineorg.springframework.bootspring-boot-dependencies${spring-boot.version}pomimport

1.2 application配置文件
application.yml文件如下

# 应用名称spring:application:name: springboot-jpa01# jpa参数配置jpa:database: MySQLdatabase-platform: org.hibernate.dialect.MySQL5InnoDBDialectshow-sql: truehibernate:ddl-auto: update# 运行环境设置profiles:active: dev# 应用服务 WEB 访问端口server:port: 8080

application-dev.yml文件如下

# 应用名称spring:datasource:driver-class-name: com.mysql.cj.jdbc.Driverurl: jdbc:mysql://localhost:3306/yg-jpa?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&useSSL=false&serverTimezone=GMT%2B8username: rootpassword: root

2.创建实体类创建与数据库表映射的实体类，绑定字段之间的对应关系，如下

package com.kkarma.web.entity; import com.fasterxml.jackson.annotation.JsonFormat; import com.fasterxml.jackson.annotation.JsonIgnore; import lombok.Data; import org.hibernate.annotations.GenericGenerator; import org.springframework.data.annotation.CreatedBy; import org.springframework.data.annotation.CreatedDate; import org.springframework.data.annotation.LastModifiedBy; import org.springframework.data.annotation.LastModifiedDate; import org.springframework.format.annotation.DateTimeFormat; import javax.persistence.*; import java.time.LocalDateTime; /** * @Author: karma * @Date: 2022/3/31 0031 - 03 - 31 - 15:13 * @Description: com.kkarma.web.entity * @version: 1.0 */@Entity@Table(name = "sys_member")@Datapublic class Member {@Id()@GeneratedValue(strategy = GenerationType.IDENTITY)@Column(name = "member_id")private Long memberId; @Column(name = "member_name", unique = true, nullable = false, length = 64)private String memberName; @Column(name = "password", length = 256)@JsonIgnoreprivate String password; @Column(name = "dept_id")private Integer deptId; @Column(name = "realname", length = 64)private String realName; @Column(name = "avatar", length = 500)private String avatar; @Column(name = "phone", length = 11)private String phone; @Column(name = "email", length = 64)private String email; @Column(name = "gender", length = 1)private Integer gender; @CreatedDate@Column(name = "gmt_create", updatable = false)@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")@JsonFormat(shape=JsonFormat.Shape.STRING, pattern="yyyy-MM-dd HH:mm:ss")private LocalDateTime gmtCreate; @CreatedBy@Column(name = "created_by", updatable = false, length = 64)private String createdBy; @LastModifiedDate@Column(name = "gmt_modified")@DateTimeFormat(pattern = "yyyy-MM-dd HH:mm:ss")@JsonFormat(shape=JsonFormat.Shape.STRING, pattern="yyyy-MM-dd HH:mm:ss")private LocalDateTime gmtModified; @LastModifiedBy@Column(name = "updated_by", length = 64)private String updatedBy; @Column(name = "remark", length = 64)private String remark; }

3.启动项目，测试验证启动项目成功之后，会自动在数据库中创建数据库表，如果创建数据库表成功，说明JPA框架继承和配置都是OK的。