开发语言: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;