• 基于javaweb的宿舍管理系统(idea+servlet+jsp+jdbc)


    一、系统简介

    本项目采用idea工具开发,jsp+servlet+jquery技术编写,数据库采用的是mysql,navicat开发工具。

    系统一共分为3个角色分别是:系统管理员,宿舍管理员,学生

    获取源码:xystgl · master · 码盗_java_bishe / java系统 · GitCode

    二、模块简介

    系统管理员

    1、登录

    2、宿舍管理员管理

    3、学生管理

    4、宿舍楼管理

    5、缺勤记录管理

    6、个人密码修改

    宿舍管理员

    1、登录

    2、发布公告信息

    3、办理学生入住信息

    4、查看寝室

    5、查看学生

    6、寝室调换

    7、签到管理

    8、缺勤记录

    9、报修管理

    10、卫生评比

    11、访客登记

    12、物品登记

    13、密码修改

    学生

    1、登录

    2、个人信息管理

    3、签到管理

    4、缺勤记录管理

    5、报修管理

    6、卫生评比

    7、密码修改

    项目简介
    难度等级:✩✩✩
    用户类型:3角色(系统管理员,宿舍管理员,学生)
    设计模式:MVC
    项目架构:B/S架构
    开发语言:Java语言
    前端技术:HTML、CSS、JS、JQuery等
    后端技术:JSP、servlet框架
    运行环境:Windows7或10、JDK1.8
    运行工具:本系统采用idea开发,仅支持idea运行,不支持MyEclipse和eclipse运行,因为三者的骨架不一样,强行导入打开运行可能会导致出现未知的错误。
    数  据  库:MySQL5.5/5.7/8.0版本
    运行服务器:Tomcat7.0/8.0/8.5/9.0等版本
    是否基于Maven环境:否
    是否采用框架:是
    数据库表数量:12张表
    JSP页面数量:40多张
    是否有分页:有分页

    相关截图

    相关代码

    登录

    1. <%@ page language="java" contentType="text/html; charset=utf-8"
    2. pageEncoding="utf-8"%>
    3. <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
    4. <%@ page import="com.demo.bean.Admin" %>
    5. <%@ page import="com.demo.bean.DormManager" %>
    6. <%@ page import="com.demo.bean.Student"%>
    7. <%@ page import="com.demo.util.*"%>
    8. <%
    9. String path = request.getContextPath();
    10. String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
    11. %>
    12. <html>
    13. <head>
    14. <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    15. <title>宿舍管理系统title>
    16. <script type="text/javascript" src="bootstrap/js/jQuery.js">script>
    17. <script type="text/javascript">
    18. function changeImg(){
    19. var imgSrc = $("#img");
    20. var src = imgSrc.attr("src");
    21. imgSrc.attr("src",chgUrl(src));
    22. }
    23. //时间戳
    24. //为了使每次生成图片不一致,即不让浏览器读缓存,所以需要加上时间戳
    25. function chgUrl(url){
    26. var timestamp = (new Date()).valueOf();
    27. url = url.substring(0,17);
    28. if((url.indexOf("&")>=0)){
    29. url = url + "×tamp=" + timestamp;
    30. }else{
    31. url = url + "?timestamp=" + timestamp;
    32. }
    33. return url;
    34. }
    35. jquery验证阻止表单提交///
    36. $(document).ready(function(){
    37. $(":submit[id=tijiao]").click(function(check){
    38. var val = $(":text[id=code]").val();
    39. var userName = document.getElementById("userName").value;
    40. var password = document.getElementById("password").value;
    41. var userType = document.getElementById("userType").value;
    42. var code = document.getElementById("code").value;
    43. var remember=document.getElementById("remember").value;
    44. if (userType =="tip") {
    45. // alert("文本框输入为空,不能提交表单!");
    46. $(":text[id=userType]").focus();
    47. check.preventDefault();//此处阻止提交表单
    48. return false;
    49. }
    50. if (userName == null || userName == "") {
    51. document.getElementById("error").innerHTML = "用户名不能为空";
    52. // alert("文本框输入为空,不能提交表单!");
    53. $(":text[id=userName]").focus();
    54. check.preventDefault();//此处阻止提交表单
    55. return false;
    56. }
    57. if (password == null || password == "") {
    58. document.getElementById("error").innerHTML = "密码不能为空";
    59. //alert("文本框输入为空,不能提交表单!");
    60. $(":text[id=password]").focus();
    61. check.preventDefault();//此处阻止提交表单
    62. return false;
    63. }
    64. if (code == null || code == "") {
    65. document.getElementById("error").innerHTML = "验证码不能为空";
    66. document.getElementByIdx_x("code").focus;
    67. //alert("文本框输入为空,不能提交表单!");
    68. $(":text[id=code]").focus();
    69. check.preventDefault();//此处阻止提交表单
    70. return false;
    71. }
    72. });
    73. });
    74. function checkForm() {
    75. var userName = document.getElementById("userName").value;
    76. var password = document.getElementById("password").value;
    77. var userType = document.getElementById("userType").value;
    78. var code = document.getElementById("code").value;
    79. var remember=document.getElementById("remember").value;
    80. if (userType =="tip") {
    81. document.getElementById("error").innerHTML = "请选择用户类型";
    82. return false;
    83. }
    84. if (userName == null || userName == "") {
    85. document.getElementById("error").innerHTML = "用户名不能为空";
    86. return false;
    87. }
    88. if (password == null || password == "") {
    89. document.getElementById("error").innerHTML = "密码不能为空";
    90. return false;
    91. }
    92. code = "codetemp=" + code;
    93. $.ajax({
    94. type:"POST",
    95. url:"codeser",
    96. data:code,
    97. success:callback
    98. });
    99. }
    100. function callback(data){
    101. if(data==2){
    102. alert("验证码错误");
    103. //document.getElementById("error").innerHTML = "验证码错误";
    104. //window.parent.window.location.href="login.jsp";
    105. //$("#info").html("验证码错误");
    106. return false;
    107. }else{
    108. var userName = document.getElementById("userName").value;
    109. var password = document.getElementById("password").value;
    110. var userType = document.getElementById("userType").value;
    111. var remember=document.getElementById("remember").value;
    112. //window.parent.window.location.href="login?userType="+userType+"&password="+password+"&userName="+userName+"&remember="+remember;
    113. // window.parent.window.location.href="main.jsp";
    114. // document.myForm.action="login";
    115. return true;
    116. }
    117. }
    118. function changeval(){
    119. var check = document.getElementById("remember");
    120. if(check.checked == true){
    121. document.getElementById("remember").value = "remember-me";
    122. }else{
    123. document.getElementById("remember").value = "0";
    124. }
    125. }
    126. script>
    127. <link href="<%=basePath%>/bootstrap/boot/bootstrap.min.css" rel="stylesheet">
    128. <link href="<%=basePath%>/bootstrap/boot/materialdesignicons.min.css" rel="stylesheet">
    129. <link href="<%=basePath%>/bootstrap/boot/style.min.css" rel="stylesheet">
    130. <link href="<%=basePath%>/bootstrap/boot/login.css" rel="stylesheet">
    131. <style>
    132. td{
    133. text-align: center;
    134. }
    135. th{
    136. text-align: center;
    137. }
    138. style>
    139. head>
    140. <body >
    141. <%-- style="
    142. background-image:url(<%=basePath%>/images/bg.jpg);
    143. background-repeat:no-repeat;background-size:cover;" --%>
    144. <div class="row lyear-wrapper">
    145. <div class="lyear-login">
    146. <div class="login-center">
    147. <div class="login-header text-center">
    148. <a href=""> <h4 style="color: #15c377;">宿舍管理系统h4>a>
    149. div>
    150. <FORM name="myForm" action="login" class="form-signin" method="post">
    151. <div class="form-group has-feedback feedback-left">
    152. <input type="text" placeholder="请输入账号" class="form-control" name="userName" id="userName"/>
    153. <span class="mdi mdi-account form-control-feedback" aria-hidden="true"> span>
    154. <span id="msg" style="color:red;">span>
    155. div>
    156. <div class="form-group has-feedback feedback-left">
    157. <input type="password" placeholder="请输入密码" class="form-control" id="password" name="password" />
    158. <span class="mdi mdi-lock form-control-feedback" aria-hidden="true">span>
    159. <span id="msg2" style="color:red;">span>
    160. div>
    161. <div class="form-group has-feedback feedback-left row">
    162. <div class="col-xs-12">
    163. <select name ="userType" class="form-control" id="userType" title="请选择角色" name="example-select" size="1">
    164. <option selected="selected" value="tip">请选择角色option>
    165. <option value="admin"${userType==1?'selected':''} >系统管理员option>
    166. <option value="dormManager"${userType==2?'selected':''}>宿舍管理员option>
    167. <option value="student"${userType==3?'selected':''}>学生option>
    168. select>
    169. select>
    170. div>
    171. div>
    172. <font color="red">${message}font>
    173. <div class="form-group">
    174. <button class="btn btn-block btn-primary" type="submit" id="login" id="tijiao" onclick="checkForm()" value="登录" >立即登录button>
    175. div>
    176. form>
    177. <footer class="col-sm-12 text-center">
    178. footer>
    179. div>
    180. div>
    181. div>
    182. body>
    183. html>
    1. package com.demo.web;
    2. import java.io.IOException;
    3. import java.security.NoSuchAlgorithmException;
    4. import java.sql.Connection;
    5. import java.util.List;
    6. import javax.servlet.ServletException;
    7. import javax.servlet.http.Cookie;
    8. import javax.servlet.http.HttpServlet;
    9. import javax.servlet.http.HttpServletRequest;
    10. import javax.servlet.http.HttpServletResponse;
    11. import javax.servlet.http.HttpSession;
    12. import com.demo.bean.Admin;
    13. import com.demo.bean.Dorm;
    14. import com.demo.bean.DormManager;
    15. import com.demo.bean.Student;
    16. import com.demo.dao.DormDao;
    17. import com.demo.dao.UserDao;
    18. import com.demo.util.DbUtil;
    19. import com.demo.util.MD5Util;
    20. /**
    21. * 登陆验证
    22. *
    23. *
    24. */
    25. public class LoginServlet extends HttpServlet {
    26. private static final long serialVersionUID = 1L;
    27. DbUtil dbUtil = new DbUtil();
    28. UserDao userDao = new UserDao();
    29. @Override
    30. protected void doGet(HttpServletRequest request, HttpServletResponse response)
    31. throws ServletException, IOException {
    32. this.doPost(request, response);
    33. }
    34. @Override
    35. protected void doPost(HttpServletRequest request, HttpServletResponse response)
    36. throws ServletException, IOException {
    37. request.setCharacterEncoding("utf-8");
    38. HttpSession session = request.getSession();
    39. String userName = request.getParameter("userName");
    40. String password = null;
    41. password=request.getParameter("password");
    42. try {
    43. password = MD5Util.EncoderPwdByMD5(request.getParameter("password"));
    44. } catch (NoSuchAlgorithmException e1) {
    45. e1.printStackTrace();
    46. }
    47. // System.out.println(password);
    48. String remember = request.getParameter("remember");
    49. // System.out.println("remember"+remember);
    50. String userType = request.getParameter("userType");
    51. Connection con = null;
    52. try {
    53. con=dbUtil.getCon();
    54. Admin currentAdmin = null;
    55. DormManager currentDormManager = null;
    56. Student currentStudent = null;
    57. //系统管理员
    58. if("admin".equals(userType)) {
    59. Admin admin = new Admin(userName, password);
    60. currentAdmin = userDao.Login(con, admin);
    61. if(currentAdmin == null) {
    62. request.setAttribute("admin", admin);
    63. request.setAttribute("error", "用户名或密码错误");
    64. request.getRequestDispatcher("login.jsp").forward(request, response);
    65. } else {
    66. if("remember-me".equals(remember)) {
    67. rememberMe(userName, password, userType,response);
    68. } else {
    69. deleteCookie(userName, request, response);
    70. }
    71. session.setAttribute("currentUserType", "admin");
    72. session.setAttribute("currentUser", currentAdmin);
    73. request.setAttribute("mainPage", "admin/blank.jsp");
    74. request.getRequestDispatcher("mainAdmin.jsp").forward(request, response);
    75. }
    76. //宿舍管理员
    77. } else if("dormManager".equals(userType)) {
    78. DormManager dormManager = new DormManager(userName, password);
    79. currentDormManager = userDao.Login(con, dormManager);
    80. if(currentDormManager == null) {
    81. request.setAttribute("dormManager", dormManager);
    82. request.setAttribute("error", "用户名或密码错误");
    83. request.getRequestDispatcher("login.jsp").forward(request, response);
    84. } else {
    85. if("remember-me".equals(remember)) {
    86. rememberMe(userName, password, userType,response);
    87. } else {
    88. deleteCookie(userName, request, response);
    89. }
    90. DormDao dormDao = new DormDao();
    91. List dormlist = dormDao.dormList(con, currentDormManager.getDormBuildId());
    92. session.setAttribute("dormlist", dormlist);
    93. session.setAttribute("buildid", currentDormManager.getDormBuildId());
    94. session.setAttribute("currentUserType", "dormManager");
    95. session.setAttribute("currentUser", currentDormManager);
    96. request.setAttribute("mainPage", "dormManager/blank.jsp");
    97. request.getRequestDispatcher("mainManager.jsp").forward(request, response);
    98. }
    99. //学生
    100. } else if("student".equals(userType)) {
    101. Student student = new Student(userName, password);
    102. currentStudent = userDao.Login(con, student);
    103. if(currentStudent == null) {
    104. request.setAttribute("student", student);
    105. request.setAttribute("error", "用户名或密码错误");
    106. request.getRequestDispatcher("login.jsp").forward(request, response);
    107. } else {
    108. if("remember-me".equals(remember)) {
    109. rememberMe(userName, password, userType,response);
    110. } else {
    111. deleteCookie(userName, request, response);
    112. }
    113. session.setAttribute("currentUserType", "student");
    114. session.setAttribute("currentUser", currentStudent);
    115. request.setAttribute("mainPage", "student/blank.jsp");
    116. request.getRequestDispatcher("mainStudent.jsp").forward(request, response);
    117. }
    118. }
    119. } catch(Exception e) {
    120. e.printStackTrace();
    121. } finally {
    122. try {
    123. dbUtil.closeCon(con);
    124. } catch (Exception e) {
    125. e.printStackTrace();
    126. }
    127. }
    128. }
    129. private void rememberMe(String userName, String password, String userType, HttpServletResponse response) {
    130. Cookie user = new Cookie("dormuser", userName+"-"+password+"-"+userType+"-"+"yes");
    131. user.setMaxAge(1*60*60*24*7);
    132. response.addCookie(user);
    133. }
    134. private void deleteCookie(String userName, HttpServletRequest request, HttpServletResponse response) {
    135. Cookie[] cookies=request.getCookies();
    136. for(int i=0;cookies!=null && i
    137. if(cookies[i].getName().equals("dormuser")){
    138. if(userName.equals(userName=cookies[i].getValue().split("-")[0])) {
    139. Cookie cookie = new Cookie(cookies[i].getName(), null);
    140. cookie.setMaxAge(0);
    141. response.addCookie(cookie);
    142. break;
    143. }
    144. }
    145. }
    146. }
    147. }


    非开源!!!!!!
    项目截图中的数据,很多是用来测试的,需求自行添加合适的数据图片

    喜欢的朋友的点赞加关注,感兴趣的同学可以研究!!!!!
    感谢  = v =
     

  • 相关阅读:
    联想集团:2022/23财年第一季度业绩
    【python】Windows 系统 chrome禁止更新
    过去式-ed的发音规则
    【精讲】vue2框架 GitHub数据获取(内含详细解析)
    Linux中间件之redis的淘汰策略和持久化
    Redis实战——优惠券秒杀(一人一单业务)
    Linux软件包管理— yum命令
    LCR 164.破解闯关密码(数字---字符)
    数据结构之八大排序——希尔排序
    一种通过注解处理数据权限设计整理
  • 原文地址:https://blog.csdn.net/qq_43485489/article/details/126420270