SpringBoot整合JPA

1.导入相关依赖

<dependency>
     <groupId>org.springframework.boot</groupId>
     <artifactId>spring-boot-starter-data-jdbc</artifactId>
</dependency>
<dependency>
     <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
      <groupId>mysql</groupId>
     <artifactId>mysql-connector-java</artifactId>
</dependency>

2.编写配置文件

spring:
  datasource:
    url: jdbc:mysql://xxxxx:3306/jpa?useUnicode=true&characterEncoding=utf-8&useSSL=true
    username: xxx
    password: xxx
    driver-class-name: com.mysql.cj.jdbc.Driver

    type: com.alibaba.druid.pool.DruidDataSource
      

  jpa:
    hibernate:
      ddl-auto: update  #自动创建表
    show-sql: true

3.编写实体类

import javax.persistence.*;

@Entity
@Table(name="user")
public class User {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY) //主键自增策略
    private Integer id;
    @Column(name="last_name")
    private String lastName;
    @Column  //默认小写
    private String email;

    public User() {
    }

    public User(Integer id, String lastName, String email) {
        this.id = id;
        this.lastName = lastName;
        this.email = 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;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", lastName='" + lastName + '\'' +
                ", email='" + email + '\'' +
                '}';
    }
}

4.编写dao层

public interface UserDao extends JpaRepository<实体类名,主键类型> {
}

5.编写Controller

@RestController
public class UserController {
    @Autowired
    UserDao userDao;
    @RequestMapping("/user")
    public User insert(User user){
        return userDao.save(user);
    }
}

可能遇到的问题：在@Table注解里的值飘红

解决：

1.IDEA连接数据库

2.

3.

 

 

4.选中对应的数据库