springboot毕设题目推荐（基于springboot的毕业设计选题系统-计算机毕业设计源码）

springboot毕设题目推荐（基于springboot的毕业设计选题系统-计算机毕业设计源码）浏览器：谷歌浏览器Maven包：Maven3.3.9数据库：mysql 5.7（一定要5.7版本）数据库工具：Navicat11开发软件：eclipse/myeclipse/idea

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

--