基于springboot的畢業(yè)設(shè)計選題系統(tǒng)的設(shè)計與實現(xiàn)-計算機畢業(yè)設(shè)計源碼+LW文檔
開發(fā)語言：Java
框架：springboot
JDK版本：JDK1.8
服務(wù)器：tomcat7
數(shù)據(jù)庫：mysql 5.7（一定要5.7版本）
數(shù)據(jù)庫工具：Navicat11
開發(fā)軟件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
瀏覽器：谷歌瀏覽器
數(shù)據(jù)庫代碼：
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 '創(chuàng)建時間',
? `ketimingcheng` varchar(200) DEFAULT NULL COMMENT '課題名稱',
? `fengmian` varchar(200) DEFAULT NULL COMMENT '封面',
? `renwushu` varchar(200) DEFAULT NULL COMMENT '任務(wù)書',
? `zhuanxiemubiao` varchar(200) DEFAULT NULL COMMENT '撰寫目標(biāo)',
? `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 '發(fā)布時間',
? `sfsh` varchar(200) DEFAULT '否' COMMENT '是否審核',
? `shhf` longtext COMMENT '審核回復(fù)',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='畢業(yè)課題';
/*!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','','撰寫目標(biāo)1','工作要求1','教師工號1','教師姓名1','院系1','2022-05-04 11:06:47','是',''),(32,'2022-05-04 03:06:47','課題名稱2','upload/biyeketi_fengmian2.jpg','','撰寫目標(biāo)2','工作要求2','教師工號2','教師姓名2','院系2','2022-05-04 11:06:47','是',''),(33,'2022-05-04 03:06:47','課題名稱3','upload/biyeketi_fengmian3.jpg','','撰寫目標(biāo)3','工作要求3','教師工號3','教師姓名3','院系3','2022-05-04 11:06:47','是',''),(34,'2022-05-04 03:06:47','課題名稱4','upload/biyeketi_fengmian4.jpg','','撰寫目標(biāo)4','工作要求4','教師工號4','教師姓名4','院系4','2022-05-04 11:06:47','是',''),(35,'2022-05-04 03:06:47','課題名稱5','upload/biyeketi_fengmian5.jpg','','撰寫目標(biāo)5','工作要求5','教師工號5','教師姓名5','院系5','2022-05-04 11:06:47','是',''),(36,'2022-05-04 03:06:47','課題名稱6','upload/biyeketi_fengmian6.jpg','','撰寫目標(biāo)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 '配置參數(shù)名稱',
? `value` varchar(100) DEFAULT NULL COMMENT '配置參數(shù)值',
? 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 '創(chuàng)建時間',
? `ketimingcheng` varchar(200) DEFAULT NULL COMMENT '課題名稱',
? `lunwentimu` varchar(200) DEFAULT NULL COMMENT '論文題目',
? `dabianchengji` int(11) DEFAULT NULL COMMENT '答辯成績',
? `dabianjieguo` varchar(200) DEFAULT NULL COMMENT '答辯結(jié)果',
? `dabianqingkuang` longtext COMMENT '答辯情況',
? `dabianriqi` date DEFAULT NULL COMMENT '答辯日期',
? `xuehao` varchar(200) DEFAULT NULL COMMENT '學(xué)號',
? `xueshengxingming` varchar(200) DEFAULT NULL COMMENT '學(xué)生姓名',
? `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','學(xué)號1','學(xué)生姓名1','教師工號1','教師姓名1'),(62,'2022-05-04 03:06:47','課題名稱2','論文題目2',2,'無修改通過','答辯情況2','2022-05-04','學(xué)號2','學(xué)生姓名2','教師工號2','教師姓名2'),(63,'2022-05-04 03:06:47','課題名稱3','論文題目3',3,'無修改通過','答辯情況3','2022-05-04','學(xué)號3','學(xué)生姓名3','教師工號3','教師姓名3'),(64,'2022-05-04 03:06:47','課題名稱4','論文題目4',4,'無修改通過','答辯情況4','2022-05-04','學(xué)號4','學(xué)生姓名4','教師工號4','教師姓名4'),(65,'2022-05-04 03:06:47','課題名稱5','論文題目5',5,'無修改通過','答辯情況5','2022-05-04','學(xué)號5','學(xué)生姓名5','教師工號5','教師姓名5'),(66,'2022-05-04 03:06:47','課題名稱6','論文題目6',6,'無修改通過','答辯情況6','2022-05-04','學(xué)號6','學(xué)生姓名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 '創(chuàng)建時間',
? `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 '聯(lián)系電話',
? 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 '創(chuàng)建時間',
? `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 '論文內(nèi)容',
? `tijiaoshijian` datetime DEFAULT NULL COMMENT '提交時間',
? `jiaoshigonghao` varchar(200) DEFAULT NULL COMMENT '教師工號',
? `jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教師姓名',
? `xuehao` varchar(200) DEFAULT NULL COMMENT '學(xué)號',
? `xueshengxingming` varchar(200) DEFAULT NULL COMMENT '學(xué)生姓名',
? 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','學(xué)號1','學(xué)生姓名1'),(52,'2022-05-04 03:06:47','課題名稱2','upload/lunwentijiao_fengmian2.jpg','','論文題目2','','2022-05-04 11:06:47','教師工號2','教師姓名2','學(xué)號2','學(xué)生姓名2'),(53,'2022-05-04 03:06:47','課題名稱3','upload/lunwentijiao_fengmian3.jpg','','論文題目3','','2022-05-04 11:06:47','教師工號3','教師姓名3','學(xué)號3','學(xué)生姓名3'),(54,'2022-05-04 03:06:47','課題名稱4','upload/lunwentijiao_fengmian4.jpg','','論文題目4','','2022-05-04 11:06:47','教師工號4','教師姓名4','學(xué)號4','學(xué)生姓名4'),(55,'2022-05-04 03:06:47','課題名稱5','upload/lunwentijiao_fengmian5.jpg','','論文題目5','','2022-05-04 11:06:47','教師工號5','教師姓名5','學(xué)號5','學(xué)生姓名5'),(56,'2022-05-04 03:06:47','課題名稱6','upload/lunwentijiao_fengmian6.jpg','','論文題目6','','2022-05-04 11:06:47','教師工號6','教師姓名6','學(xué)號6','學(xué)生姓名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 '創(chuàng)建時間',
? `title` varchar(200) NOT NULL COMMENT '標(biāo)題',
? `introduction` longtext COMMENT '簡介',
? `picture` varchar(200) NOT NULL COMMENT '圖片',
? `content` longtext NOT NULL COMMENT '內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT='公告信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
