JavaWeb学生宿舍管理系统(JSP+JDBC+Servlet)

本文档介绍了一个基于JavaWeb的学生宿舍管理系统,采用JSP、JDBC和Servlet技术,包括登录页面、学生和宿管员信息展示、快件、维修、离返校、晚归及水电费等模块。详细代码实现分布在多个JSP文件中,适用于学习和实践。
摘要由CSDN通过智能技术生成

学生宿舍管理系统
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>

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>

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>

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>

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>

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&
  • 6
    点赞
  • 90
    收藏
    觉得还不错? 一键收藏
  • 4
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 4
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值