基于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)

/**
 * Servlet implementation class LoginServlet
 */
@WebServlet("/login")
public class LoginServlet extends HttpServlet {
   
    private static final long serialVersionUID = 1L;

    /**
     * @see HttpServlet#HttpServlet()
     */
    public LoginServlet() {
   
        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("========登录=============");
        //Tomcat8.0 处理post请求乱码问题
        request.setCharacterEncoding("utf-8");
        //根据输入框标签的name属性值去获登录名和密码
        String stuCode = request.getParameter("stuCode");
        String password = request.getParameter("password");
        String remember = request.getParameter("remember");
        System.out.println("stuCode:" + stuCode + "  password:" + password + "   remember:" + remember);

        UserService userService = new UserServiceImpl();

					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);
			//跳转到宿舍楼修改页面
			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);
			

					//记住在浏览器的学号和密码有效，放行，自动登录成功将用户信息保存在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);

	/**
	 * @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.printl