(源码)基于Java SSM框架的在线教育资源管理系统.zip

-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64) -- -- Host: localhost Database: jspm4tlu5 -- ------------------------------------------------------ -- Server version 5.7.31 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!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 */; -- -- Table structure for table `config` -- 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=7 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','http://localhost:8080/jspm4tlu5/upload/picture1.jpg'),(2,'picture2','http://localhost:8080/jspm4tlu5/upload/picture2.jpg'),(3,'picture3','http://localhost:8080/jspm4tlu5/upload/picture3.jpg'),(6,'homepage',NULL); /*!40000 ALTER TABLE `config` 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=1616302240914 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 (1616302240913,'2021-03-21 04:50:39','英语考试',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=1616302307106 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 (1616302272747,'2021-03-21 04:51:12',1616302240913,'英语考试','sdgsgsgsg','[{\"text\":\"sd\",\"code\":\"A\"},{\"text\":\"fsdf\",\"code\":\"B\"},{\"text\":\"sfdf\",\"code\":\"C\"},{\"text\":\"sfff\",\"code\":\"D\"}]',5,'A','sdfsfsfsgsg',0,1),(1616302307105,'2021-03-21 04:51:46',1616302240913,'英语考试','sdfsfsgsgg','[{\"text\":\"sdfsf\",\"code\":\"A\"},{\"text\":\"sdfsf\",\"code\":\"B\"},{\"text\":\"sdf\",\"code\":\"C\"},{\"text\":\"sdfsf\",\"code\":\"D\"}]',5,'A,D','sdfssgsgs',1,2); /*!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=1616302358726 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 (1616302351160,'2021-03-21 04:52:30',11,NULL,1616302240913,'英语考试',1616302272747,'sdgsgsgsg','[{\"text\":\"sd\",\"code\":\"A\"},{\"text\":\"fsdf\",\"code\":\"B\"},{\"text\":\"sfdf\",\"code\":\"C\"},{\"text\":\"sfff\",\"code\":\"D\"}]',5,'A','sdfsfsfsgsg',5,'A'),(1616302358725,'2021-03-21 04:52:38',11,NULL,1616302240913,'英语考试',1616302307105,'sdfsfsgsgg','[{\"text\":\"sdfsf\",\"code\":\"A\"},{\"text\":\"sdfsf\",\"code\":\"B\"},{\"text\":\"sdf\",\"code\":\"C\"},{\"text\":\"sdfsf\",\"code\":\"D\"}]',5,'A,D','sdfssgsgs',0,'A,B'); /*!40000 ALTER TABLE `examrecord` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gonggaoxinxi` -- DROP TABLE IF EXISTS `gonggaoxinxi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gonggaoxinxi` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `biaoti` varchar(200) DEFAULT NULL COMMENT '标题', `tupian` varchar(200) DEFAULT NULL COMMENT '图片', `gonggaoneirong` longtext COMMENT '公告内容', `faburiqi` date DEFAULT NULL COMMENT '发布日期', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT='公告信息'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `gonggaoxinxi` -- LOCK TABLES `gonggaoxinxi` WRITE; /*!40000 ALTER TABLE `gonggaoxinxi` DISABLE KEYS */; INSERT INTO `gonggaoxinxi` VALUES (31,'2021-03-21 04:45:59','标题1','http://localhost:8080/jspm4tlu5/upload/gonggaoxinxi_tupian1.jpg','公告内容1','2021-03-21'),(32,'2021-03-21 04:46:00','标题2','http://localhost:8080/jspm4tlu5/upload/gonggaoxinxi_tupian2.jpg','公告内容2','2021-03-21'),(33,'2021-03-21 04:46:00','标题3','http://localhost:8080/jspm4tlu5/upload/gonggaoxinxi_tupian3.jpg','公告内容3','2021-03-21'),(34,'2021-03-21 04:46:00','标�