基于微信小程序远程家庭健康监测管理系统-毕业设计源码+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.苍蝇””