基于ssm的教资考前指导系统设计与实现-计算机毕业设计源码+LW文档
开发语言：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','773890001@qq.com'),(22,'2022-04-23 14:54:25','工号2','123456','教师姓名2','男','upload/jiaoshi_touxiang2.jpg','年龄2',2,'学院2','13823888882','773890002@qq.com'),(23,'2022-04-23 14:54:25','工号3','123456','教师姓名3','男','upload/jiaoshi_touxiang3.jpg','年龄3',3,'学院3','13823888883','773890003@qq.com'),(24,'2022-04-23 14:54:25','工号4','123456','教师姓名4','男','upload/jiaoshi_touxiang4.jpg','年龄4',4,'学院4','13823888884','773890004@qq.com'),(25,'2022-04-23 14:54:25','工号5','123456','教师姓名5','男','upload/jiaoshi_touxiang5.jpg','年龄5',5,'学院5','13823888885','773890005@qq.com'),(26,'2022-04-23 14:54:25','工号6','123456','教师姓名6','男','upload/jiaoshi_touxiang6.jpg','年龄6',6,'学院6','13823888886','773890006@qq.com');
/*!40000 ALTER TABLE `jiaoshi` ENABLE KEYS */;
UNLOCK TABLES;
