基于springboot的学生选课系统设计与实现-计算机毕业设计源码+LW文档

开发语言：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','某某地点','这里输入课程的简介','

这里输入课程的内容

还可以适当的插入图片

','22','李四','2022-04-30','是','这里是审核教师发布的课程信息的地方');
/*!40000 ALTER TABLE `kechengxinxi` ENABLE KEYS */;
UNLOCK TABLES;