Springboot集成Spring data jpa（一）

Springboot集成Spring data jpa核心接口详解（二）
Springboot集成Spring data jpa映射关系（三）

1、引入依赖

<?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>2.1.13.RELEASE</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>
	<groupId>com.example</groupId>
	<artifactId>jpademo</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<name>jpademo</name>
	<description>Demo project for Spring Boot</description>

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

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

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

		<!-- 引入web依赖 -->
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>
		<!-- 引入thymeleaf依赖 -->
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-thymeleaf</artifactId>
		</dependency>
		<!-- 引入mysql依赖 -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
		</dependency>
		<!-- 引入druid连接池依赖 -->
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid</artifactId>
			<version>1.1.10</version>
		</dependency>
		<!-- 引入lombok -->
		<dependency>
			<groupId>org.projectlombok</groupId>
			<artifactId>lombok</artifactId>
			<version>1.16.20</version>
		</dependency>
		<!-- 引入Springdata jpa -->
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-data-jpa</artifactId>
		</dependency>
	</dependencies>

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

</project>

2、创建实体类

package com.example.jpademo.entity;

import lombok.Data;
import lombok.EqualsAndHashCode;

import javax.persistence.*;


/**
 * @Data是lombok插件注解
 * @Entity表示这是一个实体类
 * @Table表示表明
 * @Id表示主键
 * @GeneratedValue表示主键生成策略
 * @Column表示列名
 *
 */
@Data
@Entity
@Table(name = "t_userInfo")
public class UserInfo {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "id")
    private Long id;

    @Column(name = "username")
    private String username;

    @Column(name = "password")
    private String password;

    @Column(name = "age")
    private int age;

    @Column(name = "phone")
    private String phone;

}

3、编写接口

package com.example.jpademo.dao;

import com.example.jpademo.entity.UserInfo;
import org.springframework.data.jpa.repository.JpaRepository;


/**
 *  JpaRepository接收实体对象名称和ID类型
 */
public interface UserInfoRepository extends JpaRepository<UserInfo,Long> {


}

4、application.properties配置

# 配置数据库连接
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/testdb?useUnicode=true&characterEncoding=utf8&serverTimezone=UTC
spring.datasource.username=root
spring.datasource.password=root

# 指定数据源类型
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource

# 开启正向工程，自动创建表
spring.jpa.hibernate.ddl-auto=update
# 控制台打印sql语句日志
spring.jpa.show-sql=true

5、单元测试

package com.example.jpademo;

import com.example.jpademo.dao.UserInfoRepository;
import com.example.jpademo.entity.UserInfo;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

@RunWith(SpringRunner.class)
@SpringBootTest
public class JpademoApplicationTests {

	@Autowired
	private UserInfoRepository userInfoRepository;

	/**
	 * 测试新增
	 */
	@Test
	public void testSave(){
		UserInfo info = new UserInfo();
		//id自动生成
		info.setUsername("jack");
		info.setPassword("887766");
		info.setAge(25);
		info.setPhone("13894579876");
		this.userInfoRepository.save(info);
	}

}