基于Jsp+Tomcat+Servlet+Filter的超市管理系统源码+数据库.zip

package cn.smbms.servlet.user; import java.io.IOException; import java.io.PrintWriter; import java.lang.reflect.Array; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.*; 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; import com.sun.xml.internal.bind.v2.model.core.ID; public class UserServlet extends HttpServlet { public UserServlet() { super(); } public void destroy() { super.destroy(); } public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request, response); } 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, HttpServletResponse response) throws ServletException, IOException { //判断用户账号是否可用 String userCode = request.getParameter("userCode"); HashMap<String, String> resultMap = new HashMap<String, String>(); if(StringUtils.isNullOrEmpty(userCode)){ //userCode == null || userCode.equals("") resultMap.put("userCode", "exist"); }else{ UserService userService = new UserServiceImpl(); User user = userService.selectUserCodeExist(userCode); if(null != user){ resultMap.put("userCode","exist"); }else{ resultMap.put("userCode", "notexist"); } } //把resultMap转为json字符串以json的形式输出 //配置上下文的输出类型 response.setContentType("application/json"); //从response对象中获取往外输出的writer对象 PrintWriter outPrintWriter = response.getWriter(); //把resultMap转为json字符串 输出 outPrintWriter.write(JSONArray.toJSONString(resultMap)); outPrintWriter.flush();//刷新 outPrintWriter.close();//关闭流 } private void getRoleList(HttpServletRequest request, HttpServletRes