开发语言: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','第一站','水电费时代','
地方水电费水电费时代发多少发送到水电费电商地方水电费水电费时代发多少发送到水电费电商地方水电费水电费时代发多少发送到水电费电商地方水电费水电费时代发多少发送到水电费电商地方水电费水电费时代发多少发送到水电费电商地方水电费水电费时代发多少发送到水电费电商地方水电费水电费时代发多少发送到水电费电商地方水电费水电费时代发多少发送到水电费电商地方水电费水电费时代发多少发送到水电费电商
','水电费','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 */;