基于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 */;

--