基于Android的多方交互的老年人慢病管理App开发(源码+数据库+说明).zip

-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64) -- -- Host: localhost Database: ssmh94r0 -- ------------------------------------------------------ -- 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 `chat` -- DROP TABLE IF EXISTS `chat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chat` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `userid` bigint(20) NOT NULL COMMENT '用户id', `adminid` bigint(20) DEFAULT NULL COMMENT '管理员id', `ask` longtext COMMENT '提问', `reply` longtext COMMENT '回复', `isreply` int(11) DEFAULT NULL COMMENT '是否回复', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=147 DEFAULT CHARSET=utf8 COMMENT='在线咨询'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `chat` -- LOCK TABLES `chat` WRITE; /*!40000 ALTER TABLE `chat` DISABLE KEYS */; INSERT INTO `chat` VALUES (141,'2021-02-01 02:42:59',1,1,'提问1','回复1',1),(142,'2021-02-01 02:42:59',2,2,'提问2','回复2',2),(143,'2021-02-01 02:42:59',3,3,'提问3','回复3',3),(144,'2021-02-01 02:42:59',4,4,'提问4','回复4',4),(145,'2021-02-01 02:42:59',5,5,'提问5','回复5',5),(146,'2021-02-01 02:42:59',6,6,'提问6','回复6',6); /*!40000 ALTER TABLE `chat` ENABLE KEYS */; UNLOCK TABLES; -- -- 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/ssmh94r0/upload/picture1.jpg'),(2,'picture2','http://localhost:8080/ssmh94r0/upload/picture2.jpg'),(3,'picture3','http://localhost:8080/ssmh94r0/upload/picture3.jpg'),(6,'homepage',NULL); /*!40000 ALTER TABLE `config` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `dianzibingli` -- DROP TABLE IF EXISTS `dianzibingli`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `dianzibingli` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `bianhao` varchar(200) DEFAULT NULL COMMENT '编号', `yiyuanmingcheng` varchar(200) NOT NULL COMMENT '医院名称', `yonghuming` varchar(200) DEFAULT NULL COMMENT '用户名', `xingming` varchar(200) DEFAULT NULL COMMENT '姓名', `xingbie` varchar(200) DEFAULT NULL COMMENT '性别', `nianling` varchar(200) DEFAULT NULL COMMENT '年龄', `minzu` varchar(200) DEFAULT NULL COMMENT '民族', `hunyin` varchar(200) DEFAULT NULL COMMENT '婚姻', `zhuzhi` varchar(200) DEFAULT NULL COMMENT '住址', `ruyuanriqi` date DEFAULT NULL COMMENT '入院日期', `zhusu` varchar(200) DEFAULT NULL COMMENT '主诉', `xianbingshi` longtext COMMENT '现病史', `jiwangshi` longtext COMMENT '既往史', `zhanghao` varchar(200) DEFAULT NULL COMMENT '账号', `yishengxingming` varchar(200) DEFAULT NULL COMMENT '医生姓名', `userid` bigint(20) NOT NULL COMMENT '用户id', PRIMARY KEY (`id`), UNIQUE KEY `bianhao` (`bianhao`) ) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 COMMENT='电子病历'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dianzibingli` -- LOCK TABLES `dianzibingli` WRITE; /*!40000 ALTER TABLE `dianzibingli` DISABLE KEYS */; INSERT INTO `dianzibingli` VALUES (61,'2021-02-01 02:42:59','编号1','医院名称1','用户名1','姓名1','性别1','年龄1','民族1','婚姻1','住址1','2021-02-01','主诉1','现病史1','既往史1','账号1','医生姓名1',1),(62,'2021-02-01 02:42:59','编号2','医院名称2','用户名2','姓名2','性别2','年龄2','民族2','婚姻2','住址2','2021-02-01','主诉2','现病史2','既往史2','账号2','医生姓名2',2),(63,'2021-02-01 02:42:59','编号3','医院名称3','用户名3','姓名3','性别3','年龄3','民族3','婚姻3','住址3','2021-02-01','主诉3','现病史3','既往史3','账号3','医生姓名3',3),(64,'2021-02-01 02:42:59','编号4','医院名称4','用户名4','姓名4','性别4','年龄4','民族4','婚姻4','住址4','2021-02-01','主诉4','现病史4','既往史4','账号4','医生姓名4',4),(65,'2021-02-01 02:42:59','编号5','医院名称5','用户名5','姓名5','性别5','年龄5','民族5','婚姻5','住址5','2021-02-01','主诉5','现病史5','既往史5','账号5','医生姓名5',5),(66,'2021-02-01 02:42:59','编号6','医院名称6','用户名6','姓名6','性别6','年龄6','民族6','婚姻6','住址6','2021-02-01','主诉6','现病史6','既往史6','账号6','医生姓名6',6); /*!40000 ALTER TABLE `dianzibingli` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `discussjiankangzhishi` -- DROP TABLE IF EXISTS `discussjiankangzhishi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `discussjiankangzhishi` ( `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', `content` longtext NOT NULL COMMENT '评论内容', `reply` longtext COMMENT '回复内容', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=187 DEFAULT CHARSET=utf8 COMMENT='健康知识评论表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `discussjiankangzhishi` -- LOCK TABLES `discussjiankangzhishi` WRITE; /*!40000 ALTER TABLE `discussjiankangzhishi` DISABLE KEYS */; INSERT INTO `discussjiankangzhishi` VALUES (181,'2021-02-01 02:42:59',1,1,'评论内容1','回复内容1'),(182,'2021-02-01 02:42:59',2,2,'评论内容2','回复内容2'),(183,'2021-02-01 02:42:59',3,3,'评论内容3','回复内容3'),(184,'2021-02-01 02:43:00',4,4,'评论内容4','回复内容4'),(185,'2021-02-01 02:43:00',5,5,'评论内容5','回复内容5'),(186,'2021-02-01 02:43:00',6,6,'评论内容6','回复内容6'); /*!40000 ALTER TABLE `discussjiankangzhishi` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `gerenxinxi` -- DROP TABLE IF EXISTS `gerenxinxi`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `gerenxinxi` ( `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `yonghuming` varchar(200) DEFAULT NULL COMMENT '用户名', `xingming` varchar(200) DEFAULT NULL COMMENT '姓名', `xingbie` varchar(200) DEFAULT NULL COMMENT '性别', `nianling` varchar(200) DEFAULT NULL COMMENT '年龄', `touxiang` varchar(200) DEFAULT NULL CO