基于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;