项目类型 :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, '5月21开始毕业