基于SpringBoot与Vue技术的高校毕设管理平台-计算机毕业设计源码

开发语言：Java

框架：springboot

JDK版本：JDK1.8

服务器：tomcat7

数据库：mysql 5.7（一定要5.7版本）

数据库工具：Navicat11

开发软件：eclipse/myeclipse/idea

Maven包：Maven3.3.9

浏览器：谷歌浏览器

数据库部分表：

DROP TABLE IF EXISTS `bisheketi`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `bisheketi` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`xuantimingcheng` varchar(200) NOT NULL COMMENT '选题名称',

`xuantileixing` varchar(200) NOT NULL COMMENT '选题类型',

`xuantiyaoqiu` varchar(200) DEFAULT NULL COMMENT '选题要求',

`shiyongzhuanye` varchar(200) DEFAULT NULL COMMENT '适用专业',

`faburiqi` date DEFAULT NULL COMMENT '发布日期',

`jiaoshigonghao` varchar(200) DEFAULT NULL COMMENT '教师工号',

`jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',

`jiaoshidianhua` varchar(200) DEFAULT NULL COMMENT '教师电话',

`sfsh` varchar(200) DEFAULT '待审核' COMMENT '是否审核',

`shhf` longtext COMMENT '审核回复',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COMMENT='毕设课题';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `bisheketi`

--

LOCK TABLES `bisheketi` WRITE;

/*!40000 ALTER TABLE `bisheketi` DISABLE KEYS */;

INSERT INTO `bisheketi` VALUES (41,'2023-03-21 02:35:14','选题名称1','选题类型1','选题要求1','适用专业1','2023-03-21','教师工号1','教师姓名1','13823888881','是',''),(42,'2023-03-21 02:35:14','选题名称2','选题类型2','选题要求2','适用专业2','2023-03-21','教师工号2','教师姓名2','13823888882','是',''),(43,'2023-03-21 02:35:14','选题名称3','选题类型3','选题要求3','适用专业3','2023-03-21','教师工号3','教师姓名3','13823888883','是',''),(44,'2023-03-21 02:35:14','选题名称4','选题类型4','选题要求4','适用专业4','2023-03-21','教师工号4','教师姓名4','13823888884','是',''),(45,'2023-03-21 02:35:14','选题名称5','选题类型5','选题要求5','适用专业5','2023-03-21','教师工号5','教师姓名5','13823888885','是',''),(46,'2023-03-21 02:35:14','选题名称6','选题类型6','选题要求6','适用专业6','2023-03-21','教师工号6','教师姓名6','13823888886','是',''),(47,'2023-03-21 02:35:14','选题名称7','选题类型7','选题要求7','适用专业7','2023-03-21','教师工号7','教师姓名7','13823888887','是',''),(48,'2023-03-21 02:35:14','选题名称8','选题类型8','选题要求8','适用专业8','2023-03-21','教师工号8','教师姓名8','13823888888','是','');

/*!40000 ALTER TABLE `bisheketi` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `bisherenwushu`

--

DROP TABLE IF EXISTS `bisherenwushu`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `bisherenwushu` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`xuantimingcheng` varchar(200) DEFAULT NULL COMMENT '选题名称',

`xuantileixing` varchar(200) DEFAULT NULL COMMENT '选题类型',

`renwushu` longtext COMMENT '任务书',

`jiaoshigonghao` varchar(200) DEFAULT NULL COMMENT '教师工号',

`jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',

`renwushuxiangqing` longtext COMMENT '任务书详情',

`tijiaoriqi` date DEFAULT NULL COMMENT '提交日期',

`xuehao` varchar(200) DEFAULT NULL COMMENT '学号',

`xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',

`zhuanyebanji` varchar(200) DEFAULT NULL COMMENT '专业班级',

`xueshengshouji` varchar(200) DEFAULT NULL COMMENT '学生手机',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8 COMMENT='毕设任务书';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `bisherenwushu`

--

LOCK TABLES `bisherenwushu` WRITE;

/*!40000 ALTER TABLE `bisherenwushu` DISABLE KEYS */;

INSERT INTO `bisherenwushu` VALUES (71,'2023-03-21 02:35:14','选题名称1','选题类型1','','教师工号1','教师姓名1','任务书详情1','2023-03-21','学号1','学生姓名1','专业班级1','学生手机1'),(72,'2023-03-21 02:35:14','选题名称2','选题类型2','','教师工号2','教师姓名2','任务书详情2','2023-03-21','学号2','学生姓名2','专业班级2','学生手机2'),(73,'2023-03-21 02:35:14','选题名称3','选题类型3','','教师工号3','教师姓名3','任务书详情3','2023-03-21','学号3','学生姓名3','专业班级3','学生手机3'),(74,'2023-03-21 02:35:14','选题名称4','选题类型4','','教师工号4','教师姓名4','任务书详情4','2023-03-21','学号4','学生姓名4','专业班级4','学生手机4'),(75,'2023-03-21 02:35:14','选题名称5','选题类型5','','教师工号5','教师姓名5','任务书详情5','2023-03-21','学号5','学生姓名5','专业班级5','学生手机5'),(76,'2023-03-21 02:35:14','选题名称6','选题类型6','','教师工号6','教师姓名6','任务书详情6','2023-03-21','学号6','学生姓名6','专业班级6','学生手机6'),(77,'2023-03-21 02:35:14','选题名称7','选题类型7','','教师工号7','教师姓名7','任务书详情7','2023-03-21','学号7','学生姓名7','专业班级7','学生手机7'),(78,'2023-03-21 02:35:14','选题名称8','选题类型8','','教师工号8','教师姓名8','任务书详情8','2023-03-21','学号8','学生姓名8','专业班级8','学生手机8');

/*!40000 ALTER TABLE `bisherenwushu` ENABLE KEYS */;

UNLOCK TABLES;