开发语言：Java
框架：ssm
JDK版本：JDK1.8
服务器：tomcat7
数据库：mysql 5.7（一定要5.7版本）
数据库工具：Navicat11
开发软件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
浏览器：谷歌浏览器
数据库脚本：
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/picture1.jpg’),(2,’picture2′,’upload/picture2.jpg’),(3,’picture3′,’upload/picture3.jpg’);
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `dianpingxinxi`
—
DROP TABLE IF EXISTS `dianpingxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dianpingxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`biaoti` varchar(200) NOT NULL COMMENT ‘标题’,
`xuehao` varchar(200) DEFAULT NULL COMMENT ‘学号’,
`xingming` varchar(200) DEFAULT NULL COMMENT ‘姓名’,
`dianpingneirong` longtext COMMENT ‘点评内容’,
`yijian` longtext COMMENT ‘意见’,
`dianpingshijian` datetime DEFAULT NULL COMMENT ‘点评时间’,
`gonghao` varchar(200) DEFAULT NULL COMMENT ‘工号’,
`jiaoshixingming` varchar(200) DEFAULT NULL COMMENT ‘教师姓名’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=utf8 COMMENT=’点评信息’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `dianpingxinxi`
—
LOCK TABLES `dianpingxinxi` WRITE;
/*!40000 ALTER TABLE `dianpingxinxi` DISABLE KEYS */;
INSERT INTO `dianpingxinxi` VALUES (101,’2022-04-23 14:54:25′,’标题1′,’学号1′,’姓名1′,’点评内容1′,’意见1′,’2022-04-23 22:54:25′,’工号1′,’教师姓名1′),(102,’2022-04-23 14:54:25′,’标题2′,’学号2′,’姓名2′,’点评内容2′,’意见2′,’2022-04-23 22:54:25′,’工号2′,’教师姓名2′),(103,’2022-04-23 14:54:25′,’标题3′,’学号3′,’姓名3′,’点评内容3′,’意见3′,’2022-04-23 22:54:25′,’工号3′,’教师姓名3′),(104,’2022-04-23 14:54:25′,’标题4′,’学号4′,’姓名4′,’点评内容4′,’意见4′,’2022-04-23 22:54:25′,’工号4′,’教师姓名4′),(105,’2022-04-23 14:54:25′,’标题5′,’学号5′,’姓名5′,’点评内容5′,’意见5′,’2022-04-23 22:54:25′,’工号5′,’教师姓名5′),(106,’2022-04-23 14:54:25′,’标题6′,’学号6′,’姓名6′,’点评内容6′,’意见6′,’2022-04-23 22:54:25′,’工号6′,’教师姓名6′);
/*!40000 ALTER TABLE `dianpingxinxi` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `discussjiaoxueshipin`
—
DROP TABLE IF EXISTS `discussjiaoxueshipin`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discussjiaoxueshipin` (
`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=167 DEFAULT CHARSET=utf8 COMMENT=’教学视频评论表’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `discussjiaoxueshipin`
—
LOCK TABLES `discussjiaoxueshipin` WRITE;
/*!40000 ALTER TABLE `discussjiaoxueshipin` DISABLE KEYS */;
INSERT INTO `discussjiaoxueshipin` VALUES (161,’2022-04-23 14:54:25′,1,1,’用户名1′,’评论内容1′,’回复内容1′),(162,’2022-04-23 14:54:25′,2,2,’用户名2′,’评论内容2′,’回复内容2′),(163,’2022-04-23 14:54:25′,3,3,’用户名3′,’评论内容3′,’回复内容3′),(164,’2022-04-23 14:54:25′,4,4,’用户名4′,’评论内容4′,’回复内容4′),(165,’2022-04-23 14:54:25′,5,5,’用户名5′,’评论内容5′,’回复内容5′),(166,’2022-04-23 14:54:25′,6,6,’用户名6′,’评论内容6′,’回复内容6′);
/*!40000 ALTER TABLE `discussjiaoxueshipin` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `discusswentixinxi`
—
DROP TABLE IF EXISTS `discusswentixinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discusswentixinxi` (
`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=157 DEFAULT CHARSET=utf8 COMMENT=’问题信息评论表’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `discusswentixinxi`
—
LOCK TABLES `discusswentixinxi` WRITE;
/*!40000 ALTER TABLE `discusswentixinxi` DISABLE KEYS */;
INSERT INTO `discusswentixinxi` VALUES (151,’2022-04-23 14:54:25′,1,1,’用户名1′,’评论内容1′,’回复内容1′),(152,’2022-04-23 14:54:25′,2,2,’用户名2′,’评论内容2′,’回复内容2′),(153,’2022-04-23 14:54:25′,3,3,’用户名3′,’评论内容3′,’回复内容3′),(154,’2022-04-23 14:54:25′,4,4,’用户名4′,’评论内容4′,’回复内容4′),(155,’2022-04-23 14:54:25′,5,5,’用户名5′,’评论内容5′,’回复内容5′),(156,’2022-04-23 14:54:25′,6,6,’用户名6′,’评论内容6′,’回复内容6′);
/*!40000 ALTER TABLE `discusswentixinxi` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `exampaper`
—
DROP TABLE IF EXISTS `exampaper`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `exampaper` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`name` varchar(200) NOT NULL COMMENT ‘在线练习名称’,
`time` int(11) NOT NULL COMMENT ‘练习时长(分钟)’,
`status` int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘在线练习状态’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT=’在线练习表’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `exampaper`
—
LOCK TABLES `exampaper` WRITE;
/*!40000 ALTER TABLE `exampaper` DISABLE KEYS */;
INSERT INTO `exampaper` VALUES (1,’2022-04-23 14:54:25′,’十万个为什么’,60,1);
/*!40000 ALTER TABLE `exampaper` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `examquestion`
—
DROP TABLE IF EXISTS `examquestion`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `examquestion` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`paperid` bigint(20) NOT NULL COMMENT ‘所属在线练习id（外键）’,
`papername` varchar(200) NOT NULL COMMENT ‘在线练习名称’,
`questionname` varchar(200) NOT NULL COMMENT ‘练习题库名称’,
`options` longtext COMMENT ‘选项，json字符串’,
`score` bigint(20) DEFAULT ‘0’ COMMENT ‘分值’,
`answer` varchar(200) DEFAULT NULL COMMENT ‘正确答案’,
`analysis` longtext COMMENT ‘答案解析’,
`type` bigint(20) DEFAULT ‘0’ COMMENT ‘练习题库类型，0：单选题 1：多选题 2：判断题 3：填空题（暂不考虑多项填空）’,
`sequence` bigint(20) DEFAULT ‘100’ COMMENT ‘练习题库排序，值越大排越前面’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT=’练习题库’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `examquestion`
—
LOCK TABLES `examquestion` WRITE;
/*!40000 ALTER TABLE `examquestion` DISABLE KEYS */;
INSERT INTO `examquestion` VALUES (1,’2022-04-23 14:54:25′,1,’十万个为什么’,’下面动物不属于昆虫的是（）。’,'[{\”text\”:\”A.苍蝇\”,\”code\”:\”A\”},{\”text\”:\”B.蜜蜂\”,\”code\”:\”B\”},{\”text\”:\”C.蜂鸟\”,\”code\”:\”C\”}]’,20,’C’,’蜂鸟’,0,1),(2,’2022-04-23 14:54:25′,1,’十万个为什么’,’油着火后可以用水扑灭。’,'[{\”text\”:\”A.对\”,\”code\”:\”A\”},{\”text\”:\”B.错\”,\”code\”:\”B\”}]’,20,’B’,’油着火后不可以用水扑灭’,2,2),(3,’2022-04-23 14:54:25′,1,’十万个为什么’,’地球是个球体，中间是（ ）。’,'[]’,30,’赤道’,’赤道’,3,3),(4,’2022-04-23 14:54:25′,1,’十万个为什么’,’下面动物中会流汗的有（ ）。’,'[{\”text\”:\”A.马\”,\”code\”:\”A\”},{\”text\”:\”B.猫\”,\”code\”:\”B\”},{\”text\”:\”C.狗\”,\”code\”:\”C\”}]’,30,’A,B’,’狗不会流汗’,1,4);
/*!40000 ALTER TABLE `examquestion` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `examrecord`
—
DROP TABLE IF EXISTS `examrecord`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `examrecord` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`userid` bigint(20) NOT NULL COMMENT ‘用户id’,
`username` varchar(200) DEFAULT NULL COMMENT ‘用户名’,
`paperid` bigint(20) NOT NULL COMMENT ‘在线练习id（外键）’,
`papername` varchar(200) NOT NULL COMMENT ‘在线练习名称’,
`questionid` bigint(20) NOT NULL COMMENT ‘练习题库id（外键）’,
`questionname` varchar(200) NOT NULL COMMENT ‘练习题库名称’,
`options` longtext COMMENT ‘选项，json字符串’,
`score` bigint(20) DEFAULT ‘0’ COMMENT ‘分值’,
`answer` varchar(200) DEFAULT NULL COMMENT ‘正确答案’,
`analysis` longtext COMMENT ‘答案解析’,
`myscore` bigint(20) NOT NULL DEFAULT ‘0’ COMMENT ‘练习题库得分’,
`myanswer` varchar(200) DEFAULT NULL COMMENT ‘考生答案’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1650725905281 DEFAULT CHARSET=utf8 COMMENT=’练习记录表’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `examrecord`
—
LOCK TABLES `examrecord` WRITE;
/*!40000 ALTER TABLE `examrecord` DISABLE KEYS */;
INSERT INTO `examrecord` VALUES (1650725896570,’2022-04-23 14:58:16′,11,’姓名1′,1,’十万个为什么’,1,’下面动物不属于昆虫的是（）。’,'[{\”text\”:\”A.苍蝇\”,\”code\”:\”A\”},{\”text\”:\”B.蜜蜂\”,\”code\”:\”B\”},{\”text\”:\”C.蜂鸟\”,\”code\”:\”C\”}]’,20,’C’,’蜂鸟’,0,’A’),(1650725900502,’2022-04-23 14:58:20′,11,’姓名1′,1,’十万个为什么’,2,’油着火后可以用水扑灭。’,'[{\”text\”:\”A.对\”,\”code\”:\”A\”},{\”text\”:\”B.错\”,\”code\”:\”B\”}]’,20,’B’,’油着火后不可以用水扑灭’,0,’A’),(1650725902758,’2022-04-23 14:58:21′,11,’姓名1′,1,’十万个为什么’,3,’地球是个球体，中间是（ ）。’,'[]’,30,’赤道’,’赤道’,0,’12’),(1650725905280,’2022-04-23 14:58:24′,11,’姓名1′,1,’十万个为什么’,4,’下面动物中会流汗的有（ ）。’,'[{\”text\”:\”A.马\”,\”code\”:\”A\”},{\”text\”:\”B.猫\”,\”code\”:\”B\”},{\”text\”:\”C.狗\”,\”code\”:\”C\”}]’,30,’A,B’,’狗不会流汗’,0,’B’);
/*!40000 ALTER TABLE `examrecord` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `fuxiziliao`
—
DROP TABLE IF EXISTS `fuxiziliao`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fuxiziliao` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`ziliaobianhao` varchar(200) DEFAULT NULL COMMENT ‘资料编号’,
`ziliaomingcheng` varchar(200) NOT NULL COMMENT ‘资料名称’,
`ziliaoleixing` varchar(200) NOT NULL COMMENT ‘资料类型’,
`tupian` varchar(200) NOT NULL COMMENT ‘图片’,
`shipin` varchar(200) DEFAULT NULL COMMENT ‘视频’,
`ziliaofujian` varchar(200) DEFAULT NULL COMMENT ‘资料附件’,
`ziliaojieshao` longtext COMMENT ‘资料介绍’,
`fabushijian` datetime DEFAULT NULL COMMENT ‘发布时间’,
PRIMARY KEY (`id`),
UNIQUE KEY `ziliaobianhao` (`ziliaobianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT=’复习资料’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `fuxiziliao`
—
LOCK TABLES `fuxiziliao` WRITE;
/*!40000 ALTER TABLE `fuxiziliao` DISABLE KEYS */;
INSERT INTO `fuxiziliao` VALUES (71,’2022-04-23 14:54:25′,’1111111111′,’资料名称1′,’资料类型1′,’upload/fuxiziliao_tupian1.jpg’,”,”,’资料介绍1′,’2022-04-23 22:54:25′),(72,’2022-04-23 14:54:25′,’2222222222′,’资料名称2′,’资料类型2′,’upload/fuxiziliao_tupian2.jpg’,”,”,’资料介绍2′,’2022-04-23 22:54:25′),(73,’2022-04-23 14:54:25′,’3333333333′,’资料名称3′,’资料类型3′,’upload/fuxiziliao_tupian3.jpg’,”,”,’资料介绍3′,’2022-04-23 22:54:25′),(74,’2022-04-23 14:54:25′,’4444444444′,’资料名称4′,’资料类型4′,’upload/fuxiziliao_tupian4.jpg’,”,”,’资料介绍4′,’2022-04-23 22:54:25′),(75,’2022-04-23 14:54:25′,’5555555555′,’资料名称5′,’资料类型5′,’upload/fuxiziliao_tupian5.jpg’,”,”,’资料介绍5′,’2022-04-23 22:54:25′),(76,’2022-04-23 14:54:25′,’6666666666′,’资料名称6′,’资料类型6′,’upload/fuxiziliao_tupian6.jpg’,”,”,’资料介绍6′,’2022-04-23 22:54:25′);
/*!40000 ALTER TABLE `fuxiziliao` 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) DEFAULT NULL COMMENT ‘教师姓名’,
`xingbie` varchar(200) DEFAULT NULL COMMENT ‘性别’,
`touxiang` varchar(200) DEFAULT NULL COMMENT ‘头像’,
`nianling` varchar(200) DEFAULT NULL COMMENT ‘年龄’,
`jiangjiejiage` float DEFAULT NULL COMMENT ‘讲解价格’,
`xueyuan` varchar(200) DEFAULT NULL COMMENT ‘学院’,
`dianhua` varchar(200) DEFAULT NULL COMMENT ‘电话’,
`youxiang` varchar(200) DEFAULT NULL COMMENT ‘邮箱’,
PRIMARY KEY (`id`),
UNIQUE KEY `gonghao` (`gonghao`)
) ENGINE=InnoDB AUTO_INCREMENT=27 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-23 14:54:25′,’1′,’1′,’教师姓名1′,’男’,’upload/jiaoshi_touxiang1.jpg’,’年龄1′,1,’学院1′,’13823888881′,’[email protected]’),(22,’2022-04-23 14:54:25′,’工号2′,’123456′,’教师姓名2′,’男’,’upload/jiaoshi_touxiang2.jpg’,’年龄2′,2,’学院2′,’13823888882′,’[email protected]’),(23,’2022-04-23 14:54:25′,’工号3′,’123456′,’教师姓名3′,’男’,’upload/jiaoshi_touxiang3.jpg’,’年龄3′,3,’学院3′,’13823888883′,’[email protected]’),(24,’2022-04-23 14:54:25′,’工号4′,’123456′,’教师姓名4′,’男’,’upload/jiaoshi_touxiang4.jpg’,’年龄4′,4,’学院4′,’13823888884′,’[email protected]’),(25,’2022-04-23 14:54:25′,’工号5′,’123456′,’教师姓名5′,’男’,’upload/jiaoshi_touxiang5.jpg’,’年龄5′,5,’学院5′,’13823888885′,’[email protected]’),(26,’2022-04-23 14:54:25′,’工号6′,’123456′,’教师姓名6′,’男’,’upload/jiaoshi_touxiang6.jpg’,’年龄6′,6,’学院6′,’13823888886′,’[email protected]’);
/*!40000 ALTER TABLE `jiaoshi` ENABLE KEYS */;
UNLOCK TABLES;