springboot整合jdbc-实现删除用户
-
修改controller
//删除用户 @GetMapping("/deleteUser") public String deleteUser(Integer id){ try{ this.usersService.dropUser(id); }catch (Exception e){ e.printStackTrace(); return "error"; } return "redirect:/ok"; }
-
修改业务层
void dropUser(Integer id);
//删除用户 @Override @Transactional public void dropUser(Integer id) { this.usersDao.deleteUserById(id); }
-
修改持久层
void deleteUserById(Integer id);
//删除用户 @Override public void deleteUserById(Integer id) { String sql = "delete from users where userid=?"; this.jdbcTemplate.update(sql,id); }