基于微信小程序远程家庭健康监测管理系统-毕业设计源码+LW文档

小程序开发说明

开发语言：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;