springboot整合jdbc-实现预更新用户的查询功能
-
修改controller
//预更新用户的查询 @GetMapping("/preUpdateUser") public String preUpdateUser(Integer id,Model model){ try{ Users user = this.usersService.findUserById(id); model.addAttribute("user",user); }catch (Exception e){ e.printStackTrace(); return "error"; } return "updateUser"; } }
-
修改业务层
Users findUserById(Integer id);
//预更新查询 @Override public Users findUserById(Integer id) { return this.usersDao.selectUserById(id); }
-
修改持久层
Users selectUserById(Integer id);
@Override public Users selectUserById(Integer id) { Users user = new Users(); String sql = "select * from users where userid = ?" ; // this.jdbcTemplate.query(sql, new RowCallbackHandler() { // @Override // public void processRow(ResultSet resultSet) throws SQLException { // user.setUserid(resultSet.getInt("userid")); // user.setUsername(resultSet.getString("username")); // user.setUsersex(resultSet.getString("usersex")); // } // }); Object[] arr = new Object[]{id}; this.jdbcTemplate.query(sql, arr, new RowCallbackHandler() { @Override public void processRow(ResultSet resultSet) throws SQLException { user.setUserid(resultSet.getInt("userid")); user.setUsername(resultSet.getString("username")); user.setUsersex(resultSet.getString("usersex")); } }); return user; }
-
创建用户更新页面
<!DOCTYPE html> <html lang="en" xmlns:th="http://www.thymeleaf.org"> <link rel="shortcut icon"href="../resources/favicon.ico"th:href="@{/static/favicon.ico}"> <head> <meta charset="UTF-8"> <title>Title</title> </head> <body> <form th:action="@{/user/updateUser}" method="post"> <input type="hidden" name="userid" th:value="${user.userid}"> <input type="text" name="username" th:value="${user.username}"><br> <input type="text" name="usersex" th:value="${user.usersex}"><br> <input type="submit" value="ok"> </form> </body> </html>