基于springboot的毕业设计选题系统的设计与实现-计算机毕业设计源码+LW文档

开发语言：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 */;

--