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

  <dependency>
    <groupId>MySQL</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <scope>runtime</scope>
  </dependency>

#修改tomcat默認(rèn)端口號(hào)
server.port=8090

#配置數(shù)據(jù)源信息
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://192.168.0.1:3306/test
spring.datasource.username=root
spring.datasource.password=123456
#配置jpa
spring.jpa.hibernate.ddl-auto=update
spring.jpa.show-sql=true
spring.jackson.serialization.indent_output=true

/**
 * 注意：
 * 1.這里這里是interface，不是class
 * 2.CrudRepository里面的泛型，第一個(gè)是實(shí)體類，第二個(gè)是主鍵的類型
 */
public interface UserRepository extends CrudRepository<User, Integer> {
  @Query("from User where id =:id ")
  public User getUser(@Param("id") Integer id);
}

@Entity
@Table(name = "user")
public class User {

  @Id
  @GeneratedValue(strategy = GenerationType.AUTO)
  private Integer id;
  private String name;
  private String password;

  public Integer getId() {
    return id;
  }
  public void setId(Integer id) {
    this.id = id;
  }
  public String getName() {
    return name;
  }
  public void setName(String name) {
    this.name = name;
  }
  public String getPassword() {
    return password;
  }
  public void setPassword(String password) {
    this.password = password;
  }
}

@RestController
public class UserController {
  @Autowired
  UserService service;
  /**
   * 根據(jù)id 查詢
   */
  @RequestMapping("/getUser/{id}")
  public User getUser(@PathVariable("id") Integer id) {
    return service.getUser(id);
  }

  /**
   * 根據(jù)id 刪除
   */
  @RequestMapping("/deleteUser/{id}")
  public String deleteUser(@PathVariable("id") Integer id) {
    service.deleteUser(id);
    return "刪除成功！";
  }
}