在pom.xml加入jdbcTemplate的依赖
那么只需要在需要使用的类中加入:
@Resource
private JdbcTemplate jdbcTemplate;
声明dao类为:@Repository,引入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);
}
编写DemoService类,引入DemoDao进行使用
@Resource
private DemoDao demoDao;
public void save(Demo demo){
demoDao.save(demo);
}
编写DemoController
@Resource
private DemoService demoService;
@RequestMapping("/getById")
public Demo getById(long id){
return demoService.getById(id);
}