項目訪問 localhost:8080 端口根據自己的環境變動 不要項目名訪問。

默認密碼123456 MD5Util加密方式

#eclipse 修改訪問地址不帶項目名稱 ：https://blog.csdn.net/mengxiangxingdong/article/details/80623522
# 畢業設計 課程設計

#ssm學生宿舍管理系統

#項目技術

? ?后臺 ssm(spring springMVC MyBatis)

? 前端 Layui框架
?
MD5加密

#開發工具：
? ? jdk1.8 ?eclipse或者idea ?tomcat7,8,9 ?mysql5.x(必須) ?navcat數據庫鏈接工具 其他的鏈接工具也可以
? ??
#實現功能
?管理員的登錄與登出
?管理員,班級,學生,宿舍，衛生，訪客各模塊增刪改查
?個別模塊關聯查詢
?各個模塊數據導出Excel
?
#備注

添加學生信息時，對應寢室和編輯編號，不然會添加失敗。

/* Navicat MySQL Data TransferSource Server : cookie123 Source Server Version : 50718 Source Host : cdb-83oczlep.gz.tencentcdb.com:10107 Source Database : dormitoryTarget Server Type : MYSQL Target Server Version : 50718 File Encoding : 65001Date: 2019-07-25 10:48:44 */SET FOREIGN_KEY_CHECKS=0;-- ---------------------------- -- Table structure for d_admin -- ---------------------------- DROP TABLE IF EXISTS `d_admin`; CREATE TABLE `d_admin` (`a_id` int(11) NOT NULL AUTO_INCREMENT,`a_username` varchar(20) NOT NULL,`a_password` varchar(50) NOT NULL,`a_name` varchar(20) DEFAULT NULL,`a_phone` bigint(20) DEFAULT NULL,`a_power` varchar(20) DEFAULT NULL,`a_describe` varchar(40) DEFAULT NULL,PRIMARY KEY (`a_id`) ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4;-- ---------------------------- -- Records of d_admin -- ---------------------------- INSERT INTO `d_admin` VALUES ('1', 'zxk', 'E10ADC3949BA59ABBE56E057F20F883E', '周荀凱', '138138138', '1', '高'); INSERT INTO `d_admin` VALUES ('2', 'zj', 'E10ADC3949BA59ABBE56E057F20F883E', '張杰', '138138138', '2', '低'); INSERT INTO `d_admin` VALUES ('3', 'zh', 'E10ADC3949BA59ABBE56E057F20F883E', '張歡', '138138138', '1', '高'); INSERT INTO `d_admin` VALUES ('4', 'zk', 'E10ADC3949BA59ABBE56E057F20F883E', '趙凱', '138138138', '2', '低'); INSERT INTO `d_admin` VALUES ('5', 'ywj', 'E10ADC3949BA59ABBE56E057F20F883E', '楊雯雯', '138138138', '1', '高'); INSERT INTO `d_admin` VALUES ('6', 'wh', 'E10ADC3949BA59ABBE56E057F20F883E', '王皓', '138138138', '1', '高'); INSERT INTO `d_admin` VALUES ('7', 'zw', 'E10ADC3949BA59ABBE56E057F20F883E', '張偉', '138138138', '2', '低'); INSERT INTO `d_admin` VALUES ('8', 'zj', 'E10ADC3949BA59ABBE56E057F20F883E', '趙佳', '138138138', '2', '低'); INSERT INTO `d_admin` VALUES ('9', 'wf', 'E10ADC3949BA59ABBE56E057F20F883E', '王凡', '138138138', '1', '高'); INSERT INTO `d_admin` VALUES ('10', 'zn', 'E10ADC3949BA59ABBE56E057F20F883E', '張娜', '138138138', '1', '高'); INSERT INTO `d_admin` VALUES ('11', 'jzh', 'E10ADC3949BA59ABBE56E057F20F883E', '蔣子華', '138138138', '2', '低'); INSERT INTO `d_admin` VALUES ('12', 'xl', 'E10ADC3949BA59ABBE56E057F20F883E', '薛磊', '138138138', '2', '低');-- ---------------------------- -- Table structure for d_class -- ---------------------------- DROP TABLE IF EXISTS `d_class`; CREATE TABLE `d_class` (`c_id` int(11) NOT NULL AUTO_INCREMENT,`c_classid` int(11) NOT NULL,`c_classname` varchar(30) DEFAULT NULL,`c_counsellor` varchar(30) DEFAULT NULL,PRIMARY KEY (`c_id`) ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4;-- ---------------------------- -- Records of d_class -- ---------------------------- INSERT INTO `d_class` VALUES ('1', '141', '生物', '徐超'); INSERT INTO `d_class` VALUES ('2', '151', '應化', '劉晨'); INSERT INTO `d_class` VALUES ('3', '142', '土木', '孫玲'); INSERT INTO `d_class` VALUES ('4', '161', '物流', '劉陽'); INSERT INTO `d_class` VALUES ('5', '153', '數師', '張宇'); INSERT INTO `d_class` VALUES ('6', '162', '物流', '劉陽'); INSERT INTO `d_class` VALUES ('7', '171', '自動化', '周涵涵'); INSERT INTO `d_class` VALUES ('8', '154', '土木', '孫玲'); INSERT INTO `d_class` VALUES ('9', '151', '紡織', '趙凱'); INSERT INTO `d_class` VALUES ('10', '153', '金融', '劉培'); INSERT INTO `d_class` VALUES ('12', '155', '計算機', '薄紗');-- ---------------------------- -- Table structure for d_dormgrade -- ---------------------------- DROP TABLE IF EXISTS `d_dormgrade`; CREATE TABLE `d_dormgrade` (`g_id` int(11) NOT NULL AUTO_INCREMENT,`d_id` int(11) NOT NULL,`d_dormbuilding` varchar(20) DEFAULT NULL,`d_grade` int(11) DEFAULT NULL,`create_time` datetime DEFAULT NULL,`update_time` datetime DEFAULT NULL,PRIMARY KEY (`g_id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4;-- ---------------------------- -- Records of d_dormgrade -- ---------------------------- INSERT INTO `d_dormgrade` VALUES ('1', '301', '24號樓', '6', '2019-04-25 10:51:17', '2019-05-12 17:28:38'); INSERT INTO `d_dormgrade` VALUES ('2', '302', '24號樓', '7', '2019-05-01 16:36:47', '2019-05-01 16:36:55'); INSERT INTO `d_dormgrade` VALUES ('3', '322', '24號樓', '8', '2019-05-04 16:37:42', '2019-05-04 16:37:47'); INSERT INTO `d_dormgrade` VALUES ('4', '602', '23號樓', '7', '2019-05-08 16:38:25', '2019-05-08 16:38:30'); INSERT INTO `d_dormgrade` VALUES ('5', '112', '22號樓', '7', '2019-05-12 16:38:53', '2019-05-12 16:39:00'); INSERT INTO `d_dormgrade` VALUES ('6', '222', '27號樓', '9', '2019-05-09 16:39:37', '2019-05-09 16:39:41'); INSERT INTO `d_dormgrade` VALUES ('7', '213', '27號樓', '8', '2019-05-10 16:40:02', '2019-05-10 16:40:08');-- ---------------------------- -- Table structure for d_dormitoryinfo -- ---------------------------- DROP TABLE IF EXISTS `d_dormitoryinfo`; CREATE TABLE `d_dormitoryinfo` (`d_id` int(11) NOT NULL AUTO_INCREMENT,`s_dormitoryid` int(11) NOT NULL,`d_dormbuilding` varchar(20) DEFAULT NULL,`d_bedtotal` varchar(20) DEFAULT NULL,`d_bed` varchar(20) DEFAULT NULL,`a_name` varchar(20) DEFAULT NULL,PRIMARY KEY (`d_id`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4;-- ---------------------------- -- Records of d_dormitoryinfo -- ---------------------------- INSERT INTO `d_dormitoryinfo` VALUES ('1', '311', '24號樓', '4', '3', '周荀凱'); INSERT INTO `d_dormitoryinfo` VALUES ('2', '322', '24號樓', '4', '4', '周荀凱'); INSERT INTO `d_dormitoryinfo` VALUES ('3', '601', '23號樓', '6', '6', '張杰'); INSERT INTO `d_dormitoryinfo` VALUES ('4', '602', '23號樓', '6', '5', '張杰'); INSERT INTO `d_dormitoryinfo` VALUES ('5', '111', '22號樓', '4', '4', '楊雯雯'); INSERT INTO `d_dormitoryinfo` VALUES ('6', '112', '22號樓', '4', '3', '楊雯雯'); INSERT INTO `d_dormitoryinfo` VALUES ('7', '222', '27號樓', '6', '6', '張偉'); INSERT INTO `d_dormitoryinfo` VALUES ('8', '213', '27號樓', '4', '4', '張偉'); INSERT INTO `d_dormitoryinfo` VALUES ('9', '312', '26號樓', '6', '6', '薛磊'); INSERT INTO `d_dormitoryinfo` VALUES ('10', '313', '22號樓', '4', '4', '張磊'); INSERT INTO `d_dormitoryinfo` VALUES ('11', '323', '22號樓', '6', '5', '張磊'); INSERT INTO `d_dormitoryinfo` VALUES ('12', '301', '24號樓', '6', '6', '周荀凱'); INSERT INTO `d_dormitoryinfo` VALUES ('13', '302', '24號樓', '6', '6', '周荀凱'); INSERT INTO `d_dormitoryinfo` VALUES ('14', '423', '29號樓', '4', '3', '郭浩然'); INSERT INTO `d_dormitoryinfo` VALUES ('15', '555', '30號樓', '8', '1', '李阿姨');-- ---------------------------- -- Table structure for d_dormrepair -- ---------------------------- DROP TABLE IF EXISTS `d_dormrepair`; CREATE TABLE `d_dormrepair` (`r_id` int(11) NOT NULL AUTO_INCREMENT,`d_id` int(11) NOT NULL,`d_dormbuilding` varchar(20) NOT NULL,`r_name` varchar(20) DEFAULT NULL,`reason` varchar(50) DEFAULT NULL,`create_time` datetime DEFAULT NULL,`update_time` datetime DEFAULT NULL,PRIMARY KEY (`r_id`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4;-- ---------------------------- -- Records of d_dormrepair -- ---------------------------- INSERT INTO `d_dormrepair` VALUES ('1', '301', '24號樓', '王濤', '水池', '2019-05-13 22:39:58', '2019-05-13 22:39:58'); INSERT INTO `d_dormrepair` VALUES ('2', '322', '24號樓', '王濤', '燈管', '2019-05-11 16:29:20', '2019-05-14 16:29:35'); INSERT INTO `d_dormrepair` VALUES ('3', '601', '23號樓', '馮軍', '水龍頭', '2019-05-15 16:31:14', '2019-05-14 16:31:20'); INSERT INTO `d_dormrepair` VALUES ('4', '601', '23號樓', '馮軍', '插孔', '2019-05-15 16:31:56', '2019-05-15 16:32:04'); INSERT INTO `d_dormrepair` VALUES ('5', '213', '27號樓', '馮軍', '排風扇', '2019-05-18 16:32:54', '2019-05-14 16:33:00'); INSERT INTO `d_dormrepair` VALUES ('6', '312', '26號樓', '彭建國', '空調', '2019-05-20 16:33:56', '2019-05-20 16:34:01'); INSERT INTO `d_dormrepair` VALUES ('7', '301', '27', '李四', '床壞了', '2019-07-25 10:12:51', '2019-07-25 10:12:51');-- ---------------------------- -- Table structure for d_stgrade -- ---------------------------- DROP TABLE IF EXISTS `d_stgrade`; CREATE TABLE `d_stgrade` (`g_id` int(11) NOT NULL AUTO_INCREMENT,`s_studentid` int(11) NOT NULL,`s_name` varchar(20) DEFAULT NULL,`s_grade` int(11) DEFAULT NULL,`s_classid` int(11) DEFAULT NULL,`s_dormitoryid` int(11) DEFAULT NULL,`create_time` datetime DEFAULT NULL,`update_time` datetime DEFAULT NULL,PRIMARY KEY (`g_id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;-- ---------------------------- -- Records of d_stgrade -- ---------------------------- INSERT INTO `d_stgrade` VALUES ('1', '1413032001', '張杰', '6', '141', '301', '2019-04-26 09:56:51', '2019-04-26 11:02:13'); INSERT INTO `d_stgrade` VALUES ('2', '1413032002', '趙凱', '7', '141', '301', '2019-05-01 17:00:05', '2019-05-01 17:00:13'); INSERT INTO `d_stgrade` VALUES ('3', '1413032003', '許文文', '6', '141', '301', '2019-05-06 17:00:54', '2019-05-06 17:01:01'); INSERT INTO `d_stgrade` VALUES ('4', '1413032003', '許文文', '7', '141', '301', '2019-05-16 17:01:33', '2019-05-16 17:02:15'); INSERT INTO `d_stgrade` VALUES ('5', '1413032004', '王浩', '7', '141', '301', '2019-05-10 17:03:03', '2019-05-10 17:03:09'); INSERT INTO `d_stgrade` VALUES ('6', '1413032005', '張偉', '8', '141', '301', '2019-05-14 17:03:53', '2019-05-14 17:03:56'); INSERT INTO `d_stgrade` VALUES ('7', '1513112412', '趙躍', '9', '151', '112', '2019-05-08 17:05:04', '2019-05-08 17:05:07'); INSERT INTO `d_stgrade` VALUES ('8', '1513112412', '趙躍', '9', '151', '112', '2019-05-17 17:05:34', '2019-05-17 17:05:39'); INSERT INTO `d_stgrade` VALUES ('9', '1513122418', '田野', '8', '151', '213', '2019-05-15 17:06:28', '2019-05-15 17:06:35'); INSERT INTO `d_stgrade` VALUES ('10', '1513122419', '張嘉佳', '8', '151', '213', '2019-05-15 17:07:09', '2019-05-15 17:07:13');-- ---------------------------- -- Table structure for d_student -- ---------------------------- DROP TABLE IF EXISTS `d_student`; CREATE TABLE `d_student` (`s_id` int(11) NOT NULL AUTO_INCREMENT,`s_studentid` int(11) NOT NULL,`s_name` varchar(20) DEFAULT NULL,`s_sex` varchar(20) DEFAULT NULL,`s_age` int(11) DEFAULT NULL,`s_phone` varchar(50) DEFAULT NULL,`s_classid` int(11) NOT NULL,`s_classname` varchar(20) DEFAULT NULL,`s_dormitoryid` int(11) NOT NULL,PRIMARY KEY (`s_id`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4;-- ---------------------------- -- Records of d_student -- ---------------------------- INSERT INTO `d_student` VALUES ('1', '1413032001', '張杰222', '男', '66', '138138138', '141', '生物', '301'); INSERT INTO `d_student` VALUES ('2', '1413032002', '趙凱', '男', '22', '138138138', '141', '生物', '301'); INSERT INTO `d_student` VALUES ('3', '1413032003', '許文文', '男', '21', '138138138', '141', '生物', '301'); INSERT INTO `d_student` VALUES ('4', '1413032004', '王浩', '男', '22', '138138138', '141', '生物', '301'); INSERT INTO `d_student` VALUES ('5', '1413032005', '張偉', '男', '22', '138138138', '141', '土木', '301'); INSERT INTO `d_student` VALUES ('6', '1413032006', '郭頂', '男', '21', '138138138', '141', '土木', '301'); INSERT INTO `d_student` VALUES ('7', '1513112411', '曹原', '男', '20', '138138138', '151', '應化', '112'); INSERT INTO `d_student` VALUES ('8', '1513112412', '趙躍', '男', '21', '138138138', '151', '紡織', '112'); INSERT INTO `d_student` VALUES ('9', '1513112413', '孫暢', '男', '21', '138138138', '151', '紡織', '112'); INSERT INTO `d_student` VALUES ('10', '1513122417', '周帆', '男', '21', '138138138', '161', '物流', '213'); INSERT INTO `d_student` VALUES ('11', '1513122418', '田野', '男', '21', '138138138', '153', '數師', '213'); INSERT INTO `d_student` VALUES ('12', '1513122419', '張嘉佳', '男', '20', '138138138', '153', '金融', '213');-- ---------------------------- -- Table structure for d_visitor -- ---------------------------- DROP TABLE IF EXISTS `d_visitor`; CREATE TABLE `d_visitor` (`v_id` int(11) NOT NULL AUTO_INCREMENT,`v_name` varchar(20) DEFAULT NULL,`v_phone` bigint(20) DEFAULT NULL,`v_dormitoryid` int(11) DEFAULT NULL,`v_dormbuilding` varchar(20) DEFAULT NULL,`create_time` datetime DEFAULT NULL,PRIMARY KEY (`v_id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4;-- ---------------------------- -- Records of d_visitor -- ---------------------------- INSERT INTO `d_visitor` VALUES ('1', '鄭杰', '138138138', '301', '24號樓', '2019-05-14 13:26:13'); INSERT INTO `d_visitor` VALUES ('2', '李博', '138138138', '322', '24號樓', '2019-05-12 19:36:23'); INSERT INTO `d_visitor` VALUES ('3', '張盈盈', '138138138', '601', '23號樓', '2019-05-13 19:37:11'); INSERT INTO `d_visitor` VALUES ('4', '王濤', '138138138', '111', '22號樓', '2019-05-15 19:37:46'); INSERT INTO `d_visitor` VALUES ('5', '胡浩', '138138138', '222', '27號樓', '2019-05-16 19:38:27'); INSERT INTO `d_visitor` VALUES ('6', '陳昊', '138138138', '213', '27號樓', '2019-05-18 19:39:03'); INSERT INTO `d_visitor` VALUES ('7', '劉軍', '138138138', '213', '27號樓', '2019-05-20 19:39:42'); INSERT INTO `d_visitor` VALUES ('8', '黃智', '138138138', '312', '26號樓', '2019-05-22 19:46:38'); INSERT INTO `d_visitor` VALUES ('9', '鄭杰', '123123123', '311', '24號樓', '2019-05-16 16:59:06');

總結

以上是生活随笔為你收集整理的ssm学生宿舍管理系统源码的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。