Jpa与SB整合

pom.xml

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

<dependency>
            <groupId>com.mysql</groupId>
            <artifactId>mysql-connector-j</artifactId>
            <scope>runtime</scope>
</dependency>

application.yml

#数据库连接
spring:
  datasource:
    url: jdbc:mysql://192.168.1.38:3306/handlejpa?useUnicode=true&zeroDateTimeBehavior=convertToNull&autoReconnect=true&characterEncoding=utf-8
    username: root
    password: 1
    driver-class-name: com.mysql.cj.jdbc.Driver
  jpa:
    hibernate:
      ddl-auto: create
#    jpa配置
    show-sql: true

User.java

package com.uos.handlejpa.dao;

import lombok.Data;

import javax.persistence.*;

@Data
@Entity
@Table(name="users")
public class User {
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Id
    private Long id;
    @Column(length = 64)
    private String name;
    @Column(length = 64)
    private String password;
    private int age;

    public User() {
    }

    public User(String name, String password, int age) {
        this.name = name;
        this.password = password;
        this.age = age;
    }
}

UserRespository.java

package com.uos.handlejpa.services;

import com.uos.handlejpa.dao.User;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;

@Repository
public interface UserRespository extends JpaRepository<User,Long> {
}

单元测试

package com.uos.handlejpa;

import com.uos.handlejpa.dao.User;
import com.uos.handlejpa.services.UserRespository;
import org.junit.jupiter.api.Test;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;

import javax.annotation.Resource;

@SpringBootTest
class HandleJpaApplicationTests {
    @Autowired
    private UserRespository userRespository;
    @Test
    void contextLoads() {
    }

    @Test
    void contextLoadsAddUser() {
        User user=new User("uos","123",18);
        userRespository.save(user);
    }

    @Test
    void contextLoadsUpdate() {
        User user=userRespository.findById(1L).get();
        user.setPassword("abc");
        userRespository.save(user);
    }

    @Test
    void contextLoadsDelete() {
        User user=new User("uos","123",18);
        userRespository.delete(user);
    }

    @Test
    void contextLoadsSelects() {
        userRespository.findById(1L);
    }
}