MySQL配置指南

• 在build.gradel或者pox.xml中引入依赖包:

  dependencies {
  ...
  compile('mysql:mysql-connector-java')
  }
  

• 在application.yml中配置数据库连接方式.

  spring:
  datasource:
  driver-class-name: com.mysql.jdbc.Driver
  url: jdbc:mysql://127.0.0.1:3306/demo
  username: root
  password: ""
  jpa:
  hibernate:
    ddl-auto: update
    show-sql: true
  

• 通常采用JPA对MYSQL进行操作，因此

  import javax.persistence.Entity;
  import javax.persistence.GeneratedValue;
  import javax.persistence.Id;
  @Entity
  public class Girl {
  @Id
  @GeneratedValue
  private Integer girlId;
  private String username;
  public Girl() {
  }
  public Integer getGirlId() {
      return girlId;
  }
  public void setGirlId(Integer girlId) {
      this.girlId = girlId;
  }
  public String getUsername() {
      return username;
  }
  public void setUsername(String username) {
      this.username = username;
  }
  }
  

• 需要创建一个继承JpaRepository的接口

  import org.springframework.data.jpa.repository.JpaRepository;
  interface GirlRepository extends JpaRepository<Girl, Integer> {}
  

• 控制器中调用

  import org.springframework.beans.factory.annotation.Autowired;
  import org.springframework.web.bind.annotation.*;
  import java.util.List;
  @RestController
  public class GirlController {
  @Autowired
  private GirlRepository girlRepository;
  @GetMapping("/girls")
  public List<Girl> getGirlList() {
      return girlRepository.findAll();
  }
  }