SpringBoot+JPA构建Rest接口服务

最新推荐文章于 2023-11-26 15:31:22 发布

原创

最新推荐文章于 2023-11-26 15:31:22 发布 · 313 阅读

4 ·

CC 4.0 BY-SA版权

本文介绍如何使用SpringBoot结合JPA实现一个简单的增删改查应用，包括环境搭建、依赖配置、实体类定义、Repository接口创建及RESTful API设计。

项目版本

JDK 1.8
SpringBoot 2.5.1
JPA 2.3.0
MySQL 8

创建项目

添加依赖

<!-- web-->
<dependency>
  <groupId>org.springframework.boot</groupId>
  <artifactId>spring-boot-starter-web</artifactId>
</dependency>

<!-- jpa-->
<dependency>
  <groupId>org.springframework.boot</groupId>
  <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>

<!-- mysql -->
<dependency>
  <groupId>mysql</groupId>
  <artifactId>mysql-connector-java</artifactId>
  <scope>runtime</scope>
</dependency>

数据库语句

DROP TABLE IF EXISTS `departments`;
CREATE TABLE `departments` (
  `dept_no` char(4) NOT NULL,
  `dept_name` varchar(40) NOT NULL,
  PRIMARY KEY (`dept_no`),
  UNIQUE KEY `dept_name` (`dept_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

配置数据源

server:
  port: 8082

spring:
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/test?characterEncoding=UTF-8&useSSL=false
    username: root
    password: 123456
    driver-class-name: com.mysql.jdbc.Driver
  jpa:
    hibernate:
      ddl-auto: update
    show-sql: true
    database-platform: org.hibernate.dialect.MySQL5InnoDBDialect

数据模型

@Entity
@Table(name="departments")
public class Departments {
   
   

    @Ids
    @Column(name = "dept_no")
    private String deptNo;

    @Column(name="dept_name")
    private String deptName;

    public Departments() {
   
   
    }

    public Departments(String deptNo, String deptName) {
   
   
        this.deptNo = deptNo;
        this.deptName = deptName;
    }

    public String getDeptNo() {
   
   
        return deptNo;
    }

    public String getDeptName</