基于ssm的教資考前指導系統(tǒng)設計與實現-計算機畢業(yè)設計源碼+LW文檔
開發(fā)語言：Java
框架：ssm
JDK版本：JDK1.8
服務器：tomcat7
數據庫：mysql 5.7（一定要5.7版本）
數據庫工具：Navicat11
開發(fā)軟件：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 '創(chuàng)建時間',
? `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 '創(chuàng)建時間',
? `refid` bigint(20) NOT NULL COMMENT '關聯(lián)表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 '創(chuàng)建時間',
? `refid` bigint(20) NOT NULL COMMENT '關聯(lián)表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 '創(chuàng)建時間',
? `name` varchar(200) NOT NULL COMMENT '在線練習名稱',
? `time` int(11) NOT NULL COMMENT '練習時長(分鐘)',
? `status` int(11) NOT NULL DEFAULT '0' COMMENT '在線練習狀態(tài)',
? 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 '創(chuàng)建時間',
? `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 '創(chuàng)建時間',
? `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 '創(chuàng)建時間',
? `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 '發(fā)布時間',
? 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 '創(chuàng)建時間',
? `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;
