基于springboot的學(xué)生選課系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn)-計(jì)算機(jī)畢業(yè)設(shè)計(jì)源碼+LW文檔
開(kāi)發(fā)語(yǔ)言：Java
框架：springboot
JDK版本：JDK1.8
服務(wù)器：tomcat7
數(shù)據(jù)庫(kù)：mysql 5.7（一定要5.7版本）
數(shù)據(jù)庫(kù)工具：Navicat11
開(kāi)發(fā)軟件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
瀏覽器：谷歌瀏覽器
系統(tǒng)采用了Java技術(shù),springboot + vue 的前后端分離學(xué)生選課系統(tǒng)，前端使用 element-ui 組件庫(kù)，選擇MySQL作為系統(tǒng)的數(shù)據(jù)庫(kù)，開(kāi)發(fā)工具選擇 idea來(lái)進(jìn)行系統(tǒng)的設(shè)計(jì)?；緦?shí)現(xiàn)了學(xué)生選課系統(tǒng)應(yīng)有的主要功能模塊，本系統(tǒng)有以下功能：??
（1）前臺(tái)：首頁(yè)、課程信息、校園論壇、校園公告、個(gè)人中心、后臺(tái)管理。??
?（2）管理員：首頁(yè)、個(gè)人中心、學(xué)生管理、教師管理課、程信息管理、課程分類(lèi)管理、選課信息管理、作業(yè)信息管理、提交作業(yè)管理、學(xué)生成績(jī)管理、校園論壇、系統(tǒng)管理。??
（3）學(xué)生：首頁(yè)、個(gè)人中心、選課信息管理、作業(yè)信息管理、提交作業(yè)管理、學(xué)生成績(jī)管理、我的收藏管理。??
（4）教師：首頁(yè)、個(gè)人中心、課程信息管理、選課信息管理、作業(yè)信息管理、提交作業(yè)管理、學(xué)生成績(jī)管理。
數(shù)據(jù)庫(kù)代碼：
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 '配置參數(shù)名稱(chēng)',
? `value` varchar(100) DEFAULT NULL COMMENT '配置參數(shù)值',
? 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 '創(chuàng)建時(shí)間',
? `refid` bigint(20) NOT NULL COMMENT '關(guān)聯(lián)表id',
? `userid` bigint(20) NOT NULL COMMENT '用戶(hù)id',
? `nickname` varchar(200) DEFAULT NULL COMMENT '用戶(hù)名',
? `content` longtext NOT NULL COMMENT '評(píng)論內(nèi)容',
? `reply` longtext COMMENT '回復(fù)內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1651300892568 DEFAULT CHARSET=utf8 COMMENT='課程信息評(píng)論表';
/*!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,'用戶(hù)名1','評(píng)論內(nèi)容1','回復(fù)內(nèi)容1'),(122,'2022-04-30 06:26:53',2,2,'用戶(hù)名2','評(píng)論內(nèi)容2','回復(fù)內(nèi)容2'),(123,'2022-04-30 06:26:53',3,3,'用戶(hù)名3','評(píng)論內(nèi)容3','回復(fù)內(nèi)容3'),(124,'2022-04-30 06:26:53',4,4,'用戶(hù)名4','評(píng)論內(nèi)容4','回復(fù)內(nèi)容4'),(125,'2022-04-30 06:26:53',5,5,'用戶(hù)名5','評(píng)論內(nèi)容5','回復(fù)內(nèi)容5'),(126,'2022-04-30 06:26:53',6,6,'用戶(hù)名6','評(píng)論內(nèi)容6','回復(fù)內(nèi)容6'),(1651300892567,'2022-04-30 06:41:32',36,1651300851049,'11','這里是評(píng)論教師課程的地方','這里是回復(fù)學(xué)生評(píng)論的地方');
/*!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 '創(chuàng)建時(shí)間',
? `title` varchar(200) DEFAULT NULL COMMENT '帖子標(biāo)題',
? `content` longtext NOT NULL COMMENT '帖子內(nèi)容',
? `parentid` bigint(20) DEFAULT NULL COMMENT '父節(jié)點(diǎn)id',
? `userid` bigint(20) NOT NULL COMMENT '用戶(hù)id',
? `username` varchar(200) DEFAULT NULL COMMENT '用戶(hù)名',
? `isdone` varchar(200) DEFAULT NULL COMMENT '狀態(tài)',
? 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','帖子標(biāo)題1','帖子內(nèi)容1',0,1,'用戶(hù)名1','開(kāi)放'),(92,'2022-04-30 06:26:53','帖子標(biāo)題2','帖子內(nèi)容2',0,2,'用戶(hù)名2','開(kāi)放'),(93,'2022-04-30 06:26:53','帖子標(biāo)題3','帖子內(nèi)容3',0,3,'用戶(hù)名3','開(kāi)放'),(94,'2022-04-30 06:26:53','帖子標(biāo)題4','帖子內(nèi)容4',0,4,'用戶(hù)名4','開(kāi)放'),(95,'2022-04-30 06:26:53','帖子標(biāo)題5','帖子內(nèi)容5',0,5,'用戶(hù)名5','開(kāi)放'),(96,'2022-04-30 06:26:53','帖子標(biāo)題6','帖子內(nèi)容6',0,6,'用戶(hù)名6','開(kāi)放'),(1651300920894,'2022-04-30 06:42:00','這里是發(fā)布交流論壇的地方','<p>這里輸入交流的內(nèi)容</p>',0,1651300851049,'11','開(kāi)放');
/*!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 '創(chuàng)建時(shí)間',
? `gonghao` varchar(200) NOT NULL COMMENT '工號(hào)',
? `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 '聯(lián)系手機(jī)',
? `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','工號(hào)1','123456','教師姓名1','男','773890001@qq.com','13823888881','upload/jiaoshi_xiangpian1.jpg'),(22,'2022-04-30 06:26:53','工號(hào)2','123456','教師姓名2','男','773890002@qq.com','13823888882','upload/jiaoshi_xiangpian2.jpg'),(23,'2022-04-30 06:26:53','工號(hào)3','123456','教師姓名3','男','773890003@qq.com','13823888883','upload/jiaoshi_xiangpian3.jpg'),(24,'2022-04-30 06:26:53','工號(hào)4','123456','教師姓名4','男','773890004@qq.com','13823888884','upload/jiaoshi_xiangpian4.jpg'),(25,'2022-04-30 06:26:53','工號(hào)5','123456','教師姓名5','男','773890005@qq.com','13823888885','upload/jiaoshi_xiangpian5.jpg'),(26,'2022-04-30 06:26:53','工號(hào)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 '創(chuàng)建時(shí)間',
? `kechengfenlei` varchar(200) NOT NULL COMMENT '課程分類(lèi)',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1651300988406 DEFAULT CHARSET=utf8 COMMENT='課程分類(lèi)';
/*!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','課程分類(lèi)1'),(42,'2022-04-30 06:26:53','課程分類(lèi)2'),(43,'2022-04-30 06:26:53','課程分類(lèi)3'),(44,'2022-04-30 06:26:53','課程分類(lèi)4'),(45,'2022-04-30 06:26:53','課程分類(lèi)5'),(46,'2022-04-30 06:26:53','課程分類(lèi)6'),(1651300988405,'2022-04-30 06:43:07','外語(yǔ)類(lèi)');
/*!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 '創(chuàng)建時(shí)間',
? `kechengmingcheng` varchar(200) NOT NULL COMMENT '課程名稱(chēng)',
? `kechengfengmian` varchar(200) DEFAULT NULL COMMENT '課程封面',
? `kechengfenlei` varchar(200) NOT NULL COMMENT '課程分類(lèi)',
? `shangkeshijian` datetime DEFAULT NULL COMMENT '上課時(shí)間',
? `shangkedidian` varchar(200) DEFAULT NULL COMMENT '上課地點(diǎn)',
? `kechengjianjie` longtext COMMENT '課程簡(jiǎn)介',
? `kechengneirong` longtext COMMENT '課程內(nèi)容',
? `gonghao` varchar(200) DEFAULT NULL COMMENT '工號(hào)',
? `jiaoshixingming` varchar(200) DEFAULT NULL COMMENT '教師姓名',
? `faburiqi` date DEFAULT NULL COMMENT '發(fā)布日期',
? `sfsh` varchar(200) DEFAULT '否' COMMENT '是否審核',
? `shhf` longtext COMMENT '審核回復(fù)',
? 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','課程名稱(chēng)1','upload/kechengxinxi_kechengfengmian1.jpg','課程分類(lèi)1','2022-04-30 14:26:53','上課地點(diǎn)1','課程簡(jiǎn)介1','課程內(nèi)容1','工號(hào)1','教師姓名1','2022-04-30','是',''),(32,'2022-04-30 06:26:53','課程名稱(chēng)2','upload/kechengxinxi_kechengfengmian2.jpg','課程分類(lèi)2','2022-04-30 14:26:53','上課地點(diǎn)2','課程簡(jiǎn)介2','課程內(nèi)容2','工號(hào)2','教師姓名2','2022-04-30','是',''),(33,'2022-04-30 06:26:53','課程名稱(chēng)3','upload/kechengxinxi_kechengfengmian3.jpg','課程分類(lèi)3','2022-04-30 14:26:53','上課地點(diǎn)3','課程簡(jiǎn)介3','課程內(nèi)容3','工號(hào)3','教師姓名3','2022-04-30','是',''),(34,'2022-04-30 06:26:53','課程名稱(chēng)4','upload/kechengxinxi_kechengfengmian4.jpg','課程分類(lèi)4','2022-04-30 14:26:53','上課地點(diǎn)4','課程簡(jiǎn)介4','課程內(nèi)容4','工號(hào)4','教師姓名4','2022-04-30','是',''),(35,'2022-04-30 06:26:53','課程名稱(chēng)5','upload/kechengxinxi_kechengfengmian5.jpg','課程分類(lèi)5','2022-04-30 14:26:53','上課地點(diǎn)5','課程簡(jiǎn)介5','課程內(nèi)容5','工號(hào)5','教師姓名5','2022-04-30','是',''),(36,'2022-04-30 06:26:53','課程名稱(chēng)6','upload/kechengxinxi_kechengfengmian6.jpg','課程分類(lèi)6','2022-04-30 14:26:53','上課地點(diǎn)6','課程簡(jiǎn)介6','課程內(nèi)容6','工號(hào)6','教師姓名6','2022-04-30','是',''),(1651301134816,'2022-04-30 06:45:33','某某課程','upload/1651301101013.png','外語(yǔ)類(lèi)','2022-05-02 02:02:02','某某地點(diǎn)','這里輸入課程的簡(jiǎn)介','<p>這里輸入課程的內(nèi)容</p><p>還可以適當(dāng)?shù)牟迦雸D片</p><p><img src=\"http://localhost:8080/springbootwxjjv/upload/1651301132838.jpg\"></p>','22','李四','2022-04-30','是','這里是審核教師發(fā)布的課程信息的地方');
/*!40000 ALTER TABLE `kechengxinxi` ENABLE KEYS */;
UNLOCK TABLES;
