SpringDataJPA如何CRUD?

精选30+云产品，助力企业轻松上云！>>>

1.引入jpa依赖

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

2.创建application.yml

spring:
  datasource:
    url: jdbc:mysql://localhost/bike?serverTimezone=UTC
    username: root
    password: 123456
    driver-class-name: com.mysql.jdbc.Driver
#更新自己数据表结构 控制台看到sql
  jpa:
    hibernate:
      ddl-auto: update
    show-sql: true

3.创建实体类User.java

@Entity //配置JPA映射关系 和数据表映射
@Table(name = "tbl_user") //和数据库表对应，没写的话时默认类名小写
public class User  {

    @Id //标记主键
    @GeneratedValue(strategy = GenerationType.IDENTITY) //自主键
    private Integer id;

    @Column(name = "last_name",length = 50)//和数据表相对应的列
    private String lastName;
    @Column //省略的话默认就是属性名
    private String email;

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", lastName='" + lastName + '\'' +
                ", 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;
    }
}

4.创建UserJpaReposity接口

//通过JpaRepository 来完成对数据库的操作 DAO
public interface UserResposity extends JpaRepository<User,Integer> {
}

5.UserController.java

public class UserController {

    @Autowired
    UserResposity userResposity;

    @GetMapping("/user/{id}")
    public User getUser(@PathVariable("id") Integer id){
        User user = userResposity.getOne(id);
        return user;
    }

    @GetMapping("/user")
    public User insertUser(User user){
        User save = userResposity.save(user);
        return save;
    }
}