springboot整合JPA的快速使用

这是项目结构：

先导入依赖

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

其次配置yml文件：

spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/db?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
    username: root
    password: root
  jpa:
    database: mysql
    show-sql: true
    hibernate:
      ddl-auto: update

创建一个对应数据库表的实体类

@Data//lombok
@Entity
@Table
public class Test {
    @Id//主键
    private Integer id;
    private String name;
    private String pw;
}

创建对应的接口并继承JpaRepository<T,Object>

public interface TestMapper extends JpaRepository<Test,Integer> {
}

最后创建一个controller来调用jpa封装的方法即可

@RestController
public class TestController {
    @Resource
    private TestMapper testMapper;
    @GetMapping("/")
    public String getTests(){
        List<Test> all = testMapper.findAll();
        return JSON.toJSONString(all);
    }
}