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

发布时间：2026-07-21阅读(1)

导读开发语言：Java框架：springbootJDK版本：JDK1.8服务器：tomcat7数据库：MySQL5.7（一定要5.7版本）数据库工具：Navic....

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