超市订单关系系统教学案例，Servlet+JDBC.zip

package cn.smbms.servlet.user; import java.io.IOException; import java.io.PrintWriter; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import com.alibaba.fastjson.JSONArray; import com.mysql.jdbc.StringUtils; import cn.smbms.pojo.Role; import cn.smbms.pojo.User; import cn.smbms.service.role.RoleService; import cn.smbms.service.role.RoleServiceImpl; import cn.smbms.service.user.UserService; import cn.smbms.service.user.UserServiceImpl; import cn.smbms.tools.Constants; import cn.smbms.tools.PageSupport; public class UserServlet extends HttpServlet { /** * Constructor of the object. */ public UserServlet() { super(); } /** * Destruction of the servlet. <br> */ public void destroy() { super.destroy(); // Just puts "destroy" string in log // Put your code here } /** * The doGet method of the servlet. <br> * * This method is called when a form has its tag value method equals to get. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request, response); } /** * The doPost method of the servlet. <br> * * This method is called when a form has its tag value method equals to post. * * @param request the request send by the client to the server * @param response the response send by the server to the client * @throws ServletException if an error occurred * @throws IOException if an error occurred */ public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String method = request.getParameter("method"); System.out.println("method----> " + method); if(method != null && method.equals("add")){ //增加操作 this.add(request, response); }else if(method != null && method.equals("query")){ this.query(request, response); }else if(method != null && method.equals("getrolelist")){ this.getRoleList(request, response); }else if(method != null && method.equals("ucexist")){ this.userCodeExist(request, response); }else if(method != null && method.equals("deluser")){ this.delUser(request, response); }else if(method != null && method.equals("view")){ this.getUserById(request, response,"userview.jsp"); }else if(method != null && method.equals("modify")){ this.getUserById(request, response,"usermodify.jsp"); }else if(method != null && method.equals("modifyexe")){ this.modify(request, response); }else if(method != null && method.equals("pwdmodify")){ this.getPwdByUserId(request, response); }else if(method != null && method.equals("savepwd")){ this.updatePwd(request, response); } } private void updatePwd(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { Object o = request.getSession().getAttribute(Constants.USER_SESSION); String newpassword = request.getParameter("newpassword"); boolean flag = false; if(o != null && !StringUtils.isNullOrEmpty(newpassword)){ UserService userService = new UserServiceImpl(); flag = userService.updatePwd(((User)o).getId(),newpassword); if(flag){ request.setAttribute(Constants.SYS_MESSAGE, "修改密码成功,请退出并使用新密码重新登录！"); request.getSession().removeAttribute(Constants.USER_SESSION);//session注销 }else{ request.setAttribute(Constants.SYS_MESSAGE, "修改密码失败！"); } }else{ request.setAttribute(Constants.SYS_MESSAGE, "修改密码失败！"); } request.getRequestDispatcher("pwdmodify.jsp").forward(request, response); } private void getPwdByUserId(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { Object o = request.getSession().getAttribute(Constants.USER_SESSION); String oldpassword = request.getParameter("oldpassword"); Map<String, String> resultMap = new HashMap<String, String>(); if(null == o ){//session过期 resultMap.put("result", "sessionerror"); }else if(StringUtils.isNullOrEmpty(oldpassword)){//旧密码输入为空 resultMap.put("result", "error"); }else{ String sessionPwd = ((User)o).getUserPassword(); if(oldpassword.equals(sessionPwd)){ resultMap.put("result", "true"); }else{//旧密码输入不正确 resultMap.put("result", "false"); } } response.setContentType("application/json"); PrintWriter outPrintWriter = response.getWriter(); outPrintWriter.write(JSONArray.toJSONString(resultMap)); outPrintWriter.flush(); outPrintWriter.close(); } private void modify(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String id = request.getParameter("uid"); String userName = request.getParameter("userName"); String gender = request.getParameter("gender"); String birthday = request.getParameter("birthday"); String phone = request.getParameter("phone"); String address = request.getParameter("address"); String userRole = request.getParameter("userRole"); User user = new User(); user.setId(Integer.valueOf(id)); user.setUserName(userName); user.setGender(Integer.valueOf(gender)); try { user.setBirthday(new SimpleDateFormat("yyyy-MM-dd").parse(birthday)); } catch (ParseException e) { // TODO Auto-generated catch block e.printStackTrace(); } user.setPhone(phone); user.setAddress(address); user.setUserRole(Integer.valueOf(userRole)); user.setModifyBy(((User)request.getSession().getAttribute(Constants.USER_SESSION)).getId()); user.setModifyDate(new Date()); UserService userService = new UserServiceImpl(); if(userService.modify(user)){ response.sendRedirect(request.getContextPath()+"/jsp/user.do?method=query"); }else{ request.getRequestDispatcher("usermodify.jsp").forward(request, response); } } private void getUserById(HttpServletRequest request, HttpServletResponse response,String url) throws ServletException, IOException { String id = request.getParameter("uid"); if(!StringUtils.isNullOrEmpty(id)){ //调用后台方法得到user对象 UserService userService = new UserServiceImpl(); User user = userService.getUserById(id); request.setAttribute("user", user); request.getRequestDispatcher(url).forward(request, response); } } private void delUser(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String id = request.getParameter("uid"); Integer delId = 0; try{ delId = Integer.parseInt(id); }catch (Exception e) { // TODO: handle exception delId = 0; } HashMap<String, String> resultMap = new HashMap<String, String>(); if(delId <= 0){ resultMap.put("delResult", "notexist"); }else{ UserService userService = new UserServiceImpl(); if(userService.deleteUserById(delId)){ resultMap.put("delResult", "true"); }else{ resultMap.put("delResult", "false"); } } //把resultMap转换成json对象输出 response.setContentType("application/json"); PrintWriter outPrintWriter = response.getWriter(); outPrintWriter.write(JSONArray.toJSONString(resultMap)); outPrintWriter.flush(); outPrintWriter.close(); } private void userCodeExist(HttpServletRequest request, H