spring+vue微信小程序选课系统（毕业设计）

/* SQLyog Ultimate v12.2.6 (64 bit) MySQL - 5.5.53 : Database - ssm13n54 ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`ssm13n54` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */; USE `ssm13n54`; /*Table structure for table `banji` */ DROP TABLE IF EXISTS `banji`; CREATE TABLE `banji` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `banji` varchar(200) NOT NULL COMMENT '班级', PRIMARY KEY (`id`), UNIQUE KEY `banji` (`banji`) ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='班级'; /*Data for the table `banji` */ insert into `banji`(`id`,`addtime`,`banji`) values (41,'2021-05-06 17:16:22','一班'), (42,'2021-05-06 17:16:22','班级2'), (43,'2021-05-06 17:16:22','班级3'), (44,'2021-05-06 17:16:22','班级4'), (45,'2021-05-06 17:16:22','班级5'), (46,'2021-05-06 17:16:22','班级6'); /*Table structure for table `config` */ DROP TABLE IF EXISTS `config`; 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=7 DEFAULT CHARSET=utf8 COMMENT='配置文件'; /*Data for the table `config` */ insert into `config`(`id`,`name`,`value`) values (1,'picture1','http://localhost:8080/ssm13n54/upload/1620294559508.png'), (2,'picture2','http://localhost:8080/ssm13n54/upload/1620294566209.png'), (3,'picture3','http://localhost:8080/ssm13n54/upload/1620294572578.png'), (6,'homepage',NULL); /*Table structure for table `discusskechengxinxi` */ DROP TABLE IF EXISTS `discusskechengxinxi`; 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=1620294952232 DEFAULT CHARSET=utf8 COMMENT='课程信息评论表'; /*Data for the table `discusskechengxinxi` */ insert into `discusskechengxinxi`(`id`,`addtime`,`refid`,`userid`,`nickname`,`content`,`reply`) values (91,'2021-05-06 17:16:22',1,1,'用户名1','评论内容1','回复内容1'), (92,'2021-05-06 17:16:22',2,2,'用户名2','评论内容2','回复内容2'), (93,'2021-05-06 17:16:22',3,3,'用户名3','评论内容3','回复内容3'), (94,'2021-05-06 17:16:22',4,4,'用户名4','评论内容4','回复内容4'), (95,'2021-05-06 17:16:22',5,5,'用户名5','评论内容5','回复内容5'), (96,'2021-05-06 17:16:22',6,6,'用户名6','评论内容6','回复内容6'), (1620294781442,'2021-05-06 17:53:00',51,21,'学生1','1111111111','这里回复对课程的评论'), (1620294952231,'2021-05-06 17:55:51',56,1620294895129,'001','这里可评论 教师在后台回复',''); /*Table structure for table `discussshishixinwen` */ DROP TABLE IF EXISTS `discussshishixinwen`; CREATE TABLE `discussshishixinwen` ( `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=1620294787926 DEFAULT CHARSET=utf8 COMMENT='时事新闻评论表'; /*Data for the table `discussshishixinwen` */ insert into `discussshishixinwen`(`id`,`addtime`,`refid`,`userid`,`nickname`,`content`,`reply`) values (101,'2021-05-06 17:16:22',1,1,'用户名1','评论内容1','回复内容1'), (102,'2021-05-06 17:16:22',2,2,'用户名2','评论内容2','回复内容2'), (103,'2021-05-06 17:16:22',3,3,'用户名3','评论内容3','回复内容3'), (104,'2021-05-06 17:16:22',4,4,'用户名4','评论内容4','回复内容4'), (105,'2021-05-06 17:16:22',5,5,'用户名5','评论内容5','回复内容5'), (106,'2021-05-06 17:16:22',6,6,'用户名6','评论内容6','回复内容6'), (1620294787925,'2021-05-06 17:53:07',61,21,'学生1','1111111','这里回复对新闻的评论'); /*Table structure for table `jiaoshi` */ DROP TABLE IF EXISTS `jiaoshi`; CREATE TABLE `jiaoshi` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `jiaoshigonghao` varchar(200) NOT NULL COMMENT '教师工号', `mima` varchar(200) NOT NULL COMMENT '密码', `jiaoshixingming` varchar(200) NOT NULL COMMENT '教师姓名', `xingbie` varchar(200) DEFAULT NULL COMMENT '性别', `zhaopian` varchar(200) DEFAULT NULL COMMENT '照片', `zhicheng` varchar(200) DEFAULT NULL COMMENT '职称', `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话', `jiaoshiyouxiang` varchar(200) DEFAULT NULL COMMENT '教师邮箱', PRIMARY KEY (`id`), UNIQUE KEY `jiaoshigonghao` (`jiaoshigonghao`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='教师'; /*Data for the table `jiaoshi` */ insert into `jiaoshi`(`id`,`addtime`,`jiaoshigonghao`,`mima`,`jiaoshixingming`,`xingbie`,`zhaopian`,`zhicheng`,`lianxidianhua`,`jiaoshiyouxiang`) values (11,'2021-05-06 17:16:22','教师1','123456','教师姓名1','女','http://localhost:8080/ssm13n54/upload/jiaoshi_zhaopian1.jpg','职称1','13823888881','773890001@qq.com'), (12,'2021-05-06 17:16:22','教师2','123456','教师姓名2','男','http://localhost:8080/ssm13n54/upload/jiaoshi_zhaopian2.jpg','职称2','13823888882','773890002@qq.com'), (13,'2021-05-06 17:16:22','教师3','123456','教师姓名3','男','http://localhost:8080/ssm13n54/upload/jiaoshi_zhaopian3.jpg','职称3','13823888883','773890003@qq.com'), (14,'2021-05-06 17:16:22','教师4','123456','教师姓名4','男','http://localhost:8080/ssm13n54/upload/jiaoshi_zhaopian4.jpg','职称4','13823888884','773890004@qq.com'), (15,'2021-05-06 17:16:22','教师5','123456','教师姓名5','男','http://localhost:8080/ssm13n54/upload/jiaoshi_zhaopian5.jpg','职称5','13823888885','773890005@qq.com'), (16,'2021-05-06 17:16:22','教师6','123456','教师姓名6','男','http://localhost:8080/ssm13n54/upload/jiaoshi_zhaopian6.jpg','职称6','13823888886','773890006@qq.com'); /*Table structure for table `kechengxinxi` */ DROP TABLE IF EXISTS `kechengxinxi`; 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 '课程名称', `kemu` varchar(200) DEFAULT NULL COMMENT '科目', `banji` varchar(200) DEFAULT NULL COMMENT '班级', `kechengtupian` varchar(200) DEFAULT NULL COMMENT '课程图片', `ketiyaoqiu` varchar(200) DEFAULT NULL COMMENT '课题要求', `kechengshipin` varchar(200) DEFAULT NULL COMMENT '课程视频', `kechengziliao` varchar(200) DEFAULT NULL COMMENT '课程资料', `ketineirong` longtext COMMENT '课题内容', `jiaoshigonghao` varchar(200) DEFAU