SpringBoot学习（二）

Controller的使用

1. @Controller 处理Http请求
2. @RestController spring4后新加的注解，原来返回json需要@ResponseBody配合@Controller

3. @RequestMapping 配置URL映射

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

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

@RequestMapping(value = "/say/{id}", method = RequestMethod.GET)     public String say(@PathVariable("id") Integer id)

2.@RequestParam 获取请求参数的值

@RequestMapping(value = "/say", method = RequestMethod.GET)    public String say(@RequestParam("id") Integer id)

3.@GetMapping 组合注解 代替了RequestMapping

数据库的使用

1. oracle数据库：首先导入class12.jar包 file–>project structure–>点击右侧绿色的+–>选择1.JARS or directories–>找到本地的class12.jar包导入即可
2. 在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对数据的增删改查

@RestControllerpublic class GirlController {    @Autowired    private 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);    }}