SpringBoot快速入门（三）springboot的快速连接数据库之springdatajpa以及事务管理

五、数据库操作

1.引入依赖

2.在配置文件中添加信息

3.Girl类的书写

4.GirlRepository继承JpaRepository

5.GirlController的实现&＃xff0c;可通过Postman来模拟请求

package com.lcz;import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;import java.util.List;
import java.util.Optional;/*** &＃64;Author:Coding Chaozhang*/
&＃64;RestController
public class GirlController {&＃64;Autowiredprivate GirlRepository repository;&＃64;Autowiredprivate GirlService girlService;/*** 查询所有女生列表* &＃64;return*/&＃64;GetMapping(value &＃61; "/girls")public List girlList(){return repository.findAll();}/*** 创建女生信息* &＃64;param cupSize* &＃64;param age* &＃64;return*/&＃64;PostMapping(value &＃61; "/girls")public Girl girlAdd(&＃64;RequestParam("cupSize")String cupSize,&＃64;RequestParam("age")Integer age){Girl girl&＃61;new Girl();girl.setAge(age);girl.setCupSize(cupSize);return repository.save(girl);}/*** 查询一个女生* &＃64;param id* &＃64;return*/&＃64;GetMapping(value &＃61; "/girls/{id}")public Optional girlFindOne(&＃64;PathVariable("id")Integer id){return repository.findById(id);}/*** 更新一个女生信息* &＃64;param id* &＃64;param cupSize* &＃64;param age* &＃64;return*/&＃64;PutMapping(value &＃61; "/girls/{id}")public Girl girlUpdate(&＃64;PathVariable("id")Integer id,&＃64;RequestParam("cupSize")String cupSize,&＃64;RequestParam("age") Integer age){Girl girl&＃61;new Girl();girl.setId(id);girl.setCupSize(cupSize);girl.setAge(age);return repository.save(girl);}/*** 删除女生* &＃64;param id*/&＃64;DeleteMapping(value &＃61; "/girls/{id}")public void girlDelete(&＃64;PathVariable("id")Integer id){repository.deleteById(id);}&＃64;GetMapping(value &＃61; "/girls/age/{age}")public List girlListByAge(&＃64;PathVariable("age")Integer age) {return repository.findByAge(age);}&＃64;PostMapping(value &＃61; "/girls/two")public void girlTwo(){girlService.insertTwo();}
}


六、事务管理

&＃64;Transactional

package com.lcz;import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;/*** &＃64;Author:Coding Chaozhang*/
&＃64;Service
public class GirlService {&＃64;Autowiredprivate GirlRepository girlRepository;&＃64;Transactionalpublic void insertTwo(){Girl girlA&＃61;new Girl();girlA.setCupSize("A");girlA.setAge(18);Girl girlB&＃61;new Girl();girlB.setCupSize("A");girlB.setAge(18);girlRepository.save(girlA);girlRepository.save(girlB);}
}