Spring Boot 中 Spring Data JPA
JPA是一个基于对象关系映射的标准规范。本文将介绍Spring Boot 与数据库相关简单操作的案例:
1、实战:
1、application.properties
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/test
spring.datasource.username=root
spring.datasource.password=wu25471396
#hibernate 提供了根据实体类自动维护数据库表结构的功能
spring.jpa.hibernate.ddl-auto=update
# 在控制台显示sql语句
spring.jpa.show-sql=true
# 让输出的Json字符串更美观
spring.jackson.serialization.indent-output=true
2、定义映射实体类
Hibernate支持自动将实体类映射为数据表格
@Entity //表明这是一个与数据库表映射的实体
@NamedQuery(name = "Person.withNameAndAddressNamedQuery",
query = "select p from Person p where p.name=?1 and address=?2 ")
public class Person {
@Id //主键
@GeneratedValue //主键自增,Hibernate 会为我们自动生成一个名为HIBERNATE_SEQUEMCE的序列
private Long id;
private String name;
private Integer age;
private String address;
public Person() {
super();
}
public Person(Long id, String name, Integer age, String address) {
super();
this.id = id;
this.name = name;
this.age = age;