当前位置: article > 正文

JavaWeb学生宿舍管理系统（JSP+JDBC+Servlet）_宿舍管理系统(servlet+jsp+jdbc) 附源码论文答辩ppt javaweb课程设计 ja

作者：我家小花儿 | 2024-04-23 09:04:51

踩

宿舍管理系统(servlet+jsp+jdbc) 附源码论文答辩ppt javaweb课程设计 javaweb大作

学生宿舍管理系统
java运行环境：jdk1.8；
web服务器版本：tomcat8.5；
开发工具：idea2020.1 + navicat premium 15
数据库：mysql 8.0
源码地址：学生宿舍管理系统源码
CSND无需积分下载：学生宿舍管理系统源码
文档可以参考：学生宿舍管理系统需求分析与数据库设计
欢迎有问题的同学在评论区评论呀！会及时回复的

1. 学生宿舍管理系统首页沿用通讯录首页（利用flexibile布局）

在这里插入图片描述

具体代码实现：（header.jsp+index.jsp）

header.jsp

<%@ page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<!doctype html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
    <link rel="stylesheet" href="css/bootstrap.min.css">
    <link rel="stylesheet" type="text/css" href="css/mystyles.css">
    <link rel="stylesheet" type="text/css" href="css/all.css">
    <title>学生宿舍管理系统</title>
  </head>
  <script type="text/javascript">
    function logout(){
      if(!confirm("真的要退出吗？")){
        window["event"].returnValue = false;
      }
    }
  </script>
<body>
    <nav class="navbar navbar-inverse navbar-fixed-top">
      <div class="container-fluid">
        <div class="navbar-header">
          <a class="navbar-brand text-primary" href="index.jsp">学生宿舍管理系统</a>
        </div>
        <!-- 无用户登录-->
        <c:if test="${sessionScope.studentname == null && sessionScope.dormadminname == null}">
          <div id="navbar" class="navbar-collapse collapse">
            <ul class="nav justify-content-end">
              <li class="nav-item active">
                <a class="navbar-right" href="student_login.jsp">学生登陆</a>
              </li>
              <li class="nav-item active">
                <a class="navbar-right" href="admin_login.jsp">管理员登陆</a>
              </li>
            </ul>
          </div>
        </c:if>
        <!-- 学生-->
        <c:if test="${sessionScope.studentname != null}">
        <div id="navbar" class="navbar-collapse collapse">
          <ul class="nav justify-content-end">
            <li class="nav-item active">
              <a class="navbar-right" href="student_information.jsp">正在登陆的用户为：${sessionScope.studentname}(学生)</a>
            </li>
            <li class="nav-item active">
              <a class="navbar-right" href="${pageContext.request.contextPath}/LoginOutServlet" onclick="return logout()">退出</a>
            </li>
          </ul>
        </div>
        </c:if>
        <!-- 管理员-->
        <c:if test="${sessionScope.dormadminname != null}">
          <div id="navbar" class="navbar-collapse collapse">
            <ul class="nav justify-content-end">
              <li class="nav-item active">
                <a class="navbar-right" href="admin_student_information.jsp">正在登陆的用户为：${sessionScope.dormadminname}(宿管)</a>
              </li>
              <li class="nav-item active">
                <a class="navbar-right" href="${pageContext.request.contextPath}/LoginOutServlet" onclick="return logout()">退出</a>
              </li>
            </ul>
          </div>
        </c:if>

      </div>
    </nav>
</body>
</html>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69

index.jsp

<%@ page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!doctype html>
<html lang="en">
<head>
  <!-- Required meta tags -->
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

  <!-- Bootstrap CSS -->
  <link rel="stylesheet" href="css/bootstrap.min.css">
  <link rel="icon" href="images/FINN.ico">
  <!-- my style CSS -->
  <link rel="stylesheet" type="text/css" href="css/mystyles.css">
  <link rel="stylesheet" type="text/css" href="css/all.css">
  <link rel="stylesheet" type="text/css" href="css/main.css">
  <script type="text/javascript" src="js/main.js"></script>
  <title>学生宿舍管理系统</title>
</head>
<body>
<%@ include file="header.jsp" %>
<div class="page">
  <header class="page_header">
    <h1>学生宿舍管理系统</h1>
  </header>
  <div class="cards-holder">
    <div class="card">
      <header class="card_header" data-background="">
        <h2>查看宿舍信息</h2>
      </header>
      <section class="card_content">
        <h2>学生与宿管均可查看</h2>
        <p>宿管可以查看学生用户账号密码，并且宿管可以查询学生信息。</p>
      </section>
    </div>

    <div class="card">
      <header class="card_header" data-background="">
        <h2>查看快件信息</h2>
      </header>
      <section class="card_content">
        <h2>学生与宿管均可查看</h2>
        <p>宿管可以查看所有人的快件信息并且可以提交取件人和取件人电话号码等。</p>
      </section>
    </div>

    <div class="card">
      <header class="card_header" data-background="">
        <h2>维修信息</h2>
      </header>
      <section class="card_content">
        <h2>学生与宿管均可查看</h2>
        <p>学生可以提交需要维修的物品，宿管可以修改维修物品的状态。</p>
      </section>
    </div>

    <div class="card">
      <header class="card_header" data-background="">
        <h2>离反校信息与晚归信息</h2>
      </header>
      <section class="card_content">
        <h2>学生宿管均可查看</h2>
        <p>学生仅可查看自己的离返校信息和晚归信息，宿管可以查看所有相关信息并且可以提交修改对应信息。</p>
      </section>
    </div>

    <div class="card">
      <header class="card_header" data-background="">
        <h2>水电费信息</h2>
      </header>
      <section class="card_content">
        <h2>学生宿管均可查看</h2>
        <p>学生仅仅可以查看水电费信息，宿管可以查看所有信息并且可以提交水电费缴费情况。</p>
      </section>
    </div>
  </div>
</div>
</body>
</html>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78

2. 学生用户登陆与宿管员登陆页面

在这里插入图片描述

具体代码实现：（student_login.jsp+admin_login.jsp）

student_login.jsp

<%@ page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

    <!-- Bootstrap CSS -->
    <link rel="stylesheet" href="css/bootstrap.min.css">
    <link rel="icon" href="images/FINN.ico">
    <!-- my style CSS -->
    <link rel="stylesheet" type="text/css" href="css/mystyles.css">
    <link rel="stylesheet" type="text/css" href="css/all.css">
    <link rel="stylesheet" type="text/css" href="css/main.css">
    <script type="text/javascript" src="js/main.js"></script>
    <title>学生登陆页面</title>
    <style type="text/css">
        .msg{
            color: red;
        }
    </style>
</head>
<body>
    <%@ include file="header.jsp" %>
    <div id="login">
        <div>
            <div class="form-group" align="center">
                <a href="index.jsp">
                    <img src="${pageContext.request.contextPath}/images/JACK.ico" >
                </a>
            </div>
            <div class="form-group" align="center" >学生登录</div>
        </div>

        <form action="${pageContext.request.contextPath}/StudentLoginServlet" method="post">
            <div class="form-group">
                <input type="text" class="form-control" id="username" name="username" placeholder = "请输入用户名">
                <span class="msg">${requestScope.namemsg}${requestScope.nameError}</span>
            </div>
            <div class="form-group">

                <input type="password" class="form-control" id="password" name="password" placeholder = "输入密码">
                <span class="msg">${requestScope.pwdError}${requestScope.pwdmsg}</span>
            </div>

            <div align="center">
                <button type="submit" class="btn btn-primary">登录</button>
            </div>
        </form>
    </div>

</body>
</html>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53

admin_login.jsp

<%@ page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

    <!-- Bootstrap CSS -->
    <link rel="stylesheet" href="css/bootstrap.min.css">
    <link rel="icon" href="images/FINN.ico">
    <!-- my style CSS -->
    <link rel="stylesheet" type="text/css" href="css/mystyles.css">
    <link rel="stylesheet" type="text/css" href="css/all.css">
    <link rel="stylesheet" type="text/css" href="css/main.css">
    <script type="text/javascript" src="js/main.js"></script>
    <title>宿管登陆页面</title>
    <style type="text/css">
        .msg{
            color: red;
        }
    </style>
</head>
<body>
    <%@ include file="header.jsp" %>
	<div id="login">
      <div>
          <div class="form-group" align="center">
              <a href="index.jsp">
                  <img src="${pageContext.request.contextPath}/images/FINN.ico" >
              </a>
          </div>
          <div class="form-group" align="center" >宿管登录</div>
      </div>

      <form action="${pageContext.request.contextPath}/AdminLoginServlet" method="post">
        <div class="form-group">
          <input type="text" class="form-control" id="username" name="username" placeholder = "输入用户名">
            <span class="msg">${requestScope.NAMEMSG}${requestScope.NAMEERROR}</span>
        </div>
        <div class="form-group">

            <input type="password" class="form-control" id="password" name="password" placeholder = "输入密码">
            <span class="msg">${requestScope.PWDERROR}${requestScope.PWDMSG}</span>
        </div>
        <div align="center">
            <button type="submit" class="btn btn-primary">登录</button>
        </div>
      </form>
    </div>

</body>
</html>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52

3. 宿舍学生信息页面（学生用户页面、宿管员页面）

在这里插入图片描述

具体代码实现：（student_information.jsp+admin_information.jsp）

student_information.jsp

<%--
  Created by IntelliJ IDEA.
  User: 蘑菇先生
  Date: 2020/12/21
  Time: 15:45
  To change this template use File | Settings | File Templates.
--%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
    <meta name="description" content="">
    <meta name="author" content="">
    <link rel="icon" href="images/FINN.ico">

    <title>学生宿舍管理系统</title>

    <!-- Bootstrap core CSS -->
    <link href="css/bootstrap.min.css" rel="stylesheet">

    <!-- Custom styles for this template -->
    <link href="css/dashboard.css" rel="stylesheet">
    <script type="text/javascript">
        function logout(){
            if(!confirm("真的要退出吗？")){
                window["event"].returnValue = false;
            }
        }
    </script>
</head>

<body>
<%
    String studentname = (String) request.getSession().getAttribute("studentname");
    if(studentname == null)
    {
        response.sendRedirect("index.jsp");
    }
%>
<nav class="navbar navbar-inverse navbar-fixed-top">
    <div class="container-fluid">
        <div class="navbar-header">
            <a class="navbar-brand text-primary" href="index.jsp">学生宿舍管理系统</a>
        </div>
        <div id="navbar" class="navbar-collapse collapse">
            <ul class="nav justify-content-end">
                <li class="nav-item active">
                    <a class="navbar-right" href="student_information.jsp">正在登陆的用户为：${sessionScope.studentname}(学生)</a>
                </li>
                <li class="nav-item active">
                    <a class="navbar-right" href="${pageContext.request.contextPath}/LoginOutServlet" onclick="return logout()">退出</a>
                </li>
            </ul>
        </div>
    </div>
</nav>
<div class="container-fluid">
    <div class="row">
        <div class="col-sm-3 col-md-2 sidebar hidden-xs">
            <ul class="nav nav-sidebar">
                <li class="active"><a href="student_information.jsp">宿舍信息</a></li>
                <li><a href="student_express.jsp">快件信息</a></li>
                <li><a href="student_guarantee.jsp">维修信息</a></li>
                <li><a href="student_leavereturn.jsp">学生离校与返校</a></li>
                <li><a href="student_laterecord.jsp">晚归记录</a></li>
                <li><a href="student_fee.jsp">水电费查询</a></li>
            </ul>
        </div>
        <div class="visible-xs">
            <li><a href="student_information.jsp">宿舍信息</a></li>
            <li><a href="student_express.jsp">快件信息</a></li>
            <li><a href="student_guarantee.jsp">维修信息</a></li>
            <li><a href="student_leavereturn.jsp">学生离校与返校</a></li>
            <li><a href="student_laterecord.jsp">晚归记录</a></li>
            <li><a href="student_fee.jsp">水电费查询</a></li>
        </div>
        <div class="col-sm-9 col-sm-offset-3 col-md-10 col-md-offset-2 main">
            <h2 class="sub-header">${sessionScope.dormitoryid} 的宿舍信息</h2>
            <div class="table-responsive">
                <table class="table table-striped" >
                    <thead>
                    <tr>
                        <th>学号</th>
                        <th>姓名</th>
                        <th>性别</th>
                        <th>专业</th>
                        <th>宿舍号</th>
                        <th>院系</th>
                        <th>班级</th>
                        <th>手机号</th>
                        <th>入住时间</th>
                    </tr>
                    </thead>
                    <tbody>
                        <c:forEach items="${sessionScope.student}" var="students">
                        <tr>
                            <td>${students.studentid}</td>
                            <td>${students.studentname}</td>
                            <td>${students.gender}</td>
                            <td>${students.major}</td>
                            <td>${students.dormitoryid}</td>
                            <td>${students.department}</td>
                            <td>${students.classes}</td>
                            <td>${students.phoneid}</td>
                            <td>${students.entrytime}</td>
                        </tr>
                        </c:forEach>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>

<!-- Bootstrap core JavaScript
================================================== -->
<!-- Placed at the end of the document so the pages load faster -->
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
<script src="js/bootstrap.min.js"></script>

</body>
</html>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127

admin_information.jsp

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%--
  Created by IntelliJ IDEA.
  User: 蘑菇先生
  Date: 2020/12/21
  Time: 15:45
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
    <meta name="description" content="">
    <meta name="author" content="">

    <title>学生宿舍管理系统</title>

    <!-- Bootstrap core CSS -->
    <link href="css/bootstrap.min.css" rel="stylesheet">

    <!-- Custom styles for this template -->
    <link href="css/dashboard.css" rel="stylesheet">
    <script src="https://lib.sinaapp.com/js/jquery/2.0.2/jquery-2.0.2.min.js"></script>
    <script type="text/javascript">
        function logout(){
            if(!confirm("真的要退出吗？")){
                window["event"].returnValue = false;
            }
        }
    </script>
</head>

<body>
<%
    String dormadminname = (String) request.getSession().getAttribute("dormadminname");
    if(dormadminname == null)
    {
        response.sendRedirect("index.jsp");
    }
%>
<nav class="navbar navbar-inverse navbar-fixed-top">
    <div class="container-fluid">
        <div class="navbar-header">
            <a class="navbar-brand text-primary" href="index.jsp">学生宿舍管理系统</a>
        </div>
        <div id="navbar" class="navbar-collapse collapse">
            <ul class&
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/我家小花儿/article/detail/473139