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

< properties >

         < java.version >1.8</ java.version >

         < project.build.sourceEncoding >UTF-8</ project.build.sourceEncoding >

         < project.reporting.outputEncoding >UTF-8</ project.reporting.outputEncoding >

         < spring-boot.version >2.3.7.RELEASE</ spring-boot.version >

     </ properties >

     < dependencies >

         < dependency >

             < groupId >org.springframework.boot</ groupId >

             < artifactId >spring-boot-starter-data-jpa</ artifactId >

         </ dependency >

         < dependency >

             < groupId >org.springframework.boot</ groupId >

             < artifactId >spring-boot-starter-web</ artifactId >

         </ dependency >

         < dependency >

             < groupId >mysql</ groupId >

             < artifactId >mysql-connector-java</ artifactId >

             < scope >runtime</ scope >

         </ dependency >

         < dependency >

             < groupId >org.projectlombok</ groupId >

             < artifactId >lombok</ artifactId >

         </ dependency >

         < dependency >

             < groupId >org.springframework.boot</ groupId >

             < artifactId >spring-boot-starter-test</ artifactId >

             < scope >test</ scope >

             < exclusions >

                 < exclusion >

                     < groupId >org.junit.vintage</ groupId >

                     < artifactId >junit-vintage-engine</ artifactId >

                 </ exclusion >

             </ exclusions >

         </ dependency >

     </ dependencies >

     < dependencyManagement >

         < dependencies >

             < dependency >

                 < groupId >org.springframework.boot</ groupId >

                 < artifactId >spring-boot-dependencies</ artifactId >

                 < version >${spring-boot.version}</ version >

                 < type >pom</ type >

                 < scope >import</ scope >

             </ dependency >

         </ dependencies >

     </ dependencyManagement >

# 应用名称

spring:

   application:

     name: springboot-jpa01

   # jpa参数配置

   jpa:

     database: MySQL

     database-platform: org.hibernate.dialect.MySQL5InnoDBDialect

     show-sql: true

     hibernate:

       ddl-auto: update

   # 运行环境设置

   profiles:

     active: dev

# 应用服务 WEB 访问端口

server:

   port: 8080

# 应用名称

spring:

   datasource:

     driver-class-name: com.mysql.cj.jdbc.Driver

     url: jdbc:mysql://localhost:3306/yg-jpa?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&allowMultiQueries=true&useSSL=false&serverTimezone=GMT%2B8

     username: root

     password: root

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" )

@Data

public 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 )

     @JsonIgnore

     private 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;

}