spring boot 学习--05---mysql,jpa,jdbcTemplate-应用

步骤

1. 修改实体
2. 增加dao（jpa），service层
3. 增加controller层
4. 测试

修改Demo实体

package com.springboot.study.bean;import javax.persistence.Entity;import javax.persistence.GeneratedValue;import javax.persistence.Id;/** * Demo 模型 * @author like * */@Entitypublic class Demo {     @Id      @GeneratedValue    private long id;    private String name;    private String demo;    public long getId() {        return id;    }    public void setId(long id) {        this.id = id;    }    public String getName() {        return name;    }    public void setName(String name) {        this.name = name;    }    public String getDemo() {        return demo;    }    public void setDemo(String demo) {        this.demo = demo;    }}

增加dao层（JPA）

package com.springboot.study.dao.jpa;import org.springframework.data.repository.CrudRepository;import com.springboot.study.bean.Demo;/** * 这就完成一个Dao层的开发，不需要其他注解和配置，JPA自动配置 * @author like * */public interface DemoDao extends CrudRepository<Demo, Long>{}

增加service层

package com.springboot.study.service;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import com.springboot.study.bean.Demo;import com.springboot.study.dao.jpa.DemoDao;@Servicepublic class DemoService {    @Autowired    private DemoDao demoDao;    public void save(Demo demo){        demoDao.save(demo);    }}

controller层

package com.springboot.study.controller;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RestController;import com.springboot.study.bean.Demo;import com.springboot.study.service.DemoService;/** * Demo 控制类 * @author like * */@RestController@RequestMapping("/demo")public class DemoController2 {    @Autowired    private DemoService demoService;    @RequestMapping("/saveDemo")    public String getDemo(){        Demo demo = new Demo();        demo.setId(1);        demo.setDemo("demo");        demo.setName("testDemo");        demoService.save(demo);        return "demo save success";    }}

测试

http://localhost:8080/demo/saveDemo

jdbcTemplate应用

1. 新增jdbcdao
2. 修改Service
3. 修改controller
4. 测试

新增jdbcdao

package com.springboot.study.dao.jdbcTemplate;import javax.annotation.Resource;import org.springframework.jdbc.core.BeanPropertyRowMapper;import org.springframework.jdbc.core.JdbcTemplate;import org.springframework.jdbc.core.RowMapper;import org.springframework.stereotype.Repository;import com.springboot.study.bean.Demo;@Repositorypublic class DemoJdbcDao {    @Resource    private JdbcTemplate jdbcTemplate;    public Demo getById(long id){        String sql = "select * from Demo where id=?";        RowMapper<Demo> rowMapper = new BeanPropertyRowMapper<Demo>(Demo.class);        return jdbcTemplate.queryForObject(sql, rowMapper,id);    }}

修改Service

package com.springboot.study.service;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import com.springboot.study.bean.Demo;import com.springboot.study.dao.jdbcTemplate.DemoJdbcDao;import com.springboot.study.dao.jpa.DemoDao;@Servicepublic class DemoService {    @Autowired    private DemoDao demoDao;    @Autowired    private DemoJdbcDao demoJdbcDao;    public void save(Demo demo){        demoDao.save(demo);    }    public Demo getById(long id){        return demoJdbcDao.getById(id);    }}

修改controller

package com.springboot.study.controller;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RestController;import com.springboot.study.bean.Demo;import com.springboot.study.service.DemoService;/** * Demo 控制类 * @author like * */@RestController@RequestMapping("/demo")public class DemoController2 {    @Autowired    private DemoService demoService;    @RequestMapping("/saveDemo")    public String getDemo(){        Demo demo = new Demo();        demo.setId(1);        demo.setDemo("demo");        demo.setName("testDemo");        demoService.save(demo);        return "demo save success";    }    @RequestMapping("/getById")    public Demo getDemo(long id ){        return demoService.getById(id);    }}

测试

访问 http://localhost:8080/demo/getById?id=1

结果：
成功