基于javaweb+mysql的jsp+servlet宿舍管理系统(超级管理员、宿舍管理员、学生)(java+jsp+servlet+javabean+mysql+tomcat)

基于javaweb+mysql的jsp+servlet宿舍管理系统(超级管理员、宿舍管理员、学生)(java+jsp+servlet+javabean+mysql+tomcat)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

超级管理员：登录退出、宿舍管理员管理、学生管理、宿舍楼管理、缺勤管理、修改密码

宿舍管理员：登录退出、学生管理、缺勤管理

学生：登录退出、缺勤查看

超级管理员

宿舍管理员

学生

技术框架

JSP Servlet MySQL JDBC Tomcat CSS JavaScript

基于javaweb+mysql的JSP+Servlet宿舍管理系统(超级管理员、宿舍管理员、学生)(java+jsp+servlet+javabean+mysql+tomcat)

					
					/*httpServletRequest.getSession().setAttribute("session_user", user2);
					chain.doFilter(request, response);*/
					
				}else {
					//记住在浏览器的学号和密码无效
					request.setAttribute("error", "请先登录！");
					//如未登录，就跳转到登录页面
					request.getRequestDispatcher("/index.jsp").forward(httpServletRequest, response);
				}
			}else {
				request.setAttribute("error", "请先登录！");
				//如未登录，就跳转到登录页面
				request.getRequestDispatcher("/index.jsp").forward(httpServletRequest, response);
			}
		}
	}

	private void roleJudgment(User user, HttpServletRequest httpServletRequest, ServletResponse response,
			FilterChain chain) throws IOException, ServletException {
		//获取用户角色id
		Integer  roleId = user.getRoleId();
		//获取请求地址  /DormTest/dormBuild.action

		String  requestUrI = httpServletRequest.getRequestURI();
		System.out.println("requestUrI:"+requestUrI);
		
		//动态获取项目名/DormTest
		String path = httpServletRequest.getContextPath();
		System.out.println("path:"+path);
		if( (requestUrI.startsWith(path+"/dormBuild.action") || requestUrI.startsWith(path+"/dormManager.action"))
				&& roleId.equals(0)) {
			//当用户发送的是宿舍楼管理模块或者宿舍管理员管理模块的请求时，只有在当前用户角色为超级管理员时才放行
			httpServletRequest.getSession().setAttribute("session_user", user);
			chain.doFilter(httpServletRequest, response);
			
		}else if(requestUrI.startsWith(path+"/student.action") && !roleId.equals(2)) {
			//当用户发送的请求是学生模块的请求时，只有当前用户角色不是学生就放行
			httpServletRequest.getSession().setAttribute("session_user", user);
			chain.doFilter(httpServletRequest, response);
			
		}else if(requestUrI.startsWith(path+"/record.action") ||
				requestUrI.startsWith(path+"/password.action")||
				requestUrI.startsWith(path+"/loginOut.action")||
				requestUrI.startsWith(path+"/index.action")) {
			//当用户发送的请求是考勤、修改密码、退出模块的请求时，不管用户的角色是什么，都放行
			httpServletRequest.getSession().setAttribute("session_user", user);
			chain.doFilter(httpServletRequest, response);
		}else {
			httpServletRequest.getRequestDispatcher("/index.jsp").forward(httpServletRequest, response);
		}
	}

			
		}else if(action != null && action.equals("deleteOrAcive")) {
			System.out.println("======删除或者激活=========");
			//删除或者激活
			String disabled = request.getParameter("disabled");
			
			Record record = recordService.findById(Integer.parseInt(id));
			record.setDisabled(Integer.parseInt(disabled));
			
			//查看用户是否有修改考勤记录的权限
			User user = userService.findStuCodeAndManager(record.getUser().getStuCode(),userCurr);
			System.out.println("修改权限user ："+user);
			if(user == null) {
				//无删除激活权限
				response.sendRedirect(getServletContext().getContextPath()+"/record.action?action=list");
			}else {
				//有删除激活权限
				recordService.update(record);
				//跳转到缺勤记录列表页
				response.sendRedirect(getServletContext().getContextPath()+"/record.action?action=list");
			}
		
		}
	}
		

}

/**
 * Servlet implementation class DormBuildServlet
 */
@WebServlet("/dormBuild.action")
public class DormBuildServlet extends HttpServlet {

            }
            System.out.println("========跳转到主页面=====");
            //WEB-INF下面的内容是受保护的，不能在通过地址栏直接访问，也不能通过response.sendRedirect重定向的形势访问
            request.getRequestDispatcher("/WEB-INF/jsp/main.jsp").forward(request, response);
            System.out.println("getServletContext().getContextPath():" + getServletContext().getContextPath());
        }
    }
}

/**
 * Servlet implementation class PassWordServlet
 */
@WebServlet("/password.action")
public class PassWordServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public PassWordServlet() {
        super();
        // TODO Auto-generated constructor stub
    }

	/**
	 * @see HttpServlet#service(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void service(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		System.out.println("---------------------password.action---------");
		
		String action = request.getParameter("action");
		//获取当前登录的用户
		User userCur = (User) request.getSession().getAttribute("session_user");
		System.out.println("action:"+action+" userCur:"+userCur);

			//跳转到添加页面
			request.setAttribute("mainRight", "/WEB-INF/jsp/recordAddOrUpdate.jsp");
			request.getRequestDispatcher("/WEB-INF/jsp/main.jsp").forward(request, response);
			
		}else if(action != null && action.equals("save")) {
			//保存
			String stuCode = request.getParameter("stuCode");
			String date = request.getParameter("date");
			String remark = request.getParameter("remark");
			System.out.println("remark:"+remark+"  date:"+date+"  stuCode:"+stuCode);
			
			//做保存前，判断用户是否有添加该学号学生缺勤记录的权限
			User user = userService.findStuCodeAndManager(stuCode,userCurr);
			System.out.println("查询添加缺勤权限user:"+user);
			
			if(id != null && !id.equals("")) {
				//更新
				if(user != null) {
					//有修改权限
					Record record = recordService.findById(Integer.parseInt(id));
					try {
						record.setDate(new SimpleDateFormat("yyyy-MM-dd").parse(date));
						record.setRemark(remark);
						record.setStudentId(user.getId());
						
						recordService.update(record);
					} catch (ParseException e) {
						e.printStackTrace();
					}
					response.sendRedirect(getServletContext().getContextPath()+"/record.action?action=list");
				}else {
					//无修改权限
					response.sendRedirect(getServletContext().getContextPath()+"/record.action?action=list");
				}
				
			}else {
				//保存
				if(user != null) {
					//说明当前登录的用户有添加该学号学生缺勤记录的权限
					SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
					Date date2 = null;
					try {
						date2 = dateFormat.parse(date);
					} catch (ParseException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
					
					Record record = new Record();
					record.setStudentId(user.getId());
					record.setDate(date2);

		
		UserService userService = new UserServiceImpl();
		if(action != null && action.equals("preChange")) {
			//跳转到密码修改页面
			request.setAttribute("mainRight", "/WEB-INF/jsp/passwordChange.jsp");
			request.getRequestDispatcher("/WEB-INF/jsp/main.jsp").forward(request, response);
			
		}else if(action != null && action.equals("ajaxOldPassWord")) {
			//校验用户输入的元密码是否正确
			
			//当前登录的用户在输入框输入的密码
			String oldPassWord = request.getParameter("oldPassWord");
			//当前登录的用户原始密码
			String passWord = userCur.getPassWord();
			
			if(!passWord.equals(oldPassWord)) {
				response.setCharacterEncoding("utf-8");
				PrintWriter writer = response.getWriter();
				writer.print("您输入的原始密码错误，请重新输入！");
			}
			
		}else if(action != null && action.equals("change")) {
			//修改密码
			String newPassword = request.getParameter("newPassword");
			userCur.setPassWord(newPassword);
			userService.updatePassWord(userCur);
			
			System.out.println("修改密码userCur:"+userCur);
			
			request.getRequestDispatcher("/index.jsp").forward(request, response);
		}
	}

}

/**
 * Servlet implementation class LoginOutServlet
 */

    public LoginFilter() {
        // TODO Auto-generated constructor stub
    }

	/**
	 * @see Filter#destroy()
	 */
	public void destroy() {
		// TODO Auto-generated method stub
	}

	/**
	 * @see Filter#doFilter(ServletRequest, ServletResponse, FilterChain)
	 */
	public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException {
		System.out.println("------------登录拦截器------------");
		
		HttpServletRequest  httpServletRequest = (HttpServletRequest) request;
		HttpSession  session = httpServletRequest.getSession();
		
		//①获取登录后保存在session中的用户信息
		User user  = (User) session.getAttribute("session_user");
		System.out.println("session user:"+user);
		
		UserService userService = new UserServiceImpl();
		//判断用户是否登录
		if(user != null) {
			//登录，就放行，走处理该请求的方法
			//通过user 判断登录的用户角色是否有对该请求的访问权限
			//通过request中的httpServletRequest.getRequestURI(); 来获取用户发送的请求
			roleJudgment(user,httpServletRequest,response,chain);
			
			//chain.doFilter(request, response);
		}else {
			//② 判断cookie中是否有用户信息，即学号和密码
			//第一步，去遍历所有的cookie，看是否有保存当前学号和密码的cookie
			Cookie cookie = CookieUtil.getCookieByName(httpServletRequest, "cookie_name_pass");
			System.out.println("cookie:"+cookie);
			
			if(cookie != null) {
				//有保存当前项目学号和密码的cookie
				String stuCodePass = URLDecoder.decode(cookie.getValue(),"UTF-8");
				//111#111
				System.out.println("stuCodePass:"+stuCodePass);
				
				String[]  stuCodePass2 =stuCodePass.split("#");
				//判断当前用户的学号和密码是否有效
				User user2 = userService.findByStuCodeAndPass(stuCodePass2[0], stuCodePass2[1]);
				System.out.println("user2:"+user2);

			
			//根据宿舍管理员ID，获取宿舍管理员
			User user = userService.findById(Integer.parseInt(id));
			//根据宿舍管理员ID获取宿舍管理员管理的楼栋
			List<DormBuild> userBuilds = buildService.findByUserId(user.getId());
			user.setDormBuilds(userBuilds);
			System.out.println("user:"+user);
			
			List<Integer>  userBuildids = new ArrayList<>();
			//遍历当前宿舍管理员管理的所有宿舍，获取当时当前宿舍管理员管理的所有宿舍ID
			for (DormBuild userBuild : userBuilds) {
				userBuildids.add(userBuild.getId());
			}
			
			
			request.setAttribute("userBuildids", userBuildids);
			request.setAttribute("user", user);
			request.setAttribute("mainRight", "dormManagerAddOrUpdate.jsp");
			request.getRequestDispatcher("/WEB-INF/jsp/main.jsp").forward(request, response);
		}else if(action != null & action.equals("deleteOrAcive")) {
			//删除或激活
			String  disabled =request.getParameter("disabled");
			
			//通过宿舍管理员ID获取宿舍管理员
			User user = userService.findById(Integer.parseInt(id));
			user.setDisabled(Integer.parseInt(disabled));
			userService.updateManager(user);
			
			//跳转到宿舍管理员列表页，查看所有的宿舍管理员
			//重定向，请求链断开，不能在下一个servlet或jsp中获取保存在request中的参数
			response.sendRedirect(getServletContext().getContextPath()+"/dormManager.action?action=list");
		}
	}

}

					//当前用户输入的宿舍楼名不存在，则保存用户输入的信息到数据库
					DormBuild build = new DormBuild();
					build.setName(name);
					build.setRemark(remark);
					build.setDisabled(0);
					dormBuildService.save(build);
					//保存完成，跑到宿舍楼管理列表页，查询所有宿舍楼
					List<DormBuild>  builds  = dormBuildService.find();
					//查询所有的宿舍楼，在select中遍历
					List<DormBuild>  buildSelects = dormBuildService.find();
					request.setAttribute("buildSelects", buildSelects);
					request.setAttribute("builds", builds);
					request.setAttribute("mainRight", "/WEB-INF/jsp/dormBuildList.jsp");
					request.getRequestDispatcher("/WEB-INF/jsp/main.jsp").forward(request, response);
				}
			}
			
		}else if(action != null & action.equals("preUpdate")) {
			//根据宿舍楼id，查询宿舍楼
			DormBuild build = dormBuildService.findById(Integer.parseInt(id));
			//保存宿舍楼信息，到前端页面展示
			request.setAttribute("build", build);
			//跳转到宿舍楼修改页面
			request.setAttribute("mainRight", "/WEB-INF/jsp/dormBuildAddOrUpdate.jsp");
			request.getRequestDispatcher("/WEB-INF/jsp/main.jsp").forward(request, response);
		}else if(action != null & action.equals("deleteOrAcive")) {
			//删除或激活
			String disabled = request.getParameter("disabled");
			
			DormBuild  dormBuild = dormBuildService.findById(Integer.parseInt(id));
			System.out.println("更新前dormBuild："+dormBuild);
			dormBuild.setDisabled(Integer.parseInt(disabled));
			System.out.println("更新后dormBuild："+dormBuild);
			
			//执行更新
			dormBuildService.update(dormBuild);
			//更新完成，跑到宿舍楼管理列表页，查询所有宿舍楼
			List<DormBuild>  builds  = dormBuildService.find();
			//查询所有的宿舍楼，在select中遍历
			List<DormBuild>  buildSelects = dormBuildService.find();
			request.setAttribute("buildSelects", buildSelects);
			request.setAttribute("builds", builds);
			request.setAttribute("mainRight", "/WEB-INF/jsp/dormBuildList.jsp");
			request.getRequestDispatcher("/WEB-INF/jsp/main.jsp").forward(request, response);
		}
		

        UserService userService = new UserServiceImpl();
        //去查询用户输入的登录名和密码是否正确
        User user = userService.findByStuCodeAndPass(stuCode, password);
        System.out.println("user:" + user);

        if (user == null) {
            //用户输入的学号或密码错误，跳转到登录页面，并给予提示信息
            request.setAttribute("error", "您输入的学号或密码错误！");
            //请求链未断开的跳转，可以在下一个servlet或jsp中，获取保存在request中的数据
            request.getRequestDispatcher("index.jsp").forward(request, response);
        } else {
            //用户输入学号和密码正确，登录成功，跳转到主页面
            //保存在session中的数据，默认是30分钟内有效。保存在session中的数据，在整个项目中都可以获取得到
            request.getSession().setAttribute("session_user", user);

            if (remember != null && remember.equals("remember-me")) {
                //记住密码一周  时间单位是秒
                CookieUtil.addCookie("cookie_name_pass", 7 * 24 * 60 * 60, request, response, URLEncoder.encode(stuCode, "utf-8"), URLEncoder.encode(password, "utf-8"));
            }
            System.out.println("========跳转到主页面=====");
            //WEB-INF下面的内容是受保护的，不能在通过地址栏直接访问，也不能通过response.sendRedirect重定向的形势访问
            request.getRequestDispatcher("/WEB-INF/jsp/main.jsp").forward(request, response);
            System.out.println("getServletContext().getContextPath():" + getServletContext().getContextPath());
        }
    }
}

/**
 * Servlet implementation class PassWordServlet
 */

				user.setSex(sex);
				user.setTel(tel);
				userService.updateManager(user);
				
				//修改还需修改宿舍管理员与宿舍楼的中间表
				//① 删除当前宿舍管理员管理的所有宿舍楼
				buildService.deleteByUserId(user.getId());
				
				//② 新增当前宿舍管理员管理的所有宿舍楼  
				buildService.saveManagerAndBuild(user.getId(),dormBuildIds);
			}
			//跳转到宿舍管理员列表页，查看所有的宿舍管理员
			//重定向，请求链断开，不能在下一个servlet或jsp中获取保存在request中的参数
			response.sendRedirect(getServletContext().getContextPath()+"/dormManager.action?action=list");
		
		}else if(action != null & action.equals("preUpdate")) {
			//跳转到修改宿舍管理员的页面
			
			//根据宿舍管理员ID，获取宿舍管理员
			User user = userService.findById(Integer.parseInt(id));
			//根据宿舍管理员ID获取宿舍管理员管理的楼栋
			List<DormBuild> userBuilds = buildService.findByUserId(user.getId());
			user.setDormBuilds(userBuilds);
			System.out.println("user:"+user);
			
			List<Integer>  userBuildids = new ArrayList<>();
			//遍历当前宿舍管理员管理的所有宿舍，获取当时当前宿舍管理员管理的所有宿舍ID
			for (DormBuild userBuild : userBuilds) {
				userBuildids.add(userBuild.getId());
			}
			
			
			request.setAttribute("userBuildids", userBuildids);
			request.setAttribute("user", user);
			request.setAttribute("mainRight", "dormManagerAddOrUpdate.jsp");
			request.getRequestDispatcher("/WEB-INF/jsp/main.jsp").forward(request, response);
		}else if(action != null & action.equals("deleteOrAcive")) {
			//删除或激活
			String  disabled =request.getParameter("disabled");
			
			//通过宿舍管理员ID获取宿舍管理员
			User user = userService.findById(Integer.parseInt(id));
			user.setDisabled(Integer.parseInt(disabled));
			userService.updateManager(user);

				if(user2 != null) {
					//记住在浏览器的学号和密码有效，放行，自动登录成功将用户信息保存在session中
					
					//通过user 判断登录的用户角色是否有对该请求的访问权限
					//通过request中的httpServletRequest.getRequestURI(); 来获取用
					roleJudgment(user2,httpServletRequest,response,chain);
					
					/*httpServletRequest.getSession().setAttribute("session_user", user2);
					chain.doFilter(request, response);*/
					
				}else {
					//记住在浏览器的学号和密码无效
					request.setAttribute("error", "请先登录！");
					//如未登录，就跳转到登录页面
					request.getRequestDispatcher("/index.jsp").forward(httpServletRequest, response);
				}
			}else {
				request.setAttribute("error", "请先登录！");
				//如未登录，就跳转到登录页面
				request.getRequestDispatcher("/index.jsp").forward(httpServletRequest, response);
			}
		}
	}

	private void roleJudgment(User user, HttpServletRequest httpServletRequest, ServletResponse response,
			FilterChain chain) throws IOException, ServletException {
		//获取用户角色id
		Integer  roleId = user.getRoleId();
		//获取请求地址  /DormTest/dormBuild.action

		String  requestUrI = httpServletRequest.getRequestURI();
		System.out.println("requestUrI:"+requestUrI);
		
		//动态获取项目名/DormTest
		String path = httpServletRequest.getContextPath();
		System.out.println("path:"+path);
		if( (requestUrI.startsWith(path+"/dormBuild.action") || requestUrI.startsWith(path+"/dormManager.action"))
				&& roleId.equals(0)) {
			//当用户发送的是宿舍楼管理模块或者宿舍管理员管理模块的请求时，只有在当前用户角色为超级管理员时才放行
			httpServletRequest.getSession().setAttribute("session_user", user);
			chain.doFilter(httpServletRequest, response);
			
		}else if(requestUrI.startsWith(path+"/student.action") && !roleId.equals(2)) {
			//当用户发送的请求是学生模块的请求时，只有当前用户角色不是学生就放行
			httpServletRequest.getSession().setAttribute("session_user", user);
			chain.doFilter(httpServletRequest, response);
			
		}else if(requestUrI.startsWith(path+"/record.action") ||

			List<User> students = userService.findStudent(dormBuildId,searchType,keyword,user,pageModel);
			//获取查询处理的总数量
			Integer  totalNum = userService.findTotalNum(dormBuildId,searchType,keyword,user);
			System.out.println("totalNum:"+totalNum);
			System.out.println("students:"+students);
			
			request.setAttribute("totalNum", totalNum);
			request.setAttribute("pageIndex", pageModel.getPageIndex());
			request.setAttribute("dormBuildId", dormBuildId);
			request.setAttribute("searchType", searchType);
			request.setAttribute("keyword", keyword);
			request.setAttribute("students", students);
			request.setAttribute("mainRight", "/WEB-INF/jsp/studentList.jsp");
			request.getRequestDispatcher("/WEB-INF/jsp/main.jsp").forward(request, response);
			
		}else if(action != null & action.equals("preAdd")) {
			//根据用户角色查询宿舍楼进行添加学生，
			//如当前用户 为宿舍管理员，他只能添加学生到其管理的宿舍楼
			
			//跳转到学生的添加页面
			request.setAttribute("mainRight", "/WEB-INF/jsp/studentAddOrUpdate.jsp");
			request.getRequestDispatcher("/WEB-INF/jsp/main.jsp").forward(request, response);
			
		}else if(action != null & action.equals("save")) {
			//保存学生
			String stuCode = request.getParameter("stuCode");
			String name = request.getParameter("name");
			String sex = request.getParameter("sex");
			String tel = request.getParameter("tel");
			String passWord = request.getParameter("passWord");
			String  dormBuildId= request.getParameter("dormBuildId");
			String dormCode = request.getParameter("dormCode");
			System.out.println("stuCode:"+stuCode+"  name:"+name+"   sex:"+sex+
					"  tel:"+tel+" passWord:"+passWord+" dormBuildId:"+dormBuildId+
					"  dormCode:"+dormCode);
			
			//未存在，则保存
			User student = userService.findByStuCode(stuCode);
			if(id != null && !id.equals("")) {
				//更新之前，查询数据库是否已经存在当前学号的学生，如已存在，则跳转到添加页面
				if(student != null  && !student.getId().equals(Integer.parseInt(id))) {
					System.out.println("根据学生学号查询student:"+student);
					//当前学号的学生已存在，请重新修改，跳转到该学生的修改页面
					request.getRequestDispatcher("/student.action?action=preUpdate&id="+id).forward(request, response);;
				}else {
					//更新
					User studentUpdate = userService.findById(Integer.parseInt(id));
					studentUpdate.setStuCode(stuCode);
					studentUpdate.setSex(sex);
					studentUpdate.setTel(tel);
					studentUpdate.setName(name);

/**
 * 该过滤器拦截所有以.action的请求
 */
@WebFilter("*.action")
public class LoginFilter implements Filter {

    /**
     * Default constructor. 
     */
    public LoginFilter() {
        // TODO Auto-generated constructor stub
    }

	/**
	 * @see Filter#destroy()
	 */
	public void destroy() {
		// TODO Auto-generated method stub
	}

	/**
	 * @see Filter#doFilter(ServletRequest, ServletResponse, FilterChain)
	 */
	public void doFilter(ServletRequest request, ServletResponse response, FilterChain chain) throws IOException, ServletException {
		System.out.println("------------登录拦截器------------");
		
		HttpServletRequest  httpServletRequest = (HttpServletRequest) request;
		HttpSession  session = httpServletRequest.getSession();
		
		//①获取登录后保存在session中的用户信息
		User user  = (User) session.getAttribute("session_user");
		System.out.println("session user:"+user);
		
		UserService userService = new UserServiceImpl();
		//判断用户是否登录
		if(user != null) {
			//登录，就放行，走处理该请求的方法
			//通过user 判断登录的用户角色是否有对该请求的访问权限
			//通过request中的httpServletRequest.getRequestURI(); 来获取用户发送的请求
			roleJudgment(user,httpServletRequest,response,chain);
			
			//chain.doFilter(request, response);
		}else {
			//② 判断cookie中是否有用户信息，即学号和密码
			//第一步，去遍历所有的cookie，看是否有保存当前学号和密码的cookie

			String sex = request.getParameter("sex");
			String tel = request.getParameter("tel");
			//获取复选框中用户选中的宿舍楼
			String[] dormBuildIds = request.getParameterValues("dormBuildId");
			System.out.println("name:"+name+"  pass:"+passWord+"  sex:"+sex+"  tel:"+tel+"  dormBuildIds:"+Arrays.toString(dormBuildIds));
			
			if(id == null || id.equals("")) {
				//保存
				User user = new User(name, passWord, sex, tel, null, 1);
				user.setDisabled(0);
				
				//当前登录的用户
				User user2 = (User) request.getSession().getAttribute("session_user");
				user.setCreateUserId(user2.getId());
				
				userService.saveManager(user,dormBuildIds);
				System.out.println("getServletContext().getContextPath():"+getServletContext().getContextPath());
				
			}else {
				//修改
				//通过宿舍管理员ID获取宿舍管理员
				User user = userService.findById(Integer.parseInt(id));
				user.setName(name);
				user.setPassWord(passWord);
				user.setSex(sex);
				user.setTel(tel);
				userService.updateManager(user);
				
				//修改还需修改宿舍管理员与宿舍楼的中间表
				//① 删除当前宿舍管理员管理的所有宿舍楼
				buildService.deleteByUserId(user.getId());
				
				//② 新增当前宿舍管理员管理的所有宿舍楼  
				buildService.saveManagerAndBuild(user.getId(),dormBuildIds);
			}
			//跳转到宿舍管理员列表页，查看所有的宿舍管理员
			//重定向，请求链断开，不能在下一个servlet或jsp中获取保存在request中的参数
			response.sendRedirect(getServletContext().getContextPath()+"/dormManager.action?action=list");
		
		}else if(action != null & action.equals("preUpdate")) {
			//跳转到修改宿舍管理员的页面
			
			//根据宿舍管理员ID，获取宿舍管理员
			User user = userService.findById(Integer.parseInt(id));
			//根据宿舍管理员ID获取宿舍管理员管理的楼栋
			List<DormBuild> userBuilds = buildService.findByUserId(user.getId());
			user.setDormBuilds(userBuilds);
			System.out.println("user:"+user);
			

			//删除或者激活
			String disabled = request.getParameter("disabled");
			
			Record record = recordService.findById(Integer.parseInt(id));
			record.setDisabled(Integer.parseInt(disabled));
			
			//查看用户是否有修改考勤记录的权限
			User user = userService.findStuCodeAndManager(record.getUser().getStuCode(),userCurr);
			System.out.println("修改权限user ："+user);
			if(user == null) {
				//无删除激活权限
				response.sendRedirect(getServletContext().getContextPath()+"/record.action?action=list");
			}else {
				//有删除激活权限
				recordService.update(record);
				//跳转到缺勤记录列表页
				response.sendRedirect(getServletContext().getContextPath()+"/record.action?action=list");
			}
		
		}
	}
		

}

/**
 * Servlet implementation class DormBuildServlet
 */

			String searchType = request.getParameter("searchType");
			String keyword = request.getParameter("keyword");
			//当前要查询的页面
			String pageIndex = request.getParameter("pageIndex");
			System.out.println("dormBuildId:"+dormBuildId+"  searchType:"+searchType+"  keyword:"+keyword);
			
			//默认查询第一页，需两个参数，当前页码pageIndex，每页展示的条数  
			PageModel pageModel = new PageModel();
			if(pageIndex != null && !pageIndex.equals("")) {
				pageModel.setPageIndex(Integer.parseInt(pageIndex));
			}
			List<User> students = userService.findStudent(dormBuildId,searchType,keyword,user,pageModel);
			//获取查询处理的总数量
			Integer  totalNum = userService.findTotalNum(dormBuildId,searchType,keyword,user);
			System.out.println("totalNum:"+totalNum);
			System.out.println("students:"+students);
			
			request.setAttribute("totalNum", totalNum);
			request.setAttribute("pageIndex", pageModel.getPageIndex());
			request.setAttribute("dormBuildId", dormBuildId);
			request.setAttribute("searchType", searchType);
			request.setAttribute("keyword", keyword);
			request.setAttribute("students", students);
			request.setAttribute("mainRight", "/WEB-INF/jsp/studentList.jsp");
			request.getRequestDispatcher("/WEB-INF/jsp/main.jsp").forward(request, response);
			
		}else if(action != null & action.equals("preAdd")) {
			//根据用户角色查询宿舍楼进行添加学生，
			//如当前用户 为宿舍管理员，他只能添加学生到其管理的宿舍楼
			
			//跳转到学生的添加页面
			request.setAttribute("mainRight", "/WEB-INF/jsp/studentAddOrUpdate.jsp");
			request.getRequestDispatcher("/WEB-INF/jsp/main.jsp").forward(request, response);
			
		}else if(action != null & action.equals("save")) {
			//保存学生
			String stuCode = request.getParameter("stuCode");
			String name = request.getParameter("name");
			String sex = request.getParameter("sex");
			String tel = request.getParameter("tel");
			String passWord = request.getParameter("passWord");
			String  dormBuildId= request.getParameter("dormBuildId");
			String dormCode = request.getParameter("dormCode");
			System.out.println("stuCode:"+stuCode+"  name:"+name+"   sex:"+sex+
					"  tel:"+tel+" passWord:"+passWord+" dormBuildId:"+dormBuildId+
					"  dormCode:"+dormCode);
			
			//未存在，则保存

			response.sendRedirect(getServletContext().getContextPath()+"/dormManager.action?action=list");
		
		}else if(action != null & action.equals("preUpdate")) {
			//跳转到修改宿舍管理员的页面
			
			//根据宿舍管理员ID，获取宿舍管理员
			User user = userService.findById(Integer.parseInt(id));
			//根据宿舍管理员ID获取宿舍管理员管理的楼栋
			List<DormBuild> userBuilds = buildService.findByUserId(user.getId());
			user.setDormBuilds(userBuilds);
			System.out.println("user:"+user);
			
			List<Integer>  userBuildids = new ArrayList<>();
			//遍历当前宿舍管理员管理的所有宿舍，获取当时当前宿舍管理员管理的所有宿舍ID
			for (DormBuild userBuild : userBuilds) {
				userBuildids.add(userBuild.getId());
			}
			
			
			request.setAttribute("userBuildids", userBuildids);
			request.setAttribute("user", user);
			request.setAttribute("mainRight", "dormManagerAddOrUpdate.jsp");
			request.getRequestDispatcher("/WEB-INF/jsp/main.jsp").forward(request, response);
		}else if(action != null & action.equals("deleteOrAcive")) {
			//删除或激活
			String  disabled =request.getParameter("disabled");
			
			//通过宿舍管理员ID获取宿舍管理员
			User user = userService.findById(Integer.parseInt(id));
			user.setDisabled(Integer.parseInt(disabled));
			userService.updateManager(user);
			
			//跳转到宿舍管理员列表页，查看所有的宿舍管理员
			//重定向，请求链断开，不能在下一个servlet或jsp中获取保存在request中的参数
			response.sendRedirect(getServletContext().getContextPath()+"/dormManager.action?action=list");
		}
	}

}