Spring Boot Database Operations

# Spring Boot Database operation data Source configuration

• Oracle Data Source Configuration

  Reference to "Build Spring Boot project-six"

• MySQL Data Source Configuration

  • Adding dependencies in the POM

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

  • Add the following configuration in the configuration file

    spring.datasource.driver-class-name=com.mysql.jdbc.Driverspring.datasource.url=jdbc:mysql://127.0.0.1:3306/mysqlspring.datasource.username=用户名spring.datasource.password=密码# [create|create-drop|update|validate]spring.jpa.hibernate.ddl-auto=update

Database operations

• Adding entity classes

  @Entity@Table(name = "OMS_USER")public class OmsUser implements Serializable {    private static final long serialVersionUID = 1L;    @Id    private String id;    @Column(name = "DISPLAY_ID")    private String displayId;    public String getId() {        return id;    }    public void setId(String id) {        this.id = id;    }    public String getDisplayId() {        return displayId;    }    public void setDisplayId(String displayId) {        this.displayId = displayId;    }}

  PS: Entity fields that are not mapped into columns, use @Transient annotations.

• Add DAO

  Inherit the JpaRepository class (a simple crud operation is encapsulated).

  public interface OmsUserRepository extends JpaRepository<OmsUser, String> {}

• Test

  @RestController@RequestMapping(value = "/api")public class StudentController {    @Autowired    OmsUserRepository omsUserRepository;    @GetMapping(value = "/user")    public List<OmsUser> getAllUser() {        return this.omsUserRepository.findAll();    }    @GetMapping(value = "/user/{id}")    public OmsUser getUserById(@PathVariable("id") String id) {        return omsUserRepository.findById(id).get();    }}

Spring Boot Database Operations