SpringBoot：数据访问-整合 spring-boot-starter-data-jpa

点击查看数据访问demo：LearnSpringBoot06DataJPA

Spring Data JPA - Reference 文档

简介

Spring Data的JPA模块包含一个允许定义存储库bean的自定义名称空间。它还包含JPA特有的某些特性和元素属性。通常，可以使用repositories元素来设置JPA存储库:

点击查看更多的SpringBoot教程

一、引入spring-boot-starter-data-jpa

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

二、application.yml配置文件

spring:
  datasource:
    username: root
    password: 123456
    url: jdbc:mysql://192.168.0.103:3307/jpa
    driver-class-name: com.mysql.cj.jdbc.Driver

  jpa:
#    database: mysql
#    database-platform: org.hibernate.dialect.MySQLDialect

    hibernate:
      # 更新或者创建数据表结构
      ddl-auto: update
      #      naming:
      #        physical-strategy: org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl

#    generate-ddl: true 开启逆向工程，存在数据库的表，然后数据库表可以生成实体类，只有在开发阶段设置true
    show-sql: true       # 控制台显示SQL
#    properties:
#      hibernate:
#        hbm2ddl:
#          auto: update

三、使用JPA注解配置映射关系

User.java实体类代码

package com.example.learnspringboot06datajpa.entity;

import jakarta.persistence.*;


//使用JPA注解配置映射关系
@Entity //告诉JPA这是一个实体类（和数据表映射的类）
@Table(name = "tbl_user") //@Table来指定和哪个数据表对应;如果省略默认表名就是user；
public class User {
    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)//自增主键
    private Integer id;
    @Column(name = "last_name ", length = 50)//这是和数据表对应的一个列
    private String lastName;
    @Column //省略默认列名就是属性名
    private String email;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getLastName() {
        return lastName;
    }

    public void setLastName(String lastName) {
        this.lastName = lastName;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }
}

四、创建Repository接口继承JpaRepository来完成对数据库的操作

UserRepository.java接口代码

package com.example.learnspringboot06datajpa.repository;


import com.example.learnspringboot06datajpa.entity.User;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;

//继承JpaRepository来完成对数据库的操作
@Repository
public interface UserRepository extends JpaRepository<User, Integer> {//<T, ID> T代表 entity对象，ID 对应表主键类型
}

五、测试结果

jpa数据库

项目运行后，在浏览器访问http://localhost:8081/user/2

控制台日志

在浏览器访问
http://localhost:8081/user？lastName=test&email=test01@test.com

控制台日志

六、pom.xml代码

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>3.1.1</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>
	<groupId>com.example</groupId>
	<artifactId>LearnSpringBoot06DataJPA</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<name>LearnSpringBoot06DataJPA</name>
	<description>LearnSpringBoot06DataJPA</description>
	<properties>
		<java.version>17</java.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-jdbc</artifactId>-->
<!--		</dependency>-->

		<!--
			改完POM后不生效
			法1：右击POM文件-Maven-Reload project
		-->

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

		<dependency>
			<groupId>com.mysql</groupId>
			<artifactId>mysql-connector-j</artifactId>
			<scope>runtime</scope>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
	</dependencies>

	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
			</plugin>
		</plugins>
	</build>

</project>