开发语言：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′,’这里是发布交流论坛的地方’,'<p>这里输入交流的内容</p>’,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′,’男’,’[email protected]’,’13823888881′,’upload/jiaoshi_xiangpian1.jpg’),(22,’2022-04-30 06:26:53′,’工号2′,’123456′,’教师姓名2′,’男’,’[email protected]’,’13823888882′,’upload/jiaoshi_xiangpian2.jpg’),(23,’2022-04-30 06:26:53′,’工号3′,’123456′,’教师姓名3′,’男’,’[email protected]’,’13823888883′,’upload/jiaoshi_xiangpian3.jpg’),(24,’2022-04-30 06:26:53′,’工号4′,’123456′,’教师姓名4′,’男’,’[email protected]’,’13823888884′,’upload/jiaoshi_xiangpian4.jpg’),(25,’2022-04-30 06:26:53′,’工号5′,’123456′,’教师姓名5′,’男’,’[email protected]’,’13823888885′,’upload/jiaoshi_xiangpian5.jpg’),(26,’2022-04-30 06:26:53′,’工号6′,’123456′,’教师姓名6′,’男’,’[email protected]’,’13823888886′,’upload/jiaoshi_xiangpian6.jpg’),(1651300963359,’2022-04-30 06:42:43′,’22’,’22’,’李四’,’女’,’[email protected]’,’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′,’某某地点’,’这里输入课程的简介’,'<p>这里输入课程的内容</p><p>还可以适当的插入图片</p><p><img src=\”http://localhost:8080/springbootwxjjv/upload/1651301132838.jpg\”></p>’,’22’,’李四’,’2022-04-30′,’是’,’这里是审核教师发布的课程信息的地方’);
/*!40000 ALTER TABLE `kechengxinxi` ENABLE KEYS */;
UNLOCK TABLES;