基于javaweb+mysql的jsp+servlet校园宿舍管理系统(java+jsp+javaweb+mysql+ajax)

最新推荐文章于 2023-09-12 14:58:42 发布

m0_71098312

最新推荐文章于 2023-09-12 14:58:42 发布

阅读量111

点赞数

文章标签： mysql java servlet

本文链接：https://blog.csdn.net/m0_71098312/article/details/131870776

版权

基于javaweb+mysql的jsp+servlet校园宿舍管理系统(java+jsp+javaweb+mysql+ajax)

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

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

适用

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

功能说明

基于javaweb+mysql的JSP+Servlet校园宿舍管理系统(java+jsp+javaweb+mysql+ajax)

一、项目简述

功能：宿舍管理员，最高管理员，学生三个身份，包括学生管理，宿舍管理员管理，考勤管理，宿舍楼管理，缺勤记录管理，个人信息修改等等功能。

二、项目运行

环境配置： Jdk1.8 + Tomcat8.5 + mysql + Eclispe (IntelliJ IDEA,Eclispe,MyEclispe,Sts都支持)。

项目技术： JSP + Entity+ Servlet + html+ css + JavaScript + JQuery + Ajax 等等。

				}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);
		}
	}


/**
 * Servlet implementation class DormBuildServlet
 */
@WebServlet("/dormBuild.action")
public class DormBuildServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public DormBuildServlet() {
        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("=========dormBuild.action=========");
		
		request.setCharacterEncoding("utf-8");
		String action = request.getParameter("action");
		//通过request.getParameter("id")方式获取的值都是String类型
		String id = request.getParameter("id");
		System.out.println("action:"+action);
		
		DormBuildService dormBuildService = new DormBuildServiceImpl();
		
		if(action != null & action.equals("list")) {
			List<DormBuild>  builds = new ArrayList<DormBuild>();
			if(id == null || id.equals("")) {
				//点击左侧宿舍楼管理，查询所有宿舍楼信息，跳转到宿舍楼列表页
				builds = dormBuildService.find();
			}else if(id != null && !id.equals("")) {

					user2.setPassWord(passWord);
					user2.setDormBuildId(Integer.parseInt(dormBuildId));
					user2.setDormCode(dormCode);
					user2.setRoleId(2);
					user2.setCreateUserId(user.getId());
					userService.saveStudent(user2);
					response.sendRedirect(getServletContext().getContextPath()+"/student.action?action=list");
				}
			}
			
		}else if(action != null & action.equals("preUpdate")) {
			//通过学生id查找学生并保存，以便在页面展示
			User userUpdate = userService.findById(Integer.parseInt(id));
			System.out.println("userUpdate:"+userUpdate);
			
			//判断当前登录的用户是否有修改该学生的权限，如没有跳转到学生管理的列表页；如有则跳转到修改页面
			User  user2 = userService.findByUserIdAndManager(userUpdate.getId(),user);
			System.out.println("查询管理权限user2:"+user2);
			if(user2 != null) {
				//表示有修改权限
				request.setAttribute("userUpdate", userUpdate);
				//跳转到学生管理的修改页面
				request.setAttribute("mainRight", "/WEB-INF/jsp/studentAddOrUpdate.jsp");
				request.getRequestDispatcher("/WEB-INF/jsp/main.jsp").forward(request, response);
			}else {
				//表示无修改权限，跳转到学生管理的列表页
				response.sendRedirect(getServletContext().getContextPath()+"/student.action?action=list");
			}
			
			
		}else if(action != null & action.equals("deleteOrActive")) {
			//删除或激活
			User studentUpdate = userService.findById(Integer.parseInt(id));
			studentUpdate.setDisabled(Integer.parseInt(disabled));
			
			//判断当前登录的用户是否有修改该学生的权限，如没有跳转到学生管理的列表页；如有则跳转到修改页面
			User  user2 = userService.findByUserIdAndManager(studentUpdate.getId(),user);
			System.out.println("查询删除激活权限user2:"+user2);
			if(user2 != null) {
				//表示有修改权限
				userService.updateStudent(studentUpdate);

			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");
		}
	}

}
package com.demo.util;

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

    /**
     * Default constructor. 
     */

			//执行更新
			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);
		}
		
		
	}

}
package com.demo.servlet;

/**
 * Servlet implementation class DormManagerServlet
 */
@WebServlet("/dormManager.action")
public class DormManagerServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()

			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);
			
			//未存在，则保存
			User student = userService.findByStuCode(stuCode);
			if(id != null && !id.equals("")) {
				//更新之前，查询数据库是否已经存在当前学号的学生，如已存在，则跳转到添加页面
				if(student != null  && !student.getId().equals(Integer.parseInt(id))) {

				//点击左侧宿舍楼管理，查询所有宿舍楼信息，跳转到宿舍楼列表页
				builds = dormBuildService.find();
			}else if(id != null && !id.equals("")) {
				//点击搜索按钮搜索宿舍楼，根据宿舍楼id查询宿舍楼信息
				DormBuild  build = dormBuildService.findById(Integer.parseInt(id));
				builds.add(build);
			}
			
			//查询所有的宿舍楼，在select中遍历
			List<DormBuild>  buildSelects = dormBuildService.find();
			request.setAttribute("buildSelects", buildSelects);
			request.setAttribute("id", id);
			System.out.println("builds:"+builds);
			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("preAdd")) {
			//表示跳转到宿舍楼添加页面
			request.setAttribute("mainRight", "/WEB-INF/jsp/dormBuildAddOrUpdate.jsp");
			request.getRequestDispatcher("/WEB-INF/jsp/main.jsp").forward(request, response);
			
		}else if(action != null & action.equals("save")) {
			//保存数据
			String name = request.getParameter("name");
			String remark = request.getParameter("remark");
			System.out.println("name:"+name+"  remark:"+remark);
			
			
			//宿舍楼名字不能重复，从数据库查询，当前用户输入的宿舍楼名字是否已经存在
			DormBuild  dormBuild = dormBuildService.findByName(name);
			System.out.println("dormBuild:"+dormBuild);
			
			if(id != null && !id.equals("")) {
				//更新
				if(dormBuild != null && !dormBuild.getId().equals(Integer.parseInt(id))) {
					//表示跳转到宿舍楼添加页面
					request.setAttribute("error", "当前宿舍楼名已存在，请重新输入！");
					
					//根据宿舍楼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 {
					dormBuild = dormBuildService.findById(Integer.parseInt(id));

			}else {
				//表示无修改权限，跳转到学生管理的列表页
				response.sendRedirect(getServletContext().getContextPath()+"/student.action?action=list");
			}
			
			
		}else if(action != null & action.equals("deleteOrActive")) {
			//删除或激活
			User studentUpdate = userService.findById(Integer.parseInt(id));
			studentUpdate.setDisabled(Integer.parseInt(disabled));
			
			//判断当前登录的用户是否有修改该学生的权限，如没有跳转到学生管理的列表页；如有则跳转到修改页面
			User  user2 = userService.findByUserIdAndManager(studentUpdate.getId(),user);
			System.out.println("查询删除激活权限user2:"+user2);
			if(user2 != null) {
				//表示有修改权限
				userService.updateStudent(studentUpdate);
				response.sendRedirect(getServletContext().getContextPath()+"/student.action?action=list");
			}else {
				//表示无修改权限，跳转到学生管理的列表页
				response.sendRedirect(getServletContext().getContextPath()+"/student.action?action=list");
			}
			
		}
			
	}
}

package com.demo.servlet;

				DormBuild  build = dormBuildService.findById(Integer.parseInt(id));
				builds.add(build);
			}
			
			//查询所有的宿舍楼，在select中遍历
			List<DormBuild>  buildSelects = dormBuildService.find();
			request.setAttribute("buildSelects", buildSelects);
			request.setAttribute("id", id);
			System.out.println("builds:"+builds);
			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("preAdd")) {
			//表示跳转到宿舍楼添加页面
			request.setAttribute("mainRight", "/WEB-INF/jsp/dormBuildAddOrUpdate.jsp");
			request.getRequestDispatcher("/WEB-INF/jsp/main.jsp").forward(request, response);
			
		}else if(action != null & action.equals("save")) {
			//保存数据
			String name = request.getParameter("name");
			String remark = request.getParameter("remark");
			System.out.println("name:"+name+"  remark:"+remark);
			
			
			//宿舍楼名字不能重复，从数据库查询，当前用户输入的宿舍楼名字是否已经存在
			DormBuild  dormBuild = dormBuildService.findByName(name);
			System.out.println("dormBuild:"+dormBuild);
			
			if(id != null && !id.equals("")) {
				//更新
				if(dormBuild != null && !dormBuild.getId().equals(Integer.parseInt(id))) {
					//表示跳转到宿舍楼添加页面
					request.setAttribute("error", "当前宿舍楼名已存在，请重新输入！");
					
					//根据宿舍楼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 {

		}else if(action != null & action.equals("preUpdate")) {
			//通过学生id查找学生并保存，以便在页面展示
			User userUpdate = userService.findById(Integer.parseInt(id));
			System.out.println("userUpdate:"+userUpdate);
			
			//判断当前登录的用户是否有修改该学生的权限，如没有跳转到学生管理的列表页；如有则跳转到修改页面
			User  user2 = userService.findByUserIdAndManager(userUpdate.getId(),user);
			System.out.println("查询管理权限user2:"+user2);
			if(user2 != null) {
				//表示有修改权限
				request.setAttribute("userUpdate", userUpdate);
				//跳转到学生管理的修改页面
				request.setAttribute("mainRight", "/WEB-INF/jsp/studentAddOrUpdate.jsp");
				request.getRequestDispatcher("/WEB-INF/jsp/main.jsp").forward(request, response);
			}else {
				//表示无修改权限，跳转到学生管理的列表页
				response.sendRedirect(getServletContext().getContextPath()+"/student.action?action=list");
			}
			
			
		}else if(action != null & action.equals("deleteOrActive")) {
			//删除或激活
			User studentUpdate = userService.findById(Integer.parseInt(id));
			studentUpdate.setDisabled(Integer.parseInt(disabled));
			
			//判断当前登录的用户是否有修改该学生的权限，如没有跳转到学生管理的列表页；如有则跳转到修改页面
			User  user2 = userService.findByUserIdAndManager(studentUpdate.getId(),user);
			System.out.println("查询删除激活权限user2:"+user2);
			if(user2 != null) {
				//表示有修改权限
				userService.updateStudent(studentUpdate);
				response.sendRedirect(getServletContext().getContextPath()+"/student.action?action=list");
			}else {
				//表示无修改权限，跳转到学生管理的列表页
				response.sendRedirect(getServletContext().getContextPath()+"/student.action?action=list");
			}
			
		}
			
	}
}

package com.demo.servlet;

			request.setAttribute("totalNum", totalNum);
			request.setAttribute("startDate", startDate);
			request.setAttribute("endDate", endDate);
			request.setAttribute("dormBuildId", dormBuildId);
			request.setAttribute("searchType", searchType);
			request.setAttribute("keyword", keyword);
			request.setAttribute("pageIndex", pageModel.getPageIndex());
			request.setAttribute("records", records);
			request.setAttribute("mainRight", "/WEB-INF/jsp/recordList.jsp");
			request.getRequestDispatcher("/WEB-INF/jsp/main.jsp").forward(request, response);
			
		}else if(action != null && action.equals("preAdd")) {
			//跳转到添加页面
			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();
					}

		}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);
					studentUpdate.setPassWord(passWord);
					studentUpdate.setDormBuildId(Integer.parseInt(dormBuildId));
					studentUpdate.setDormCode(dormCode);
					
					userService.updateStudent(studentUpdate);
					response.sendRedirect(getServletContext().getContextPath()+"/student.action?action=list");
				}
				
			}else {
				//保存
				if(student != null) {

        System.out.println("stuCode:" + stuCode + "  password:" + password + "   remember:" + remember);

        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());
        }
    }
}
package com.demo.servlet;

			}
			
		}
			
	}
}

package com.demo.servlet;

/**
 * Servlet implementation class RecordServlet
 */
@WebServlet("/record.action")
public class RecordServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public RecordServlet() {
        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("====record.action========");

				//通过宿舍管理员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);
			
			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");

			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");
			}
		
		}
	}
		

}
package com.demo.servlet;

/**
 * Servlet implementation class DormBuildServlet
 */
@WebServlet("/dormBuild.action")
public class DormBuildServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public DormBuildServlet() {
        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("=========dormBuild.action=========");

			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);
			
			//未存在，则保存
			User student = userService.findByStuCode(stuCode);
			if(id != null && !id.equals("")) {
				//更新之前，查询数据库是否已经存在当前学号的学生，如已存在，则跳转到添加页面
				if(student != null  && !student.getId().equals(Integer.parseInt(id))) {
					System.out.println("根据学生学号查询student:"+student);

					dormBuild = dormBuildService.findById(Integer.parseInt(id));
					dormBuild.setName(name);
					dormBuild.setRemark(remark);
					
					//执行更新
					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);
					
				}
			}else {
				//保存
				if(dormBuild != null) {
					//当前用户输入的宿舍楼名已存在
					//表示跳转到宿舍楼添加页面
					request.setAttribute("error", "当前宿舍楼名已存在，请重新输入！");
					request.setAttribute("mainRight", "/WEB-INF/jsp/dormBuildAddOrUpdate.jsp");
					request.getRequestDispatcher("/WEB-INF/jsp/main.jsp").forward(request, response);
				}else {
					//当前用户输入的宿舍楼名不存在，则保存用户输入的信息到数据库
					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);
			//跳转到宿舍楼修改页面

				//无删除激活权限
				response.sendRedirect(getServletContext().getContextPath()+"/record.action?action=list");
			}else {
				//有删除激活权限
				recordService.update(record);
				//跳转到缺勤记录列表页
				response.sendRedirect(getServletContext().getContextPath()+"/record.action?action=list");
			}
		
		}
	}
		

}
package com.demo.servlet;

/**
 * Servlet implementation class DormBuildServlet
 */
@WebServlet("/dormBuild.action")
public class DormBuildServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public DormBuildServlet() {
        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("=========dormBuild.action=========");
		
		request.setCharacterEncoding("utf-8");
		String action = request.getParameter("action");

			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");


/**
 * Servlet implementation class DormBuildServlet
 */
@WebServlet("/dormBuild.action")
public class DormBuildServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public DormBuildServlet() {
        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("=========dormBuild.action=========");
		
		request.setCharacterEncoding("utf-8");
		String action = request.getParameter("action");
		//通过request.getParameter("id")方式获取的值都是String类型
		String id = request.getParameter("id");
		System.out.println("action:"+action);
		
		DormBuildService dormBuildService = new DormBuildServiceImpl();
		
		if(action != null & action.equals("list")) {
			List<DormBuild>  builds = new ArrayList<DormBuild>();

        String password = request.getParameter("password");
        String remember = request.getParameter("remember");
        System.out.println("stuCode:" + stuCode + "  password:" + password + "   remember:" + remember);

        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());
        }
    }
}
package com.demo.servlet;

/**
 * Servlet implementation class PassWordServlet
 */

		Cookie cookie = getCookieByName(request,cookieName);
		//如有该项目保存学号和密码的cookie，则更改cookie的值，如未有则新建cookie
		if(cookie != null) {
			cookie.setValue(stuCode+"#"+password);
		}else {
			cookie = new Cookie(cookieName, stuCode+"#"+password);
		}
		
		//设置cookie的有效时间
		cookie.setMaxAge(time);
		//设置cookie的作用范围 只在当前项目范围中有效
		cookie.setPath(request.getContextPath());
		System.out.println("request.getContextPath():"+request.getContextPath());
		
		response.addCookie(cookie);
	}

	public static Cookie getCookieByName(HttpServletRequest request, String cookieName) {
		//从request中获取当前项目的作用cookie
		Cookie[] cookies = request.getCookies();
		//遍历所有cookie
		if(cookies != null && cookies.length >0) {
			for (Cookie cookie : cookies) {
				//根据cookie的名字获取cookie，并返回
				if(cookie.getName().equals(cookieName)) {
					return cookie;
				}
			}
		}
		return null;
	}

}
package com.demo.servlet;

/**
 * Servlet implementation class IndexServlet
 */
@WebServlet("/index.action")
public class IndexServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;

			//获取查询结果总数
			Integer totalNum = recordService.getToTalNum(startDate,endDate,dormBuildId,
					searchType,keyword,userCurr);
			System.out.println("totalNum:"+totalNum);
			
			request.setAttribute("totalNum", totalNum);
			request.setAttribute("startDate", startDate);
			request.setAttribute("endDate", endDate);
			request.setAttribute("dormBuildId", dormBuildId);
			request.setAttribute("searchType", searchType);
			request.setAttribute("keyword", keyword);
			request.setAttribute("pageIndex", pageModel.getPageIndex());
			request.setAttribute("records", records);
			request.setAttribute("mainRight", "/WEB-INF/jsp/recordList.jsp");
			request.getRequestDispatcher("/WEB-INF/jsp/main.jsp").forward(request, response);
			
		}else if(action != null && action.equals("preAdd")) {
			//跳转到添加页面
			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");


public class CookieUtil {

	public static void addCookie(String cookieName, int time, 
			HttpServletRequest request,HttpServletResponse response, 
			String stuCode, String password) {
		//根据保存学号和密码的cookie的名字获取cookie
		Cookie cookie = getCookieByName(request,cookieName);
		//如有该项目保存学号和密码的cookie，则更改cookie的值，如未有则新建cookie
		if(cookie != null) {
			cookie.setValue(stuCode+"#"+password);
		}else {
			cookie = new Cookie(cookieName, stuCode+"#"+password);
		}
		
		//设置cookie的有效时间
		cookie.setMaxAge(time);
		//设置cookie的作用范围 只在当前项目范围中有效
		cookie.setPath(request.getContextPath());
		System.out.println("request.getContextPath():"+request.getContextPath());
		
		response.addCookie(cookie);
	}

	public static Cookie getCookieByName(HttpServletRequest request, String cookieName) {
		//从request中获取当前项目的作用cookie
		Cookie[] cookies = request.getCookies();
		//遍历所有cookie
		if(cookies != null && cookies.length >0) {
			for (Cookie cookie : cookies) {
				//根据cookie的名字获取cookie，并返回
				if(cookie.getName().equals(cookieName)) {
					return cookie;
				}
			}
		}
		return null;
	}

}
package com.demo.servlet;

					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);
					record.setDisabled(0);
					record.setRemark(remark);
					//保存数据到数据库
					recordService.save(record);
					
					response.sendRedirect(getServletContext().getContextPath()+"/record.action?action=list");
				}else {
					//没有添加的权限,跳转到添加页面
					request.setAttribute("error", "您没有添加该学号学生缺勤记录的权限！");
					request.setAttribute("mainRight", "/WEB-INF/jsp/recordAddOrUpdate.jsp");
					request.getRequestDispatcher("/WEB-INF/jsp/main.jsp").forward(request, response);
				}
			}
			
			
			
		}else if(action != null && action.equals("preUpdate")) {
			//跳转到修改页面
			Record record = recordService.findById(Integer.parseInt(id));
			System.out.println("record:"+record);
			
			//查看用户是否有修改考勤记录的权限
			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 {
				request.setAttribute("record", record);
				request.setAttribute("mainRight", "/WEB-INF/jsp/recordAddOrUpdate.jsp");
				request.getRequestDispatcher("/WEB-INF/jsp/main.jsp").forward(request, response);

请添加图片描述

m0_71098312

关注

0
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
基于javaweb+mysql的jsp+servlet校园宿舍管理系统(java+jsp+javaweb+mysql+ajax)

项目技术： JSP + Entity+ Servlet + html+ css + JavaScript + JQuery + Ajax 等等。功能：宿舍管理员，最高管理员，学生三个身份，包括学生管理，宿舍管理员管理，考勤管理，宿舍楼管理，缺勤记录管理，个人信息修改等等功能。基于javaweb+mysql的jsp+servlet校园宿舍管理系统(java+jsp+javaweb+mysql+ajax)课程设计，大作业，毕业设计，项目练习，学习演示等。
复制链接

扫一扫