spring--boot数据库增删改查

1 spring:
2 datasource:
3 driver-class-name: com.mysql.jdbc.Driver
4 url: jdbc:mysql://localhost:3306/dbgirl
5 username: root
6 password: root
7 jpa:
8 hibernate:
9 ddl-auto: update
10 show-sql: true

package com.girl; 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; /**
* 获取所有的女生列表
*
* @return
*/
@GetMapping(value = "/girls")
public List<Girl> getAllGirl() {
return girlRepository.findAll();
}

@PutMapping(value = "/girls/{id}")
public Girl girlUpdate(@PathVariable("id") Integer id, @RequestParam("cupSize") String cupSize, @RequestParam("age") Integer age) { Girl girl = new Girl();
girl.setId(id);
girl.setCupSize(cupSize);
girl.setAge(age); return girlRepository.save(girl);
}

@DeleteMapping(value = "/girls/{id}")
public void girlDelete(@PathVariable("id") Integer id) {
girlRepository.deleteById(id);
}

/**
* 添加一个女生
*
* @param cupSize
* @param age
* @return
*/
@PostMapping(value = "/girls")
public Girl girlAdd(@RequestParam("cupSize") String cupSize, @RequestParam("age") Integer age) {
Girl girl = new Girl();
girl.setCupSize(cupSize);
girl.setAge(age);
return girlRepository.save(girl);
}