开发语言: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/1645665610445.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `gongzuorenyuan`
--
DROP TABLE IF EXISTS `gongzuorenyuan`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `gongzuorenyuan` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`renyuanzhanghao` varchar(200) NOT NULL COMMENT '人员账号',
`mima` varchar(200) NOT NULL COMMENT '密码',
`renyuanxingming` varchar(200) NOT NULL COMMENT '人员姓名',
`nianling` int(11) DEFAULT NULL COMMENT '年龄',
`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',
`shouji` varchar(200) DEFAULT NULL COMMENT '手机',
`zhaopian` varchar(200) DEFAULT NULL COMMENT '照片',
PRIMARY KEY (`id`),
UNIQUE KEY `renyuanzhanghao` (`renyuanzhanghao`)
) ENGINE=InnoDB AUTO_INCREMENT=1645665519268 DEFAULT CHARSET=utf8 COMMENT='工作人员';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `gongzuorenyuan`
--
LOCK TABLES `gongzuorenyuan` WRITE;
/*!40000 ALTER TABLE `gongzuorenyuan` DISABLE KEYS */;
INSERT INTO `gongzuorenyuan` VALUES (21,'2022-02-24 01:13:28','人员账号1','123456','人员姓名1',1,'男','13823888881','upload/gongzuorenyuan_zhaopian1.jpg'),(22,'2022-02-24 01:13:28','人员账号2','123456','人员姓名2',2,'男','13823888882','upload/gongzuorenyuan_zhaopian2.jpg'),(23,'2022-02-24 01:13:28','人员账号3','123456','人员姓名3',3,'男','13823888883','upload/gongzuorenyuan_zhaopian3.jpg'),(24,'2022-02-24 01:13:28','人员账号4','123456','人员姓名4',4,'男','13823888884','upload/gongzuorenyuan_zhaopian4.jpg'),(25,'2022-02-24 01:13:28','人员账号5','123456','人员姓名5',5,'男','13823888885','upload/gongzuorenyuan_zhaopian5.jpg'),(26,'2022-02-24 01:13:28','人员账号6','123456','人员姓名6',6,'男','13823888886','upload/gongzuorenyuan_zhaopian6.jpg'),(1645665519267,'2022-02-24 01:18:39','22','22','时代',22,'女','11122233333','upload/1645665529227.jpg');
/*!40000 ALTER TABLE `gongzuorenyuan` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jiezhongdengji`
--
DROP TABLE IF EXISTS `jiezhongdengji`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiezhongdengji` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`jiezhongdanhao` varchar(200) DEFAULT NULL COMMENT '接种单号',
`yimiaomingcheng` varchar(200) DEFAULT NULL COMMENT '疫苗名称',
`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`shouji` varchar(200) DEFAULT NULL COMMENT '手机',
`jiezhongshijian` datetime DEFAULT NULL COMMENT '接种时间',
`xiacijiezhong` datetime DEFAULT NULL COMMENT '下次接种',
`beizhu` varchar(200) DEFAULT NULL COMMENT '备注',
`renyuanzhanghao` varchar(200) DEFAULT NULL COMMENT '人员账号',
`renyuanxingming` varchar(200) DEFAULT NULL COMMENT '人员姓名',
PRIMARY KEY (`id`),
UNIQUE KEY `jiezhongdanhao` (`jiezhongdanhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1645665719606 DEFAULT CHARSET=utf8 COMMENT='接种登记';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jiezhongdengji`
--
LOCK TABLES `jiezhongdengji` WRITE;
/*!40000 ALTER TABLE `jiezhongdengji` DISABLE KEYS */;
INSERT INTO `jiezhongdengji` VALUES (61,'2022-02-24 01:13:28','1111111111','疫苗名称1','账号1','姓名1','手机1','2022-02-24 09:13:28','2022-02-24 09:13:28','备注1','人员账号1','人员姓名1'),(62,'2022-02-24 01:13:28','2222222222','疫苗名称2','账号2','姓名2','手机2','2022-02-24 09:13:28','2022-02-24 09:13:28','备注2','人员账号2','人员姓名2'),(63,'2022-02-24 01:13:28','3333333333','疫苗名称3','账号3','姓名3','手机3','2022-02-24 09:13:28','2022-02-24 09:13:28','备注3','人员账号3','人员姓名3'),(64,'2022-02-24 01:13:28','4444444444','疫苗名称4','账号4','姓名4','手机4','2022-02-24 09:13:28','2022-02-24 09:13:28','备注4','人员账号4','人员姓名4'),(65,'2022-02-24 01:13:28','5555555555','疫苗名称5','账号5','姓名5','手机5','2022-02-24 09:13:28','2022-02-24 09:13:28','备注5','人员账号5','人员姓名5'),(66,'2022-02-24 01:13:28','6666666666','疫苗名称6','账号6','姓名6','手机6','2022-02-24 09:13:28','2022-02-24 09:13:28','备注6','人员账号6','人员姓名6'),(1645665719605,'2022-02-24 01:21:59','1645665712232','水电费时代','11','水电费','11122211111','2022-02-24 09:21:52','2022-02-28 10:21:52','水电费水电费时代发送到','22','时代');
/*!40000 ALTER TABLE `jiezhongdengji` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `jiezhongdian`
--
DROP TABLE IF EXISTS `jiezhongdian`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jiezhongdian` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`zhandianbianhao` varchar(200) DEFAULT NULL COMMENT '站点编号',
`zhandianmingcheng` varchar(200) NOT NULL COMMENT '站点名称',
`zhandiandizhi` varchar(200) DEFAULT NULL COMMENT '站点地址',
`zhandianxiangqing` longtext COMMENT '站点详情',
`fuzeren` varchar(200) DEFAULT NULL COMMENT '负责人',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`zhandianfengmian` varchar(200) DEFAULT NULL COMMENT '站点封面',
`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
`clicknum` int(11) DEFAULT '0' COMMENT '点击次数',
PRIMARY KEY (`id`),
UNIQUE KEY `zhandianbianhao` (`zhandianbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1645665561013 DEFAULT CHARSET=utf8 COMMENT='接种点';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `jiezhongdian`
--
LOCK TABLES `jiezhongdian` WRITE;
/*!40000 ALTER TABLE `jiezhongdian` DISABLE KEYS */;
INSERT INTO `jiezhongdian` VALUES (31,'2022-02-24 01:13:28','1111111111','站点名称1','站点地址1','站点详情1','负责人1','13823888881','upload/jiezhongdian_zhandianfengmian1.jpg','2022-02-24 09:17:40',2),(32,'2022-02-24 01:13:28','2222222222','站点名称2','站点地址2','站点详情2','负责人2','13823888882','upload/jiezhongdian_zhandianfengmian2.jpg','2022-02-24 09:20:47',5),(33,'2022-02-24 01:13:28','3333333333','站点名称3','站点地址3','站点详情3','负责人3','13823888883','upload/jiezhongdian_zhandianfengmian3.jpg','2022-02-24 09:13:28',3),(34,'2022-02-24 01:13:28','4444444444','站点名称4','站点地址4','站点详情4','负责人4','13823888884','upload/jiezhongdian_zhandianfengmian4.jpg','2022-02-24 09:13:28',4),(35,'2022-02-24 01:13:28','5555555555','站点名称5','站点地址5','站点详情5','负责人5','13823888885','upload/jiezhongdian_zhandianfengmian5.jpg','2022-02-24 09:13:28',5),(36,'2022-02-24 01:13:28','6666666666','站点名称6','站点地址6','站点详情6','负责人6','13823888886','upload/jiezhongdian_zhandianfengmian6.jpg','2022-02-24 09:13:28',6),(1645665561012,'2022-02-24 01:19:20','1645665547899','第一站','水电费时代','<p>地方水电费水电费时代发多少发送到水电费电商地方水电费水电费时代发多少发送到水电费电商地方水电费水电费时代发多少发送到水电费电商地方水电费水电费时代发多少发送到水电费电商地方水电费水电费时代发多少发送到水电费电商地方水电费水电费时代发多少发送到水电费电商地方水电费水电费时代发多少发送到水电费电商地方水电费水电费时代发多少发送到水电费电商地方水电费水电费时代发多少发送到水电费电商</p><p><br></p>','水电费','11122233333','upload/1645665554513.jpg','2022-02-24 09:20:54',1);
/*!40000 ALTER TABLE `jiezhongdian` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `liuguandengji`
--
DROP TABLE IF EXISTS `liuguandengji`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `liuguandengji` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`dengjibianhao` varchar(200) DEFAULT NULL COMMENT '登记编号',
`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',
`shouji` varchar(200) DEFAULT NULL COMMENT '手机',
`dengjishijian` datetime DEFAULT NULL COMMENT '登记时间',
`likaishijian` datetime DEFAULT NULL COMMENT '离开时间',
`shentizhuangtai` varchar(200) DEFAULT NULL COMMENT '身体状态',
`beizhu` varchar(200) DEFAULT NULL COMMENT '备注',
`renyuanzhanghao` varchar(200) DEFAULT NULL COMMENT '人员账号',
`renyuanxingming` varchar(200) DEFAULT NULL COMMENT '人员姓名',
PRIMARY KEY (`id`),
UNIQUE KEY `dengjibianhao` (`dengjibianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1645665731949 DEFAULT CHARSET=utf8 COMMENT='留观登记';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `liuguandengji`
--
LOCK TABLES `liuguandengji` WRITE;
/*!40000 ALTER TABLE `liuguandengji` DISABLE KEYS */;
INSERT INTO `liuguandengji` VALUES (71,'2022-02-24 01:13:28','1111111111','账号1','姓名1','手机1','2022-02-24 09:13:28','2022-02-24 09:13:28','健康','备注1','人员账号1','人员姓名1'),(72,'2022-02-24 01:13:28','2222222222','账号2','姓名2','手机2','2022-02-24 09:13:28','2022-02-24 09:13:28','健康','备注2','人员账号2','人员姓名2'),(73,'2022-02-24 01:13:28','3333333333','账号3','姓名3','手机3','2022-02-24 09:13:28','2022-02-24 09:13:28','健康','备注3','人员账号3','人员姓名3'),(74,'2022-02-24 01:13:28','4444444444','账号4','姓名4','手机4','2022-02-24 09:13:28','2022-02-24 09:13:28','健康','备注4','人员账号4','人员姓名4'),(75,'2022-02-24 01:13:28','5555555555','账号5','姓名5','手机5','2022-02-24 09:13:28','2022-02-24 09:13:28','健康','备注5','人员账号5','人员姓名5'),(76,'2022-02-24 01:13:28','6666666666','账号6','姓名6','手机6','2022-02-24 09:13:28','2022-02-24 09:13:28','健康','备注6','人员账号6','人员姓名6'),(1645665731948,'2022-02-24 01:22:11','1645665725813','11','水电费','11122211111','2022-02-24 09:22:05','2022-02-24 11:22:05','健康','水电费水电费时代第三方','22','时代');
/*!40000 ALTER TABLE `liuguandengji` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `news`
--
DROP TABLE IF EXISTS `news`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `news` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`title` varchar(200) NOT NULL COMMENT '标题',
`introduction` longtext COMMENT '简介',
`picture` varchar(200) NOT NULL COMMENT '图片',
`content` longtext NOT NULL COMMENT '内容',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1645665631897 DEFAULT CHARSET=utf8 COMMENT='疫苗资讯';
/*!40101 SET character_set_client = @saved_cs_client */;