springboot毕业设计管理系统-JAVA【数据库设计、论文、源码、开题报告】

最新推荐文章于 2024-04-17 12:54:39 发布
浪工程序设计合作
最新推荐文章于 2024-04-17 12:54:39 发布
阅读量311
点赞数
分类专栏： Java项目实战文章标签：数据库 java spring boot
本文链接：https://blog.csdn.net/laowang8/article/details/128411144
版权
Java项目实战专栏收录该内容
374 篇文章 54 订阅
订阅专栏
功能介绍

管理员：对用户进行信息编辑，同时可对系统应该具备的功能进行分析。可以对首页，个人中心，公告信息管理，学生管理，教师管理，课题信息管理，选题信息管理，开题报告管理，任务书管理，检查报告管理，论文信息管理，开题评分管理，任务评分管理，检查评分管理，论文评分管理等
教师：首页，个人中心，课题信息管理，选题信息管理，开题报告管理，任务书管理，检查报告管理，论文信息管理，开题评分管理，任务评分管理，检查评分管理，论文评分管理等功能进行高校范围内操作
学生：首页，个人中心，课题信息管理，选题信息管理，开题报告管理，任务书管理，检查报告管理，论文信息管理，开题评分管理，任务评分管理，检查评分管理，论文评分管理等功能进行高校范围内操作
数据库脚本


-- MySQL dump 10.13  Distrib 5.7.31, for Linux (x86_64)
--
-- Host: localhost    Database: springbootuy772
-- ------------------------------------------------------
-- Server version	5.7.31

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Current Database: `springbootuy772`
--

/*!40000 DROP DATABASE IF EXISTS `springbootuy772`*/;

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `springbootuy772` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;

USE `springbootuy772`;

--
-- 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 `jianchabaogao`
--

DROP TABLE IF EXISTS `jianchabaogao`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jianchabaogao` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `ketimingcheng` varchar(200) DEFAULT NULL COMMENT '课题名称',
  `laiyuan` varchar(200) DEFAULT NULL COMMENT '来源',
  `gonghao` varchar(200) DEFAULT NULL COMMENT '工号',
  `jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
  `xibu` varchar(200) DEFAULT NULL COMMENT '系部',
  `jianchamingcheng` varchar(200) NOT NULL COMMENT '检查名称',
  `jianchaneirong` longtext COMMENT '检查内容',
  `jianchawendang` varchar(200) DEFAULT NULL COMMENT '检查文档',
  `xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
  `xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',
  `zhuanye` varchar(200) DEFAULT NULL COMMENT '专业',
  `tijiaoriqi` date DEFAULT NULL COMMENT '提交日期',
  `sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
  `shhf` longtext COMMENT '审核回复',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1649646305926 DEFAULT CHARSET=utf8 COMMENT='检查报告';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `jianchabaogao`
--

LOCK TABLES `jianchabaogao` WRITE;
/*!40000 ALTER TABLE `jianchabaogao` DISABLE KEYS */;
INSERT INTO `jianchabaogao` VALUES (71,'2022-04-11 02:55:51','课题名称1','来源1','工号1','教师姓名1','系部1','检查名称1','检查内容1','','学号1','学生姓名1','专业1','2022-04-11','是',''),(72,'2022-04-11 02:55:51','课题名称2','来源2','工号2','教师姓名2','系部2','检查名称2','检查内容2','','学号2','学生姓名2','专业2','2022-04-11','是',''),(73,'2022-04-11 02:55:51','课题名称3','来源3','工号3','教师姓名3','系部3','检查名称3','检查内容3','','学号3','学生姓名3','专业3','2022-04-11','是',''),(74,'2022-04-11 02:55:51','课题名称4','来源4','工号4','教师姓名4','系部4','检查名称4','检查内容4','','学号4','学生姓名4','专业4','2022-04-11','是',''),(75,'2022-04-11 02:55:51','课题名称5','来源5','工号5','教师姓名5','系部5','检查名称5','检查内容5','','学号5','学生姓名5','专业5','2022-04-11','是',''),(76,'2022-04-11 02:55:51','课题名称6','来源6','工号6','教师姓名6','系部6','检查名称6','检查内容6','','学号6','学生姓名6','专业6','2022-04-11','是',''),(1649646305925,'2022-04-11 03:05:05','某某课题','科研项目','22','李四','某某部门','某某检查','这里输入提交中期检查报告的地方','upload/1649646288647.docx','11','张三','某某专业','2022-04-11','是','审核中期检查报告，并评分');
/*!40000 ALTER TABLE `jianchabaogao` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jianchapingfen`
--

DROP TABLE IF EXISTS `jianchapingfen`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jianchapingfen` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `ketimingcheng` varchar(200) DEFAULT NULL COMMENT '课题名称',
  `laiyuan` varchar(200) DEFAULT NULL COMMENT '来源',
  `gonghao` varchar(200) DEFAULT NULL COMMENT '工号',
  `jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
  `xibu` varchar(200) DEFAULT NULL COMMENT '系部',
  `jianchamingcheng` varchar(200) DEFAULT NULL COMMENT '检查名称',
  `pingfen` int(11) NOT NULL COMMENT '评分',
  `pingjiajianyi` longtext COMMENT '评价建议',
  `xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
  `xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',
  `zhuanye` varchar(200) DEFAULT NULL COMMENT '专业',
  `pingfenriqi` date DEFAULT NULL COMMENT '评分日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1649646339503 DEFAULT CHARSET=utf8 COMMENT='检查评分';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `jianchapingfen`
--

LOCK TABLES `jianchapingfen` WRITE;
/*!40000 ALTER TABLE `jianchapingfen` DISABLE KEYS */;
INSERT INTO `jianchapingfen` VALUES (111,'2022-04-11 02:55:51','课题名称1','来源1','工号1','教师姓名1','系部1','检查名称1',1,'评价建议1','学号1','学生姓名1','专业1','2022-04-11'),(112,'2022-04-11 02:55:51','课题名称2','来源2','工号2','教师姓名2','系部2','检查名称2',2,'评价建议2','学号2','学生姓名2','专业2','2022-04-11'),(113,'2022-04-11 02:55:51','课题名称3','来源3','工号3','教师姓名3','系部3','检查名称3',3,'评价建议3','学号3','学生姓名3','专业3','2022-04-11'),(114,'2022-04-11 02:55:51','课题名称4','来源4','工号4','教师姓名4','系部4','检查名称4',4,'评价建议4','学号4','学生姓名4','专业4','2022-04-11'),(115,'2022-04-11 02:55:51','课题名称5','来源5','工号5','教师姓名5','系部5','检查名称5',5,'评价建议5','学号5','学生姓名5','专业5','2022-04-11'),(116,'2022-04-11 02:55:51','课题名称6','来源6','工号6','教师姓名6','系部6','检查名称6',6,'评价建议6','学号6','学生姓名6','专业6','2022-04-11'),(1649646339502,'2022-04-11 03:05:39','某某课题','科研项目','22','李四','某某部门','某某检查',63,'评价跟建议','11','张三','某某专业','2022-04-11');
/*!40000 ALTER TABLE `jianchapingfen` 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 '创建时间',
  `gonghao` varchar(200) NOT NULL COMMENT '工号',
  `mima` varchar(200) NOT NULL COMMENT '密码',
  `jiaoshixingming` varchar(200) NOT NULL COMMENT '教师姓名',
  `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
  `youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',
  `lianxishouji` varchar(200) DEFAULT NULL COMMENT '联系手机',
  `xibu` varchar(200) DEFAULT NULL COMMENT '系部',
  `zhiwu` varchar(200) DEFAULT NULL COMMENT '职务',
  `xiangpian` varchar(200) DEFAULT NULL COMMENT '相片',
  PRIMARY KEY (`id`),
  UNIQUE KEY `gonghao` (`gonghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1649645966539 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-04-11 02:55:51','工号1','123456','教师姓名1','男','773890001@qq.com','13823888881','系部1','职务1','upload/jiaoshi_xiangpian1.jpg'),(22,'2022-04-11 02:55:51','工号2','123456','教师姓名2','男','773890002@qq.com','13823888882','系部2','职务2','upload/jiaoshi_xiangpian2.jpg'),(23,'2022-04-11 02:55:51','工号3','123456','教师姓名3','男','773890003@qq.com','13823888883','系部3','职务3','upload/jiaoshi_xiangpian3.jpg'),(24,'2022-04-11 02:55:51','工号4','123456','教师姓名4','男','773890004@qq.com','13823888884','系部4','职务4','upload/jiaoshi_xiangpian4.jpg'),(25,'2022-04-11 02:55:51','工号5','123456','教师姓名5','男','773890005@qq.com','13823888885','系部5','职务5','upload/jiaoshi_xiangpian5.jpg'),(26,'2022-04-11 02:55:51','工号6','123456','教师姓名6','男','773890006@qq.com','13823888886','系部6','职务6','upload/jiaoshi_xiangpian6.jpg'),(1649645966538,'2022-04-11 02:59:26','22','22','李四','女','133@163.com','13333333333','某某部门','某某职务','upload/1649645976927.jpeg');
/*!40000 ALTER TABLE `jiaoshi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kaitibaogao`
--

DROP TABLE IF EXISTS `kaitibaogao`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kaitibaogao` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `ketimingcheng` varchar(200) DEFAULT NULL COMMENT '课题名称',
  `laiyuan` varchar(200) DEFAULT NULL COMMENT '来源',
  `gonghao` varchar(200) DEFAULT NULL COMMENT '工号',
  `jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
  `xibu` varchar(200) DEFAULT NULL COMMENT '系部',
  `baogaomingcheng` varchar(200) DEFAULT NULL COMMENT '报告名称',
  `baogaoneirong` longtext COMMENT '报告内容',
  `fujianwendang` varchar(200) DEFAULT NULL COMMENT '附件文档',
  `xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
  `xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',
  `zhuanye` varchar(200) DEFAULT NULL COMMENT '专业',
  `tijiaoriqi` date DEFAULT NULL COMMENT '提交日期',
  `sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
  `shhf` longtext COMMENT '审核回复',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1649646098902 DEFAULT CHARSET=utf8 COMMENT='开题报告';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kaitibaogao`
--

LOCK TABLES `kaitibaogao` WRITE;
/*!40000 ALTER TABLE `kaitibaogao` DISABLE KEYS */;
INSERT INTO `kaitibaogao` VALUES (51,'2022-04-11 02:55:51','课题名称1','来源1','工号1','教师姓名1','系部1','报告名称1','报告内容1','','学号1','学生姓名1','专业1','2022-04-11','是',''),(52,'2022-04-11 02:55:51','课题名称2','来源2','工号2','教师姓名2','系部2','报告名称2','报告内容2','','学号2','学生姓名2','专业2','2022-04-11','是',''),(53,'2022-04-11 02:55:51','课题名称3','来源3','工号3','教师姓名3','系部3','报告名称3','报告内容3','','学号3','学生姓名3','专业3','2022-04-11','是',''),(54,'2022-04-11 02:55:51','课题名称4','来源4','工号4','教师姓名4','系部4','报告名称4','报告内容4','','学号4','学生姓名4','专业4','2022-04-11','是',''),(55,'2022-04-11 02:55:51','课题名称5','来源5','工号5','教师姓名5','系部5','报告名称5','报告内容5','','学号5','学生姓名5','专业5','2022-04-11','是',''),(56,'2022-04-11 02:55:51','课题名称6','来源6','工号6','教师姓名6','系部6','报告名称6','报告内容6','','学号6','学生姓名6','专业6','2022-04-11','是',''),(1649646098901,'2022-04-11 03:01:38','某某课题','科研项目','22','李四','某某部门','某某报告','这里是学生提交开题报告的地方，','upload/1649646097013.docx','11','张三','某某专业','2022-04-11','是','这里是审核学生提交的开题报告，并点击评分');
/*!40000 ALTER TABLE `kaitibaogao` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `kaitipingfen`
--

DROP TABLE IF EXISTS `kaitipingfen`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `kaitipingfen` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `ketimingcheng` varchar(200) DEFAULT NULL COMMENT '课题名称',
  `laiyuan` varchar(200) DEFAULT NULL COMMENT '来源',
  `gonghao` varchar(200) DEFAULT NULL COMMENT '工号',
  `jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
  `xibu` varchar(200) DEFAULT NULL COMMENT '系部',
  `baogaomingcheng` varchar(200) DEFAULT NULL COMMENT '报告名称',
  `pingfen` int(11) NOT NULL COMMENT '评分',
  `pingjiajianyi` longtext COMMENT '评价建议',
  `xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
  `xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',
  `zhuanye` varchar(200) DEFAULT NULL COMMENT '专业',
  `pingfenriqi` date DEFAULT NULL COMMENT '评分日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1649646197744 DEFAULT CHARSET=utf8 COMMENT='开题评分';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `kaitipingfen`
--

LOCK TABLES `kaitipingfen` WRITE;
/*!40000 ALTER TABLE `kaitipingfen` DISABLE KEYS */;
INSERT INTO `kaitipingfen` VALUES (91,'2022-04-11 02:55:51','课题名称1','来源1','工号1','教师姓名1','系部1','报告名称1',1,'评价建议1','学号1','学生姓名1','专业1','2022-04-11'),(92,'2022-04-11 02:55:51','课题名称2','来源2','工号2','教师姓名2','系部2','报告名称2',2,'评价建议2','学号2','学生姓名2','专业2','2022-04-11'),(93,'2022-04-11 02:55:51','课题名称3','来源3','工号3','教师姓名3','系部3','报告名称3',3,'评价建议3','学号3','学生姓名3','专业3','2022-04-11'),(94,'2022-04-11 02:55:51','课题名称4','来源4','工号4','教师姓名4','系部4','报告名称4',4,'评价建议4','学号4','学生姓名4','专业4','2022-04-11'),(95,'2022-04-11 02:55:51','课题名称5','来源5','工号5','教师姓名5','系部5','报告名称5',5,'评价建议5','学号5','学生姓名5','专业5','2022-04-11'),(96,'2022-04-11 02:55:51','课题名称6','来源6','工号6','教师姓名6','系部6','报告名称6',6,'评价建议6','学号6','学生姓名6','专业6','2022-04-11'),(1649646197743,'2022-04-11 03:03:17','某某课题','科研项目','22','李四','某某部门','某某报告',60,'这里是教师评分开题报告的地方','11','张三','某某专业','2022-04-11');
/*!40000 ALTER TABLE `kaitipingfen` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ketixinxi`
--

DROP TABLE IF EXISTS `ketixinxi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ketixinxi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `ketimingcheng` varchar(200) NOT NULL COMMENT '课题名称',
  `nandu` varchar(200) NOT NULL COMMENT '难度',
  `laiyuan` varchar(200) NOT NULL COMMENT '来源',
  `leixing` varchar(200) DEFAULT NULL COMMENT '类型',
  `miaoshu` longtext COMMENT '描述',
  `gonghao` varchar(200) DEFAULT NULL COMMENT '工号',
  `jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
  `xibu` varchar(200) DEFAULT NULL COMMENT '系部',
  `faburiqi` date DEFAULT NULL COMMENT '发布日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1649646001645 DEFAULT CHARSET=utf8 COMMENT='课题信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ketixinxi`
--

LOCK TABLES `ketixinxi` WRITE;
/*!40000 ALTER TABLE `ketixinxi` DISABLE KEYS */;
INSERT INTO `ketixinxi` VALUES (32,'2022-04-11 02:55:51','课题名称2','难','教师自拟','应用设计','描述2','工号2','教师姓名2','系部2','2022-04-11'),(33,'2022-04-11 02:55:51','课题名称3','难','教师自拟','应用设计','描述3','工号3','教师姓名3','系部3','2022-04-11'),(34,'2022-04-11 02:55:51','课题名称4','难','教师自拟','应用设计','描述4','工号4','教师姓名4','系部4','2022-04-11'),(35,'2022-04-11 02:55:51','课题名称5','难','教师自拟','应用设计','描述5','工号5','教师姓名5','系部5','2022-04-11'),(36,'2022-04-11 02:55:51','课题名称6','难','教师自拟','应用设计','描述6','工号6','教师姓名6','系部6','2022-04-11'),(1649646001644,'2022-04-11 03:00:00','某某课题','适中','科研项目','应用设计','这里是教师发布课题信息的地方','22','李四','某某部门','2022-04-11');
/*!40000 ALTER TABLE `ketixinxi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lunwenpingfen`
--

DROP TABLE IF EXISTS `lunwenpingfen`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lunwenpingfen` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `ketimingcheng` varchar(200) DEFAULT NULL COMMENT '课题名称',
  `laiyuan` varchar(200) DEFAULT NULL COMMENT '来源',
  `gonghao` varchar(200) DEFAULT NULL COMMENT '工号',
  `jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
  `xibu` varchar(200) DEFAULT NULL COMMENT '系部',
  `lunwenmingcheng` varchar(200) DEFAULT NULL COMMENT '论文名称',
  `pingfen` int(11) NOT NULL COMMENT '评分',
  `pingjiajianyi` longtext COMMENT '评价建议',
  `xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
  `xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',
  `zhuanye` varchar(200) DEFAULT NULL COMMENT '专业',
  `pingfenriqi` date DEFAULT NULL COMMENT '评分日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1649646407919 DEFAULT CHARSET=utf8 COMMENT='论文评分';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lunwenpingfen`
--

LOCK TABLES `lunwenpingfen` WRITE;
/*!40000 ALTER TABLE `lunwenpingfen` DISABLE KEYS */;
INSERT INTO `lunwenpingfen` VALUES (123,'2022-04-11 02:55:51','课题名称3','来源3','工号3','教师姓名3','系部3','论文名称3',3,'评价建议3','学号3','学生姓名3','专业3','2022-04-11'),(124,'2022-04-11 02:55:51','课题名称4','来源4','工号4','教师姓名4','系部4','论文名称4',4,'评价建议4','学号4','学生姓名4','专业4','2022-04-11'),(125,'2022-04-11 02:55:51','课题名称5','来源5','工号5','教师姓名5','系部5','论文名称5',5,'评价建议5','学号5','学生姓名5','专业5','2022-04-11'),(126,'2022-04-11 02:55:51','课题名称6','来源6','工号6','教师姓名6','系部6','论文名称6',6,'评价建议6','学号6','学生姓名6','专业6','2022-04-11'),(1649646407918,'2022-04-11 03:06:47','某某课题','科研项目','22','李四','某某部门','某某论文',59,'评价建议','11','张三','某某专业','2022-04-11');
/*!40000 ALTER TABLE `lunwenpingfen` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `lunwenxinxi`
--

DROP TABLE IF EXISTS `lunwenxinxi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lunwenxinxi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `ketimingcheng` varchar(200) DEFAULT NULL COMMENT '课题名称',
  `laiyuan` varchar(200) DEFAULT NULL COMMENT '来源',
  `gonghao` varchar(200) DEFAULT NULL COMMENT '工号',
  `jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
  `xibu` varchar(200) DEFAULT NULL COMMENT '系部',
  `lunwenmingcheng` varchar(200) NOT NULL COMMENT '论文名称',
  `lunwenjianjie` longtext COMMENT '论文简介',
  `lunwenwendang` varchar(200) DEFAULT NULL COMMENT '论文文档',
  `xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
  `xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',
  `zhuanye` varchar(200) DEFAULT NULL COMMENT '专业',
  `tijiaoriqi` date DEFAULT NULL COMMENT '提交日期',
  `sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
  `shhf` longtext COMMENT '审核回复',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1649646372974 DEFAULT CHARSET=utf8 COMMENT='论文信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lunwenxinxi`
--

LOCK TABLES `lunwenxinxi` WRITE;
/*!40000 ALTER TABLE `lunwenxinxi` DISABLE KEYS */;
INSERT INTO `lunwenxinxi` VALUES (81,'2022-04-11 02:55:51','课题名称1','来源1','工号1','教师姓名1','系部1','论文名称1','论文简介1','','学号1','学生姓名1','专业1','2022-04-11','是',''),(82,'2022-04-11 02:55:51','课题名称2','来源2','工号2','教师姓名2','系部2','论文名称2','论文简介2','','学号2','学生姓名2','专业2','2022-04-11','是',''),(83,'2022-04-11 02:55:51','课题名称3','来源3','工号3','教师姓名3','系部3','论文名称3','论文简介3','','学号3','学生姓名3','专业3','2022-04-11','是',''),(84,'2022-04-11 02:55:51','课题名称4','来源4','工号4','教师姓名4','系部4','论文名称4','论文简介4','','学号4','学生姓名4','专业4','2022-04-11','是',''),(85,'2022-04-11 02:55:51','课题名称5','来源5','工号5','教师姓名5','系部5','论文名称5','论文简介5','','学号5','学生姓名5','专业5','2022-04-11','是',''),(86,'2022-04-11 02:55:51','课题名称6','来源6','工号6','教师姓名6','系部6','论文名称6','论文简介6','','学号6','学生姓名6','专业6','2022-04-11','是',''),(1649646372973,'2022-04-11 03:06:12','某某课题','科研项目','22','李四','某某部门','某某论文','这里输入提交论文的地方','upload/1649646363652.docx','11','张三','某某专业','2022-04-11','是','审核论坛，并评分');
/*!40000 ALTER TABLE `lunwenxinxi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `renwupingfen`
--

DROP TABLE IF EXISTS `renwupingfen`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `renwupingfen` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `ketimingcheng` varchar(200) DEFAULT NULL COMMENT '课题名称',
  `laiyuan` varchar(200) DEFAULT NULL COMMENT '来源',
  `gonghao` varchar(200) DEFAULT NULL COMMENT '工号',
  `jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
  `xibu` varchar(200) DEFAULT NULL COMMENT '系部',
  `renwushumingcheng` varchar(200) DEFAULT NULL COMMENT '任务书名称',
  `pingfen` int(11) NOT NULL COMMENT '评分',
  `pingjiajianyi` longtext COMMENT '评价建议',
  `xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
  `xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',
  `zhuanye` varchar(200) DEFAULT NULL COMMENT '专业',
  `pingfenriqi` date DEFAULT NULL COMMENT '评分日期',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1649646268318 DEFAULT CHARSET=utf8 COMMENT='任务评分';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `renwupingfen`
--

LOCK TABLES `renwupingfen` WRITE;
/*!40000 ALTER TABLE `renwupingfen` DISABLE KEYS */;
INSERT INTO `renwupingfen` VALUES (101,'2022-04-11 02:55:51','课题名称1','来源1','工号1','教师姓名1','系部1','任务书名称1',1,'评价建议1','学号1','学生姓名1','专业1','2022-04-11'),(102,'2022-04-11 02:55:51','课题名称2','来源2','工号2','教师姓名2','系部2','任务书名称2',2,'评价建议2','学号2','学生姓名2','专业2','2022-04-11'),(103,'2022-04-11 02:55:51','课题名称3','来源3','工号3','教师姓名3','系部3','任务书名称3',3,'评价建议3','学号3','学生姓名3','专业3','2022-04-11'),(104,'2022-04-11 02:55:51','课题名称4','来源4','工号4','教师姓名4','系部4','任务书名称4',4,'评价建议4','学号4','学生姓名4','专业4','2022-04-11'),(105,'2022-04-11 02:55:51','课题名称5','来源5','工号5','教师姓名5','系部5','任务书名称5',5,'评价建议5','学号5','学生姓名5','专业5','2022-04-11'),(106,'2022-04-11 02:55:51','课题名称6','来源6','工号6','教师姓名6','系部6','任务书名称6',6,'评价建议6','学号6','学生姓名6','专业6','2022-04-11'),(1649646268317,'2022-04-11 03:04:28','某某课题','科研项目','22','李四','某某部门','某某任务书',62,'这里输入评价跟建议','11','张三','某某专业','2022-04-11');
/*!40000 ALTER TABLE `renwupingfen` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `renwushu`
--

DROP TABLE IF EXISTS `renwushu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `renwushu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `ketimingcheng` varchar(200) DEFAULT NULL COMMENT '课题名称',
  `laiyuan` varchar(200) DEFAULT NULL COMMENT '来源',
  `gonghao` varchar(200) DEFAULT NULL COMMENT '工号',
  `jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
  `xibu` varchar(200) DEFAULT NULL COMMENT '系部',
  `renwushumingcheng` varchar(200) NOT NULL COMMENT '任务书名称',
  `renwushuneirong` longtext COMMENT '任务书内容',
  `xiangguanwendang` varchar(200) DEFAULT NULL COMMENT '相关文档',
  `xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
  `xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',
  `zhuanye` varchar(200) DEFAULT NULL COMMENT '专业',
  `tijiaoshijian` datetime DEFAULT NULL COMMENT '提交时间',
  `sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
  `shhf` longtext COMMENT '审核回复',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1649646234874 DEFAULT CHARSET=utf8 COMMENT='任务书';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `renwushu`
--

LOCK TABLES `renwushu` WRITE;
/*!40000 ALTER TABLE `renwushu` DISABLE KEYS */;
INSERT INTO `renwushu` VALUES (61,'2022-04-11 02:55:51','课题名称1','来源1','工号1','教师姓名1','系部1','任务书名称1','任务书内容1','','学号1','学生姓名1','专业1','2022-04-11 10:55:51','是',''),(62,'2022-04-11 02:55:51','课题名称2','来源2','工号2','教师姓名2','系部2','任务书名称2','任务书内容2','','学号2','学生姓名2','专业2','2022-04-11 10:55:51','是',''),(63,'2022-04-11 02:55:51','课题名称3','来源3','工号3','教师姓名3','系部3','任务书名称3','任务书内容3','','学号3','学生姓名3','专业3','2022-04-11 10:55:51','是',''),(64,'2022-04-11 02:55:51','课题名称4','来源4','工号4','教师姓名4','系部4','任务书名称4','任务书内容4','','学号4','学生姓名4','专业4','2022-04-11 10:55:51','是',''),(65,'2022-04-11 02:55:51','课题名称5','来源5','工号5','教师姓名5','系部5','任务书名称5','任务书内容5','','学号5','学生姓名5','专业5','2022-04-11 10:55:51','是',''),(66,'2022-04-11 02:55:51','课题名称6','来源6','工号6','教师姓名6','系部6','任务书名称6','任务书内容6','','学号6','学生姓名6','专业6','2022-04-11 10:55:51','是',''),(1649646234873,'2022-04-11 03:03:54','某某课题','科研项目','22','李四','某某部门','某某任务书','这里是学生提交任务书的地方','upload/1649646224131.docx','11','张三','某某专业','2022-04-11 11:03:30','是','审核任务书，并评分');
/*!40000 ALTER TABLE `renwushu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `token`
--

DROP TABLE IF EXISTS `token`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `token` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `userid` bigint(20) NOT NULL COMMENT '用户id',
  `username` varchar(100) NOT NULL COMMENT '用户名',
  `tablename` varchar(100) DEFAULT NULL COMMENT '表名',
  `role` varchar(100) DEFAULT NULL COMMENT '角色',
  `token` varchar(200) NOT NULL COMMENT '密码',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
  `expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='token表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `token`
--

LOCK TABLES `token` WRITE;
/*!40000 ALTER TABLE `token` DISABLE KEYS */;
INSERT INTO `token` VALUES (1,1649645966538,'22','jiaoshi','教师','rv38j2hmuucj5go538ij2e1zcu2we8tf','2022-04-11 02:59:31','2022-04-11 04:06:18'),(2,1649645938741,'11','xuesheng','学生','w4y7bf81wf93ofn1yrqnci1udcd4exc3','2022-04-11 03:00:06','2022-04-11 04:06:57'),(3,1,'admin','users','管理员','z2apxlsi83zx0jiqeaa6zim8w1em7b73','2022-04-11 03:07:13','2022-04-11 04:07:13');
/*!40000 ALTER TABLE `token` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `username` varchar(100) NOT NULL COMMENT '用户名',
  `password` varchar(100) NOT NULL COMMENT '密码',
  `role` varchar(100) DEFAULT '管理员' COMMENT '角色',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'admin','admin','管理员','2022-04-11 02:55:51');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xuantixinxi`
--

DROP TABLE IF EXISTS `xuantixinxi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xuantixinxi` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `ketimingcheng` varchar(200) DEFAULT NULL COMMENT '课题名称',
  `nandu` varchar(200) DEFAULT NULL COMMENT '难度',
  `laiyuan` varchar(200) DEFAULT NULL COMMENT '来源',
  `leixing` varchar(200) DEFAULT NULL COMMENT '类型',
  `miaoshu` longtext COMMENT '描述',
  `gonghao` varchar(200) DEFAULT NULL COMMENT '工号',
  `jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',
  `xibu` varchar(200) DEFAULT NULL COMMENT '系部',
  `xuantishijian` datetime DEFAULT NULL COMMENT '选题时间',
  `xuantibeizhu` varchar(200) DEFAULT NULL COMMENT '选题备注',
  `xuehao` varchar(200) DEFAULT NULL COMMENT '学号',
  `xueshengxingming` varchar(200) DEFAULT NULL COMMENT '学生姓名',
  `zhuanye` varchar(200) DEFAULT NULL COMMENT '专业',
  `sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',
  `shhf` longtext COMMENT '审核回复',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1649646033049 DEFAULT CHARSET=utf8 COMMENT='选题信息';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xuantixinxi`
--

LOCK TABLES `xuantixinxi` WRITE;
/*!40000 ALTER TABLE `xuantixinxi` DISABLE KEYS */;
INSERT INTO `xuantixinxi` VALUES (41,'2022-04-11 02:55:51','课题名称1','难度1','来源1','类型1','描述1','工号1','教师姓名1','系部1','2022-04-11 10:55:51','选题备注1','学号1','学生姓名1','专业1','是',''),(42,'2022-04-11 02:55:51','课题名称2','难度2','来源2','类型2','描述2','工号2','教师姓名2','系部2','2022-04-11 10:55:51','选题备注2','学号2','学生姓名2','专业2','是',''),(43,'2022-04-11 02:55:51','课题名称3','难度3','来源3','类型3','描述3','工号3','教师姓名3','系部3','2022-04-11 10:55:51','选题备注3','学号3','学生姓名3','专业3','是',''),(44,'2022-04-11 02:55:51','课题名称4','难度4','来源4','类型4','描述4','工号4','教师姓名4','系部4','2022-04-11 10:55:51','选题备注4','学号4','学生姓名4','专业4','是',''),(45,'2022-04-11 02:55:51','课题名称5','难度5','来源5','类型5','描述5','工号5','教师姓名5','系部5','2022-04-11 10:55:51','选题备注5','学号5','学生姓名5','专业5','是',''),(46,'2022-04-11 02:55:51','课题名称6','难度6','来源6','类型6','描述6','工号6','教师姓名6','系部6','2022-04-11 10:55:51','选题备注6','学号6','学生姓名6','专业6','是',''),(1649646033048,'2022-04-11 03:00:32','某某课题','适中','科研项目','应用设计','这里是教师发布课题信息的地方','22','李四','某某部门','2022-04-11 11:00:20','这里是学生选题申请的地方','11','张三','某某专业','是','这里是教师审核选题信息的地方');
/*!40000 ALTER TABLE `xuantixinxi` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `xuesheng`
--

DROP TABLE IF EXISTS `xuesheng`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xuesheng` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `xuehao` varchar(200) NOT NULL COMMENT '学号',
  `mima` varchar(200) NOT NULL COMMENT '密码',
  `xueshengxingming` varchar(200) NOT NULL COMMENT '学生姓名',
  `xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
  `youxiang` varchar(200) DEFAULT NULL COMMENT '邮箱',
  `shoujihaoma` varchar(200) DEFAULT NULL COMMENT '手机号码',
  `zhuanye` varchar(200) DEFAULT NULL COMMENT '专业',
  `xiangpian` varchar(200) DEFAULT NULL COMMENT '相片',
  PRIMARY KEY (`id`),
  UNIQUE KEY `xuehao` (`xuehao`)
) ENGINE=InnoDB AUTO_INCREMENT=1649645938742 DEFAULT CHARSET=utf8 COMMENT='学生';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xuesheng`
--

LOCK TABLES `xuesheng` WRITE;
/*!40000 ALTER TABLE `xuesheng` DISABLE KEYS */;
INSERT INTO `xuesheng` VALUES (11,'2022-04-11 02:55:51','学号1','123456','学生姓名1','男','773890001@qq.com','13823888881','专业1','upload/xuesheng_xiangpian1.jpg'),(12,'2022-04-11 02:55:51','学号2','123456','学生姓名2','男','773890002@qq.com','13823888882','专业2','upload/xuesheng_xiangpian2.jpg'),(13,'2022-04-11 02:55:51','学号3','123456','学生姓名3','男','773890003@qq.com','13823888883','专业3','upload/xuesheng_xiangpian3.jpg'),(14,'2022-04-11 02:55:51','学号4','123456','学生姓名4','男','773890004@qq.com','13823888884','专业4','upload/xuesheng_xiangpian4.jpg'),(15,'2022-04-11 02:55:51','学号5','123456','学生姓名5','男','773890005@qq.com','13823888885','专业5','upload/xuesheng_xiangpian5.jpg'),(16,'2022-04-11 02:55:51','学号6','123456','学生姓名6','男','773890006@qq.com','13823888886','专业6','upload/xuesheng_xiangpian6.jpg'),(1649645938741,'2022-04-11 02:58:58','11','11','张三','男','131@163.com','13111111111','某某专业','upload/1649646011886.jpg');
/*!40000 ALTER TABLE `xuesheng` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2022-04-18 15:51:46
项目截图

在这里插入图片描述
浪工程序设计合作
关注
0
点赞
踩
2

收藏

觉得还不错? 一键收藏
0
评论
springboot毕业设计管理系统-JAVA【数据库设计、论文、源码、开题报告】

管理员：对用户进行信息编辑，同时可对系统应该具备的功能进行分析。可以对首页，个人中心，公告信息管理，学生管理，教师管理，课题信息管理，选题信息管理，开题报告管理，任务书管理，检查报告管理，论文信息管理，开题评分管理，任务评分管理，检查评分管理，论文评分管理等教师：首页，个人中心，课题信息管理，选题信息管理，开题报告管理，任务书管理，检查报告管理，论文信息管理，开题评分管理，任务评分管理，检查评分管理，论文评分管理等功能进行高校范围内操作。
复制链接

扫一扫