计算机毕业设计基于SSM的宿舍管理系统的设计与实现 Java实战项目附源码+文档+视频讲解

博主介绍：✌从事软件开发10年之余，专注于Java技术领域、Python人工智能及数据挖掘、小程序项目开发和Android项目开发等。CSDN、掘金、华为云、InfoQ、阿里云等平台优质作者✌

🍅文末获取源码联系🍅

👇🏻 精彩专栏推荐订阅👇🏻 不然下次找不到哟
————————————————

计算机毕业设计题目《1000套》✌

一.前言介绍

二.功能设计

三.功能截图

四.数据库表结构设计

五.关键代码

六.论文目录参考

七.源码获取

一.前言介绍及开发技术

长期以来，数据内容，数据传播，数据储存等都是一门门专业的内容，因为需要记住的内容很多，造成古人的言简意赅，如今互联网的到来让数据更加的清晰好认不复杂，一目了然不出错，毕竟在整个历史上数据的丢失，传承的断代，都是因为数据不能好好的保存，不能好好的流传。当年的年代用互联网思维和互联网技术，对大量数据的录入更新，存储汇总，备份分析方面，使得远远的超过传统的数据管理技术。本次开发宿舍管理系统，解决了寝室信息管理关于数据方面的管理分析，存储传输的痛点，不仅仅对管理员提供了便利，还能提高用户的满意度。此次开发程序使用到的开发工具有：Eclipse，Mysql等工具，使用的开发语言是Java。

二.功能设计

本次开发的宿舍管理系统实现了班级寝室公告管理、报修管理、字典表管理、访客管理、论坛管理、寝室寝室公告管理、老师管理、寝室管理、寝室卫生管理、宿管管理、调寝申请管理、学生管理、学生考勤管理、学生请假管理、管理员管理等功能。

三.功能截图

寝室管理功能模块主要实现寝室的增加、修改、删除、查看的功能。

寝室公告信息管理模块提供的功能操作有：新增寝室公告，修改寝室公告，删除寝室公告操作。

报修功能模块的功能有：新增报修,修改报修,删除报修。

四.数据库表结构设计

CREATE TABLE `banjigonggao` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',`laoshi_id` int(11) DEFAULT NULL COMMENT '老师',`banjigonggao_uuid_number` varchar(200) DEFAULT NULL COMMENT '班级公告编号',`banjigonggao_name` varchar(200) DEFAULT NULL COMMENT '班级公告名称  Search111 ',`banjigonggao_file` varchar(200) DEFAULT NULL COMMENT '附件',`banjigonggao_types` int(11) DEFAULT NULL COMMENT '班级公告类型 Search111',`banji_types` int(11) DEFAULT NULL COMMENT '班级 Search111',`banjigonggao_content` longtext COMMENT '公告内容',`insert_time` timestamp NULL DEFAULT NULL COMMENT '发布时间',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间  show3 listShow',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='班级公告';/*Data for the table `banjigonggao` */insert  into `banjigonggao`(`id`,`laoshi_id`,`banjigonggao_uuid_number`,`banjigonggao_name`,`banjigonggao_file`,`banjigonggao_types`,`banji_types`,`banjigonggao_content`,`insert_time`,`create_time`) values (1,3,'1680599893467','班级公告名称1','upload/file.rar',3,1,'公告内容1','2023-04-04 17:18:13','2023-04-04 17:18:13'),(2,3,'1680599893398','班级公告名称2','upload/file.rar',2,2,'公告内容2','2023-04-04 17:18:13','2023-04-04 17:18:13'),(3,2,'1680599893431','班级公告名称3','upload/file.rar',3,2,'公告内容3','2023-04-04 17:18:13','2023-04-04 17:18:13'),(4,3,'1680599893380','班级公告名称4','upload/file.rar',2,2,'公告内容4','2023-04-04 17:18:13','2023-04-04 17:18:13'),(5,2,'1680599893391','班级公告名称5','upload/file.rar',4,2,'公告内容5','2023-04-04 17:18:13','2023-04-04 17:18:13'),(6,2,'1680599893395','班级公告名称6','upload/file.rar',3,1,'公告内容6','2023-04-04 17:18:13','2023-04-04 17:18:13'),(7,1,'1680599893462','班级公告名称7','upload/file.rar',4,1,'公告内容7','2023-04-04 17:18:13','2023-04-04 17:18:13'),(8,1,'1680599893454','班级公告名称8','upload/file.rar',3,1,'公告内容8','2023-04-04 17:18:13','2023-04-04 17:18:13'),(9,2,'1680599893462','班级公告名称9','upload/file.rar',2,2,'公告内容9','2023-04-04 17:18:13','2023-04-04 17:18:13'),(10,1,'1680599893448','班级公告名称10','upload/file.rar',4,1,'公告内容10','2023-04-04 17:18:13','2023-04-04 17:18:13'),(11,1,'1680599893379','班级公告名称11','upload/file.rar',4,2,'公告内容11','2023-04-04 17:18:13','2023-04-04 17:18:13'),(12,1,'1680599893374','班级公告名称12','upload/file.rar',3,1,'公告内容12','2023-04-04 17:18:13','2023-04-04 17:18:13'),(13,1,'1680599893382','班级公告名称13','upload/file.rar',1,1,'公告内容13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(14,2,'1680599893466','班级公告名称14','upload/file.rar',4,1,'公告内容14','2023-04-04 17:18:13','2023-04-04 17:18:13'),(15,2,'1680602260834','公告111','/upload/1680602268491.doc',3,1,'<p>广东省格式</p>','2023-04-04 17:57:52','2023-04-04 17:57:52');/*Table structure for table `baoxiu` */DROP TABLE IF EXISTS `baoxiu`;CREATE TABLE `baoxiu` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',`xuesheng_id` int(11) DEFAULT NULL COMMENT '学生',`baoxiu_uuid_number` varchar(200) DEFAULT NULL COMMENT '报修编号',`baoxiu_address` varchar(200) DEFAULT NULL COMMENT '报修标题 Search111  ',`baoxiu_name` varchar(200) DEFAULT NULL COMMENT '报修位置',`baoxiu_types` int(11) NOT NULL COMMENT '报修类型 Search111 ',`baoxiu_content` longtext COMMENT '报修内容',`insert_time` timestamp NULL DEFAULT NULL COMMENT '报修时间',`baoxiu_zhuangtai_types` int(11) DEFAULT '1' COMMENT '报修状态 Search111 ',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show3 listShow',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='报修';/*Data for the table `baoxiu` */insert  into `baoxiu`(`id`,`xuesheng_id`,`baoxiu_uuid_number`,`baoxiu_address`,`baoxiu_name`,`baoxiu_types`,`baoxiu_content`,`insert_time`,`baoxiu_zhuangtai_types`,`create_time`) values (1,1,'1680599893442','报修标题1','报修位置1',1,'报修内容1','2023-04-04 17:18:13',2,'2023-04-04 17:18:13'),(2,1,'1680599893459','报修标题2','报修位置2',4,'报修内容2','2023-04-04 17:18:13',1,'2023-04-04 17:18:13'),(3,2,'1680599893455','报修标题3','报修位置3',4,'报修内容3','2023-04-04 17:18:13',1,'2023-04-04 17:18:13'),(4,3,'1680599893479','报修标题4','报修位置4',2,'报修内容4','2023-04-04 17:18:13',2,'2023-04-04 17:18:13'),(5,2,'1680599893479','报修标题5','报修位置5',4,'报修内容5','2023-04-04 17:18:13',1,'2023-04-04 17:18:13'),(6,1,'1680599893399','报修标题6','报修位置6',3,'报修内容6','2023-04-04 17:18:13',2,'2023-04-04 17:18:13'),(7,2,'1680599893460','报修标题7','报修位置7',2,'报修内容7','2023-04-04 17:18:13',1,'2023-04-04 17:18:13'),(8,2,'1680599893433','报修标题8','报修位置8',3,'报修内容8','2023-04-04 17:18:13',2,'2023-04-04 17:18:13'),(9,2,'1680599893408','报修标题9','报修位置9',1,'报修内容9','2023-04-04 17:18:13',2,'2023-04-04 17:18:13'),(10,3,'1680599893446','报修标题10','报修位置10',1,'报修内容10','2023-04-04 17:18:13',1,'2023-04-04 17:18:13'),(11,1,'1680599893433','报修标题11','报修位置11',1,'报修内容11','2023-04-04 17:18:13',1,'2023-04-04 17:18:13'),(12,3,'1680599893475','报修标题12','报修位置12',2,'报修内容12','2023-04-04 17:18:13',2,'2023-04-04 17:18:13'),(13,1,'1680599893418','报修标题13','报修位置13',3,'报修内容13','2023-04-04 17:18:13',2,'2023-04-04 17:18:13'),(14,1,'1680599893444','报修标题14','报修位置14',1,'报修内容14','2023-04-04 17:18:13',2,'2023-04-04 17:18:13'),(15,1,'1680600532784','标题11','位置12111',3,'广大发给大神','2023-04-04 17:29:00',2,'2023-04-04 17:29:00'),(16,2,'1680601868325','报修111','位置2222',4,'个地方都是发过的','2023-04-04 17:51:17',1,'2023-04-04 17:51:17');/*Table structure for table `config` */DROP TABLE IF EXISTS `config`;CREATE TABLE `config` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`name` varchar(100) DEFAULT NULL COMMENT '配置参数名称',`value` varchar(100) DEFAULT NULL COMMENT '配置参数值',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';/*Data for the table `config` */insert  into `config`(`id`,`name`,`value`) values (1,'轮播图111','upload/config1.jpg'),(2,'轮播图2','upload/config2.jpg'),(3,'轮播图3','upload/config3.jpg');/*Table structure for table `dictionary` */DROP TABLE IF EXISTS `dictionary`;CREATE TABLE `dictionary` (`id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`dic_code` varchar(200) DEFAULT NULL COMMENT '字段',`dic_name` varchar(200) DEFAULT NULL COMMENT '字段名',`code_index` int(11) DEFAULT NULL COMMENT '编码',`index_name` varchar(200) DEFAULT NULL COMMENT '编码名字  Search111 ',`super_id` int(11) DEFAULT NULL COMMENT '父字段id',`beizhu` varchar(200) DEFAULT NULL COMMENT '备注',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='字典表';/*Data for the table `dictionary` */insert  into `dictionary`(`id`,`dic_code`,`dic_name`,`code_index`,`index_name`,`super_id`,`beizhu`,`create_time`) values (17,'sex_types','性别类型',1,'男',NULL,NULL,'2023-04-04 17:16:38'),(18,'sex_types','性别类型',2,'女',NULL,NULL,'2023-04-04 17:16:38'),(19,'banji_types','班级',1,'班级1',NULL,NULL,'2023-04-04 17:16:38'),(20,'banji_types','班级',2,'班级2',NULL,NULL,'2023-04-04 17:16:39'),(21,'jinyong_types','账户状态',1,'启用',NULL,NULL,'2023-04-04 17:16:39'),(22,'jinyong_types','账户状态',2,'禁用',NULL,NULL,'2023-04-04 17:16:39'),(23,'loudong_types','楼栋',1,'楼栋1',NULL,NULL,'2023-04-04 17:16:39'),(24,'loudong_types','楼栋',2,'楼栋2',NULL,NULL,'2023-04-04 17:16:39'),(25,'danyuan_types','单元',1,'单元1',NULL,NULL,'2023-04-04 17:16:39'),(26,'danyuan_types','单元',2,'单元2',NULL,NULL,'2023-04-04 17:16:39'),(27,'forum_types','帖子类型',1,'帖子类型1',NULL,NULL,'2023-04-04 17:16:39'),(28,'forum_types','帖子类型',2,'帖子类型2',NULL,NULL,'2023-04-04 17:16:39'),(29,'forum_types','帖子类型',3,'帖子类型3',NULL,NULL,'2023-04-04 17:16:39'),(30,'forum_state_types','帖子状态',1,'发帖',NULL,NULL,'2023-04-04 17:16:39'),(31,'forum_state_types','帖子状态',2,'回帖',NULL,NULL,'2023-04-04 17:16:39'),(32,'xueshengkaoqin_types','考勤状态',1,'正常',NULL,NULL,'2023-04-04 17:16:39'),(33,'xueshengkaoqin_types','考勤状态',2,'请假',NULL,NULL,'2023-04-04 17:16:39'),(34,'xueshengkaoqin_types','考勤状态',3,'缺勤',NULL,NULL,'2023-04-04 17:16:39'),(35,'baoxiu_types','报修类型',1,'报修类型1',NULL,NULL,'2023-04-04 17:16:39'),(36,'baoxiu_types','报修类型',2,'报修类型2',NULL,NULL,'2023-04-04 17:16:39'),(37,'baoxiu_types','报修类型',3,'报修类型3',NULL,NULL,'2023-04-04 17:16:39'),(38,'baoxiu_types','报修类型',4,'报修类型4',NULL,NULL,'2023-04-04 17:16:39'),(39,'baoxiu_zhuangtai_types','报修状态',1,'已报修',NULL,NULL,'2023-04-04 17:16:39'),(40,'baoxiu_zhuangtai_types','报修状态',2,'已维修',NULL,NULL,'2023-04-04 17:16:39'),(41,'gonggao_types','寝室公告类型',1,'寝室公告类型1',NULL,NULL,'2023-04-04 17:16:39'),(42,'gonggao_types','寝室公告类型',2,'寝室公告类型2',NULL,NULL,'2023-04-04 17:16:39'),(43,'banjigonggao_types','班级公告类型',1,'公告类型1',NULL,NULL,'2023-04-04 17:16:39'),(44,'banjigonggao_types','班级公告类型',2,'公告类型2',NULL,NULL,'2023-04-04 17:16:39'),(45,'banjigonggao_types','班级公告类型',3,'公告类型3',NULL,NULL,'2023-04-04 17:16:39'),(46,'banjigonggao_types','班级公告类型',4,'公告类型4',NULL,NULL,'2023-04-04 17:16:39'),(47,'qinshiweisheng_types','卫生状态',1,'非常好',NULL,NULL,'2023-04-04 17:16:39'),(48,'qinshiweisheng_types','卫生状态',2,'好',NULL,NULL,'2023-04-04 17:16:39'),(49,'qinshiweisheng_types','卫生状态',3,'一般',NULL,NULL,'2023-04-04 17:16:39'),(50,'qinshiweisheng_types','卫生状态',4,'差',NULL,NULL,'2023-04-04 17:16:39'),(51,'qinshiweisheng_types','卫生状态',4,'非常差',NULL,NULL,'2023-04-04 17:16:39'),(52,'qinshiweisheng_hege_types','是否合格',1,'不合格',NULL,NULL,'2023-04-04 17:16:39'),(53,'qinshiweisheng_hege_types','是否合格',2,'合格',NULL,NULL,'2023-04-04 17:16:40'),(54,'xueshengqingjia_types','请假类型',1,'生病',NULL,NULL,'2023-04-04 17:16:40'),(55,'xueshengqingjia_types','请假类型',2,'有事',NULL,NULL,'2023-04-04 17:16:40'),(56,'xueshengqingjia_yesno_types','申请状态',1,'待审核',NULL,NULL,'2023-04-04 17:16:40'),(57,'xueshengqingjia_yesno_types','申请状态',2,'同意',NULL,NULL,'2023-04-04 17:16:40'),(58,'xueshengqingjia_yesno_types','申请状态',3,'拒绝',NULL,NULL,'2023-04-04 17:16:40'),(59,'tiaoqinshenqing_types','调寝申请类型',1,'调寝申请类型1',NULL,NULL,'2023-04-04 17:16:40'),(60,'tiaoqinshenqing_types','调寝申请类型',2,'调寝申请类型2',NULL,NULL,'2023-04-04 17:16:40'),(61,'tiaoqinshenqing_types','调寝申请类型',3,'调寝申请类型3',NULL,NULL,'2023-04-04 17:16:40'),(62,'tiaoqinshenqing_types','调寝申请类型',4,'调寝申请类型4',NULL,NULL,'2023-04-04 17:16:40'),(63,'tiaoqinshenqing_yesno_types','申请状态',1,'待审核',NULL,NULL,'2023-04-04 17:16:40'),(64,'tiaoqinshenqing_yesno_types','申请状态',2,'同意',NULL,NULL,'2023-04-04 17:16:40'),(65,'tiaoqinshenqing_yesno_types','申请状态',3,'拒绝',NULL,NULL,'2023-04-04 17:16:40'),(66,'tiaoqinshenqing_types','调寝申请类型',5,'调寝申请5',NULL,'','2023-04-04 17:52:32');/*Table structure for table `fangke` */DROP TABLE IF EXISTS `fangke`;CREATE TABLE `fangke` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',`xuesheng_id` int(11) DEFAULT NULL COMMENT '学生',`qinshi_id` int(11) DEFAULT NULL COMMENT '寝室',`fangke_name` varchar(200) DEFAULT NULL COMMENT '访客姓名 Search111 ',`fangke_phone` varchar(200) DEFAULT NULL COMMENT '访客手机号',`fangke_id_number` varchar(200) DEFAULT NULL COMMENT '访客身份证号',`sex_types` int(11) DEFAULT NULL COMMENT '性别',`fangke_content` longtext COMMENT '来访事由 ',`laifang_time` timestamp NULL DEFAULT NULL COMMENT '来访时间',`likai_time` timestamp NULL DEFAULT NULL COMMENT '离开时间',`insert_time` timestamp NULL DEFAULT NULL COMMENT '录入时间',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='访客';/*Data for the table `fangke` */insert  into `fangke`(`id`,`xuesheng_id`,`qinshi_id`,`fangke_name`,`fangke_phone`,`fangke_id_number`,`sex_types`,`fangke_content`,`laifang_time`,`likai_time`,`insert_time`,`create_time`) values (1,3,1,'访客姓名1','17703786901','410224199010102001',2,'来访事由1','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(2,3,2,'访客姓名2','17703786902','410224199010102002',2,'来访事由2','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(3,1,3,'访客姓名3','17703786903','410224199010102003',2,'来访事由3','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(4,3,4,'访客姓名4','17703786904','410224199010102004',1,'来访事由4','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(5,1,5,'访客姓名5','17703786905','410224199010102005',1,'来访事由5','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(6,2,6,'访客姓名6','17703786906','410224199010102006',1,'来访事由6','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(7,3,7,'访客姓名7','17703786907','410224199010102007',2,'来访事由7','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(8,2,8,'访客姓名8','17703786908','410224199010102008',1,'来访事由8','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(9,1,9,'访客姓名9','17703786909','410224199010102009',2,'来访事由9','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(10,1,10,'访客姓名10','17703786910','410224199010102010',1,'来访事由10','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(11,1,11,'访客姓名11','17703786911','410224199010102011',2,'来访事由11','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(12,3,12,'访客姓名12','17703786912','410224199010102012',2,'来访事由12','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(13,2,13,'访客姓名13','17703786913','410224199010102013',2,'来访事由13','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(14,3,14,'访客姓名14','17703786914','410224199010102014',1,'来访事由14','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(15,2,12,'张飒','17778889999','410224199910233333',1,'<p>广东省归属感是</p>','2023-04-04 17:55:56','2023-04-05 00:00:00','2023-04-04 17:56:11','2023-04-04 17:56:11');/*Table structure for table `forum` */DROP TABLE IF EXISTS `forum`;CREATE TABLE `forum` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',`forum_name` varchar(200) DEFAULT NULL COMMENT '帖子标题  Search111 ',`xuesheng_id` int(11) DEFAULT NULL COMMENT '学生',`laoshi_id` int(11) DEFAULT NULL COMMENT '老师',`suguan_id` int(11) DEFAULT NULL COMMENT '宿管',`users_id` int(11) DEFAULT NULL COMMENT '管理员',`forum_content` longtext COMMENT '发布内容',`super_ids` int(11) DEFAULT NULL COMMENT '父id',`forum_types` int(11) DEFAULT NULL COMMENT '帖子类型  Search111 ',`forum_state_types` int(11) DEFAULT NULL COMMENT '帖子状态',`insert_time` timestamp NULL DEFAULT NULL COMMENT '发帖时间',`update_time` timestamp NULL DEFAULT NULL COMMENT '修改时间',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show2',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COMMENT='论坛';/*Data for the table `forum` */insert  into `forum`(`id`,`forum_name`,`xuesheng_id`,`laoshi_id`,`suguan_id`,`users_id`,`forum_content`,`super_ids`,`forum_types`,`forum_state_types`,`insert_time`,`update_time`,`create_time`) values (1,'帖子标题1',1,NULL,NULL,NULL,'发布内容1',4,2,1,'2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(2,'帖子标题2',3,NULL,NULL,NULL,'发布内容2',22,1,1,'2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(3,'帖子标题3',3,NULL,NULL,NULL,'发布内容3',105,3,1,'2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(4,'帖子标题4',3,NULL,NULL,NULL,'发布内容4',325,2,1,'2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(5,'帖子标题5',3,NULL,NULL,NULL,'发布内容5',97,3,1,'2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(6,'帖子标题6',2,NULL,NULL,NULL,'发布内容6',35,2,1,'2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(7,'帖子标题7',2,NULL,NULL,NULL,'发布内容7',285,3,1,'2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(8,'帖子标题8',1,NULL,NULL,NULL,'发布内容8',200,3,1,'2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(9,'帖子标题9',2,NULL,NULL,NULL,'发布内容9',387,3,1,'2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(10,'帖子标题10',3,NULL,NULL,NULL,'发布内容10',45,2,1,'2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(11,'帖子标题11',1,NULL,NULL,NULL,'发布内容11',31,1,1,'2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(12,'帖子标题12',2,NULL,NULL,NULL,'发布内容12',489,1,1,'2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(13,'帖子标题13',1,NULL,NULL,NULL,'发布内容13',401,3,1,'2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(14,'帖子标题14',1,NULL,NULL,NULL,'发布内容14',378,3,1,'2023-04-04 17:18:13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(15,NULL,2,NULL,NULL,NULL,'把对方打钢带管',14,NULL,2,'2023-04-04 17:50:41',NULL,'2023-04-04 17:50:41'),(16,'帖子222',2,NULL,NULL,NULL,'<p>固定死的干啥公司打工的</p>',NULL,2,1,'2023-04-04 17:50:54',NULL,'2023-04-04 17:50:54'),(17,NULL,NULL,NULL,NULL,1,'干活第三个',16,NULL,2,'2023-04-04 17:54:38',NULL,'2023-04-04 17:54:38'),(18,NULL,NULL,NULL,1,NULL,'哈哈哈哈',16,NULL,2,'2023-04-04 17:55:24',NULL,'2023-04-04 17:55:24'),(19,NULL,NULL,2,NULL,NULL,'孤独颂歌',16,NULL,2,'2023-04-04 17:58:01',NULL,'2023-04-04 17:58:01');/*Table structure for table `gonggao` */DROP TABLE IF EXISTS `gonggao`;CREATE TABLE `gonggao` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',`suguan_id` int(11) DEFAULT NULL COMMENT '宿管',`gonggao_name` varchar(200) DEFAULT NULL COMMENT '寝室公告名称 Search111  ',`gonggao_photo` varchar(200) DEFAULT NULL COMMENT '寝室公告图片 ',`gonggao_types` int(11) NOT NULL COMMENT '寝室公告类型 Search111 ',`insert_time` timestamp NULL DEFAULT NULL COMMENT '发布时间',`gonggao_content` longtext COMMENT '寝室公告详情 ',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show1 show2 nameShow',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='寝室公告';/*Data for the table `gonggao` */insert  into `gonggao`(`id`,`suguan_id`,`gonggao_name`,`gonggao_photo`,`gonggao_types`,`insert_time`,`gonggao_content`,`create_time`) values (1,3,'寝室公告名称1','upload/gonggao1.jpg',1,'2023-04-04 17:18:13','寝室公告详情1','2023-04-04 17:18:13'),(2,2,'寝室公告名称2','upload/gonggao2.jpg',2,'2023-04-04 17:18:13','寝室公告详情2','2023-04-04 17:18:13'),(3,3,'寝室公告名称3','upload/gonggao3.jpg',2,'2023-04-04 17:18:13','寝室公告详情3','2023-04-04 17:18:13'),(4,1,'寝室公告名称4','upload/gonggao4.jpg',2,'2023-04-04 17:18:13','寝室公告详情4','2023-04-04 17:18:13'),(5,3,'寝室公告名称5','upload/gonggao5.jpg',2,'2023-04-04 17:18:13','寝室公告详情5','2023-04-04 17:18:13'),(6,3,'寝室公告名称6','upload/gonggao6.jpg',2,'2023-04-04 17:18:13','寝室公告详情6','2023-04-04 17:18:13'),(7,2,'寝室公告名称7','upload/gonggao7.jpg',1,'2023-04-04 17:18:13','寝室公告详情7','2023-04-04 17:18:13'),(8,1,'寝室公告名称8','upload/gonggao8.jpg',2,'2023-04-04 17:18:13','寝室公告详情8','2023-04-04 17:18:13'),(9,3,'寝室公告名称9','upload/gonggao9.jpg',1,'2023-04-04 17:18:13','寝室公告详情9','2023-04-04 17:18:13'),(10,1,'寝室公告名称10','upload/gonggao10.jpg',2,'2023-04-04 17:18:13','寝室公告详情10','2023-04-04 17:18:13'),(11,1,'寝室公告名称11','upload/gonggao11.jpg',1,'2023-04-04 17:18:13','寝室公告详情11','2023-04-04 17:18:13'),(12,2,'寝室公告名称12','upload/gonggao12.jpg',1,'2023-04-04 17:18:13','寝室公告详情12','2023-04-04 17:18:13'),(13,3,'寝室公告名称13','upload/gonggao13.jpg',1,'2023-04-04 17:18:13','寝室公告详情13','2023-04-04 17:18:13'),(14,2,'寝室公告名称14','upload/gonggao14.jpg',2,'2023-04-04 17:18:13','寝室公告详情14','2023-04-04 17:18:13');/*Table structure for table `laoshi` */DROP TABLE IF EXISTS `laoshi`;CREATE TABLE `laoshi` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',`username` varchar(200) DEFAULT NULL COMMENT '账户',`password` varchar(200) DEFAULT NULL COMMENT '密码',`laoshi_uuid_number` varchar(200) DEFAULT NULL COMMENT '老师工号 Search111 ',`laoshi_name` varchar(200) DEFAULT NULL COMMENT '老师姓名 Search111 ',`laoshi_phone` varchar(200) DEFAULT NULL COMMENT '老师手机号',`laoshi_id_number` varchar(200) DEFAULT NULL COMMENT '老师身份证号',`laoshi_photo` varchar(200) DEFAULT NULL COMMENT '老师头像',`sex_types` int(11) DEFAULT NULL COMMENT '性别',`laoshi_email` varchar(200) DEFAULT NULL COMMENT '老师邮箱',`jinyong_types` int(11) DEFAULT NULL COMMENT '账户状态 Search111 ',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='老师';/*Data for the table `laoshi` */insert  into `laoshi`(`id`,`username`,`password`,`laoshi_uuid_number`,`laoshi_name`,`laoshi_phone`,`laoshi_id_number`,`laoshi_photo`,`sex_types`,`laoshi_email`,`jinyong_types`,`create_time`) values (1,'a1','123456','1680599893401','老师姓名1','17703786901','410224199010102001','upload/laoshi1.jpg',2,'1@qq.com',2,'2023-04-04 17:18:13'),(2,'a2','123456','1680599893439','老师姓名2','17703786902','410224199010102002','upload/laoshi2.jpg',1,'2@qq.com',1,'2023-04-04 17:18:13'),(3,'a3','123456','1680599893405','老师姓名3','17703786903','410224199010102003','upload/laoshi3.jpg',2,'3@qq.com',1,'2023-04-04 17:18:13');/*Table structure for table `qinshi` */DROP TABLE IF EXISTS `qinshi`;CREATE TABLE `qinshi` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',`qinshi_uuid_number` varchar(200) DEFAULT NULL COMMENT '寝室编号 Search111  ',`loudong_types` int(11) NOT NULL COMMENT '楼栋 Search111 ',`danyuan_types` int(11) NOT NULL COMMENT '单元 Search111 ',`qinshi_name` varchar(200) DEFAULT NULL COMMENT '寝室名称 Search111  ',`qinshi_address` varchar(200) DEFAULT NULL COMMENT '寝室位置',`qinshi_content` longtext COMMENT '寝室备注',`insert_time` timestamp NULL DEFAULT NULL COMMENT '录入时间',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='寝室';/*Data for the table `qinshi` */insert  into `qinshi`(`id`,`qinshi_uuid_number`,`loudong_types`,`danyuan_types`,`qinshi_name`,`qinshi_address`,`qinshi_content`,`insert_time`,`create_time`) values (1,'1680599893467',2,1,'寝室名称1','寝室位置1','寝室备注1','2023-04-04 17:18:13','2023-04-04 17:18:13'),(2,'1680599893480',1,1,'寝室名称2','寝室位置2','寝室备注2','2023-04-04 17:18:13','2023-04-04 17:18:13'),(3,'1680599893421',1,1,'寝室名称3','寝室位置3','寝室备注3','2023-04-04 17:18:13','2023-04-04 17:18:13'),(4,'1680599893463',2,1,'寝室名称4','寝室位置4','寝室备注4','2023-04-04 17:18:13','2023-04-04 17:18:13'),(5,'1680599893429',2,2,'寝室名称5','寝室位置5','寝室备注5','2023-04-04 17:18:13','2023-04-04 17:18:13'),(6,'1680599893490',2,1,'寝室名称6','寝室位置6','寝室备注6','2023-04-04 17:18:13','2023-04-04 17:18:13'),(7,'1680599893429',1,1,'寝室名称7','寝室位置7','寝室备注7','2023-04-04 17:18:13','2023-04-04 17:18:13'),(8,'1680599893444',2,2,'寝室名称8','寝室位置8','寝室备注8','2023-04-04 17:18:13','2023-04-04 17:18:13'),(9,'1680599893454',2,1,'寝室名称9','寝室位置9','寝室备注9','2023-04-04 17:18:13','2023-04-04 17:18:13'),(10,'1680599893441',1,1,'寝室名称10','寝室位置10','寝室备注10','2023-04-04 17:18:13','2023-04-04 17:18:13'),(11,'1680599893461',2,2,'寝室名称11','寝室位置11','寝室备注11','2023-04-04 17:18:13','2023-04-04 17:18:13'),(12,'1680599893453',2,1,'寝室名称12','寝室位置12','寝室备注12','2023-04-04 17:18:13','2023-04-04 17:18:13'),(13,'1680599893416',2,2,'寝室名称13','寝室位置13','寝室备注13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(14,'1680599893482',1,2,'寝室名称14','寝室位置14','寝室备注14','2023-04-04 17:18:13','2023-04-04 17:18:13');/*Table structure for table `qinshiweisheng` */DROP TABLE IF EXISTS `qinshiweisheng`;CREATE TABLE `qinshiweisheng` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',`qinshi_id` int(11) DEFAULT NULL COMMENT '寝室',`qinshiweisheng_uuid_number` varchar(200) DEFAULT NULL COMMENT '寝室卫生编号',`qinshiweisheng_name` varchar(200) DEFAULT NULL COMMENT '寝室卫生标题',`qinshiweisheng_photo` varchar(200) DEFAULT NULL COMMENT '寝室照片 ',`qinshiweisheng_types` int(11) DEFAULT NULL COMMENT '卫生状态 Search111',`qinshiweisheng_hege_types` int(11) DEFAULT NULL COMMENT '是否合格 Search111',`qinshiweisheng_video` varchar(200) DEFAULT NULL COMMENT '检查视频',`qinshiweisheng_dafen` decimal(10,2) DEFAULT NULL COMMENT '打分',`qinshiweisheng_time` date DEFAULT NULL COMMENT '所属日期 Search111',`qinshiweisheng_content` longtext COMMENT '卫生详情',`insert_time` timestamp NULL DEFAULT NULL COMMENT '录入时间',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间  show2 photoShow',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='寝室卫生';/*Data for the table `qinshiweisheng` */insert  into `qinshiweisheng`(`id`,`qinshi_id`,`qinshiweisheng_uuid_number`,`qinshiweisheng_name`,`qinshiweisheng_photo`,`qinshiweisheng_types`,`qinshiweisheng_hege_types`,`qinshiweisheng_video`,`qinshiweisheng_dafen`,`qinshiweisheng_time`,`qinshiweisheng_content`,`insert_time`,`create_time`) values (1,1,'1680599893397','寝室卫生标题1','upload/qinshiweisheng1.jpg',3,1,'upload/video.mp4','780.93','2023-04-04','卫生详情1','2023-04-04 17:18:13','2023-04-04 17:18:13'),(2,2,'1680599893404','寝室卫生标题2','upload/qinshiweisheng2.jpg',3,1,'upload/video.mp4','82.07','2023-04-04','卫生详情2','2023-04-04 17:18:13','2023-04-04 17:18:13'),(3,3,'1680599893420','寝室卫生标题3','upload/qinshiweisheng3.jpg',4,2,'upload/video.mp4','857.94','2023-04-04','卫生详情3','2023-04-04 17:18:13','2023-04-04 17:18:13'),(4,4,'1680599893494','寝室卫生标题4','upload/qinshiweisheng4.jpg',2,1,'upload/video.mp4','919.31','2023-04-04','卫生详情4','2023-04-04 17:18:13','2023-04-04 17:18:13'),(5,5,'1680599893479','寝室卫生标题5','upload/qinshiweisheng5.jpg',1,1,'upload/video.mp4','339.38','2023-04-04','卫生详情5','2023-04-04 17:18:13','2023-04-04 17:18:13'),(6,6,'1680599893431','寝室卫生标题6','upload/qinshiweisheng6.jpg',2,1,'upload/video.mp4','601.82','2023-04-04','卫生详情6','2023-04-04 17:18:13','2023-04-04 17:18:13'),(7,7,'1680599893465','寝室卫生标题7','upload/qinshiweisheng7.jpg',2,2,'upload/video.mp4','561.86','2023-04-04','卫生详情7','2023-04-04 17:18:13','2023-04-04 17:18:13'),(8,8,'1680599893421','寝室卫生标题8','upload/qinshiweisheng8.jpg',1,2,'upload/video.mp4','585.92','2023-04-04','卫生详情8','2023-04-04 17:18:13','2023-04-04 17:18:13'),(9,9,'1680599893430','寝室卫生标题9','upload/qinshiweisheng9.jpg',3,2,'upload/video.mp4','203.96','2023-04-04','卫生详情9','2023-04-04 17:18:13','2023-04-04 17:18:13'),(10,10,'1680599893485','寝室卫生标题10','upload/qinshiweisheng10.jpg',4,1,'upload/video.mp4','385.28','2023-04-04','卫生详情10','2023-04-04 17:18:13','2023-04-04 17:18:13'),(11,11,'1680599893439','寝室卫生标题11','upload/qinshiweisheng11.jpg',2,1,'upload/video.mp4','621.59','2023-04-04','卫生详情11','2023-04-04 17:18:13','2023-04-04 17:18:13'),(12,12,'1680599893433','寝室卫生标题12','upload/qinshiweisheng12.jpg',2,2,'upload/video.mp4','32.47','2023-04-04','卫生详情12','2023-04-04 17:18:13','2023-04-04 17:18:13'),(13,13,'1680599893484','寝室卫生标题13','upload/qinshiweisheng13.jpg',1,2,'upload/video.mp4','665.41','2023-04-04','卫生详情13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(14,14,'1680599893408','寝室卫生标题14','upload/qinshiweisheng14.jpg',4,1,'upload/video.mp4','419.53','2023-04-04','卫生详情14','2023-04-04 17:18:13','2023-04-04 17:18:13');/*Table structure for table `suguan` */DROP TABLE IF EXISTS `suguan`;CREATE TABLE `suguan` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',`username` varchar(200) DEFAULT NULL COMMENT '账户',`password` varchar(200) DEFAULT NULL COMMENT '密码',`suguan_uuid_number` varchar(200) DEFAULT NULL COMMENT '宿管工号 Search111 ',`suguan_name` varchar(200) DEFAULT NULL COMMENT '宿管姓名 Search111 ',`suguan_phone` varchar(200) DEFAULT NULL COMMENT '宿管手机号',`suguan_id_number` varchar(200) DEFAULT NULL COMMENT '宿管身份证号',`suguan_photo` varchar(200) DEFAULT NULL COMMENT '宿管头像',`sex_types` int(11) DEFAULT NULL COMMENT '性别',`suguan_email` varchar(200) DEFAULT NULL COMMENT '宿管邮箱',`jinyong_types` int(11) DEFAULT NULL COMMENT '账户状态 Search111 ',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='宿管';/*Data for the table `suguan` */insert  into `suguan`(`id`,`username`,`password`,`suguan_uuid_number`,`suguan_name`,`suguan_phone`,`suguan_id_number`,`suguan_photo`,`sex_types`,`suguan_email`,`jinyong_types`,`create_time`) values (1,'a1','123456','1680599893422','宿管姓名1','17703786901','410224199010102001','upload/suguan1.jpg',2,'1@qq.com',1,'2023-04-04 17:18:13'),(2,'a2','123456','1680599893442','宿管姓名2','17703786902','410224199010102002','upload/suguan2.jpg',1,'2@qq.com',2,'2023-04-04 17:18:13'),(3,'a3','123456','1680599893438','宿管姓名3','17703786903','410224199010102003','upload/suguan3.jpg',2,'3@qq.com',1,'2023-04-04 17:18:13');/*Table structure for table `tiaoqinshenqing` */DROP TABLE IF EXISTS `tiaoqinshenqing`;CREATE TABLE `tiaoqinshenqing` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',`xuesheng_id` int(11) DEFAULT NULL COMMENT '学生',`qinshi_id` int(11) DEFAULT NULL COMMENT '寝室',`tiaoqinshenqing_uuid_number` varchar(200) DEFAULT NULL COMMENT '调寝申请编号',`tiaoqinshenqing_name` varchar(200) DEFAULT NULL COMMENT '申请标题  Search111 ',`tiaoqinshenqing_types` int(11) DEFAULT NULL COMMENT '调寝申请类型 Search111',`tiaoqinshenqing_content` longtext COMMENT '申请缘由 ',`insert_time` timestamp NULL DEFAULT NULL COMMENT '申请时间',`tiaoqinshenqing_yesno_types` int(11) DEFAULT NULL COMMENT '申请状态 Search111 ',`tiaoqinshenqing_yesno_text` longtext COMMENT '处理意见',`tiaoqinshenqing_shenhe_time` timestamp NULL DEFAULT NULL COMMENT '审核时间',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间  show3 listShow',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COMMENT='调寝申请';/*Table structure for table `token` */DROP TABLE IF EXISTS `token`;CREATE TABLE `token` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`userid` bigint(20) NOT NULL COMMENT '学生id',`username` varchar(100) NOT NULL COMMENT '学生名',`tablename` varchar(100) DEFAULT NULL COMMENT '表名',`role` varchar(100) DEFAULT NULL COMMENT '角色',`token` varchar(200) NOT NULL COMMENT '密码',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',`expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='token表';/*Data for the table `token` */insert  into `token`(`id`,`userid`,`username`,`tablename`,`role`,`token`,`addtime`,`expiratedtime`) values (1,1,'a1','xuesheng','学生','eeam76vm0oo54a09ij1cdjh53455r506','2023-04-04 17:21:10','2023-04-04 18:21:11'),(2,1,'admin','users','管理员','herlhzfvy40ij88a2x8mwt7v0f6v7g00','2023-04-04 17:39:25','2023-04-04 19:00:04'),(3,2,'a2','xuesheng','学生','zmos597q53nxcme8f7wlaa3khjmbxgng','2023-04-04 17:50:30','2023-04-04 18:50:30'),(4,1,'a1','suguan','宿管','n1w8wincgrql9c8zfclvoq9s2yx1g6xy','2023-04-04 17:55:13','2023-04-04 18:55:14'),(5,2,'a2','laoshi','老师','qbokvx7jr3ncrjn2mvnb17881txt88be','2023-04-04 17:57:34','2023-04-04 18:57:35');/*Table structure for table `users` */DROP TABLE IF EXISTS `users`;CREATE TABLE `users` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`username` varchar(100) NOT NULL COMMENT '学生名',`password` varchar(100) NOT NULL COMMENT '密码',`role` varchar(100) DEFAULT '管理员' COMMENT '角色',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='管理员';/*Data for the table `users` */insert  into `users`(`id`,`username`,`password`,`role`,`addtime`) values (1,'admin','admin','管理员','2023-04-04 17:16:38');/*Table structure for table `xuesheng` */DROP TABLE IF EXISTS `xuesheng`;CREATE TABLE `xuesheng` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',`qinshi_id` int(11) DEFAULT NULL COMMENT '寝室',`username` varchar(200) DEFAULT NULL COMMENT '账户',`password` varchar(200) DEFAULT NULL COMMENT '密码',`xuesheng_uuid_number` varchar(200) DEFAULT NULL COMMENT '学号 Search111 ',`xuesheng_name` varchar(200) DEFAULT NULL COMMENT '学生姓名 Search111 ',`xuesheng_phone` varchar(200) DEFAULT NULL COMMENT '学生手机号',`xuesheng_id_number` varchar(200) DEFAULT NULL COMMENT '学生身份证号',`xuesheng_photo` varchar(200) DEFAULT NULL COMMENT '学生头像',`sex_types` int(11) DEFAULT NULL COMMENT '性别',`banji_types` int(11) DEFAULT NULL COMMENT '班级',`xuesheng_email` varchar(200) DEFAULT NULL COMMENT '学生邮箱',`jinyong_types` int(11) DEFAULT NULL COMMENT '账户状态 Search111 ',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='学生';/*Data for the table `xuesheng` */insert  into `xuesheng`(`id`,`qinshi_id`,`username`,`password`,`xuesheng_uuid_number`,`xuesheng_name`,`xuesheng_phone`,`xuesheng_id_number`,`xuesheng_photo`,`sex_types`,`banji_types`,`xuesheng_email`,`jinyong_types`,`create_time`) values (1,1,'a1','123456','1680599893420','学生姓名1','17703786901','410224199010102001','upload/xuesheng1.jpg',1,2,'1@qq.com',1,'2023-04-04 17:18:13'),(2,2,'a2','123456','1680599893434','学生姓名2','17703786902','410224199010102002','upload/xuesheng2.jpg',1,2,'2@qq.com',1,'2023-04-04 17:18:13'),(3,3,'a3','123456','1680599893419','学生姓名3','17703786903','410224199010102003','upload/xuesheng3.jpg',2,1,'3@qq.com',1,'2023-04-04 17:18:13');/*Table structure for table `xueshengkaoqin` */DROP TABLE IF EXISTS `xueshengkaoqin`;CREATE TABLE `xueshengkaoqin` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',`xuesheng_id` int(11) DEFAULT NULL COMMENT '学生',`xueshengkaoqin_types` int(11) DEFAULT NULL COMMENT '考勤状态 Search111 ',`xueshengkaoqin_time` date DEFAULT NULL COMMENT '所属日期 Search111 ',`xueshengkaoqin_content` longtext COMMENT '考勤备注',`insert_time` timestamp NULL DEFAULT NULL COMMENT '录入时间',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show3 listShow',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='学生考勤';/*Data for the table `xueshengkaoqin` */insert  into `xueshengkaoqin`(`id`,`xuesheng_id`,`xueshengkaoqin_types`,`xueshengkaoqin_time`,`xueshengkaoqin_content`,`insert_time`,`create_time`) values (1,3,1,'2023-04-04','考勤备注1','2023-04-04 17:18:13','2023-04-04 17:18:13'),(2,1,1,'2023-04-04','考勤备注2','2023-04-04 17:18:13','2023-04-04 17:18:13'),(3,1,2,'2023-04-04','考勤备注3','2023-04-04 17:18:13','2023-04-04 17:18:13'),(4,2,1,'2023-04-04','考勤备注4','2023-04-04 17:18:13','2023-04-04 17:18:13'),(5,2,1,'2023-04-04','考勤备注5','2023-04-04 17:18:13','2023-04-04 17:18:13'),(6,2,2,'2023-04-04','考勤备注6','2023-04-04 17:18:13','2023-04-04 17:18:13'),(7,3,3,'2023-04-04','考勤备注7','2023-04-04 17:18:13','2023-04-04 17:18:13'),(8,1,1,'2023-04-04','考勤备注8','2023-04-04 17:18:13','2023-04-04 17:18:13'),(9,2,3,'2023-04-04','考勤备注9','2023-04-04 17:18:13','2023-04-04 17:18:13'),(10,2,2,'2023-04-04','考勤备注10','2023-04-04 17:18:13','2023-04-04 17:18:13'),(11,2,3,'2023-04-04','考勤备注11','2023-04-04 17:18:13','2023-04-04 17:18:13'),(12,3,1,'2023-04-04','考勤备注12','2023-04-04 17:18:13','2023-04-04 17:18:13'),(13,3,2,'2023-04-04','考勤备注13','2023-04-04 17:18:13','2023-04-04 17:18:13'),(14,2,3,'2023-04-04','考勤备注14','2023-04-04 17:18:13','2023-04-04 17:18:13'),(15,1,1,'2023-04-03','<p>广东省发生的个</p>','2023-04-04 17:57:22','2023-04-04 17:57:22');/*Table structure for table `xueshengqingjia` */DROP TABLE IF EXISTS `xueshengqingjia`;CREATE TABLE `xueshengqingjia` (`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',`xuesheng_id` int(200) DEFAULT NULL COMMENT '学生',`xueshengqingjia_name` varchar(200) DEFAULT NULL COMMENT '请假标题 Search111 ',`xueshengqingjia_text` longtext COMMENT '请假缘由',`xueshengqingjia_types` int(11) DEFAULT NULL COMMENT '请假类型 Search111',`insert_time` timestamp NULL DEFAULT NULL COMMENT '申请时间',`xueshengqingjia_time` timestamp NULL DEFAULT NULL COMMENT '请假时间',`xueshengqingjia_number` int(200) DEFAULT NULL COMMENT '请假天数',`xueshengqingjia_yesno_types` int(11) DEFAULT NULL COMMENT '申请状态 Search111 ',`xueshengqingjia_yesno_text` longtext COMMENT '处理意见',`xueshengqingjia_shenhe_time` timestamp NULL DEFAULT NULL COMMENT '审核时间',`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show3 listShow',PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='学生请假';/*Data for the table `xueshengqingjia` */insert  into `xueshengqingjia`(`id`,`xuesheng_id`,`xueshengqingjia_name`,`xueshengqingjia_text`,`xueshengqingjia_types`,`insert_time`,`xueshengqingjia_time`,`xueshengqingjia_number`,`xueshengqingjia_yesno_types`,`xueshengqingjia_yesno_text`,`xueshengqingjia_shenhe_time`,`create_time`) values (1,2,'请假标题1','请假缘由1',1,'2023-04-04 17:18:13','2023-04-04 17:18:13',435,1,NULL,NULL,'2023-04-04 17:18:13'),(2,2,'请假标题2','请假缘由2',1,'2023-04-04 17:18:13','2023-04-04 17:18:13',370,1,NULL,NULL,'2023-04-04 17:18:13'),(3,2,'请假标题3','请假缘由3',1,'2023-04-04 17:18:13','2023-04-04 17:18:13',385,1,NULL,NULL,'2023-04-04 17:18:13'),(4,3,'请假标题4','请假缘由4',2,'2023-04-04 17:18:13','2023-04-04 17:18:13',370,1,NULL,NULL,'2023-04-04 17:18:13'),(5,2,'请假标题5','请假缘由5',1,'2023-04-04 17:18:13','2023-04-04 17:18:13',362,1,NULL,NULL,'2023-04-04 17:18:13'),(6,2,'请假标题6','请假缘由6',1,'2023-04-04 17:18:13','2023-04-04 17:18:13',444,1,NULL,NULL,'2023-04-04 17:18:13'),(7,2,'请假标题7','请假缘由7',2,'2023-04-04 17:18:13','2023-04-04 17:18:13',358,1,NULL,NULL,'2023-04-04 17:18:13'),(8,3,'请假标题8','请假缘由8',1,'2023-04-04 17:18:13','2023-04-04 17:18:13',146,1,NULL,NULL,'2023-04-04 17:18:13'),(9,3,'请假标题9','请假缘由9',1,'2023-04-04 17:18:13','2023-04-04 17:18:13',191,1,NULL,NULL,'2023-04-04 17:18:13'),(10,2,'请假标题10','请假缘由10',1,'2023-04-04 17:18:13','2023-04-04 17:18:13',194,1,NULL,NULL,'2023-04-04 17:18:13'),(11,1,'请假标题11','请假缘由11',1,'2023-04-04 17:18:13','2023-04-04 17:18:13',500,1,NULL,NULL,'2023-04-04 17:18:13'),(12,1,'请假标题12','请假缘由12',1,'2023-04-04 17:18:13','2023-04-04 17:18:13',412,1,NULL,NULL,'2023-04-04 17:18:13'),(13,3,'请假标题13','请假缘由13',1,'2023-04-04 17:18:13','2023-04-04 17:18:13',347,1,NULL,NULL,'2023-04-04 17:18:13'),(14,3,'请假标题14','请假缘由14',1,'2023-04-04 17:18:13','2023-04-04 17:18:13',316,1,NULL,NULL,'2023-04-04 17:18:13'),(15,1,'请假表题222','大概多少根深蒂固',1,'2023-04-04 17:34:13','2023-04-05 00:00:00',2,3,'个哈哈哈','2023-04-04 17:58:27','2023-04-04 17:34:13'),(16,2,'请假2222','更大功夫大师和',1,'2023-04-04 17:51:53','2023-04-05 00:00:00',3,2,'个哈哈哈或或','2023-04-04 17:58:21','2023-04-04 17:51:53');/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

五.关键代码

package com.controller;
import java.util.Arrays;
import java.util.Calendar;
import java.util.Date;
import java.util.Map;
import javax.servlet.http.HttpServletRequest;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;
import com.annotation.IgnoreAuth;
import com.baomidou.mybatisplus.mapper.EntityWrapper;
import com.entity.TokenEntity;
import com.entity.UserEntity;
import com.service.TokenService;
import com.service.UserService;
import com.utils.CommonUtil;
import com.utils.MD5Util;
import com.utils.MPUtil;
import com.utils.PageUtils;
import com.utils.R;
import com.utils.ValidatorUtils;/*** 登录相关*/
@RequestMapping("users")
@RestController
public class UserController{@Autowiredprivate UserService userService;@Autowiredprivate TokenService tokenService;/*** 登录*/@IgnoreAuth@PostMapping(value = "/login")public R login(String username, String password, String captcha, HttpServletRequest request) {UserEntity user = userService.selectOne(new EntityWrapper<UserEntity>().eq("username", username));if(user==null || !user.getPassword().equals(password)) {return R.error("账号或密码不正确");}String token = tokenService.generateToken(user.getId(),username, "users", user.getRole());return R.ok().put("token", token);}/*** 注册*/@IgnoreAuth@PostMapping(value = "/register")public R register(@RequestBody UserEntity user){
//    	ValidatorUtils.validateEntity(user);if(userService.selectOne(new EntityWrapper<UserEntity>().eq("username", user.getUsername())) !=null) {return R.error("用户已存在");}userService.insert(user);return R.ok();}/*** 退出*/@GetMapping(value = "logout")public R logout(HttpServletRequest request) {request.getSession().invalidate();return R.ok("退出成功");}/*** 密码重置*/@IgnoreAuth@RequestMapping(value = "/resetPass")public R resetPass(String username, HttpServletRequest request){UserEntity user = userService.selectOne(new EntityWrapper<UserEntity>().eq("username", username));if(user==null) {return R.error("账号不存在");}user.setPassword("123456");userService.update(user,null);return R.ok("密码已重置为：123456");}/*** 列表*/@RequestMapping("/page")public R page(@RequestParam Map<String, Object> params,UserEntity user){EntityWrapper<UserEntity> ew = new EntityWrapper<UserEntity>();PageUtils page = userService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.allLike(ew, user), params), params));return R.ok().put("data", page);}/*** 列表*/@RequestMapping("/list")public R list( UserEntity user){EntityWrapper<UserEntity> ew = new EntityWrapper<UserEntity>();ew.allEq(MPUtil.allEQMapPre( user, "user")); return R.ok().put("data", userService.selectListView(ew));}/*** 信息*/@RequestMapping("/info/{id}")public R info(@PathVariable("id") String id){UserEntity user = userService.selectById(id);return R.ok().put("data", user);}/*** 获取用户的session用户信息*/@RequestMapping("/session")public R getCurrUser(HttpServletRequest request){Long id = (Long)request.getSession().getAttribute("userId");UserEntity user = userService.selectById(id);return R.ok().put("data", user);}/*** 保存*/@PostMapping("/save")public R save(@RequestBody UserEntity user){
//    	ValidatorUtils.validateEntity(user);if(userService.selectOne(new EntityWrapper<UserEntity>().eq("username", user.getUsername())) !=null) {return R.error("用户已存在");}userService.insert(user);return R.ok();}/*** 修改*/@RequestMapping("/update")public R update(@RequestBody UserEntity user){
//        ValidatorUtils.validateEntity(user);UserEntity u = userService.selectOne(new EntityWrapper<UserEntity>().eq("username", user.getUsername()));if(u!=null && u.getId()!=user.getId() && u.getUsername().equals(user.getUsername())) {return R.error("用户名已存在。");}userService.updateById(user);//全部更新return R.ok();}/*** 删除*/@RequestMapping("/delete")public R delete(@RequestBody Long[] ids){userService.deleteBatchIds(Arrays.asList(ids));return R.ok();}
}