计算机javaweb毕设项目 基于Jsp+Servlet的宿舍管理系统

项目类型 :JAVA WEB项目
项目名称: 基于Jsp+Servlet的宿舍管理系统

用户类型 :3个角色(管理员+宿管员+学生)
系统类型 :后台系统
设计模式 :jsp+Servlet+MVC
开发工具 :Eclipse
数据库 :Mysql+Navicat
数据库表 :13张
适用 :软件工程、计算机科学与技术等JAVA课程的学习和实验

参考资料: 流程图、ER图、数据库设计等

宿舍管理系统参考流程图:

学生端:

**宿管员 **分配床位​:

宿管员宿舍调换

管理员统计缺勤

宿舍卫生打分

管理员端功能介绍

登录

宿管员信息管理

学生信息管理

宿舍楼管理(其中点击管理员按钮,可以为该宿舍楼设置宿管员)

为该宿舍楼添加管理员(可以是多个)

学生缺勤记录(根据时间、宿舍楼、姓名等查询)

宿管员端功能介绍

宿舍公告(每个宿舍楼的宿管发布该宿舍楼的新闻)

办理入住

寝室查看

寝室调换(创新点)

学生缺勤

处理保修

宿舍卫生评比

宿舍卫生检查

访客登记

借用物品登记

学生端功能介绍

个人信息查看

个人缺勤记录

故障报修申请

数据库设计

项目结构(bean+dao+filter+servlet)

数据库结构加数据



    /*
     Navicat Premium Data Transfer
    
     Source Server         : localhost
     Source Server Type    : MySQL
     Source Server Version : 50722
     Source Host           : localhost:3306
     Source Schema         : db_dorm
    
     Target Server Type    : MySQL
     Target Server Version : 50722
     File Encoding         : 65001
    
     Date: 13/09/2021 23:46:58
    */
    
    SET NAMES utf8mb4;
    SET FOREIGN_KEY_CHECKS = 0;
    
    -- ----------------------------
    -- Table structure for t_admin
    -- ----------------------------
    DROP TABLE IF EXISTS `t_admin`;
    CREATE TABLE `t_admin`  (
      `adminId` int(11) NOT NULL AUTO_INCREMENT,
      `userName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `password` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `sex` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `tel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      PRIMARY KEY (`adminId`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of t_admin
    -- ----------------------------
    INSERT INTO `t_admin` VALUES (1, 'admin', 'ICy5YqxZB1uWSwcVLSNLcA==', 'Lero', '', '123');
    INSERT INTO `t_admin` VALUES (2, 'zhch', 'ICy5YqxZB1uWSwcVLSNLcA==', 'zhouchao', '', '13329261139');
    INSERT INTO `t_admin` VALUES (3, 'user', 'ICy5YqxZB1uWSwcVLSNLcA==', 'user', 'nan', '11');
    
    -- ----------------------------
    -- Table structure for t_dorm
    -- ----------------------------
    DROP TABLE IF EXISTS `t_dorm`;
    CREATE TABLE `t_dorm`  (
      `dormId` int(11) NOT NULL AUTO_INCREMENT,
      `dormBuildId` int(11) DEFAULT NULL,
      `dormName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `dormType` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `dormNumber` int(11) DEFAULT NULL,
      `dormTel` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `dormMoney` decimal(6, 2) DEFAULT NULL,
      `dormSD` decimal(5, 2) DEFAULT NULL,
      `dormStatus` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `dormRemark` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      PRIMARY KEY (`dormId`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 105 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of t_dorm
    -- ----------------------------
    INSERT INTO `t_dorm` VALUES (1, 3, '101', 'M', 8, '888888', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (2, 3, '102', 'M', 8, '888889', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (3, 3, '103', 'M', 8, '888890', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (4, 3, '104', 'M', 8, '888891', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (5, 3, '105', 'M', 8, '888892', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (6, 3, '106', 'M', 8, '888893', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (7, 3, '107', 'M', 8, '888894', 800.00, 88.00, 'N', '空置可入住');
    INSERT INTO `t_dorm` VALUES (8, 3, '108', 'M', 8, '888895', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (9, 3, '109', 'M', 8, '888896', 800.00, 88.00, 'N', '空置可入住');
    INSERT INTO `t_dorm` VALUES (10, 3, '110', 'M', 8, '888897', 800.00, 88.00, 'N', '空置可入住');
    INSERT INTO `t_dorm` VALUES (11, 3, '111', 'M', 8, '888898', 800.00, 88.00, 'Y', '空置可入住');
    INSERT INTO `t_dorm` VALUES (12, 3, '112', 'M', 8, '888899', 800.00, 88.00, 'Y', '空置可入住');
    INSERT INTO `t_dorm` VALUES (13, 3, '113', 'M', 8, '888900', 800.00, 88.00, 'Y', '空置可入住');
    INSERT INTO `t_dorm` VALUES (14, 3, '114', 'M', 8, '888901', 800.00, 88.00, 'Y', '空置可入住');
    INSERT INTO `t_dorm` VALUES (15, 3, '115', 'M', 8, '888902', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (16, 3, '116', 'M', 8, '888903', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (17, 3, '117', 'M', 8, '888904', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (18, 3, '118', 'M', 8, '888905', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (19, 3, '119', 'M', 8, '888906', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (20, 3, '120', 'M', 8, '888907', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (21, 3, '201', 'M', 8, '888908', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (22, 3, '202', 'M', 8, '888909', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (23, 3, '203', 'M', 8, '888910', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (24, 3, '204', 'M', 8, '888911', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (25, 3, '205', 'M', 8, '888912', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (26, 3, '206', 'M', 8, '888913', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (27, 3, '207', 'M', 8, '888914', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (28, 3, '208', 'M', 8, '888915', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (29, 3, '209', 'M', 8, '888916', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (30, 3, '210', 'M', 8, '888917', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (31, 3, '211', 'M', 8, '888918', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (32, 3, '212', 'M', 8, '888919', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (33, 3, '213', 'M', 8, '888920', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (34, 3, '214', 'M', 8, '888921', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (35, 3, '215', 'M', 8, '888922', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (36, 3, '216', 'M', 8, '888923', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (37, 3, '217', 'M', 8, '888924', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (38, 3, '218', 'M', 8, '888925', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (39, 3, '219', 'M', 8, '888926', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (40, 3, '220', 'M', 8, '888927', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (41, 3, '301', 'M', 8, '888928', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (42, 3, '302', 'M', 8, '888929', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (43, 3, '303', 'M', 8, '888930', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (44, 3, '304', 'M', 8, '888931', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (45, 3, '305', 'M', 8, '888932', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (46, 3, '306', 'M', 8, '888933', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (47, 3, '307', 'M', 8, '888934', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (48, 3, '308', 'M', 8, '888935', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (49, 3, '309', 'M', 8, '888936', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (50, 3, '310', 'M', 8, '888937', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (51, 3, '311', 'M', 8, '888938', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (52, 3, '312', 'M', 8, '888939', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (53, 3, '313', 'M', 8, '888940', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (54, 3, '314', 'M', 8, '888941', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (55, 3, '315', 'M', 8, '888942', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (56, 3, '316', 'M', 8, '888943', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (57, 3, '317', 'M', 8, '888944', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (58, 3, '318', 'M', 8, '888945', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (59, 3, '319', 'M', 8, '888946', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (60, 3, '320', 'M', 8, '888947', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (61, 3, '401', 'M', 8, '888948', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (62, 3, '402', 'M', 8, '888949', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (63, 3, '403', 'M', 8, '888950', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (64, 3, '404', 'M', 8, '888951', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (65, 3, '405', 'M', 8, '888952', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (66, 3, '406', 'M', 8, '888953', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (67, 3, '407', 'M', 8, '888954', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (68, 3, '408', 'M', 8, '888955', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (69, 3, '409', 'M', 8, '888956', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (70, 3, '410', 'M', 8, '888957', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (71, 3, '411', 'M', 8, '888958', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (72, 3, '412', 'M', 8, '888959', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (73, 3, '413', 'M', 8, '888960', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (74, 3, '414', 'M', 8, '888961', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (75, 3, '415', 'M', 8, '888962', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (76, 3, '416', 'M', 8, '888963', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (77, 3, '417', 'M', 8, '888964', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (78, 3, '418', 'M', 8, '888965', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (79, 3, '419', 'M', 8, '888966', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (80, 3, '420', 'M', 8, '888967', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (81, 3, '501', 'M', 8, '888968', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (82, 3, '502', 'M', 8, '888969', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (83, 3, '503', 'M', 8, '888970', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (84, 3, '504', 'M', 8, '888971', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (85, 3, '505', 'M', 8, '888972', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (86, 3, '506', 'M', 8, '888973', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (87, 3, '507', 'M', 8, '888974', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (88, 3, '508', 'M', 8, '888975', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (89, 3, '509', 'M', 8, '888976', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (90, 3, '510', 'M', 8, '888977', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (91, 3, '511', 'M', 8, '888978', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (92, 3, '512', 'M', 8, '888979', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (93, 3, '513', 'M', 8, '888980', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (94, 3, '514', 'M', 8, '888981', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (95, 3, '515', 'M', 8, '888982', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (96, 3, '516', 'M', 8, '888983', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (97, 3, '517', 'M', 8, '888984', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (98, 3, '518', 'M', 8, '888985', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (99, 3, '519', 'M', 8, '888986', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (100, 3, '520', 'M', 8, '888987', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (101, 1, '101', 'M', 8, '111111', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (102, 1, '102', 'M', 8, '222222', 800.00, 88.00, 'Y', '空置可入住');
    INSERT INTO `t_dorm` VALUES (103, 2, '101', 'M', 8, '333333', 800.00, 88.00, 'Y', '满员');
    INSERT INTO `t_dorm` VALUES (104, 2, '212', 'M', 8, '444444', 800.00, 88.00, 'Y', '空置可入住');


    -- ----------------------------
    -- Table structure for t_goods
    -- ----------------------------
    DROP TABLE IF EXISTS `t_goods`;
    CREATE TABLE `t_goods`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `dormid` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `dorm` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `name` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `stunum` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `goods` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `date` datetime(0) DEFAULT NULL,
      `temp` text CHARACTER SET utf8 COLLATE utf8_general_ci,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of t_goods
    -- ----------------------------
    INSERT INTO `t_goods` VALUES (8, '3栋', '212', '周超', '11712052', '电脑', '2015-05-21 01:23:12', '外出');
    INSERT INTO `t_goods` VALUES (9, '3栋', '101', '小明', '2022', '钥匙', '2021-09-13 21:40:24', '借用钥匙');
    
    -- ----------------------------
    -- Table structure for t_info
    -- ----------------------------
    DROP TABLE IF EXISTS `t_info`;
    CREATE TABLE `t_info`  (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `type` int(11) DEFAULT NULL,
      `title` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `content` text CHARACTER SET utf8 COLLATE utf8_general_ci,
      `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
      `date` date DEFAULT NULL,
      `time` time(0) DEFAULT NULL,
      PRIMARY KEY (`id`) USING BTREE
    ) ENGINE = InnoDB AUTO_INCREMENT = 37 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Records of t_info
    -- ----------------------------
    INSERT INTO `t_info` VALUES (24, 3, '寝室晚上十点关门,请早点回寝室', ' 寝室晚上十点关门,请早点回寝室', '周超', '2021-09-13', '00:00:00');
    INSERT INTO `t_info` VALUES (25, 3, '第十五周宿舍卫生评比结果', ' 恭喜212寝室获得第一名', '周超', '2021-09-13', '00:00:00');
    INSERT INTO `t_info` VALUES (26, 3, '【失物招领】有同学捡到一张饭卡,请留意', ' 请失主来宿管这里领取', '周超', '2021-09-13', '00:00:00');
    INSERT INTO `t_info` VALUES (27, 3, '212寝室使用大功率电器,特此批评', ' 寝室禁用一切大功率电器', '周超', '2021-09-13', '00:00:00');
    INSERT INTO `t_info` VALUES (29, 3, '停电通知', ' 今天下午宿舍会停电一小时', '周超', '2021-09-13', '00:00:00');
    INSERT INTO `t_info` VALUES (30, 3, '第一周卫生评比结果', ' 请大家浏览各自的主页', '周超', '2021-09-13', '00:00:00');
    INSERT INTO `t_info` VALUES (31, 3, '521开始毕业


项目获取:

https://gitee.com/sinonfin/L-javaWebSha/tree/master

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值