【SpringBoot学习】15-SpringData-JPA整合

1、yml配置文件

spring:
  datasource:
    username: root
    password: xxxxx
    url: jdbc:mysql://127.0.0.1:3306/jpa-boot?serverTimezone=GMT%2B8
    driver-class-name: com.mysql.cj.jdbc.Driver
  jpa:
    hibernate:
      ddl-auto: update
    show-sql: true

2、基本依赖

 <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>
<dependency>
   <groupId>mysql</groupId>
     <artifactId>mysql-connector-java</artifactId>
     <scope>runtime</scope>
 </dependency>

3、实体类

/**
 * JPA orm(对象关系映射)模型
 * @author AnQi
 * @date 2020/3/8 11 56:42
 * @description
 */
@Entity  //说明是和数据表映射的类
@Table(name = "tbl_user") //指定对应映射的表明  默认表明为user
public class User {

    @Id //指定主键
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer id;
    @Column(name = "user_name",length = 5) //与数据表对应的一个字段
    private String username;
    @Column//省略不写就是 属性名字
    private String password;

    public Integer getId() {
        return id;
    }

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

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

}

在yml中配置了ddl-auto: update 会自动 创建对应数据库的表 如果修改了实体类 会同时更新表

4、dao接口

/**
 * 自定义接口 继承JpaRepository crud操作 分页排序等功能
 * @author AnQi
 * @date 2020/3/8 13 07:20
 * @description
 */
//指定泛型
    //操作的实体类
    //主键数据类型
public interface UserRepository extends JpaRepository<User,Integer> {}

5、controller层

/**
 * @author AnQi
 * @date 2020/3/8 13 14:28
 * @description
 */
@RestController
public class UserController {
    @Autowired
    UserRepository userRepository;
    @GetMapping("/user/{id}")
    public User getUserById(@PathVariable("id") Integer id){
        Optional<User> byId = userRepository.findById(id);
        User user = byId.get();
        return user;
    }
    @GetMapping("/user")
    public User addUser(User user){
        User save = userRepository.save(user);
        return save;
    }**加粗样式**
}

注意：

使用Innodb引擎才支持事务回滚