Spring Boot数据库操作（下）

一 RESTful API设计

二 获取女生列表

1 GirlController

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

2 GirlRespository

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

3 测试结果

三 创建一个女生

1 GirlController

package com.imooc;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
@RestController
public class GirlController {
     
     @Autowired
     private GirlRepository girlRepository;
     
     @GetMapping(value="/girls")
     public List<Girl> girlList(){
           return girlRepository.findAll();
     }
     
     @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);
     }
}

2 测试结果

四 通过id查询一个女生

1 GirlController

package com.imooc;
import java.util.List;
import javax.websocket.server.PathParam;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
@RestController
public class GirlController {
     
     @Autowired
     private GirlRepository girlRepository;
     
     @GetMapping(value="/girls")
     public List<Girl> girlList(){
           return girlRepository.findAll();
     }
     
     @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);
     }
     
     @GetMapping(value="/girls/{id}")
     public Girl girlFindOne(@PathVariable("id") Integer id)
     {
           return girlRepository.findOne(id);
     }
}

2 测试结果

五 通过id更新一个女生

1 GirlController

package com.imooc;
import java.util.List;
import javax.websocket.server.PathParam;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
@RestController
public class GirlController {
     
     @Autowired
     private GirlRepository girlRepository;
     
     @GetMapping(value="/girls")
     public List<Girl> girlList(){
           return girlRepository.findAll();
     }
     
     @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);
     }
     
     @GetMapping(value="/girls/{id}")
     public Girl girlFindOne(@PathVariable("id") Integer id)
     {
           return girlRepository.findOne(id);
     }
     @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);
           
     }
}

2 测试结果

六 通过id删除一个女生

1 GirlController

package com.imooc;
import java.util.List;
import javax.websocket.server.PathParam;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
@RestController
public class GirlController {
     
     @Autowired
     private GirlRepository girlRepository;
     
     @GetMapping(value="/girls")
     public List<Girl> girlList(){
           return girlRepository.findAll();
     }
     
     @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);
     }
     
     @GetMapping(value="/girls/{id}")
     public Girl girlFindOne(@PathVariable("id") Integer id)
     {
           return girlRepository.findOne(id);
     }
     @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.delete(id);
     }
}

2 测试结果

七 通过年龄查询

1 GirlController

package com.imooc;
import java.util.List;
import javax.websocket.server.PathParam;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.DeleteMapping;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
@RestController
public class GirlController {
     
     @Autowired
     private GirlRepository girlRepository;
     
     @GetMapping(value="/girls")
     public List<Girl> girlList(){
           return girlRepository.findAll();
     }
     
     @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);
     }
     
     @GetMapping(value="/girls/{id}")
     public Girl girlFindOne(@PathVariable("id") Integer id)
     {
           return girlRepository.findOne(id);
     }
     @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.delete(id);
     }
     
     @GetMapping(value="/girls/age/{age}")
     public List<Girl> girlListByage(@PathVariable("age") Integer age){
           return girlRepository.findByAge(age);
     }
}

2 GirlRespository

package com.imooc;
import java.util.List;
import org.springframework.data.jpa.repository.JpaRepository;
public interface GirlRepository extends JpaRepository<Girl, Integer>{
     public List<Girl> findByAge(Integer age);
}

3 测试结果