毕业设计之计算机软考系统的设计与实现-微信小程序源码.zip

-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64) -- -- Host: localhost Database: ssmo13x7 -- ------------------------------------------------------ -- 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/ssmo13x7/upload/picture1.jpg'),(2,'picture2','http://localhost:8080/ssmo13x7/upload/picture2.jpg'),(3,'picture3','http://localhost:8080/ssmo13x7/upload/picture3.jpg'),(6,'homepage','http://localhost:8080/ssmo13x7/upload/1614568559096.jpg'); /*!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=1614568447395 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 (1614568447394,'2021-03-01 03:14:07','计算机基础考试',30,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=1614568537461 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 (1614568481474,'2021-03-01 03:14:40',1614568447394,'计算机基础考试','范德萨','[{\"text\":\"A.富士达\",\"code\":\"A\"},{\"text\":\"B.ff的撒范德萨\",\"code\":\"B\"},{\"text\":\"C.范德萨范德萨 \",\"code\":\"C\"},{\"text\":\"D.范德萨\",\"code\":\"D\"}]',5,'A','范德萨发',0,1),(1614568511860,'2021-03-01 03:15:11',1614568447394,'计算机基础考试','分成四大范德萨','[{\"text\":\"A.范德萨范德萨\",\"code\":\"A\"},{\"text\":\"B.广泛大概\",\"code\":\"B\"},{\"text\":\"C.广泛的给对方\",\"code\":\"C\"},{\"text\":\"D.广泛大锅饭给\",\"code\":\"D\"}]',5,'A,C','广泛的房东',1,3),(1614568525733,'2021-03-01 03:15:25',1614568447394,'计算机基础考试','广泛的广泛的','[{\"text\":\"A.对\",\"code\":\"A\"},{\"text\":\"B.错\",\"code\":\"B\"}]',5,'A','广泛的是个负担',2,5),(1614568537460,'2021-03-01 03:15:37',1614568447394,'计算机基础考试','房东广泛的','[]',5,'111','广东佛山广泛的',3,6); /*!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=1614568800698 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 (1614568651765,'2021-03-01 03:17:31',1614568629536,NULL,1614568447394,'计算机基础考试',1614568481474,'范德萨','[{\"text\":\"A.富士达\",\"code\":\"A\",\"checked\":true},{\"text\":\"B.ff的撒范德萨\",\"code\":\"B\",\"checked\":false},{\"text\":\"C.范德萨范德萨 \",\"code\":\"C\",\"checked\":false},{\"text\":\"D.范德萨\",\"code\":\"D\",\"checked\":false}]',5,'A','范德萨发',5,'A'),(1614568655648,'2021-03-01 03:17:34',1614568629536,NULL,1614568447394,'计算机基础考试',1614568511860,'分成四大范德萨','[{\"text\":\"A.范德萨范德萨\",\"code\":\"A\",\"checked\":true},{\"text\":\"B.广泛大概\",\"code\":\"B\",\"checked\":true},{\"text\":\"C.广泛的给对方\",\"code\":\"C\",\"checked\":false},{\"text\":\"D.广泛大锅饭给\",\"code\":\"D\",\"checked\":false}]',5,'A,C','广泛的房东',0,'A,B'),(1614568657445,'2021-03-01 03:17:36',1614568629536,NULL,1614568447394,'计算机基础考试',1614568525733,'广泛的广泛的','[{\"text\":\"A.对\",\"code\":\"A\",\"checked\":true},{\"text\":\"B.错\",\"code\":\"B\",\"checked\":false}]',5,'A','广泛的是个负担',5,'A'),(1614568659503,'2021-03-01 03:17:38',1614568629536,NULL,1614568447394,'计算机基础考试',1614568537460,'房东广泛的','[]',5,'111','广东佛山广泛的',0,'df '),(1614568792437,'2021-03-01 03:19:52',1614568775187,NULL,1614568447394,'计算机基础考试',1614568481474,'范�