功能介绍
本系统分为用户和管理员两个角色，用户的操作主要为微信端，管理员的操作为服务端。用户在微信端可以根据不同的分类浏览体检套餐，可以预约，管理自己的预约信息、体检报告信息、收藏信息等；管理员可以管理体检报告信息、用户信息、体检常识信息以及体检预约和用户信息等。用户和管理员的功能相互串连形成完整的基于微信小程序的医院体检管理系统。
根据用户和管理员的功能可以分为微信端和服务端两个界面，在微信端中主要的功能为：
（1）体检套餐功能，根据不同的分类进行体检套餐的展示；
（2）查询功能，用户可以根据不同的字段来进行特定体检套餐的搜索，本功能是一个系统最基本的功能；
（3）预约功能，在体检套餐的详情里可以直接预约；
（4）用户管理功能，包括注册用户和对用户资料的信息；
（5）体检常识信息功能，可以查看管理员发布的体检常识；
（6）体检报告信息功能，可以查询自己的体检结果；
（7）在线咨询功能，可以实现在线解疑。
本系统的管理员服务端功能包括：
（1）体检套餐信息管理功能，对体检套餐进行上传、删除、编辑；
（2）个人中心管理功能，对管理员账号、密码进行管理；
（3）体检常识管理功能，对体检常识进行发布和管理；
（4）体检分类信息管理功能，可以管理分类信息；
（5）体检预约管理功能，包括查询预约和安排体检；
（6）体检报告管理功能，可以管理用户的体检报告信息；
（7）用户管理功能，查询和管理用户的信息。
使用技术
使用框架：SSM
开发语言：Java、小程序 ，
前端技术：JavaScript、VUE.js（2.X）、css3
框架：ssm，JDK版本：JDK1.8 ，
服务器：tomcat9 ，
数据库：mysql 5.7，
数据库工具：Navicat11，
开发软件：eclipse/myeclipse/idea，
浏览器：谷歌浏览器，
小程序运行软件：微信开发者
数据库脚本
-- MySQL dump 10.13 Distrib 5.7.31, for Linux (x86_64)---- Host: localhost Database: ssmer602-- -------------------------------------------------------- Server version5.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 */;CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ssmer602`/*!40100 DEFAULT CHARACTER SET utf8mb4 */;USE ssmer602;---- 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=1617359522893 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 (61,'-04-02 10:01:16',1,1,'提问1','回复1',1),(62,'-04-02 10:01:16',2,2,'提问2','回复2',2),(63,'-04-02 10:01:16',3,3,'提问3','回复3',3),(64,'-04-02 10:01:16',4,4,'提问4','回复4',4),(65,'-04-02 10:01:16',5,5,'提问5','回复5',5),(66,'-04-02 10:01:16',6,6,'提问6','回复6',6),(1617358642833,'-04-02 10:17:21',1617358565854,NULL,'请问有老年人体检套餐吗',NULL,0),(1617358825857,'-04-02 10:20:25',1617358565854,1,NULL,'1',0),(1617359136582,'-04-02 10:25:36',1617358565854,NULL,'请问体检前要注意哪些',NULL,0),(1617359227782,'-04-02 10:27:07',1617358565854,1,NULL,'可查看体检常识相关',NULL),(1617359460099,'-04-02 10:30:59',1617359331001,NULL,'请问有老年人健康体检套餐吗',NULL,0),(1617359522892,'-04-02 10:32:02',1617359331001,1,NULL,'有的，可直接搜索或按分类查看',NULL);/*!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/ssmer602/upload/1617358474244.jpg'),(2,'picture2','http://localhost:8080/ssmer602/upload/1617358481980.jpg'),(3,'picture3','http://localhost:8080/ssmer602/upload/1617359008382.jpg'),(6,'homepage',NULL);/*!40000 ALTER TABLE `config` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `discusstijiantaocan`--DROP TABLE IF EXISTS `discusstijiantaocan`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `discusstijiantaocan` (`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=97 DEFAULT CHARSET=utf8 COMMENT='体检套餐评论表';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `discusstijiantaocan`--LOCK TABLES `discusstijiantaocan` WRITE;/*!40000 ALTER TABLE `discusstijiantaocan` DISABLE KEYS */;INSERT INTO `discusstijiantaocan` VALUES (91,'-04-02 10:01:16',1,1,'用户名1','评论内容1','回复内容1'),(92,'-04-02 10:01:16',2,2,'用户名2','评论内容2','回复内容2'),(93,'-04-02 10:01:16',3,3,'用户名3','评论内容3','回复内容3'),(94,'-04-02 10:01:16',4,4,'用户名4','评论内容4','回复内容4'),(95,'-04-02 10:01:16',5,5,'用户名5','评论内容5','回复内容5'),(96,'-04-02 10:01:16',6,6,'用户名6','评论内容6','回复内容6');/*!40000 ALTER TABLE `discusstijiantaocan` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `news`--DROP TABLE IF EXISTS `news`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `news` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`title` varchar(200) NOT NULL COMMENT '标题',`introduction` longtext COMMENT '简介',`picture` varchar(200) NOT NULL COMMENT '图片',`content` longtext NOT NULL COMMENT '内容',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1617359056194 DEFAULT CHARSET=utf8 COMMENT='体检常识';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `news`--LOCK TABLES `news` WRITE;/*!40000 ALTER TABLE `news` DISABLE KEYS */;INSERT INTO `news` VALUES (81,'-04-02 10:01:16','标题1','简介1','http://localhost:8080/ssmer602/upload/news_picture1.jpg','内容1'),(82,'-04-02 10:01:16','标题2','简介2','http://localhost:8080/ssmer602/upload/1617358113048.jpg','<p>内容2</p>'),(83,'-04-02 10:01:16','标题3','简介3','http://localhost:8080/ssmer602/upload/news_picture3.jpg','内容3'),(85,'-04-02 10:01:16','标题5','简介5','http://localhost:8080/ssmer602/upload/1617358122855.jpg','<p>内容5</p>'),(86,'-04-02 10:01:16','标题6','简介6','http://localhost:8080/ssmer602/upload/news_picture6.jpg','内容6'),(1617359056193,'-04-02 10:24:15','体检前一天不能吃什么？','体检前饮食注意','http://localhost:8080/ssmer602/upload/1617359028706.jpg','<p>体检前一天晚上不能吃什么?很多受检的朋友在体检前一天都不知道吃什么好，因为很多体检前都不能吃消化不好的食物的，下面小编就介绍下体检前一天晚上不能吃什么。</p><p>碘高的食品：如深海鱼油、藻类、海带、海鱼、海蜇皮等，由于这些海产品含碘量高，会影响甲状腺功能检测。含嘌呤类的食物：中年人每年做健康体检时，要注意检测血液的尿酸浓度，由于嘌呤类的食物对尿酸检测有影响，所以不要吃含嘌呤类的食物，如动物内脏、海鲜类食品。</p><p>含糖食品：体检前尽量不吃喝各种甜食、饮料等，这些食品含糖量高，对血糖、尿糖的检测有一定影响。</p><p>高蛋白食品：如鸡蛋、肉类等，以免影响对肾脏功能的检测。</p><p>高脂肪食品：如果吃了高脂肪的食物，如肉类、动物内脏等，血脂会上升，会影响血脂的检测。</p><p><img src=\"http://localhost:8080/ssmer602/upload/1617359053955.jpg\"></p>');/*!40000 ALTER TABLE `news` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `storeup`--DROP TABLE IF EXISTS `storeup`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `storeup` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`userid` bigint(20) NOT NULL COMMENT '用户id',`refid` bigint(20) DEFAULT NULL COMMENT '收藏id',`tablename` varchar(200) DEFAULT NULL COMMENT '表名',`name` varchar(200) NOT NULL COMMENT '收藏名称',`picture` varchar(200) NOT NULL COMMENT '收藏图片',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1617359413116 DEFAULT CHARSET=utf8 COMMENT='收藏表';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `storeup`--LOCK TABLES `storeup` WRITE;/*!40000 ALTER TABLE `storeup` DISABLE KEYS */;/*!40000 ALTER TABLE `storeup` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `tijianbaogao`--DROP TABLE IF EXISTS `tijianbaogao`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `tijianbaogao` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '订单编号',`taocanmingcheng` varchar(200) DEFAULT NULL COMMENT '套餐名称',`fenlei` varchar(200) DEFAULT NULL COMMENT '分类',`tupian` varchar(200) DEFAULT NULL COMMENT '图片',`baogaodanhao` varchar(200) DEFAULT NULL COMMENT '报告单号',`tijianbaogao` varchar(200) DEFAULT NULL COMMENT '体检报告',`baogaojieguo` longtext COMMENT '报告结果',`baogaoshijian` datetime DEFAULT NULL COMMENT '报告时间',`yonghuming` varchar(200) DEFAULT NULL COMMENT '用户名',`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',`shouji` varchar(200) DEFAULT NULL COMMENT '手机',`userid` bigint(20) DEFAULT NULL COMMENT '用户id',PRIMARY KEY (`id`),UNIQUE KEY `baogaodanhao` (`baogaodanhao`)) ENGINE=InnoDB AUTO_INCREMENT=1617359503505 DEFAULT CHARSET=utf8 COMMENT='体检报告';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `tijianbaogao`--LOCK TABLES `tijianbaogao` WRITE;/*!40000 ALTER TABLE `tijianbaogao` DISABLE KEYS */;INSERT INTO `tijianbaogao` VALUES (51,'-04-02 10:01:16','订单编号1','套餐名称1','分类1','http://localhost:8080/ssmer602/upload/1617358093625.jpg','报告单号1','','报告结果1','-04-02 18:01:16','用户名1','姓名1','手机1',1),(52,'-04-02 10:01:16','订单编号2','套餐名称2','分类2','http://localhost:8080/ssmer602/upload/tijianbaogao_tupian2.jpg','报告单号2','','报告结果2','-04-02 18:01:16','用户名2','姓名2','手机2',2),(53,'-04-02 10:01:16','订单编号3','套餐名称3','分类3','http://localhost:8080/ssmer602/upload/tijianbaogao_tupian3.jpg','报告单号3','','报告结果3','-04-02 18:01:16','用户名3','姓名3','手机3',3),(54,'-04-02 10:01:16','订单编号4','套餐名称4','分类4','http://localhost:8080/ssmer602/upload/tijianbaogao_tupian4.jpg','报告单号4','','报告结果4','-04-02 18:01:16','用户名4','姓名4','手机4',4),(55,'-04-02 10:01:16','订单编号5','套餐名称5','分类5','http://localhost:8080/ssmer602/upload/tijianbaogao_tupian5.jpg','报告单号5','','报告结果5','-04-02 18:01:16','用户名5','姓名5','手机5',5),(56,'-04-02 10:01:16','订单编号6','套餐名称6','分类6','http://localhost:8080/ssmer602/upload/tijianbaogao_tupian6.jpg','报告单号6','','报告结果6','-04-02 18:01:16','用户名6','姓名6','手机6',6),(1617359193610,'-04-02 10:26:33','1617359078848','员工入职体检基础项目','入职体检','http://localhost:8080/ssmer602/upload/1617358955666.jpg','1617359177979','http://localhost:8080/ssmer602/upload/1617359181757.docx','基本正常','-04-08 10:00:00','1','陈一','12345678978',1617358565854),(1617359503504,'-04-02 10:31:43','1617359414469','员工入职体检基础项目','入职体检','http://localhost:8080/ssmer602/upload/1617358955666.jpg','1617359476546','http://localhost:8080/ssmer602/upload/1617359479828.docx','各项指标正常','-04-07 09:00:00','2','张一','12345678978',1617359331001);/*!40000 ALTER TABLE `tijianbaogao` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `tijianfenlei`--DROP TABLE IF EXISTS `tijianfenlei`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `tijianfenlei` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`fenlei` varchar(200) NOT NULL COMMENT '分类',PRIMARY KEY (`id`),UNIQUE KEY `fenlei` (`fenlei`)) ENGINE=InnoDB AUTO_INCREMENT=1617358931094 DEFAULT CHARSET=utf8 COMMENT='体检分类';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `tijianfenlei`--LOCK TABLES `tijianfenlei` WRITE;/*!40000 ALTER TABLE `tijianfenlei` DISABLE KEYS */;INSERT INTO `tijianfenlei` VALUES (21,'-04-02 10:01:16','学生体检'),(22,'-04-02 10:01:16','入职体检'),(23,'-04-02 10:01:16','女性健康'),(24,'-04-02 10:01:16','老年体检'),(1617358931093,'-04-02 10:22:10','男性健康');/*!40000 ALTER TABLE `tijianfenlei` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `tijiantaocan`--DROP TABLE IF EXISTS `tijiantaocan`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `tijiantaocan` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`taocanmingcheng` varchar(200) NOT NULL COMMENT '套餐名称',`fenlei` varchar(200) NOT NULL COMMENT '分类',`taocanxiangmu` int(11) DEFAULT NULL COMMENT '套餐项目',`tupian` varchar(200) DEFAULT NULL COMMENT '图片',`jiage` int(11) DEFAULT NULL COMMENT '价格',`tijianneirong` longtext COMMENT '体检内容',`tijiandidian` varchar(200) DEFAULT NULL COMMENT '体检地点',`zhuyishixiang` longtext COMMENT '注意事项',`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',`clicknum` int(11) DEFAULT '0' COMMENT '点击次数',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=1617358995809 DEFAULT CHARSET=utf8 COMMENT='体检套餐';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `tijiantaocan`--LOCK TABLES `tijiantaocan` WRITE;/*!40000 ALTER TABLE `tijiantaocan` DISABLE KEYS */;INSERT INTO `tijiantaocan` VALUES (31,'-04-02 10:01:16','套餐名称1','入职体检',1,'http://localhost:8080/ssmer602/upload/1617358007106.jpg',1,'<p>体检内容1</p>','体检地点1','注意事项1','-04-02 18:06:32',2),(32,'-04-02 10:01:16','套餐名称2','女性健康',2,'http://localhost:8080/ssmer602/upload/tijiantaocan_tupian2.jpg',2,'<p>体检内容2</p>','体检地点2','注意事项2','-04-02 18:06:59',3),(33,'-04-02 10:01:16','套餐名称3','学生体检',3,'http://localhost:8080/ssmer602/upload/1617358032231.jpg',3,'<p>体检内容3</p>','体检地点3','注意事项3','-04-02 18:07:04',4),(34,'-04-02 10:01:16','套餐名称4','老年体检',4,'http://localhost:8080/ssmer602/upload/1617358042950.jpg',4,'<p>体检内容4</p>','体检地点4','注意事项4','-04-02 18:29:18',12),(35,'-04-02 10:01:16','套餐名称5','入职体检',5,'http://localhost:8080/ssmer602/upload/1617358057288.jpg',5,'<p>体检内容5</p>','体检地点5','注意事项5','-04-02 18:07:27',6),(1617358995808,'-04-02 10:23:15','员工入职体检基础项目','入职体检',11,'http://localhost:8080/ssmer602/upload/1617358955666.jpg',220,'<p>身高和体重的一般检查、体格检查、营养、发育、血压、胸肺听诊、心率、心律、血常规、肝功能、尿常规、心电图、胸部x光、杂音、肝脾、视力、眼、耳、鼻、喉等。</p>','门诊大楼','前一天应注意休息，不要饮酒吃药，而且晚餐后不要再进食，保证空腹；','-04-02 18:30:26',4);/*!40000 ALTER TABLE `tijiantaocan` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `tijianyuyue`--DROP TABLE IF EXISTS `tijianyuyue`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `tijianyuyue` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`dingdanbianhao` varchar(200) DEFAULT NULL COMMENT '订单编号',`taocanmingcheng` varchar(200) DEFAULT NULL COMMENT '套餐名称',`fenlei` varchar(200) DEFAULT NULL COMMENT '分类',`tupian` varchar(200) DEFAULT NULL COMMENT '图片',`jiage` int(11) DEFAULT NULL COMMENT '价格',`goumairiqi` date DEFAULT NULL COMMENT '购买日期',`yuyueshijian` datetime DEFAULT NULL COMMENT '预约时间',`beizhu` varchar(200) DEFAULT NULL COMMENT '备注',`yonghuming` varchar(200) DEFAULT NULL COMMENT '用户名',`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',`shouji` varchar(200) DEFAULT NULL COMMENT '手机',`shenfenzheng` varchar(200) DEFAULT NULL COMMENT '身份证',`sfsh` varchar(200) DEFAULT '否' COMMENT '是否审核',`shhf` longtext COMMENT '审核回复',`ispay` varchar(200) DEFAULT '未支付' COMMENT '是否支付',`userid` bigint(20) DEFAULT NULL COMMENT '用户id',PRIMARY KEY (`id`),UNIQUE KEY `dingdanbianhao` (`dingdanbianhao`)) ENGINE=InnoDB AUTO_INCREMENT=1617359425625 DEFAULT CHARSET=utf8 COMMENT='体检预约';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `tijianyuyue`--LOCK TABLES `tijianyuyue` WRITE;/*!40000 ALTER TABLE `tijianyuyue` DISABLE KEYS */;INSERT INTO `tijianyuyue` VALUES (41,'-04-02 10:01:16','订单编号1','套餐名称1','分类1','http://localhost:8080/ssmer602/upload/tijianyuyue_tupian1.jpg',1,'-04-02','-04-02 18:01:16','备注1','用户名1','姓名1','手机1','身份证1','是','','未支付',1),(42,'-04-02 10:01:16','订单编号2','套餐名称2','分类2','http://localhost:8080/ssmer602/upload/tijianyuyue_tupian2.jpg',2,'-04-02','-04-02 18:01:16','备注2','用户名2','姓名2','手机2','身份证2','是','','未支付',2),(43,'-04-02 10:01:16','订单编号3','套餐名称3','分类3','http://localhost:8080/ssmer602/upload/tijianyuyue_tupian3.jpg',3,'-04-02','-04-02 18:01:16','备注3','用户名3','姓名3','手机3','身份证3','是','','未支付',3),(44,'-04-02 10:01:16','订单编号4','套餐名称4','分类4','http://localhost:8080/ssmer602/upload/1617358085409.jpg',4,'-04-02','-04-02 18:01:16','备注4','用户名4','姓名4','手机4','身份证4','是','','未支付',4),(45,'-04-02 10:01:16','订单编号5','套餐名称5','分类5','http://localhost:8080/ssmer602/upload/tijianyuyue_tupian5.jpg',5,'-04-02','-04-02 18:01:16','备注5','用户名5','姓名5','手机5','身份证5','是','','未支付',5),(46,'-04-02 10:01:16','订单编号6','套餐名称6','分类6','http://localhost:8080/ssmer602/upload/tijianyuyue_tupian6.jpg',6,'-04-02','-04-02 18:01:16','备注6','用户名6','姓名6','手机6','身份证6','是','','未支付',6),(1617359102643,'-04-02 10:25:01','1617359078848','员工入职体检基础项目','入职体检','http://localhost:8080/ssmer602/upload/1617358955666.jpg',220,'-04-02','-04-03 09:00:00','','1','陈一','12345678978','123456789789456123','是','ok','已支付',1617358565854),(1617359425624,'-04-02 10:30:24','1617359414469','员工入职体检基础项目','入职体检','http://localhost:8080/ssmer602/upload/1617358955666.jpg',220,'-04-02','-04-04 08:30:14','','2','张一','12345678978','123456789987456321','是','ok','已支付',1617359331001);/*!40000 ALTER TABLE `tijianyuyue` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `token`--DROP TABLE IF EXISTS `token`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `token` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`userid` bigint(20) NOT NULL COMMENT '用户id',`username` varchar(100) NOT NULL COMMENT '用户名',`tablename` varchar(100) DEFAULT NULL COMMENT '表名',`role` varchar(100) DEFAULT NULL COMMENT '角色',`token` varchar(200) NOT NULL COMMENT '密码',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',`expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',PRIMARY KEY (`id`)) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='token表';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `token`--LOCK TABLES `token` WRITE;/*!40000 ALTER TABLE `token` DISABLE KEYS */;INSERT INTO `token` VALUES (1,1,'abo','users','管理员','9wl2x9rtjq2cbcv3szj30ir77pb7rq25','-04-02 10:05:31','-04-02 11:21:48'),(2,1617358565854,'1','yonghu','用户','8thlgzbbqwqlrr02qoqp7c8k3d2dkary','-04-02 10:16:11','-04-02 11:16:11'),(3,1617359331001,'2','yonghu','用户','nfae9xoocnssiut64nt472yfhdm4ivny','-04-02 10:28:56','-04-02 11:28:57');/*!40000 ALTER TABLE `token` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `users`--DROP TABLE IF EXISTS `users`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `users` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`username` varchar(100) NOT NULL COMMENT '用户名',`password` varchar(100) NOT NULL COMMENT '密码',`role` varchar(100) DEFAULT '管理员' COMMENT '角色',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP 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 `users`--LOCK TABLES `users` WRITE;/*!40000 ALTER TABLE `users` DISABLE KEYS */;INSERT INTO `users` VALUES (1,'abo','abo','管理员','-04-02 10:01:16');/*!40000 ALTER TABLE `users` ENABLE KEYS */;UNLOCK TABLES;---- Table structure for table `yonghu`--DROP TABLE IF EXISTS `yonghu`;/*!40101 SET @saved_cs_client= @@character_set_client */;/*!40101 SET character_set_client = utf8 */;CREATE TABLE `yonghu` (`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',`yonghuming` varchar(200) NOT NULL COMMENT '用户名',`mima` varchar(200) NOT NULL COMMENT '密码',`xingming` varchar(200) DEFAULT NULL COMMENT '姓名',`touxiang` varchar(200) DEFAULT NULL COMMENT '头像',`xingbie` varchar(200) DEFAULT NULL COMMENT '性别',`shouji` varchar(200) DEFAULT NULL COMMENT '手机',`shenfenzheng` varchar(200) DEFAULT NULL COMMENT '身份证',`hunfou` varchar(200) DEFAULT NULL COMMENT '婚否',PRIMARY KEY (`id`),UNIQUE KEY `yonghuming` (`yonghuming`)) ENGINE=InnoDB AUTO_INCREMENT=1617359331002 DEFAULT CHARSET=utf8 COMMENT='用户';/*!40101 SET character_set_client = @saved_cs_client */;---- Dumping data for table `yonghu`--LOCK TABLES `yonghu` WRITE;/*!40000 ALTER TABLE `yonghu` DISABLE KEYS */;INSERT INTO `yonghu` VALUES (11,'-04-02 10:01:16','用户1','123456','姓名1','http://localhost:8080/ssmer602/upload/yonghu_touxiang1.jpg','男','13823888881','440300199101010001','未婚'),(12,'-04-02 10:01:16','用户2','123456','姓名2','http://localhost:8080/ssmer602/upload/yonghu_touxiang2.jpg','男','13823888882','44030019920002','未婚'),(13,'-04-02 10:01:16','用户3','123456','姓名3','http://localhost:8080/ssmer602/upload/yonghu_touxiang3.jpg','男','13823888883','440300199303030003','未婚'),(14,'-04-02 10:01:16','用户4','123456','姓名4','http://localhost:8080/ssmer602/upload/yonghu_touxiang4.jpg','男','13823888884','440300199404040004','未婚'),(15,'-04-02 10:01:16','用户5','123456','姓名5','http://localhost:8080/ssmer602/upload/yonghu_touxiang5.jpg','男','13823888885','440300199505050005','未婚'),(16,'-04-02 10:01:16','用户6','123456','姓名6','http://localhost:8080/ssmer602/upload/yonghu_touxiang6.jpg','男','13823888886','440300199606060006','未婚'),(1617358565854,'-04-02 10:16:05','1','1','陈一','http://localhost:8080/ssmer602/upload/1617358582151.jpg','女','12345678978','123456789789456123','未婚'),(1617359331001,'-04-02 10:28:51','2','2','张一','http://localhost:8080/ssmer602/upload/1617359342132.jpg','女','12345678978','123456789987456321','已婚');/*!40000 ALTER TABLE `yonghu` ENABLE KEYS */;UNLOCK TABLES;/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;-- Dump completed on -04-02 21:32:43
