springboot简单的增删改查:
1.底层代码实现
public interface GirlRespository extends JpaRepository<Girl,Integer>{
//通过年龄
public List<Girl> findByAge(Integer age);
}
2增删改查:
@Autowired
private GirlRespository girlRespository;
//所有的记录
@GetMapping(value = "/girls") @GetMapping
public List<Girl> girlList(){
return girlRespository.findAll();
}
//增加一条记录
@PostMapping(value = "/addgirl") @PostMapping
public Girl girladd(@RequestParam("cupSize") String cupSize,
@RequestParam("age") Integer age
){
Girl girl=new Girl();
girl.setAge(age);
girl.setCupSize(cupSize);
return girlRespository.save(girl);
}
// 根据id进行查询 @GetMapping
@GetMapping(value = "/find/{id}")
public Girl findOne(@PathVariable("id") Integer id){
return girlRespository.findOne(id);
}
//根据id进行更新 @PutMaping
@PutMapping(value = "/update/{id}")
public Girl updateGirl(@PathVariable("id") Integer id,
@RequestParam("age") Integer newage,
@RequestParam("cupsize") String newSize) {
Girl girl=new Girl();
girl.setId(id);
girl.setAge(newage);
girl.setCupSize(newSize);
return girlRespository.save(girl);
}
//根据id删除记录 @DeleteMaping
@DeleteMapping(value = "/delete/{id}")
public void girldelete(@PathVariable("id") Integer id){
girlRespository.delete(id);
}
@GetMapping(value = "/findage/{age}")
public List<Girl> findByAge(@PathVariable("age") Integer age){
return girlRespository.findByAge(age);
}
事务篇:
注:在增加,删除,更新记录是,请添注解:
@Transactional
@Transactional
public void insertTwo(){
Girl girl=new Girl();
girl.setCupSize("E");
girl.setAge(187777);
girlRespository.save(girl);
Girl girl2=new Girl();
girl2.setAge( null);
girl2.setCupSize("F");
girlRespository.save(girl2);
}
参考地址:(典型的老司机)
http://www.imooc.com/learn/810