SpringBoot学习（二）

Controller的使用

@Controller 处理Http请求
@RestController spring4后新加的注解，原来返回json需要@ResponseBody配合@Controller
@RequestMapping 配置URL映射

@RestController 相当于@Controller与@ResponseBody相结合

请求参数的处理
1. @PathVariable 获取url中的数据

@RequestMapping(value = “/say/{id}”, method = RequestMethod.GET)
public String say(@PathVariable(“id”) Integer id)
1
2
2.@RequestParam 获取请求参数的值

@RequestMapping(value = “/say”, method = RequestMethod.GET)
public String say(@RequestParam(“id”) Integer id)
1
2
3.@GetMapping 组合注解 代替了RequestMapping

数据库的使用

oracle数据库：首先导入class12.jar包 file–>project structure–>点击右侧绿色的+–>选择1.JARS or directories–>找到本地的class12.jar包导入即可
在application.yml配置文件中编写
datasource:
driver-class-name: oracle.jdbc.OracleDriver
url: jdbc:oracle:thin:@localhost:1521:XE
username: test
password: 123
jpa:
hibernate:
ddl-auto: create //创建表，如果表存在 覆盖掉 一般使用update
show-sql: true
3.用jpa对数据的增删改查
@RestController
public class GirlController {

@Autowiredprivate GirlRepository girlRepository;@GetMapping(value = "/girls")/** * 查询所有数据 */public List<Girl> getGirls(){    return girlRepository.findAll();}/** * 添加数据 * @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);}/** * 根据id查找 * @param id * @return */@GetMapping(value = "/girls/{id}")public Girl girlFindOne(@PathVariable("id") Integer id){    return girlRepository.findOne(id);}/** * 更新 * @param id * @param cupSize * @param age * @return */@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);}/** * 删除 * @param id */@DeleteMapping(value = "/girls/{id}")public void girlDelete(@PathVariable("id") Integer id){    girlRepository.delete(id);}/** * 通过年龄查询 * @param age * @return */@GetMapping(value = "/girls/age/{age}")public List<Girl> girlListByAge(@PathVariable("age") Integer age){    return girlRepository.findByAge(age);}

}