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