JavaWeb课程大作业-Servlet+JSP+MySQL课室管理系统

package com.xiao.servlet.User;/* */ import com.alibaba.fastjson.JSONArray; import com.xiao.pojo.Role; import com.xiao.pojo.User; import com.xiao.service.Role.RoleServiceImpl; import com.xiao.service.User.UserServiceImpl; import com.xiao.util.Constants; import com.xiao.util.PageSupport; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; 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; //实现Servlet复用 public class UserServlet extends HttpServlet { @Override protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { String method = req.getParameter("method"); if(method.equals("savePwd")){ this.savePwd(req,resp); }else if(method.equals("pwdmodify")){ this.verifyPwd(req,resp); }else if(method.equals("query")){ this.query(req,resp); }else if(method.equals("add")){ this.add(req,resp); }else if(method.equals("getRoleList")){ this.getRoleList(req,resp); }else if(method.equals("ifExist")){ this.ifExist(req,resp); }else if(method.equals("deluser")){ this.deleteUser(req,resp); }else if(method.equals("modify")){ this.findById(req,resp); }else if(method.equals("modifyexe")){ this.modify(req,resp); }else if(method.equals("view")){ this.viewUser(req,resp); } } @Override protected void doPost(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { doGet(req, resp); } //用户修改密码方法 public void savePwd(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException { //从Session中获取ID Object obj = req.getSession().getAttribute(Constants.USER_SESSION); //获取前端页面传来的新密码 String newpassword = req.getParameter("newpassword"); //先判断不为空 再比较密码是否相等 if(obj != null && newpassword != null){ User user = (User) obj; UserServiceImpl userService = new UserServiceImpl(); //修改密码并返回结果 boolean flag = userService.updatePassword(user.getId(), newpassword); //如果密码修改成功 移除当前session if(flag){ req.setAttribute("message","修改密码成功，请使用新密码登录!"); req.getSession().removeAttribute(Constants.USER_SESSION); }else{ req.setAttribute("message","密码修改失败 新密码不符合规范"); } }else{ req.setAttribute("message","新密码不能为空!"); } //修改完了 重定向到此修改页面 req.getRequestDispatcher("pwdmodify.jsp").forward(req,resp); } //验证密码的方法 public void verifyPwd(HttpServletRequest req, HttpServletResponse resp)throws IOException{ //依旧从session中取ID Object obj = req.getSession().getAttribute(Constants.USER_SESSION); //取 前端传来的旧密码 String oldpassword = req.getParameter("oldpassword"); //将结果存放在map集合中 让Ajax使用 Map<String, String> resultMap = new HashMap<>(); //下面开始判断 键都是用result 此处匹配js中的Ajax代码 if(obj == null){ //说明session被移除了 或未登录|已注销 resultMap.put("result","sessionerror"); }else if(oldpassword == null){ //前端输入的密码为空 resultMap.put("result","error"); }else { //如果旧密码与前端传来的密码相同 if(((User)obj).getUserPassword().equals(oldpassword)){ resultMap.put("result","true"); }else{ //前端输入的密码和真实密码不相同 resultMap.put("result","false"); } } //上面已经封装好 现在需要传给Ajax 格式为json 所以我们得转换格式 resp.setContentType("application/json");//将应用的类型变成json PrintWriter writer = resp.getWriter(); //JSONArray 阿里巴巴的JSON工具类 用途就是：转换格式 writer.write(JSONArray.toJSONString(resultMap)); writer.flush(); writer.close(); } //查询用户列表的方法 public void query(HttpServletRequest req, HttpServletResponse resp){ //查询用户列表 //从前端获取数据 String queryUserName = req.getParameter("queryName"); String temp = req.getParameter("queryUserRole");//值为0 、1、2、3 String pageIndex = req.getParameter("pageIndex"); int queryUserRole = 0; //获取用户列表 UserServiceImpl userService = new UserServiceImpl(); //第一次走这个请求，一定是第一页，页面大小固定的 List<User> userList = null; int currentPageNo = 1;//当前页码 int pageSize = 5;//页数 可以把这个写到配置文件中，方便后期修改 if(queryUserName == null){ queryUserName = ""; } if(temp!=null && !temp.equals("")){ queryUserRole = Integer.parseInt(temp);//给查询赋值！0,1,2,3 } if(pageIndex!=null){ currentPageNo = Integer.parseInt(pageIndex); } //获取用户总数 分页：上一页 下一页 int totalCount = userService.getUserCounts(queryUserName, queryUserRole); //总页数支持 PageSupport pageSupport = new PageSupport(); System.out.println("当前页："+currentPageNo); pageSupport.setCurrentPageNo(currentPageNo); pageSupport.setPageSize(pageSize); System.out.println("获取用户总数"+totalCount); pageSupport.setTotalCount(totalCount); //总共的页数 int totalPageCount = pageSupport.getTotalPageCount(); //控制首页和尾页 //如果页数小于1，就显示第一页 页数大于 最后一页就 显示最后一页 if(currentPageNo<1){ currentPageNo =1; }else if(currentPageNo>totalPageCount){//当前页面大于了最后一页 currentPageNo = totalPageCount; } System.out.println("返回UserList的数据测试"+queryUserName+":"+queryUserRole+":"+currentPageNo+":"+pageSize); //获取用户列表展示 userList = userService.getUserList(queryUserName, queryUserRole, currentPageNo, pageSize); //将数据传给前端 System.out.println(userList); // for (User user : userList) { // System.out.println(user.toString()); // } req.setAttribute("userList",userList); RoleServiceImpl roleService = new RoleServiceImpl(); //所有角色 List<Role> roleList = roleService.getRoleList(); req.setAttribute("roleList",roleList); req.setAttribute("totalCount",totalCount); req.setAttribute("currentPageNo",currentPageNo); req.setAttribute("totalPageCount",totalPageCount); req.setAttribute("queryUserName",queryUserName); req.setAttribute("queryUserRole",queryUserRole); //返回至前端 try { req.getRequestDispatcher("userlist.jsp").forward(req,resp); } catch (ServletException e) { e.printStackTrace(