【Java Web期末小项目】基于IDEA+Tomcat+Servlet+MySql+JSP的学生宿舍管理系统（增删改）

已于 2024-06-26 20:36:54 修改
阅读量698 收藏 14
点赞数 27
文章标签： java 前端 tomcat servlet intellij-idea
于 2024-06-26 19:50:24 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/2301_81030220/article/details/139996409
版权

 一、【项目简介】

本项目是基于Tomcat+Servlet+MySql+JSP实现的学生宿舍管理系统，适合大一初学Java web的期末小项目，增删改查

  1. 开发工具：IDEA 2022.2
  2. 开发环境：JDK 1.8 + Tomcat 9.0.55 +MySql 8.0（Navicat)

二、【项目结构】

三、【前期准备】

  1. 新建数据库
  2. 输入数据库代码 
    DROP TABLE IF EXISTS `t_employee`;

CREATE TABLE `t_employee`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `emp_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '员工姓名',
  `emp_gender` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '员工性别',
  `emp_dept` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '员工部门',
  `emp_salary` double DEFAULT NULL COMMENT '员工薪资',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;


INSERT INTO `t_employee` VALUES (1, '张三', '男', '软件部', 3000);
INSERT INTO `t_employee` VALUES (2, '小辉', '男', '软件部', 2500);
INSERT INTO `t_employee` VALUES (3, '王五', '女', '软件部', 3000);
  3. 配置JDK和Tomcat:

四、【前端代码】

  1. 登录页代码 
    <!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <title>登录</title>
  <style>
    * {
      margin: 0;
      padding: 0;
      box-sizing: border-box;
    }
    body {
      background: url('https://www.fjpit.edu.cn/_upload/article/images/85/0a/ace6605245f7aa03c4f70daef565/4859390e-bc87-42e1-896f-44386bc14740.png') no-repeat center center fixed;
      background-size: cover;
      height: 100vh;
      display: flex;
      justify-content: center;
      align-items: center;
      font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
    }
    .login_box {
      text-align: center;
      width: 40%;
      background: rgba(255, 255, 255, 0.85);
      padding: 30px;
      border-radius: 10px;
      color: black;
      box-shadow: 0 0 20px rgba(0, 0, 0, 0.2);
    }
    .login_box h2 {
      margin-bottom: 20px;
      text-align: center;
    }
    input[type="text"],
    input[type="password"] {
      width: 60%;
      font-size: 20px;
      color: black;
      background: transparent;
      padding: 8px 10px;
      margin-top: 10px;
      border: none;
      border-bottom: 0.5px solid black;
      outline: none;
    }

    .button-box{
      display: flex;
      justify-content: center;
    }

    button {
      margin-top: 20px;
      width: 60%;
      height: 40px;
      background-color: #0073e6;
      color: white;
      border: none;
      cursor: pointer;
      transition: background-color 0.3s;
    }
    button:hover {
      background-color: #005bb5;
    }

    .footer{
      text-align: center;
    }

    .footer img{
      margin-top: 20px;
      width: 200px;
      height: 35px;
    }
  </style>
</head>
<body>
<div class="login_box">
  <h2>学生宿舍管理系统</h2>
  <form action="loginServlet" method="POST">
    <div class="input_box">
      账号：<input type="text" name="account"><br>
    </div>
    <div class="input_box">
      密码：<input type="password" name="password"><br>
    </div>
    <div class="button-box"><button>登录</button></div>
  </form>
  <div class="footer">
    这里放置logo<img src="https://cas.paas.fjpit.cn/cas/file/png/logo.png?cas-server-site-ui__20240411__fe9a3bfc-24dc-42ef-8610-9ff46ac9a0d8__lQLPJyDFBuzsWEnM8M0F-rAunPjPBWF25gYEiP2J_fYA_1530_240.png">
  </div>
</div>
</body>
</html>

  2. 主页代码

    <%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>学生宿舍管理系统</title>
    <style>
        * {
            text-decoration: none;
            color: inherit;
            font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
            box-sizing: border-box;
        }
        body {
            background: url('https://www.fjpit.edu.cn/_upload/article/images/85/0a/ace6605245f7aa03c4f70daef565/4859390e-bc87-42e1-896f-44386bc14740.png') no-repeat center center fixed;
            background-size: cover;
            margin: 0;
            padding: 0;
            height: 100vh;
            display: flex;
            justify-content: center;
            align-items: center;
            background-blend-mode: overlay;
        }
        .main {
            width: 943px;
            height: 618px;
            background: rgba(255, 255, 255, 0.85);
            box-shadow: 0 4px 20px rgba(0, 0, 0, 0.3);
            border-radius: 20px;
            overflow: hidden;
            display: flex;
            flex-direction: column;
        }
        .header {
            background: #0073e6;
            color: white;
            padding: 20px;
            display: flex;
            justify-content: space-between;
            align-items: center;
            border-top-left-radius: 20px;
            border-top-right-radius: 20px;
        }
        .header .title {
            font-size: 1.8em;
            font-weight: bold;
        }
        .header .user {
            font-size: 1.2em;
        }
        .content {
            padding: 30px;
            text-align: center;
            flex-grow: 1;
        }
        .content h2 {
            margin-top: 0;
            color: #0073e6;
            font-size: 3em;
        }
        .menu {
            margin: 20px 0;
            display: flex;
            justify-content: center;
            gap: 60px;
        }
        .menu a {
            background: #0073e6;
            color: white;
            padding: 20px 40px;
            border-radius: 10px;
            text-decoration: none;
            transition: background 0.3s, transform 0.3s;
            font-size: 1.2em;
        }
        .menu a:hover {
            background: #005bb5;
            transform: scale(1.1);
        }
        .search-box {
            margin: 20px auto;
            text-align: center;
        }
        .search-box input[type="text"] {
            width: 70%;
            padding: 15px;
            font-size: 1.1em;
            border: 2px solid #0073e6;
            border-radius: 10px;
        }
        .footer {
            background: #0073e6;
            color: white;
            padding: 20px;
            text-align: center;
            border-bottom-left-radius: 20px;
            border-bottom-right-radius: 20px;
            font-size: 1.1em;
        }
        .footer img {
            width: 270px;
            height: 50px;
        }
    </style>
</head>
<body>
<div class="main">
    <div class="header">
        <div class="title">福信学生宿舍管理系统</div>
        <div class="user">欢迎您，管理员 <a href="adminCenter.jsp">管理员中心</a></div>
    </div>
    <div class="content">
        <h2>欢迎登录学生宿舍管理系统</h2>
        <div class="menu">
            <a href="empList">宿舍信息</a>
            <a href="addEmp.html">添加宿舍</a>
        </div>
        <div class="search-box">
            <input type="text" placeholder="请输入学生姓名 宿舍号">
        </div>
        <p>请从上方菜单中选择您需要的操作</p>
    </div>
    <div class="footer">
        这里放置logo<img src="https://cas.paas.fjpit.cn/cas/file/png/logo.png?cas-server-site-ui__20240411__fe9a3bfc-24dc-42ef-8610-9ff46ac9a0d8__lQLPJyDFBuzsWEnM8M0F-rAunPjPBWF25gYEiP2J_fYA_1530_240.png">
    </div>
</div>
</body>
</html>

  3. 信息列表代码

    <%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>

<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>学生宿舍信息</title>
    <style>
        * {
            text-decoration: none;
            color: inherit;
            font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
            box-sizing: border-box;
        }
        body {
            background: url('https://www.fjpit.edu.cn/_upload/article/images/85/0a/ace6605245f7aa03c4f70daef565/4859390e-bc87-42e1-896f-44386bc14740.png') no-repeat center center fixed;
            background-size: cover;
            margin: 0;
            padding: 0;
            height: 100vh;
            display: flex;
            justify-content: center;
            align-items: center;
            background-blend-mode: overlay;
        }
        .main {
            width: 85%;
            max-width: 1400px;
            background: rgba(255, 255, 255, 0.85);
            box-shadow: 0 4px 20px rgba(0, 0, 0, 0.3);
            border-radius: 20px;
            overflow: hidden;
            display: flex;
            flex-direction: column;
        }
        .header, .footer {
            background: #0073e6;
            color: white;
            padding: 20px;
            display: flex;
            justify-content: space-between;
            align-items: center;
        }
        .header {
            border-top-left-radius: 20px;
            border-top-right-radius: 20px;
        }
        .footer {
            background: #0073e6;
            color: white;
            padding: 20px;
            text-align: center;
            border-bottom-left-radius: 20px;
            border-bottom-right-radius: 20px;
            font-size: 1.1em;
            justify-content: center;
        }

        .footer img{
            width: 270px;
            height: 50px;

        }
        .header a, .footer a {
            color: white;
            margin-left: 30px;
            font-weight: bold;
        }
        .content {
            width: 969px;
            height: 445px;
            margin: 0 auto;
            padding: 20px;
            text-align: center;
            flex-grow: 1;
            display: flex;
            flex-direction: column;
            justify-content: center;
        }
        .content h2 {
            margin-bottom: 5px;
            color: #0073e6;
            font-size: 2.5em;
        }
        .menu {
            margin: 20px 0;
            display: flex;
            justify-content: space-between;
        }
        .menu a {
            background: #0073e6;
            color: white;
            padding: 10px 20px;
            border-radius: 10px;
            text-decoration: none;
            transition: background 0.3s, transform 0.3s;
            font-size: 1em;
        }
        .menu a:hover {
            background: #005bb5;
            transform: scale(1.05);
        }
        .two {
            margin: 20px 0;
        }
        .two th, .two td {
            border: 1px solid #0073e6;
            padding: 10px;
        }
        .two table {
            width: 100%;
            border-collapse: collapse;
        }
        .two table thead {
            background: #0073e6;
            color: white;
        }
        .page-nav {
            margin: 20px 0;
            display: flex;
            justify-content: center;
        }
        .page-nav a {
            margin: 0 10px;
            color: #0073e6;
            text-decoration: none;
        }
        .page-nav a.pageActive {
            color: black;
            margin-bottom: 5px;
        }
    </style>
</head>
<body>
<div class="main">
    <div class="header">
        <p>欢迎您，管理员</p>
    </div>
    <div class="content">
        <h2>学生宿舍列表</h2>
        <div class="menu">
            <a href="main.jsp">返回系统</a>
            <a href="addEmp.html">添加宿舍</a>
        </div>
        <div class="two">
            <table>
                <thead>
                <tr>
                    <th>编号</th>
                    <th>宿舍号</th>
                    <th>是否满员</th>
                    <th>楼层</th>
                    <th>人数</th>
                    <th>操作</th>
                </tr>
                </thead>
                <tbody>
                <c:forEach var="employee" items="${requestScope.pageDTO.date}">
                    <tr>
                        <td>${employee.id}</td>
                        <td>${employee.empName}</td>
                        <td>${employee.empGender}</td>
                        <td>${employee.empDept}</td>
                        <td>${employee.empSalary}</td>
                        <td><a href="findById?id=${employee.id}">修改</a> <a href="delEmp?id=${employee.id}">删除</a></td>
                    </tr>
                </c:forEach>
                </tbody>
            </table>
        </div>
        <div class="page-nav">
            <c:if test="${pageDTO.pageNumber>1}">
                <a href="empList?pageNumber=${pageDTO.pageNumber -1}">上一页</a>
            </c:if>
            <c:forEach var="i" begin="1" end="${pageDTO.totalPage}">
                <a href="empList?pageNumber=${i}" class="${i == pageDTO.pageNumber ? 'pageActive' : ''}">${i}</a>
            </c:forEach>
            <c:if test="${pageDTO.pageNumber < pageDTO.totalPage}">
                <a href="empList?pageNumber=${pageDTO.pageNumber+1}">下一页</a>
            </c:if>
        </div>
    </div>
    <div class="footer">
        这里放置logo<img src="https://cas.paas.fjpit.cn/cas/file/png/logo.png?cas-server-site-ui__20240411__fe9a3bfc-24dc-42ef-8610-9ff46ac9a0d8__lQLPJyDFBuzsWEnM8M0F-rAunPjPBWF25gYEiP2J_fYA_1530_240.png">
    </div>
</div>
</body>
</html>

  4. 修改和添加页代码

    <%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>学生宿舍信息</title>
    <style>
        * {
            text-decoration: none;
            color: inherit;
            font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
            box-sizing: border-box;
        }
        body {
            background: url('https://www.fjpit.edu.cn/_upload/article/images/85/0a/ace6605245f7aa03c4f70daef565/4859390e-bc87-42e1-896f-44386bc14740.png') no-repeat center center fixed;
            background-size: cover;
            margin: 0;
            padding: 0;
            height: 100vh;
            display: flex;
            justify-content: center;
            align-items: center;
            background-blend-mode: overlay;
        }
        .main {
            width: 85%;
            max-width: 1400px;
            background: rgba(255, 255, 255, 0.85);
            box-shadow: 0 4px 20px rgba(0, 0, 0, 0.3);
            border-radius: 20px;
            overflow: hidden;
            display: flex;
            flex-direction: column;
        }
        .header, .footer {
            background: #0073e6;
            color: white;
            padding: 20px;
            display: flex;
            justify-content: space-between;
            align-items: center;
        }
        .header {
            border-top-left-radius: 20px;
            border-top-right-radius: 20px;
        }
        .footer {
            background: #0073e6;
            color: white;
            padding: 20px;
            text-align: center;
            border-bottom-left-radius: 20px;
            border-bottom-right-radius: 20px;
            font-size: 1.1em;
            justify-content: center;
        }

        .footer img{
            width: 270px;
            height: 50px;

        }
        .header a, .footer a {
            color: white;
            margin-left: 30px;
            font-weight: bold;
        }
        .content {
            width: 969px;
            height: 445px;
            margin: 0 auto;
            padding: 20px;
            text-align: center;
            flex-grow: 1;
            display: flex;
            flex-direction: column;
            justify-content: center;
        }
        .content h2 {
            margin-top: 50px;
            color: #0073e6;
            font-size: 2.5em;
        }
        .menu {
            display: flex;
            justify-content: center;
        }
        .menu a {
            background: #0073e6;
            color: white;
            padding: 10px 20px;
            border-radius: 10px;
            text-decoration: none;
            transition: background 0.3s, transform 0.3s;
            font-size: 1em;
            margin: 0 10px 0 10px;
        }
        .menu a:hover {
            background: #005bb5;
            transform: scale(1.05);
        }
        .search-box {
            margin: 20px auto;
            text-align: center;
        }
        .search-box input[type="text"] {
            width: 60%;
            padding: 10px;
            font-size: 1em;
            border: 2px solid #0073e6;
            border-radius: 10px;
        }
        .form-container {
            margin: 10px 0;
            display: flex;
            flex-direction: column;
            align-items: center;
        }
        .form-container form {
            width: 50%;
            background: #f7f7f7;
            border-radius: 10px;
            box-shadow: 0 4px 10px rgba(0, 0, 0, 0.1);
        }
        .form-container form input[type="text"], .form-container form input[type="radio"], .form-container form button {
            margin: 10px 0;
            padding: 10px;
            font-size: 1em;
        }
        .form-container form button {
            width: 100px;
            border: none;
            border-radius: 6px;
            cursor: pointer;
        }
        .form-container .add {
            background: #005bb5;
            color: white;
        }
        .form-container .new {
            background: #005bb5;
            color: white;
        }
    </style>
</head>
<body>
<div class="main">
    <div class="header">
        <p>欢迎您，管理员</p>
    </div>
    <div class="content">

        <h2>修改宿舍信息</h2>
        <div class="menu">
            <a href="main.jsp">返回系统</a>
            <a href="empList">宿舍列表</a>
        </div>
        <div class="form-container">
            <form action="updateEmp" method="post">
                <input type="hidden" name="id" value="${employee.id}">
                宿舍：<input name="empName" value="${employee.empName}" type="text" /><br />
                是否满员：
                <c:choose>
                    <c:when test="${employee.empGender == '是'}">
                        <label><input name="empGender" type="radio" value="是" checked/>是</label>
                    </c:when>
                    <c:otherwise>
                        <label><input name="empGender" type="radio" value="是">是</label>
                    </c:otherwise>
                </c:choose>
                <c:choose>
                    <c:when test="${employee.empGender == '否'}">
                        <label><input type="radio" name="empGender" value="否" checked/>否</label><br />
                    </c:when>
                    <c:otherwise>
                        <label><input type="radio" name="empGender" value="否">否</label><br />
                    </c:otherwise>
                </c:choose>
                人数：<input value="${ employee.empSalary}" name="empSalary" type="text" /><br>
                <button class="add">修改</button>
                <button class="new" type="reset">重置</button>
            </form>
        </div>
    </div>
    <div class="footer">
        这里放置logo<img src="https://cas.paas.fjpit.cn/cas/file/png/logo.png?cas-server-site-ui__20240411__fe9a3bfc-24dc-42ef-8610-9ff46ac9a0d8__lQLPJyDFBuzsWEnM8M0F-rAunPjPBWF25gYEiP2J_fYA_1530_240.png">
    </div>
</div>
</body>
</html>

    <!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <title>添加宿舍信息</title>
  <style>
    * {
      margin: 0;
      padding: 0;
      box-sizing: border-box;
      font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
    }
    body {
      background: url('https://www.fjpit.edu.cn/_upload/article/images/85/0a/ace6605245f7aa03c4f70daef565/4859390e-bc87-42e1-896f-44386bc14740.png') no-repeat center center fixed;
      background-size: cover;
      height: 100vh;
      display: flex;
      justify-content: center;
      align-items: center;
    }
    .main {
      width: 600px;
      background: rgba(255, 255, 255, 0.95);
      box-shadow: 0 4px 20px rgba(0, 0, 0, 0.2);
      border-radius: 20px;
      padding: 20px;
    }
    .header, .footer {
      background: #0073e6;
      color: white;
      padding: 10px 20px;
      border-radius: 10px 10px 0 0;
      text-align: center;
    }
    .header a, .footer a {
      color: white;
      text-decoration: none;
      margin: 0 10px;
      font-weight: bold;
    }
    .content {
      padding: 20px;
      text-align: center;
    }
    .content h2 {
      margin-top: 0;
      color: #0073e6;
      font-size: 1.8em;
    }
    .content form {
      flex-direction: column;
      text-align: center;
    }
    .content form input[type="text"],
    .content form input[type="radio"] {
      margin: 10px 0;
      padding: 10px;
      width: 300px;
      border: 1px solid #0073e6;
      border-radius: 5px;
      font-size: 1em;
    }
    .content form label {
      font-size: 1em;
      color: #0073e6;
    }
    .content form button {
      margin-top: 20px;
      background: #0073e6;
      color: white;
      padding: 10px 20px;
      border: none;
      border-radius: 5px;
      cursor: pointer;
      transition: background 0.3s;
      font-size: 1em;
    }
    .content form button:hover {
      background: #005bb5;
    }
    .footer {
      background: #0073e6;
      color: white;
      border-radius: 0 0 20px 20px;
      text-align: center;
    }

    .footer img{
      width: 180px;
      height: 30px;

    }
  </style>
</head>
<body>
<div class="main">
  <div class="header">
    <a href="empList">宿舍信息</a>
    <a href="main.jsp">返回系统</a>
  </div>
  <div class="content">
    <h2>添加宿舍信息</h2>
    <form action="saveEmp" method="post">
      <div>
        名称：<input name="empName" type="text" /><br />
      </div>
      <div>
        是否空置：<label><input name="empGender" type="radio" value="是">是</label>
        <label><input  type="radio" name="empGender" value="否">否</label><br />
      </div>
      <div>
        宿舍类型：<input name="empDept" type="text" /><br />
      </div>
      <div>
        费用：<input name="empSalary" type="text" /><br>
      </div>
      <div>
        <button type="submit" >添加</button>
        <button type="reset">重置</button>
      </div>
    </form>
  </div>
  <div class="footer">
    这里放置logo<img src="https://cas.paas.fjpit.cn/cas/file/png/logo.png?cas-server-site-ui__20240411__fe9a3bfc-24dc-42ef-8610-9ff46ac9a0d8__lQLPJyDFBuzsWEnM8M0F-rAunPjPBWF25gYEiP2J_fYA_1530_240.png">
  </div>
</div>
</body>
</html>

  5. 修改和添加反馈代码

    <%--
  Created by IntelliJ IDEA.
  User: 86177
  Date: 2024/5/24
  Time: 14:38
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>消息提示</title>
    <style>
        * {
            margin: 0;
            padding: 0;
            box-sizing: border-box;
            font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
        }
        body {
            background: url('https://www.fjpit.edu.cn/_upload/article/images/85/0a/ace6605245f7aa03c4f70daef565/4859390e-bc87-42e1-896f-44386bc14740.png') no-repeat center center fixed;
            background-size: cover;
            height: 100vh;
            display: flex;
            justify-content: center;
            align-items: center;
        }
        .main {
            width: 600px;
            background: rgba(255, 255, 255, 0.95);
            box-shadow: 0 4px 20px rgba(0, 0, 0, 0.2);
            border-radius: 20px;
            padding: 20px;
            text-align: center;
        }
        .header, .footer {
            background: #0073e6;
            color: white;
            padding: 10px 20px;
            border-radius: 10px 10px 0 0;
        }
        .header a, .footer a {
            color: white;
            text-decoration: none;
            margin: 0 10px;
            font-weight: bold;
        }
        .content {
            padding: 20px;
            color: #0073e6;
            font-size: 1.2em;
        }
        .footer {
            background: #0073e6;
            color: white;
            border-radius: 0 0 20px 20px;
            text-align: center;
        }

        .footer img{
            width: 180px;
            height: 30px;

        }
        .back-link {
            display: inline-block;
            margin-top: 20px;
            padding: 10px 20px;
            background: #0073e6;
            color: white;
            border-radius: 5px;
            text-decoration: none;
            transition: background 0.3s;
        }
        .back-link:hover {
            background: #005bb5;
        }
    </style>
</head>
<body>
<div class="main">
    <div class="header">
        <a href="empList">宿舍信息</a>
        <a href="addEmp.html">添加宿舍</a>
    </div>
    <div class="content">
        ${requestScope.msg}
        <br>
        <a href="empList" class="back-link">返回</a>
    </div>
    <div class="footer">
        这里放置logo<img src="https://cas.paas.fjpit.cn/cas/file/png/logo.png?cas-server-site-ui__20240411__fe9a3bfc-24dc-42ef-8610-9ff46ac9a0d8__lQLPJyDFBuzsWEnM8M0F-rAunPjPBWF25gYEiP2J_fYA_1530_240.png">
    </div>
</div>
</body>
</html>

  6. 个人中心代码

    <%--
  Created by IntelliJ IDEA.
  User: c
  Date: 2024/6/26
  Time: 16:11
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<!DOCTYPE html>
<html lang="en">
<head>
  <meta charset="UTF-8">
  <title>管理员中心</title>
  <style>
    * {
      text-decoration: none;
      color: inherit;
      font-family: 'Segoe UI', Tahoma, Geneva, Verdana, sans-serif;
      box-sizing: border-box;
    }
    body {
      background: url('https://www.fjpit.edu.cn/_upload/article/images/85/0a/ace6605245f7aa03c4f70daef565/4859390e-bc87-42e1-896f-44386bc14740.png') no-repeat center center fixed;
      background-size: cover;
      margin: 0;
      padding: 0;
      height: 100vh;
      display: flex;
      justify-content: center;
      align-items: center;
      background-blend-mode: overlay;
    }
    .main {
      width: 943px;
      height: 618px;
      background: rgba(255, 255, 255, 0.85);
      box-shadow: 0 4px 20px rgba(0, 0, 0, 0.3);
      border-radius: 20px;
      overflow: hidden;
      display: flex;
      flex-direction: column;
    }
    .header {
      background: #0073e6;
      color: white;
      padding: 20px;
      display: flex;
      justify-content: space-between;
      align-items: center;
      border-top-left-radius: 20px;
      border-top-right-radius: 20px;
    }
    .header .title {
      font-size: 1.8em;
      font-weight: bold;
    }
    .header .user {
      font-size: 1.2em;
    }
    .content {
      padding: 30px;
      text-align: center;
      flex-grow: 1;
    }
    .content h2 {
      margin-top: 0;
      color: #0073e6;
      font-size: 3em;
    }
    .menu {
      margin: 20px 0;
      display: flex;
      justify-content: center;
      gap: 60px;
    }
    .menu a {
      background: #0073e6;
      color: white;
      padding: 20px 40px;
      border-radius: 10px;
      text-decoration: none;
      transition: background 0.3s, transform 0.3s;
      font-size: 1.2em;
    }
    .menu a:hover {
      background: #005bb5;
      transform: scale(1.1);
    }
    .footer {
      background: #0073e6;
      color: white;
      padding: 20px;
      text-align: center;
      border-bottom-left-radius: 20px;
      border-bottom-right-radius: 20px;
      font-size: 1.1em;
    }
    .footer img {
      width: 270px;
      height: 50px;
    }
  </style>
</head>
<body>
<div class="main">
  <div class="header">
    <div class="title">管理员中心</div>
    <div class="user">欢迎您，管理员</div>
  </div>
  <div class="content">
    <h2>管理员操作菜单</h2>
    <div class="menu">
      <a href="empList">查看宿舍信息</a>
      <a href="main.jsp">返回系统主页</a>
      <a href="login.html">退出系统登录</a>
    </div>
  </div>
  <div class="footer">
    这里放置logo<img src="https://cas.paas.fjpit.cn/cas/file/png/logo.png?cas-server-site-ui__20240411__fe9a3bfc-24dc-42ef-8610-9ff46ac9a0d8__lQLPJyDFBuzsWEnM8M0F-rAunPjPBWF25gYEiP2J_fYA_1530_240.png">
  </div>
</div>
</body>
</html>

五、【后端代码实现】

  1. 登录处理器实现 
    package com.servlet;

import cn.hutool.crypto.digest.MD5;
import com.dao.StudentDao;
import com.model.Student;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import java.io.IOException;

@WebServlet("/loginServlet")
public class LoginServlet extends HttpServlet {
    private StudentDao studentDao = new StudentDao();

    @Override
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        String account = req.getParameter("account");
        Student student = studentDao.selectByAccount(account);
        if (student == null){
            resp.getWriter().println("账号出错");
            resp.getWriter().close();
            return;
        }
        String stuPassword = student.getStuPassword();

        String password = req.getParameter("password");
        if (!stuPassword.equals(MD5.create().digestHex16(password))){
            resp.getWriter().println("密码错误");
            resp.getWriter().close();
            return;
        }
        HttpSession session = req.getSession();
        session.setAttribute("username",student.getStuName());

        resp.sendRedirect("main.jsp");
    }
}

  2. 宿舍增删改实现 
    package com.servlet;

import com.dao.EmployeeDao;
import com.model.Employee;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;

@WebServlet("/saveEmp")
public class EmpSaveServlet extends HttpServlet {
 private EmployeeDao employeeDao= new EmployeeDao();

    @Override
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        String name = req.getParameter("empName");
        String gender = req.getParameter("empGender");
        String salary = req.getParameter("empSalary");

        int row = employeeDao.insert(new Employee(null, name, gender, null, Double.parseDouble(salary)));
        if (row > 0) {
            req.setAttribute("msg", "宿舍添加成功");
        } else {
            req.setAttribute("msg", "宿舍添加失败");
        }
        req.getRequestDispatcher("msg.jsp").forward(req, resp);
    }
}

    package com.servlet;

import com.dao.EmployeeDao;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;


@WebServlet("/delEmp")
public class EmpDelServlet extends HttpServlet {

    private EmployeeDao employeeDao = new EmployeeDao();

    @Override
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

        String id = req.getParameter("id");
        int row = employeeDao.delete(Integer.parseInt(id));

        if (row>0){
            req.setAttribute("msg","宿舍删除成功");
        }else{
            req.setAttribute("msg","宿舍删除失败");
        }

        req.getRequestDispatcher("msg.jsp").forward(req,resp);



    }
}

    package com.servlet;

import com.dao.EmployeeDao;
import com.model.Employee;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;


@WebServlet("/updateEmp")
public class EmpUpdateServlet extends HttpServlet {
    private EmployeeDao employeeDao = new EmployeeDao();

    @Override
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        req.setCharacterEncoding("utf-8");
        String id = req.getParameter("id");
        String name = req.getParameter("empName");
        String gender = req.getParameter("empGender");
        String salary = req.getParameter("empSalary");
        Employee employee = new Employee(Integer.parseInt(id), name, gender, "1", Double.parseDouble(salary));
        int rows = employeeDao.updateById(employee);
        if (rows > 0) {
            req.setAttribute("msg", "宿舍修改成功");
        } else {
            req.setAttribute("msg", "宿舍修改失败");
        }
        req.getRequestDispatcher("msg.jsp").forward(req, resp);


    }
}

  3. 分页列表实现 
    package com.servlet;

import com.dao.EmployeeDao;
import com.model.Employee;
import com.dto.PageDTO;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;


@WebServlet("/empList")
public class EmpListServlet extends HttpServlet {

     private EmployeeDao employeeDao = new EmployeeDao();

    @Override
    protected void service(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {
        String pageNumberStr = req.getParameter("pageNumber");
        String pageLimitStr = req.getParameter("pageLimit");

        int pageNumber = 1;
        int pageLimit = 5;
        if (pageNumberStr!=null){
            pageNumber = Integer.parseInt(pageNumberStr);
        }
        if (pageLimitStr!=null){
            pageLimit = Integer.parseInt(pageLimitStr);
        }
        PageDTO<Employee> pageDTO = employeeDao.selectList(pageNumber, pageLimit);

        req.setAttribute("pageDTO", pageDTO);

        req.getRequestDispatcher("EmpList.jsp").forward(req, resp);

    }
}

  4. 数据库实现：需要根据电脑配置的Mysql,自行修改数据库用户名和密码 
    package com.servlet;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;


public class Main {
    public static void main(String[] args) throws ClassNotFoundException, SQLException {

        Class.forName("com.mysql.cj.jdbc.Driver");

        String url ="jdbc:mysql://localhost:3306/web"; //

        String user ="root";
        String password ="123456";

        Connection connection=DriverManager.getConnection(url,user,password);

        String sql = "insert into t_student(stu_name,stu_gender,stu_birthday,stu_account,stu_password) values('小明','男','2000-12-13','xiaoming','123456')";
        PreparedStatement preparedStatement = connection.prepareStatement(sql);
        preparedStatement.executeUpdate();
        System.out.println(connection);

    }
}

  5. PageDTO 
    package com.dto;


import java.util.List;

public class PageDTO<T> {

    private int pageNumber;
    private int pageLimit;
    private int totalPage;
    private int totalCount;

    private List<T> date;

    public PageDTO() {
    }

    public PageDTO(int pageNumber, int pageLimit, int totalPage, int totalCount, List<T> date) {
        this.pageNumber = pageNumber;
        this.pageLimit = pageLimit;
        this.totalPage = totalPage;
        this.totalCount = totalCount;
        this.date = date;
    }

    @Override
    public String toString() {
        return "PageDTO{" +
                "pageNumber=" + pageNumber +
                ", pageLimit=" + pageLimit +
                ", totalPage=" + totalPage +
                ", totalCount=" + totalCount +
                ", date=" + date +
                '}';
    }

    public int getPageNumber() {
        return pageNumber;
    }

    public void setPageNumber(int pageNumber) {
        this.pageNumber = pageNumber;
    }

    public int getPageLimit() {
        return pageLimit;
    }

    public void setPageLimit(int pageLimit) {
        this.pageLimit = pageLimit;
    }

    public int getTotalPage() {
        return totalPage;
    }

    public void setTotalPage(int totalPage) {
        this.totalPage = totalPage;
    }

    public int getTotalCount() {
        return totalCount;
    }

    public void setTotalCount(int totalCount) {
        this.totalCount = totalCount;
    }

    public List<T> getDate() {
        return date;
    }

    public void setDate(List<T> date) {
        this.date = date;
    }
}
  6. 数据库交互 
    package com.dao;

import com.utils.DBUtils;
import com.dto.PageDTO;
import com.model.Employee;

import java.sql.*;
import java.util.ArrayList;


public class EmployeeDao {
public int selectCount(){
    try {
        Connection connection = DBUtils.getConnection();
        String sql = "select count(*) totalCount from t_employee";
        PreparedStatement preparedStatement = connection.prepareStatement(sql);
        ResultSet resultSet = preparedStatement.executeQuery();
        if (resultSet.next()) {
            return resultSet.getInt("totalCount");
        }
        return 0;
    } catch (SQLException e) {
        throw new RuntimeException(e);
    }
}

    public PageDTO<Employee> selectList(int pageNumber , int pageLimit){

    int totalCount = selectCount();
    int totalPage = totalCount / pageLimit;
    if (totalCount % pageLimit >0){
        totalPage++;
    }

        try {
            Connection connection = DBUtils.getConnection();
            int offset = (pageNumber - 1) *pageLimit;
            String sql = "select * from t_employee limit ?,?";
            PreparedStatement preparedStatement = connection.prepareStatement(sql);

            preparedStatement.setInt(1,offset);
            preparedStatement.setInt(2,pageLimit);

            ResultSet resultSet = preparedStatement.executeQuery();

            ArrayList<Employee> employees = new ArrayList<>();
            while(resultSet.next()){
                int id = resultSet.getInt("id");
                String empName = resultSet.getString("emp_name");
                String empGender = resultSet.getString("emp_gender");
                String empDept = resultSet.getString("emp_dept");
                double empSalary = resultSet.getDouble("emp_salary");

                Employee employee = new Employee(id, empName, empGender, empDept, empSalary);

                employees.add(employee);
            }
            PageDTO<Employee> pageDTO = new PageDTO<>(pageNumber, pageLimit, totalPage, totalCount, employees);
            return pageDTO;
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }

    }

    public int delete( Integer id){
        return DBUtils.executeUpdate("delete from t_employee where id = ?",id);
    }



    public int insert(Employee employee){
        return DBUtils.executeUpdate("insert into t_employee(emp_name,emp_gender,emp_dept,emp_salary)values(?,?,1,?)",
                employee.getEmpName(), employee.getEmpGender(), employee.getEmpSalary());

    }

    public Employee selectById(int selectId){
        try {
            Connection connection = DBUtils.getConnection();
            String sql = "select * from t_employee where id = ?";
            PreparedStatement preparedStatement = connection.prepareStatement(sql);
            preparedStatement.setInt(1,selectId);
            ResultSet resultSet = preparedStatement.executeQuery();
            if (resultSet.next()){
                int id = resultSet.getInt("id");
                String empName = resultSet.getString("emp_name");
                String empGender = resultSet.getString("emp_gender");
                String empDept = resultSet.getString("emp_dept");
                double empSalary = resultSet.getDouble("emp_salary");
                Employee employee = new Employee(id, empName, empGender, empDept, empSalary);
                return employee;
            }
            return null;
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }

    public int updateById(Employee employee){
        return DBUtils.executeUpdate("update t_employee set emp_name=?,emp_gender=?," +
                "emp_dept=?,emp_salary=? where id=?",employee.getEmpName(),employee.getEmpGender(),
                employee.getEmpDept(),employee.getEmpSalary(),employee.getId());
    }

}

    package com.dao;

import com.model.Student;
import com.utils.DBUtils;

import java.sql.*;

public class StudentDao {

    //               selectByAccount()
    public Student selectByAccount(String account){
        try {
            Connection connection = DBUtils.getConnection();
            String sql = "select * from t_student where stu_account = ?";
            PreparedStatement preparedStatement = connection.prepareStatement(sql);
            preparedStatement.setString(1,account);

            ResultSet resultSet = preparedStatement.executeQuery();
            // while ?
            if (resultSet.next()){

                int id = resultSet.getInt("id");
                String stuName = resultSet.getString("stu_name");
                String stuGender = resultSet.getString("stu_gender");
                Date stuBirther = resultSet.getDate("stu_birthday");
                String styAccount = resultSet.getString("stu_account");
                String stuPassword = resultSet.getString("stu_password");
                Student student = new Student(id, stuName, stuGender, stuBirther, styAccount, stuPassword);
                return student;
            }else{

                return null;
            }
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }

    public int insert(Student student){
         return DBUtils.executeUpdate("insert into t_student(stu_name,stu_gender,stu_birthday,stu_account,stu_password) values(?,?,?,?,?)",
                student.getStuName(),
                student.getStuGender(),
                student.getStuBirthday(),
                student.getStuAccount(),
                student.getStuPassword()
                );
    }

}

  7. 数据库连接 
    package com.utils;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;


public class DBUtils {

    private static final String URL = "jdbc:mysql://localhost:3306/web";
    private static final String USER = "root";
    private static final String PASSWORD = "123456";

    public static Connection getConnection(){
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            return  DriverManager.getConnection(URL, USER, PASSWORD);
        } catch (ClassNotFoundException | SQLException e) {
            throw new RuntimeException(e);
        }
    }
    public static int  executeUpdate(String sql,Object ...params){
        try {
            Connection connection = DBUtils.getConnection();
            PreparedStatement preparedStatement = connection.prepareStatement(sql);
            for (int i = 0; i < params.length; i++) {
                preparedStatement.setObject(i+1,params[i]);
            }
            return preparedStatement.executeUpdate();
        } catch (SQLException e) {
            throw new RuntimeException(e);
        }
    }
}

  8. 时间信息实现 
    package com.test;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;

public class StringToDateTest {

    public static void main(String[] args) throws ParseException {

        String dateStr = "2024-05-17";

        SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");
        Date parse = simpleDateFormat.parse(dateStr);
        System.out.println(parse);
    }
}
package com.test;

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;

public class StringToDateTest {

    public static void main(String[] args) throws ParseException {

        String dateStr = "2024-05-17";

        SimpleDateFormat simpleDateFormat = new SimpleDateFormat("yyyy-MM-dd");
        Date parse = simpleDateFormat.parse(dateStr);
        System.out.println(parse);
    }
}

六、【部分效果展示】

七、【源代码下载】

https://download.csdn.net/download/2301_81030220/89485949?spm=1001.2014.3001.5503icon-default.png?t=N7T8https://download.csdn.net/download/2301_81030220/89485949?spm=1001.2014.3001.5503

Mustrack
关注
  • 27
    点赞
  • 踩
  • 14
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
【附源码】Java计算机毕业设计学生宿舍管理系统（程序+LW+部署）(1)
花昔 计算机毕设源码程序
03-18 405
项目运行环境配置：Jdk1.8 + Tomcat7.0 + Mysql + HBuilderX（Webstorm也行）+ Eclispe（IntelliJ IDEA,Eclispe,MyEclispe,Sts都支持）。项目技术：java+ mybatis + Maven等等组成，B/S模式 + Maven管理等等。环境需要1.运行环境：最好是java jdk 1.8，我们在这个平台上运行的。其他版本理论上也可以。2.IDE环境：IDEA，Eclipse,Myeclipse都可以。推荐IDEA。
springMVC+mysql实现的Java web学生宿舍管理系统源码.zip
05-15
springMVC+mysql实现的Java web学生宿舍管理系统源码和论文
JavaWeb宿舍管理系统项目源码 下载
04-22
项目说明： 本项目采用纯Servlet开发，是新手练习的不二项目，框架之类的可以略过了。数据库使用的是MySQL，使用Eclipse开发。 项目分管理员、宿舍管理员以及学生三个类型。 管理员：宿舍管理员管理、学生管理、宿舍管理、缺勤记录、修改密码、退出登录。 宿舍管理员：学生查看、缺勤记录、修改密码、退出登录。 学生：缺勤记录、修改密码、退出登录。 管理员和宿舍管理员使用userName登录，学生使用stuNum登录。
学生宿舍管理系统（Javaweb版本）
08-04
javaweb使用Tomcat连接MySQL数据库，编写的学生宿舍管理系统，有不足之处，望各位大佬指正。
JavaWeb学生宿舍管理系统（JSP+JDBC+Servlet）
叫我蘑菇先生
12-27 1万+
学生宿舍管理系统 java运行环境：jdk1.8； web服务器版本：tomcat8.5； 开发工具：idea2020.1 + navicat premium 15 数据库：mysql 8.0 源码地址：学生宿舍管理系统源码 CSND无需积分下载：学生宿舍管理系统源码 文档可以参考：学生宿舍管理系统需求分析与数据库设计 sql文件百度网盘下载链接：百度网盘下载链接 提取码：svt7 欢迎有问题的同学在评论区评论呀！会及时回复的 1. 学生宿舍管理系统首页沿用通讯录首页（利用flexibile布局） 具体
基于Servlet、JSP技术的学生在线考试系统
wxy198的博客
01-24 1035
基于servlet、jsp技术、MVC架构模式的学生在线考试系统（JAVA EE大作业）
基于Jsp+JavaBean+Servlet+MySQL的学生宿舍信息管理系统源码+项目说明(课程作业).zip
12-15
基于Jsp+JavaBean+Servlet+MySQL的学生宿舍信息管理系统源码+项目说明(课程作业).zip 1.开发前期进行需求分析、概要设计及详细设计，使用Rational Rose进行UML建模（含用例图、类图、业务流程图、状态图、活动图、包...
基于JSP+servlet+mysql 开发 javaWeb 学生宿舍管理系统源码+数据库+详细使用说明
06-14
基于JSP+servlet+mysql 开发 javaWeb 学生宿舍管理系统源码+数据库+详细使用说明本项目是一套成熟的大作业项目系统，获取98分，主要针对计算机相关专业的正在做大作业的学生和需要项目实战练习的学习者，可作为课程...
javaweb期末作业-基于MySQL + Tomcat + IDEA + JSP + Servlet宾馆管理系统+文档说明
03-16
javaweb期末作业-基于MySQL + Tomcat + IDEA + JSP + Servlet开发源码+文档说明+界面截 - 不懂运行，下载完可以私聊问，可远程教学 该资源内项目源码是个人的毕设，代码都测试ok，都是运行成功后才上传资源，答辩...
基于 Servlet+jsp+mysql 开发 JavaWeb 学生宿舍管理系统源码+数据库（高分项目）
06-14
基于 Servlet+JSP+Mysql 开发 JavaWeb 学生宿舍管理系统源码+数据库（高分项目）本项目是一套成熟的大作业项目系统，获取98分，主要针对计算机相关专业的正在做大作业的学生和需要项目实战练习的学习者，可作为课程...
基于Servlet+mysql+jsp学生宿舍信息管理系统(高分课设)
01-04
基于Servlet+mysql+jsp学生宿舍信息管理系统(高分课设)已获导师指导并通过的95分的高分期末大作业项目，可作为课程设计和期末大作业，下载即用无需修改，项目完整确保可以运行。 该系统功能完善、界面美观、操作简单...
JavaWeb项目实战之宿舍管理系统（Java毕业设计含源码）
11-12
该课程主要涉及到的技术有：bootstrap，bootstrap-datetime时间插件，JSP，JavaScript，jQuery，servlet，JDBC，Mysql。JDK版本为1.8，Tomcat8.0. 涉及的功能大致有：宿舍管理员管理，学生管理，宿舍楼管理，缺勤记录管理，修改密码，退出系统，用户登录及记住密码
一个Java web校园宿舍管理系统的源码
feng_p的博客
12-26 1804
分享一个Java web校园宿舍管理系统的源码 开发环境： (My)Eclipse MySQL Jdbc Struts tomcat jsp 图片: 下载地址：https://download.csdn.net/download/feng_p/13786676
JavaWeb-学生宿舍管理系统
热门推荐
林北
02-11 3万+
之前就写过学生宿舍管理系统了，但是是用Java swing写的，swing版学生宿舍管理系统，最近在学servlet和jsp之类的web知识，所以就想把之前的学生宿舍管理系统写成Web，该系统能够完成登录，查询宿舍信息，查询快件，报修，离校和返校登记以及晚归记录等功能 所用技术：bootstrap，jsp，servlet，jdbc 服务器是tomcat 数据库是MySQL 界面效果：boot...
基于javaweb的学生宿舍管理系统 源码 数据库代码
ProZuoy的博客
06-29 5428
项目开发环境：jdk1.7 tomcat7.0 mysql5.7 源码私聊获取
javaweb宿舍管理系统源码_宿舍信息管理系统展示
weixin_39850062的博客
12-29 1541
宿舍信息管理系统 今天整理学习笔记的时候发现了自己当时学SSM框架的时候写了一个简单的Javaweb宿舍信息管理系统，虽然现在看来写的不是很好，但今日写此文章也算是纪念自己的第一个SSM小项目了，话不多说，直接开始。项目简介：本项目为基于SSM框架的JavaWeb项目，项目名全称 "宿舍信息管理系统" ，是专门为方便基于宿舍制下的学生管理而打造的一个管理系统。项目功能模块：学生管理：学生信息的基本...
配置Java开发环境
最新发布
Broken_x的博客
07-10 1085
Java开发环境配置
期末作业node.js+mysql超市管理系统简易
12-07
以下是一个基于Node.js和MySQL的超市管理系统的简单示例： 1. 首先，需要安装Node.js和MySQL，并创建一个名为“supermarket”的数据库。 2. 创建一个名为“products”的表，其中包含以下列：id（自动递增的主键），name，price和quantity。 3. 在Node.js中安装mysql模块，以便能够连接到MySQL数据库。 4. 创建一个名为“app.js”的文件，并在其中编写以下代码： ```javascript const express = require('express'); const mysql = require('mysql'); const app = express(); // 创建MySQL连接 const connection = mysql.createConnection({ host: 'localhost', user: 'root', password: 'password', database: 'supermarket' }); // 连接到MySQL数据库 connection.connect((err) => { if (err) { console.error('Error connecting to database: ' + err.stack); return; } console.log('Connected to database as id ' + connection.threadId); }); // 获取所有产品 app.get('/products', (req, res) => { connection.query('SELECT * FROM products', (error, results, fields) => { if (error) throw error; res.send(results); }); }); // 获取单个产品 app.get('/products/:id', (req, res) => { const id = req.params.id; connection.query('SELECT * FROM products WHERE id = ?', [id], (error, results, fields) => { if (error) throw error; res.send(results[0]); }); }); // 添加新产品 app.post('/products', (req, res) => { const { name, price, quantity } = req.body; connection.query('INSERT INTO products (name, price, quantity) VALUES (?, ?, ?)', [name, price, quantity], (error, results, fields) => { if (error) throw error; res.send('Product added successfully'); }); }); // 更新产品 app.put('/products/:id', (req, res) => { const id = req.params.id; const { name, price, quantity } = req.body; connection.query('UPDATE products SET name = ?, price = ?, quantity = ? WHERE id = ?', [name, price, quantity, id], (error, results, fields) => { if (error) throw error; res.send('Product updated successfully'); }); }); // 删除产品 app.delete('/products/:id', (req, res) => { const id = req.params.id; connection.query('DELETE FROM products WHERE id = ?', [id], (error, results, fields) => { if (error) throw error; res.send('Product deleted successfully'); }); }); // 启动服务器 app.listen(3000, () => { console.log('Server started on port 3000'); }); ``` 5. 运行“app.js”文件，启动服务器。 6. 使用Postman或类似的工具测试API端点，例如： - GET /products：获取所有产品 - GET /products/1：获取ID为1的产品 - POST /products：添加新产品 - PUT /products/1：更新ID为1的产品 - DELETE /products/1：删除ID为1的产品

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

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

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值