Spring MVC篇二、使用JdbcTemplate进行数据库操作

上一篇只是一个简单的Spring MVC框架，接下来添加一些跟数据库的交互。

 1 public User findUser(final String username, final String password) { 2     String sql = "select id,user_name, credit from t_user_info where user_name = ? and password = ?"; 3     User user = null; 4     try { 5       RowMapper<User> rm = ParameterizedBeanPropertyRowMapper.newInstance(User.class); 6       user = (User) jdbcTemplate.queryForObject(sql, new Object[]{username, password}, rm); 7     }catch (Exception e){ 8       e.printStackTrace(); 9     }10     return user;11   }

 1 @Service("userService") 2 public class UserService { 3   @Autowired 4   UserDao userDao; 5   public User findUser(String username,String password){ 6     return userDao.findUser(username,password); 7   } 8  9   public int findUserCount(String username,String password){10     return userDao.findUserCount(username,password);11   }12 13   public boolean insertUser(User user){14     return userDao.insertUser(user);15   }16 }

 1 @RequestMapping(value = "/index.html", method = RequestMethod.POST) 2   public ModelAndView userIndex(String username, String password) { 3     if (StringUtil.isEmpty(username) || StringUtil.isEmpty(password)) { 4       logger.error("用户名或密码为空"); 5       ModelAndView modelAndView = new ModelAndView("/index"); 6       modelAndView.addObject("error", "用户名或密码为空！"); 7       return modelAndView; 8     } 9 10 //    int count = userService.findUserCount(username,password);11     User user = userService.findUser(username, password);12     if (user == null) {13       logger.info("用户名或密码错误");14       ModelAndView modelAndView = new ModelAndView("/index");15       modelAndView.addObject("username", username);16       modelAndView.addObject("error", "用户：" + username + "不存在或用户密码错误！");17       return modelAndView;18     }19     ModelAndView mav = new ModelAndView("success");20     mav.addObject("username", username);21     mav.addObject("password", password);22     logger.info("username : " + username + ", password : " + password);23     return mav;24   }

海外公司注册、海外银行开户、跨境平台代入驻、VAT、EPR等知识和在线办理：https://www.xlkjsw.com

原标题：Spring MVC篇二、使用JdbcTemplate进行数据库操作

关键词：Spring