小程序开发说明
开发语言：Java 框架：ssm JDK版本：JDK1.8 服务器：tomcat7 数据库：mysql 5.7（一定要5.7版本） 数据库工具：Navicat11 开发软件：eclipse/myeclipse/idea Maven包：Maven3.3.9 浏览器：谷歌浏览器
小程序框架：uniapp 小程序开发软件：HBuilder X 小程序运行软件：微信开发者
关键代码：
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 discussshipinkecheng
--
DROP TABLE IF EXISTS discussshipinkecheng;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE discussshipinkecheng (
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=117 DEFAULT CHARSET=utf8 COMMENT='视频课程评论表';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table discussshipinkecheng
--
LOCK TABLES discussshipinkecheng WRITE;
/*!40000 ALTER TABLE discussshipinkecheng DISABLE KEYS /;
INSERT INTO discussshipinkecheng VALUES (111,'2022-02-21 08:35:17',1,1,'用户名1','评论内容1','回复内容1'),(112,'2022-02-21 08:35:17',2,2,'用户名2','评论内容2','回复内容2'),(113,'2022-02-21 08:35:17',3,3,'用户名3','评论内容3','回复内容3'),(114,'2022-02-21 08:35:17',4,4,'用户名4','评论内容4','回复内容4'),(115,'2022-02-21 08:35:17',5,5,'用户名5','评论内容5','回复内容5'),(116,'2022-02-21 08:35:17',6,6,'用户名6','评论内容6','回复内容6');
/!40000 ALTER TABLE discussshipinkecheng 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-02-21 08:35:17','十万个为什么',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-02-21 08:35:17',1,'十万个为什么','下面动物不属于昆虫的是（）。','[{\"text\":\"A.苍蝇\",\"code\":\"A\"},{\"text\":\"B.蜜蜂\",\"code\":\"B\"},{\"text\":\"C.蜂鸟\",\"code\":\"C\"}]',20,'C','蜂鸟',0,1),(2,'2022-02-21 08:35:17',1,'十万个为什么','油着火后可以用水扑灭。','[{\"text\":\"A.对\",\"code\":\"A\"},{\"text\":\"B.错\",\"code\":\"B\"}]',20,'B','油着火后不可以用水扑灭',2,2),(3,'2022-02-21 08:35:17',1,'十万个为什么','地球是个球体，中间是（ ）。','[]',30,'赤道','赤道',3,3),(4,'2022-02-21 08:35:17',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=1645433332826 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 (1645433287063,'2022-02-21 08:48:06',11,'学生姓名1',1,'十万个为什么',1,'下面动物不属于昆虫的是（）。','[{\"text\":\"A.苍蝇\",\"code\":\"A\",\"checked\":false},{\"text\":\"B.蜜蜂\",\"code\":\"B\",\"checked\":false},{\"text\":\"C.蜂鸟\",\"code\":\"C\",\"checked\":true}]',20,'C','蜂鸟',20,'C'),(1645433300893,'2022-02-21 08:48:20',11,'学生姓名1',1,'十万个为什么',2,'油着火后可以用水扑灭。','[{\"text\":\"A.对\",\"code\":\"A\",\"checked\":false},{\"text\":\"B.错\",\"code\":\"B\",\"checked\":true}]',20,'B','油着火后不可以用水扑灭',20,'B'),(1645433318940,'2022-02-21 08:48:38',11,'学生姓名1',1,'十万个为什么',3,'地球是个球体，中间是（ ）。','[]',30,'赤道','赤道',0,'11'),(1645433332825,'2022-02-21 08:48:51',11,'学生姓名1',1,'十万个为什么',4,'下面动物中会流汗的有（ ）。','[{\"text\":\"A.马\",\"code\":\"A\",\"checked\":true},{\"text\":\"B.猫\",\"code\":\"B\",\"checked\":true},{\"text\":\"C.狗\",\"code\":\"C\",\"checked\":false}]',30,'A,B','狗不会流汗',30,'A,B');
/!40000 ALTER TABLE examrecord ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table forum
--
DROP TABLE IF EXISTS forum;
/*!40101 SET @saved_cs_client = @@character_set_client /;
/!40101 SET character_set_client = utf8 /;
CREATE TABLE forum (
id bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
title varchar(200) DEFAULT NULL COMMENT '帖子标题',
content longtext NOT NULL COMMENT '帖子内容',
parentid bigint(20) DEFAULT NULL COMMENT '父节点id',
userid bigint(20) NOT NULL COMMENT '用户id',
username varchar(200) DEFAULT NULL COMMENT '用户名',
isdone varchar(200) DEFAULT NULL COMMENT '状态',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='交流论坛';
/!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table forum
--
LOCK TABLES forum WRITE;
/*!40000 ALTER TABLE forum DISABLE KEYS /;
INSERT INTO forum VALUES (61,'2022-02-21 08:35:17','帖子标题1','帖子内容1',0,1,'用户名1','开放'),(62,'2022-02-21 08:35:17','帖子标题2','帖子内容2',0,2,'用户名2','开放'),(63,'2022-02-21 08:35:17','帖子标题3','帖子内容3',0,3,'用户名3','开放'),(64,'2022-02-21 08:35:17','帖子标题4','帖子内容4',0,4,'用户名4','开放'),(65,'2022-02-21 08:35:17','帖子标题5','帖子内容5',0,5,'用户名5','开放'),(66,'2022-02-21 08:35:17','帖子标题6','帖子内容6',0,6,'用户名6','开放');
/!40000 ALTER TABLE forum ENABLE KEYS */;
UNLOCK TABLES;
