springboot管理系统毕业设计（基于springboot的学生选课系统设计与实现-计算机毕业设计源码）

抹上胭脂 2023-03-18 17:46:09

收藏赞分享

开发语言：Java

框架：springboot

JDK版本：JDK1.8

服务器：tomcat7

数据库：MySQL 5.7（一定要5.7版本）

数据库工具：Navicat11

开发软件：eclipse/myeclipse/idea

Maven包：Maven3.3.9

浏览器：谷歌浏览器

系统采用了Java技术,springboot vue 的前后端分离学生选课系统，前端使用 element-ui 组件库，选择MySQL作为系统的数据库，开发工具选择 idea来进行系统的设计。基本实现了学生选课系统应有的主要功能模块，本系统有以下功能：

（1）前台：首页、课程信息、校园论坛、校园公告、个人中心、后台管理。

（2）管理员：首页、个人中心、学生管理、教师管理课、程信息管理、课程分类管理、选课信息管理、作业信息管理、提交作业管理、学生成绩管理、校园论坛、系统管理。

（3）学生：首页、个人中心、选课信息管理、作业信息管理、提交作业管理、学生成绩管理、我的收藏管理。

（4）教师：首页、个人中心、课程信息管理、选课信息管理、作业信息管理、提交作业管理、学生成绩管理。

数据库代码：

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/1651301006721.png'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');

/*!40000 ALTER TABLE `config` ENABLE KEYS */;

UNLOCK TABLES;

-- Table structure for table `discusskechengxinxi`

DROP TABLE IF EXISTS `discusskechengxinxi`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `discusskechengxinxi` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`refid` bigint(20) NOT NULL COMMENT '关联表id',

`userid` bigint(20) NOT NULL COMMENT '用户id',

`nickname` varchar(200) DEFAULT NULL COMMENT '用户名',

`content` longtext NOT NULL COMMENT '评论内容',

`reply` longtext COMMENT '回复内容',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=1651300892568 DEFAULT CHARSET=utf8 COMMENT='课程信息评论表';

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `discusskechengxinxi`

LOCK TABLES `discusskechengxinxi` WRITE;

/*!40000 ALTER TABLE `discusskechengxinxi` DISABLE KEYS */;

INSERT INTO `discusskechengxinxi` VALUES (121,'2022-04-30 06:26:53',1,1,'用户名1','评论内容1','回复内容1'),(122,'2022-04-30 06:26:53',2,2,'用户名2','评论内容2','回复内容2'),(123,'2022-04-30 06:26:53',3,3,'用户名3','评论内容3','回复内容3'),(124,'2022-04-30 06:26:53',4,4,'用户名4','评论内容4','回复内容4'),(125,'2022-04-30 06:26:53',5,5,'用户名5','评论内容5','回复内容5'),(126,'2022-04-30 06:26:53',6,6,'用户名6','评论内容6','回复内容6'),(1651300892567,'2022-04-30 06:41:32',36,1651300851049,'11','这里是评论教师课程的地方','这里是回复学生评论的地方');

/*!40000 ALTER TABLE `discusskechengxinxi` ENABLE KEYS */;

UNLOCK TABLES;

-- Table structure for table `forum`

DROP TABLE IF EXISTS `forum`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `forum` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`title` varchar(200) DEFAULT NULL COMMENT '帖子标题',

`content` longtext NOT NULL COMMENT '帖子内容',

`parentid` bigint(20) DEFAULT NULL COMMENT '父节点id',

`userid` bigint(20) NOT NULL COMMENT '用户id',

`username` varchar(200) DEFAULT NULL COMMENT '用户名',

`isdone` varchar(200) DEFAULT NULL COMMENT '状态',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=1651300920895 DEFAULT CHARSET=utf8 COMMENT='校园论坛';

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `forum`

LOCK TABLES `forum` WRITE;

/*!40000 ALTER TABLE `forum` DISABLE KEYS */;

INSERT INTO `forum` VALUES (91,'2022-04-30 06:26:53','帖子标题1','帖子内容1',0,1,'用户名1','开放'),(92,'2022-04-30 06:26:53','帖子标题2','帖子内容2',0,2,'用户名2','开放'),(93,'2022-04-30 06:26:53','帖子标题3','帖子内容3',0,3,'用户名3','开放'),(94,'2022-04-30 06:26:53','帖子标题4','帖子内容4',0,4,'用户名4','开放'),(95,'2022-04-30 06:26:53','帖子标题5','帖子内容5',0,5,'用户名5','开放'),(96,'2022-04-30 06:26:53','帖子标题6','帖子内容6',0,6,'用户名6','开放'),(1651300920894,'2022-04-30 06:42:00','这里是发布交流论坛的地方','这里输入交流的内容',0,1651300851049,'11','开放');

/*!40000 ALTER TABLE `forum` 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 '联系手机',

`xiangpian` varchar(200) DEFAULT NULL COMMENT '相片',

PRIMARY KEY (`id`),

UNIQUE KEY `gonghao` (`gonghao`)

) ENGINE=InnoDB AUTO_INCREMENT=1651300963360 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-30 06:26:53','工号1','123456','教师姓名1','男','773890001@qq.com','13823888881','upload/jiaoshi_xiangpian1.jpg'),(22,'2022-04-30 06:26:53','工号2','123456','教师姓名2','男','773890002@qq.com','13823888882','upload/jiaoshi_xiangpian2.jpg'),(23,'2022-04-30 06:26:53','工号3','123456','教师姓名3','男','773890003@qq.com','13823888883','upload/jiaoshi_xiangpian3.jpg'),(24,'2022-04-30 06:26:53','工号4','123456','教师姓名4','男','773890004@qq.com','13823888884','upload/jiaoshi_xiangpian4.jpg'),(25,'2022-04-30 06:26:53','工号5','123456','教师姓名5','男','773890005@qq.com','13823888885','upload/jiaoshi_xiangpian5.jpg'),(26,'2022-04-30 06:26:53','工号6','123456','教师姓名6','男','773890006@qq.com','13823888886','upload/jiaoshi_xiangpian6.jpg'),(1651300963359,'2022-04-30 06:42:43','22','22','李四','女','133@163.com','13333333333','upload/1651301080078.jpeg');

/*!40000 ALTER TABLE `jiaoshi` ENABLE KEYS */;

UNLOCK TABLES;

-- Table structure for table `kechengfenlei`

DROP TABLE IF EXISTS `kechengfenlei`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `kechengfenlei` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`kechengfenlei` varchar(200) NOT NULL COMMENT '课程分类',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=1651300988406 DEFAULT CHARSET=utf8 COMMENT='课程分类';

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `kechengfenlei`

LOCK TABLES `kechengfenlei` WRITE;

/*!40000 ALTER TABLE `kechengfenlei` DISABLE KEYS */;

INSERT INTO `kechengfenlei` VALUES (41,'2022-04-30 06:26:53','课程分类1'),(42,'2022-04-30 06:26:53','课程分类2'),(43,'2022-04-30 06:26:53','课程分类3'),(44,'2022-04-30 06:26:53','课程分类4'),(45,'2022-04-30 06:26:53','课程分类5'),(46,'2022-04-30 06:26:53','课程分类6'),(1651300988405,'2022-04-30 06:43:07','外语类');

/*!40000 ALTER TABLE `kechengfenlei` ENABLE KEYS */;

UNLOCK TABLES;

-- Table structure for table `kechengxinxi`

DROP TABLE IF EXISTS `kechengxinxi`;

/*!40101 SET @saved_cs_client = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `kechengxinxi` (

`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',

`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',

`kechengmingcheng` varchar(200) NOT NULL COMMENT '课程名称',

`kechengfengmian` varchar(200) DEFAULT NULL COMMENT '课程封面',

`kechengfenlei` varchar(200) NOT NULL COMMENT '课程分类',

`shangkeshijian` datetime DEFAULT NULL COMMENT '上课时间',

`shangkedidian` varchar(200) DEFAULT NULL COMMENT '上课地点',

`kechengjianjie` longtext COMMENT '课程简介',

`kechengneirong` longtext COMMENT '课程内容',

`gonghao` varchar(200) DEFAULT NULL COMMENT '工号',

`jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教师姓名',

`faburiqi` date DEFAULT NULL COMMENT '发布日期',

`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',

`shhf` longtext COMMENT '审核回复',

PRIMARY KEY (`id`)

) ENGINE=InnoDB AUTO_INCREMENT=1651301134817 DEFAULT CHARSET=utf8 COMMENT='课程信息';

/*!40101 SET character_set_client = @saved_cs_client */;

-- Dumping data for table `kechengxinxi`

LOCK TABLES `kechengxinxi` WRITE;

/*!40000 ALTER TABLE `kechengxinxi` DISABLE KEYS */;

INSERT INTO `kechengxinxi` VALUES (31,'2022-04-30 06:26:53','课程名称1','upload/kechengxinxi_kechengfengmian1.jpg','课程分类1','2022-04-30 14:26:53','上课地点1','课程简介1','课程内容1','工号1','教师姓名1','2022-04-30','是',''),(32,'2022-04-30 06:26:53','课程名称2','upload/kechengxinxi_kechengfengmian2.jpg','课程分类2','2022-04-30 14:26:53','上课地点2','课程简介2','课程内容2','工号2','教师姓名2','2022-04-30','是',''),(33,'2022-04-30 06:26:53','课程名称3','upload/kechengxinxi_kechengfengmian3.jpg','课程分类3','2022-04-30 14:26:53','上课地点3','课程简介3','课程内容3','工号3','教师姓名3','2022-04-30','是',''),(34,'2022-04-30 06:26:53','课程名称4','upload/kechengxinxi_kechengfengmian4.jpg','课程分类4','2022-04-30 14:26:53','上课地点4','课程简介4','课程内容4','工号4','教师姓名4','2022-04-30','是',''),(35,'2022-04-30 06:26:53','课程名称5','upload/kechengxinxi_kechengfengmian5.jpg','课程分类5','2022-04-30 14:26:53','上课地点5','课程简介5','课程内容5','工号5','教师姓名5','2022-04-30','是',''),(36,'2022-04-30 06:26:53','课程名称6','upload/kechengxinxi_kechengfengmian6.jpg','课程分类6','2022-04-30 14:26:53','上课地点6','课程简介6','课程内容6','工号6','教师姓名6','2022-04-30','是',''),(1651301134816,'2022-04-30 06:45:33','某某课程','upload/1651301101013.png','外语类','2022-05-02 02:02:02','某某地点','这里输入课程的简介','这里输入课程的内容还可以适当的插入图片<img src=\"http://localhost:8080/springbootwxjjv/upload/1651301132838.jpg\">','22','李四','2022-04-30','是','这里是审核教师发布的课程信息的地方');

/*!40000 ALTER TABLE `kechengxinxi` ENABLE KEYS */;

UNLOCK TABLES;

springboot管理系统毕业设计（基于springboot的学生选课系统设计与实现-计算机毕业设计源码）(1)