开发语言：Java
框架：springboot
JDK版本：JDK1.8
服务器：tomcat7
数据库：mysql 5.7（一定要5.7版本）
数据库工具：Navicat11
开发软件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
浏览器：谷歌浏览器
数据库代码：
DROP TABLE IF EXISTS `biyeketi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `biyeketi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`ketimingcheng` varchar(200) DEFAULT NULL COMMENT '课题名称',
`fengmian` varchar(200) DEFAULT NULL COMMENT '封面',
`renwushu` varchar(200) DEFAULT NULL COMMENT '任务书',
`zhuanxiemubiao` varchar(200) DEFAULT NULL COMMENT '撰写目标',
`gongzuoyaoqiu` longtext COMMENT '工作要求',
`jiaoshigonghao` varchar(200) DEFAULT NULL COMMENT '教师工号',
`jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
`yuanxi` varchar(200) DEFAULT NULL COMMENT '院系',
`fabushijian` datetime DEFAULT NULL COMMENT '发布时间',
`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
`shhf` longtext COMMENT '审核回复',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='毕业课题';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `biyeketi`
--
LOCK TABLES `biyeketi` WRITE;
/*!40000 ALTER TABLE `biyeketi` DISABLE KEYS */;
INSERT INTO `biyeketi` VALUES (31,'2022-05-04 03:06:47','课题名称1','upload/biyeketi_fengmian1.jpg','','撰写目标1','工作要求1','教师工号1','教师姓名1','院系1','2022-05-04 11:06:47','是',''),(32,'2022-05-04 03:06:47','课题名称2','upload/biyeketi_fengmian2.jpg','','撰写目标2','工作要求2','教师工号2','教师姓名2','院系2','2022-05-04 11:06:47','是',''),(33,'2022-05-04 03:06:47','课题名称3','upload/biyeketi_fengmian3.jpg','','撰写目标3','工作要求3','教师工号3','教师姓名3','院系3','2022-05-04 11:06:47','是',''),(34,'2022-05-04 03:06:47','课题名称4','upload/biyeketi_fengmian4.jpg','','撰写目标4','工作要求4','教师工号4','教师姓名4','院系4','2022-05-04 11:06:47','是',''),(35,'2022-05-04 03:06:47','课题名称5','upload/biyeketi_fengmian5.jpg','','撰写目标5','工作要求5','教师工号5','教师姓名5','院系5','2022-05-04 11:06:47','是',''),(36,'2022-05-04 03:06:47','课题名称6','upload/biyeketi_fengmian6.jpg','','撰写目标6','工作要求6','教师工号6','教师姓名6','院系6','2022-05-04 11:06:47','是','');
/*!40000 ALTER TABLE `biyeketi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `config`
--
DROP TABLE IF EXISTS `config`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `config` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`name` varchar(100) NOT NULL COMMENT '配置参数名称',
`value` varchar(100) DEFAULT NULL COMMENT '配置参数值',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='配置文件';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `config`
--
LOCK TABLES `config` WRITE;
/*!40000 ALTER TABLE `config` DISABLE KEYS */;
INSERT INTO `config` VALUES (1,'picture1','upload/picture1.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `dabianchengji`
--
DROP TABLE IF EXISTS `dabianchengji`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dabianchengji` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`ketimingcheng` varchar(200) DEFAULT NULL COMMENT '课题名称',
`lunwentimu` varchar(200) DEFAULT NULL COMMENT '论文题目',
`dabianchengji` int(11) DEFAULT NULL COMMENT '答辩成绩',
`dabianjieguo` varchar(200) DEFAULT NULL COMMENT '答辩结果',
`dabianqingkuang` longtext COMMENT '答辩情况',
`dabianriqi` date DEFAULT NULL COMMENT '答辩日期',
`xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
`xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',
`jiaoshigonghao` varchar(200) DEFAULT NULL COMMENT '教师工号',
`jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='答辩成绩';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `dabianchengji`
--
LOCK TABLES `dabianchengji` WRITE;
/*!40000 ALTER TABLE `dabianchengji` DISABLE KEYS */;
INSERT INTO `dabianchengji` VALUES (61,'2022-05-04 03:06:47','课题名称1','论文题目1',1,'无修改通过','答辩情况1','2022-05-04','学号1','学生姓名1','教师工号1','教师姓名1'),(62,'2022-05-04 03:06:47','课题名称2','论文题目2',2,'无修改通过','答辩情况2','2022-05-04','学号2','学生姓名2','教师工号2','教师姓名2'),(63,'2022-05-04 03:06:47','课题名称3','论文题目3',3,'无修改通过','答辩情况3','2022-05-04','学号3','学生姓名3','教师工号3','教师姓名3'),(64,'2022-05-04 03:06:47','课题名称4','论文题目4',4,'无修改通过','答辩情况4','2022-05-04','学号4','学生姓名4','教师工号4','教师姓名4'),(65,'2022-05-04 03:06:47','课题名称5','论文题目5',5,'无修改通过','答辩情况5','2022-05-04','学号5','学生姓名5','教师工号5','教师姓名5'),(66,'2022-05-04 03:06:47','课题名称6','论文题目6',6,'无修改通过','答辩情况6','2022-05-04','学号6','学生姓名6','教师工号6','教师姓名6');
/*!40000 ALTER TABLE `dabianchengji` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jiaoshi`
--
DROP TABLE IF EXISTS `jiaoshi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiaoshi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`jiaoshigonghao` varchar(200) DEFAULT NULL COMMENT '教师工号',
`mima` varchar(200) DEFAULT NULL COMMENT '密码',
`jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
`zhaopian` varchar(200) DEFAULT NULL COMMENT '照片',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`zhicheng` varchar(200) DEFAULT NULL COMMENT '职称',
`yuanxi` varchar(200) DEFAULT NULL COMMENT '院系',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
PRIMARY KEY (`id`),
UNIQUE KEY `jiaoshigonghao` (`jiaoshigonghao`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='教师';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jiaoshi`
--
LOCK TABLES `jiaoshi` WRITE;
/*!40000 ALTER TABLE `jiaoshi` DISABLE KEYS */;
INSERT INTO `jiaoshi` VALUES (21,'2022-05-04 03:06:47','教师工号1','123456','教师姓名1','upload/jiaoshi_zhaopian1.jpg','男','助教','院系1','13823888881'),(22,'2022-05-04 03:06:47','教师工号2','123456','教师姓名2','upload/jiaoshi_zhaopian2.jpg','男','助教','院系2','13823888882'),(23,'2022-05-04 03:06:47','教师工号3','123456','教师姓名3','upload/jiaoshi_zhaopian3.jpg','男','助教','院系3','13823888883'),(24,'2022-05-04 03:06:47','教师工号4','123456','教师姓名4','upload/jiaoshi_zhaopian4.jpg','男','助教','院系4','13823888884'),(25,'2022-05-04 03:06:47','教师工号5','123456','教师姓名5','upload/jiaoshi_zhaopian5.jpg','男','助教','院系5','13823888885'),(26,'2022-05-04 03:06:47','教师工号6','123456','教师姓名6','upload/jiaoshi_zhaopian6.jpg','男','助教','院系6','13823888886');
/*!40000 ALTER TABLE `jiaoshi` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `lunwentijiao`
--
DROP TABLE IF EXISTS `lunwentijiao`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lunwentijiao` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`ketimingcheng` varchar(200) DEFAULT NULL COMMENT '课题名称',
`fengmian` varchar(200) DEFAULT NULL COMMENT '封面',
`kaitibaogao` varchar(200) DEFAULT NULL COMMENT '开题报告',
`lunwentimu` varchar(200) DEFAULT NULL COMMENT '论文题目',
`lunwenneirong` varchar(200) DEFAULT NULL COMMENT '论文内容',
`tijiaoshijian` datetime DEFAULT NULL COMMENT '提交时间',
`jiaoshigonghao` varchar(200) DEFAULT NULL COMMENT '教师工号',
`jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
`xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
`xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT='论文提交';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `lunwentijiao`
--
LOCK TABLES `lunwentijiao` WRITE;
/*!40000 ALTER TABLE `lunwentijiao` DISABLE KEYS */;
INSERT INTO `lunwentijiao` VALUES (51,'2022-05-04 03:06:47','课题名称1','upload/lunwentijiao_fengmian1.jpg','','论文题目1','','2022-05-04 11:06:47','教师工号1','教师姓名1','学号1','学生姓名1'),(52,'2022-05-04 03:06:47','课题名称2','upload/lunwentijiao_fengmian2.jpg','','论文题目2','','2022-05-04 11:06:47','教师工号2','教师姓名2','学号2','学生姓名2'),(53,'2022-05-04 03:06:47','课题名称3','upload/lunwentijiao_fengmian3.jpg','','论文题目3','','2022-05-04 11:06:47','教师工号3','教师姓名3','学号3','学生姓名3'),(54,'2022-05-04 03:06:47','课题名称4','upload/lunwentijiao_fengmian4.jpg','','论文题目4','','2022-05-04 11:06:47','教师工号4','教师姓名4','学号4','学生姓名4'),(55,'2022-05-04 03:06:47','课题名称5','upload/lunwentijiao_fengmian5.jpg','','论文题目5','','2022-05-04 11:06:47','教师工号5','教师姓名5','学号5','学生姓名5'),(56,'2022-05-04 03:06:47','课题名称6','upload/lunwentijiao_fengmian6.jpg','','论文题目6','','2022-05-04 11:06:47','教师工号6','教师姓名6','学号6','学生姓名6');
/*!40000 ALTER TABLE `lunwentijiao` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `news`
--
DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`title` varchar(200) NOT NULL COMMENT '标题',
`introduction` longtext COMMENT '简介',
`picture` varchar(200) NOT NULL COMMENT '图片',
`content` longtext NOT NULL COMMENT '内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT='公告信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
如需定做或者获取更多资料，请联系QQ：375279829
客服QQ