基于微信小程序的视力保养连锁预约系统设计与实现-计算机毕业设计源码+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 ​​address​​; /*!40101 SET @saved_cs_client = @@character_set_client /; /!40101 SET character_set_client = utf8 /; CREATE TABLE ​​address​​​ ( ​​id​​ bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', ​​​addtime​​​ timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', ​​​userid​​​ bigint(20) NOT NULL COMMENT '用户id', ​​​address​​​ varchar(200) NOT NULL COMMENT '地址', ​​​name​​​ varchar(200) NOT NULL COMMENT '收货人', ​​​phone​​​ varchar(200) NOT NULL COMMENT '电话', ​​​isdefault​​​ varchar(200) NOT 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 ​​address​​ --

LOCK TABLES ​​address​​ WRITE; /*!40000 ALTER TABLE ​​address​​ DISABLE KEYS /; INSERT INTO ​​address​​​ VALUES (1,'2022-04-12 07:54:21',11,'宇宙银河系金星1号','金某','13823888881','是'),(2,'2022-04-12 07:54:21',12,'宇宙银河系木星1号','木某','13823888882','是'),(3,'2022-04-12 07:54:21',13,'宇宙银河系水星1号','水某','13823888883','是'),(4,'2022-04-12 07:54:21',14,'宇宙银河系火星1号','火某','13823888884','是'),(5,'2022-04-12 07:54:21',15,'宇宙银河系土星1号','土某','13823888885','是'),(6,'2022-04-12 07:54:21',16,'宇宙银河系月球1号','月某','13823888886','是'); /!40000 ALTER TABLE ​​address​​ ENABLE KEYS */; UNLOCK TABLES;

-- -- Table structure for table ​​cart​​ --

DROP TABLE IF EXISTS ​​cart​​; /*!40101 SET @saved_cs_client = @@character_set_client /; /!40101 SET character_set_client = utf8 /; CREATE TABLE ​​cart​​​ ( ​​id​​ bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', ​​​addtime​​​ timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', ​​​tablename​​​ varchar(200) DEFAULT 'shangpinxinxi' COMMENT '商品表名', ​​​userid​​​ bigint(20) NOT NULL COMMENT '用户id', ​​​goodid​​​ bigint(20) NOT NULL COMMENT '商品id', ​​​goodname​​​ varchar(200) DEFAULT NULL COMMENT '商品名称', ​​​picture​​​ varchar(200) DEFAULT NULL COMMENT '图片', ​​​buynumber​​​ int(11) NOT NULL COMMENT '购买数量', ​​​price​​​ float DEFAULT NULL COMMENT '单价', ​​​discountprice​​​ float DEFAULT NULL COMMENT '会员价', ​​​mendianzhanghao​​​ varchar(200) DEFAULT NULL COMMENT '商户名称', PRIMARY KEY (​​​id​​​) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='购物车表'; /!40101 SET character_set_client = @saved_cs_client */;

-- -- Dumping data for table ​​cart​​ --

LOCK TABLES ​​cart​​ WRITE; /*!40000 ALTER TABLE ​​cart​​ DISABLE KEYS /; /!40000 ALTER TABLE ​​cart​​ 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=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 ​​discussfuwuxiangmu​​ --

DROP TABLE IF EXISTS ​​discussfuwuxiangmu​​; /*!40101 SET @saved_cs_client = @@character_set_client /; /!40101 SET character_set_client = utf8 /; CREATE TABLE ​​discussfuwuxiangmu​​​ ( ​​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=137 DEFAULT CHARSET=utf8 COMMENT='服务项目评论表'; /!40101 SET character_set_client = @saved_cs_client */;

-- -- Dumping data for table ​​discussfuwuxiangmu​​ --

LOCK TABLES ​​discussfuwuxiangmu​​ WRITE; /*!40000 ALTER TABLE ​​discussfuwuxiangmu​​ DISABLE KEYS /; INSERT INTO ​​discussfuwuxiangmu​​​ VALUES (131,'2022-04-12 07:54:21',1,1,'用户名1','评论内容1','回复内容1'),(132,'2022-04-12 07:54:21',2,2,'用户名2','评论内容2','回复内容2'),(133,'2022-04-12 07:54:21',3,3,'用户名3','评论内容3','回复内容3'),(134,'2022-04-12 07:54:21',4,4,'用户名4','评论内容4','回复内容4'),(135,'2022-04-12 07:54:22',5,5,'用户名5','评论内容5','回复内容5'),(136,'2022-04-12 07:54:22',6,6,'用户名6','评论内容6','回复内容6'); /!40000 ALTER TABLE ​​discussfuwuxiangmu​​ ENABLE KEYS */; UNLOCK TABLES;

-- -- Table structure for table ​​discussshangpinxinxi​​ --

DROP TABLE IF EXISTS ​​discussshangpinxinxi​​; /*!40101 SET @saved_cs_client = @@character_set_client /; /!40101 SET character_set_client = utf8 /; CREATE TABLE ​​discussshangpinxinxi​​​ ( ​​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=147 DEFAULT CHARSET=utf8 COMMENT='商品信息评论表'; /!40101 SET character_set_client = @saved_cs_client */;

-- -- Dumping data for table ​​discussshangpinxinxi​​ --

LOCK TABLES ​​discussshangpinxinxi​​ WRITE; /*!40000 ALTER TABLE ​​discussshangpinxinxi​​ DISABLE KEYS /; INSERT INTO ​​discussshangpinxinxi​​​ VALUES (141,'2022-04-12 07:54:22',1,1,'用户名1','评论内容1','回复内容1'),(142,'2022-04-12 07:54:22',2,2,'用户名2','评论内容2','回复内容2'),(143,'2022-04-12 07:54:22',3,3,'用户名3','评论内容3','回复内容3'),(144,'2022-04-12 07:54:22',4,4,'用户名4','评论内容4','回复内容4'),(145,'2022-04-12 07:54:22',5,5,'用户名5','评论内容5','回复内容5'),(146,'2022-04-12 07:54:22',6,6,'用户名6','评论内容6','回复内容6'); /!40000 ALTER TABLE ​​discussshangpinxinxi​​ ENABLE KEYS */; UNLOCK TABLES;

-- -- Table structure for table ​​fuwuxiangmu​​ --

DROP TABLE IF EXISTS ​​fuwuxiangmu​​; /*!40101 SET @saved_cs_client = @@character_set_client /; /!40101 SET character_set_client = utf8 /; CREATE TABLE ​​fuwuxiangmu​​​ ( ​​id​​ bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', ​​​addtime​​​ timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', ​​​xiangmubianhao​​​ varchar(200) DEFAULT NULL COMMENT '项目编号', ​​​xiangmumingcheng​​​ varchar(200) DEFAULT NULL COMMENT '项目名称', ​​​xiangmuleixing​​​ varchar(200) DEFAULT NULL COMMENT '项目类型', ​​​jiage​​​ float DEFAULT NULL COMMENT '价格', ​​​fengmian​​​ varchar(200) DEFAULT NULL COMMENT '封面', ​​​xiangxijieshao​​​ longtext COMMENT '详细介绍', ​​​mendianzhanghao​​​ varchar(200) DEFAULT NULL COMMENT '门店账号', ​​​mendianmingcheng​​​ varchar(200) DEFAULT NULL COMMENT '门店名称', ​​​thumbsupnum​​​ int(11) DEFAULT '0' COMMENT '赞', ​​​crazilynum​​​ int(11) DEFAULT '0' COMMENT '踩', ​​​clicktime​​​ datetime DEFAULT NULL COMMENT '最近点击时间', ​​​clicknum​​​ int(11) DEFAULT '0' COMMENT '点击次数', PRIMARY KEY (​​​id​​​), UNIQUE KEY ​​​xiangmubianhao​​​ (​​​xiangmubianhao​​​) ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='服务项目'; /!40101 SET character_set_client = @saved_cs_client */;

-- -- Dumping data for table ​​fuwuxiangmu​​ --

LOCK TABLES ​​fuwuxiangmu​​ WRITE; /*!40000 ALTER TABLE ​​fuwuxiangmu​​ DISABLE KEYS /; INSERT INTO ​​fuwuxiangmu​​​ VALUES (41,'2022-04-12 07:54:21','1111111111','项目名称1','项目类型1',1,'upload/fuwuxiangmu_fengmian1.jpg','详细介绍1','门店账号1','门店名称1',1,1,'2022-04-12 15:54:21',1),(42,'2022-04-12 07:54:21','2222222222','项目名称2','项目类型2',2,'upload/fuwuxiangmu_fengmian2.jpg','详细介绍2','门店账号2','门店名称2',2,2,'2022-04-12 15:54:21',2),(43,'2022-04-12 07:54:21','3333333333','项目名称3','项目类型3',3,'upload/fuwuxiangmu_fengmian3.jpg','详细介绍3','门店账号3','门店名称3',3,3,'2022-04-12 15:54:21',3),(44,'2022-04-12 07:54:21','4444444444','项目名称4','项目类型4',4,'upload/fuwuxiangmu_fengmian4.jpg','详细介绍4','门店账号4','门店名称4',4,4,'2022-04-12 15:54:21',4),(45,'2022-04-12 07:54:21','5555555555','项目名称5','项目类型5',5,'upload/fuwuxiangmu_fengmian5.jpg','详细介绍5','门店账号5','门店名称5',5,5,'2022-04-12 15:54:21',5),(46,'2022-04-12 07:54:21','6666666666','项目名称6','项目类型6',6,'upload/fuwuxiangmu_fengmian6.jpg','详细介绍6','门店账号6','门店名称6',6,6,'2022-04-12 15:54:21',6); /!40000 ALTER TABLE ​​fuwuxiangmu​​ ENABLE KEYS */; UNLOCK TABLES;

-- -- Table structure for table ​​mendian​​ --

DROP TABLE IF EXISTS ​​mendian​​; /*!40101 SET @saved_cs_client = @@character_set_client /; /!40101 SET character_set_client = utf8 /; CREATE TABLE ​​mendian​​​ ( ​​id​​ bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键', ​​​addtime​​​ timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', ​​​mendianzhanghao​​​ varchar(200) NOT NULL COMMENT '门店账号', ​​​mima​​​ varchar(200) NOT NULL COMMENT '密码', ​​​mendianmingcheng​​​ varchar(200) NOT NULL COMMENT '门店名称', ​​​fuzeren​​​ varchar(200) DEFAULT NULL COMMENT '负责人', ​​​lianxidianhua​​​ varchar(200) DEFAULT NULL COMMENT '联系电话', ​​​dianputupian​​​ varchar(200) DEFAULT NULL COMMENT '店铺图片', ​​​dianpudizhi​​​ varchar(200) DEFAULT NULL COMMENT '店铺地址', ​​​money​​​ float DEFAULT '0' COMMENT '余额', PRIMARY KEY (​​​id​​​), UNIQUE KEY ​​​mendianzhanghao​​​ (​​​mendianzhanghao​​​) ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 COMMENT='门店'; /!40101 SET character_set_client = @saved_cs_client */;

-- -- Dumping data for table ​​mendian​​ --

LOCK TABLES ​​mendian​​​ WRITE; /*!40000 ALTER TABLE ​​​mendian​​ DISABLE KEYS /; INSERT INTO ​​mendian​​​ VALUES (21,'2022-04-12 07:54:21','门店账号1','123456','门店名称1','负责人1','13823888881','upload/mendian_dianputupian1.jpg','店铺地址1',100),(22,'2022-04-12 07:54:21','门店账号2','123456','门店名称2','负责人2','13823888882','upload/mendian_dianputupian2.jpg','店铺地址2',100),(23,'2022-04-12 07:54:21','门店账号3','123456','门店名称3','负责人3','13823888883','upload/mendian_dianputupian3.jpg','店铺地址3',100),(24,'2022-04-12 07:54:21','门店账号4','123456','门店名称4','负责人4','13823888884','upload/mendian_dianputupian4.jpg','店铺地址4',100),(25,'2022-04-12 07:54:21','门店账号5','123456','门店名称5','负责人5','13823888885','upload/mendian_dianputupian5.jpg','店铺地址5',100),(26,'2022-04-12 07:54:21','门店账号6','123456','门店名称6','负责人6','13823888886','upload/mendian_dianputupian6.jpg','店铺地址6',100); /!40000 ALTER TABLE ​​mendian​​ ENABLE KEYS */; UNLOCK TABLES;