一 pom
<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 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>org.fkit</groupId>
<artifactId>simplespringdatajpatest</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>jar</packaging>
<name>simplespringdatajpatest</name>
<url>http://maven.apache.org</url>
<!-- spring-boot-starter-parent是Spring Boot的核心启动器, 包含了自动配置、日志和YAML等大量默认的配置,大大简化了我们的开发。
引入之后相关的starter引入就不需要添加version配置, spring boot会自动选择最合适的版本进行添加。 -->
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.0.0.RELEASE</version>
<relativePath />
</parent>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
<java.version>1.8</java.version>
</properties>
<dependencies>
<!-- 添加spring-boot-starter-web模块依赖 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!-- 添加spring-boot-starter-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>
<!-- 添加Spring Data JPA依赖 -->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
</project>
二 启动类
package org.fkit.simplespringdatajpatest;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
public class App
{
public static void main( String[] args )
{
// SpringApplication 用于从main方法启动Spring应用的类。
SpringApplication.run(App.class, args);
}
}
三 持久化类
package org.fkit.simplespringdatajpatest.bean;
import java.io.Serializable;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
@Entity
@Table(name="tb_student")
public class Student implements Serializable{
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private int id;
private String name ;
private String address ;
private int age ;
private char sex;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
public char getSex() {
return sex;
}
public void setSex(char sex) {
this.sex = sex;
}
}
四 控制器
package org.fkit.simplespringdatajpatest.controller;
import java.util.ArrayList;
import java.util.List;
import javax.annotation.Resource;
import org.fkit.simplespringdatajpatest.bean.Student;
import org.fkit.simplespringdatajpatest.service.StudentService;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
@RestController
@RequestMapping("/student")
public class StudentController {
// 注入StudentService
@Resource
private StudentService studentService;
@RequestMapping("/save")
public String save() {
Student swk = new Student();
swk.setAddress("广州");
swk.setName("孙悟空");
swk.setAge(700);
swk.setSex('男');
Student zzj = new Student();
zzj.setAddress("广州");
zzj.setName("蜘蛛精");
zzj.setAge(700);
zzj.setSex('女');
Student nmw = new Student();
nmw.setAddress("广州");
nmw.setName("牛魔王");
nmw.setAge(500);
nmw.setSex('男');
List<Student> students = new ArrayList<>();
students.add(swk);
students.add(zzj);
students.add(nmw);
studentService.saveAll(students);
return "保存学生对象成功";
}
@RequestMapping("/name")
public Student getByName(String name) {
return studentService.getStuByName(name);
}
@RequestMapping("/nameAndAddress")
public List<Student> getByNameAndAddress(String name,String address) {
return studentService.getStusByNameAndAddress(name, address);
}
@RequestMapping("/nameLike")
public List<Student> getByNameLile(String name) {
return studentService.getStusByNameLike(name);
}
}
五 Repository
package org.fkit.simplespringdatajpatest.repository;
import java.util.List;
import org.fkit.simplespringdatajpatest.bean.Student;
import org.springframework.data.jpa.repository.JpaRepository;
public interface StudentRepository extends JpaRepository<Student, Integer> {
/**
* 通过学生姓名来查询学生对象
* 此方法相当于JPQL语句代码:select s from Student s where s.name = ?1
* @param name 参数
* @return Student对象
*/
Student findByName(String name);
/**
* 通过名字和地址查询学生信息
* 此方法相当于JPQL语句代码:select s from Student s where s.name = ?1 and s.address=?2
* @param name
* @param address
* @return 包含Student对象的List集合
*/
List<Student> findByNameAndAddress(String name , String address);
/**
* 通过学生姓名模糊查询学生信息
* 此方法相当于JPQL语句代码:select s from Student s where s.name like ?1
* @param name 参数
* @return 包含Student对象的List集合
*/
List<Student> findByNameLike(String name);
}
六 Service
package org.fkit.simplespringdatajpatest.service;
import java.util.List;
import javax.annotation.Resource;
import org.fkit.simplespringdatajpatest.bean.Student;
import org.fkit.simplespringdatajpatest.repository.StudentRepository;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
@Service
public class StudentService {
// 注入数据访问层接口对象
@Resource
private StudentRepository studentRepository;
@Transactional
public void saveAll(List<Student> students) {
studentRepository.saveAll(students);
}
public Student getStuByName(String name) {
return studentRepository.findByName(name);
}
public List<Student> getStusByNameAndAddress(String name,String address) {
return studentRepository.findByNameAndAddress(name,address);
}
public List<Student> getStusByNameLike(String name) {
return studentRepository.findByNameLike("%"+name+"%");
}
}
七 配置文件
########################################################
### \u6570\u636E\u6E90\u4FE1\u606F\u914D\u7F6E
########################################################
# \u6570\u636E\u5E93\u5730\u5740
spring.datasource.url=jdbc:mysql://localhost:3306/springdatajpa
# \u7528\u6237\u540D
spring.datasource.username=root
# \u5BC6\u7801
spring.datasource.password=
# \u6570\u636E\u5E93\u9A71\u52A8
spring.datasource.driverClassName=com.mysql.jdbc.Driver
# \u6307\u5B9A\u8FDE\u63A5\u6C60\u4E2D\u6700\u5927\u7684\u6D3B\u8DC3\u8FDE\u63A5\u6570.
spring.datasource.max-active=20
# \u6307\u5B9A\u8FDE\u63A5\u6C60\u6700\u5927\u7684\u7A7A\u95F2\u8FDE\u63A5\u6570\u91CF.
spring.datasource.max-idle=8
# \u6307\u5B9A\u5FC5\u987B\u4FDD\u6301\u8FDE\u63A5\u7684\u6700\u5C0F\u503C
spring.datasource.min-idle=8
# \u6307\u5B9A\u542F\u52A8\u8FDE\u63A5\u6C60\u65F6\uFF0C\u521D\u59CB\u5EFA\u7ACB\u7684\u8FDE\u63A5\u6570\u91CF
spring.datasource.initial-size=10
########################################################
### JPA\u6301\u4E45\u5316\u914D\u7F6E
########################################################
# \u6307\u5B9A\u6570\u636E\u5E93\u7684\u7C7B\u578B
spring.jpa.database=MySQL
# \u6307\u5B9A\u662F\u5426\u9700\u8981\u5728\u65E5\u5FD7\u4E2D\u663E\u793Asql\u8BED\u53E5
spring.jpa.show-sql=true
# \u6307\u5B9A\u81EA\u52A8\u521B\u5EFA|\u66F4\u65B0|\u9A8C\u8BC1\u6570\u636E\u5E93\u8868\u7ED3\u6784\u7B49\u914D\u7F6E\uFF0C\u914D\u7F6E\u6210update
# \u8868\u793A\u5982\u679C\u6570\u636E\u5E93\u4E2D\u5B58\u5728\u6301\u4E45\u5316\u7C7B\u5BF9\u5E94\u7684\u8868\u5C31\u4E0D\u521B\u5EFA\uFF0C\u4E0D\u5B58\u5728\u5C31\u521B\u5EFA\u5BF9\u5E94\u7684\u8868
spring.jpa.hibernate.ddl-auto=update
# Naming strategy
# \u6307\u5B9A\u547D\u540D\u7B56\u7565
spring.jpa.hibernate.naming-strategy=org.hibernate.cfg.ImprovedNamingStrategy
# \u6307\u5B9A\u6570\u636E\u5E93\u65B9\u8A00
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
八 测试