基于微信小程序视力保养连锁预约系统-计算机毕业设计源码+LW文档

大家好，欢迎来到IT知识分享网。

小程序开发说明

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