基于微信小程序的視力保養(yǎng)連鎖預(yù)約系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn)-計(jì)算機(jī)畢業(yè)設(shè)計(jì)源碼+LW文檔
小程序開發(fā)說明
開發(fā)語言：Java
框架：ssm
JDK版本：JDK1.8
服務(wù)器：tomcat7
數(shù)據(jù)庫：mysql 5.7（一定要5.7版本）
數(shù)據(jù)庫工具：Navicat11
開發(fā)軟件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
瀏覽器：谷歌瀏覽器
小程序框架：uniapp
小程序開發(fā)軟件：HBuilder X
小程序運(yùn)行軟件：微信開發(fā)者
數(shù)據(jù)庫腳本：
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 '創(chuàng)建時(shí)間',
? `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 '是否默認(rèn)地址[是/否]',
? 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 '創(chuàng)建時(shí)間',
? `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 '購買數(shù)量',
? `price` float DEFAULT NULL COMMENT '單價(jià)',
? `discountprice` float DEFAULT NULL COMMENT '會員價(jià)',
? `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 '配置參數(shù)名稱',
? `value` varchar(100) DEFAULT NULL COMMENT '配置參數(shù)值',
? 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 '創(chuàng)建時(shí)間',
? `refid` bigint(20) NOT NULL COMMENT '關(guān)聯(lián)表id',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `nickname` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `content` longtext NOT NULL COMMENT '評論內(nèi)容',
? `reply` longtext COMMENT '回復(fù)內(nèi)容',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=137 DEFAULT CHARSET=utf8 COMMENT='服務(wù)項(xiàng)目評論表';
/*!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','評論內(nèi)容1','回復(fù)內(nèi)容1'),(132,'2022-04-12 07:54:21',2,2,'用戶名2','評論內(nèi)容2','回復(fù)內(nèi)容2'),(133,'2022-04-12 07:54:21',3,3,'用戶名3','評論內(nèi)容3','回復(fù)內(nèi)容3'),(134,'2022-04-12 07:54:21',4,4,'用戶名4','評論內(nèi)容4','回復(fù)內(nèi)容4'),(135,'2022-04-12 07:54:22',5,5,'用戶名5','評論內(nèi)容5','回復(fù)內(nèi)容5'),(136,'2022-04-12 07:54:22',6,6,'用戶名6','評論內(nèi)容6','回復(fù)內(nèi)容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 '創(chuàng)建時(shí)間',
? `refid` bigint(20) NOT NULL COMMENT '關(guān)聯(lián)表id',
? `userid` bigint(20) NOT NULL COMMENT '用戶id',
? `nickname` varchar(200) DEFAULT NULL COMMENT '用戶名',
? `content` longtext NOT NULL COMMENT '評論內(nèi)容',
? `reply` longtext COMMENT '回復(fù)內(nèi)容',
? 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','評論內(nèi)容1','回復(fù)內(nèi)容1'),(142,'2022-04-12 07:54:22',2,2,'用戶名2','評論內(nèi)容2','回復(fù)內(nèi)容2'),(143,'2022-04-12 07:54:22',3,3,'用戶名3','評論內(nèi)容3','回復(fù)內(nèi)容3'),(144,'2022-04-12 07:54:22',4,4,'用戶名4','評論內(nèi)容4','回復(fù)內(nèi)容4'),(145,'2022-04-12 07:54:22',5,5,'用戶名5','評論內(nèi)容5','回復(fù)內(nèi)容5'),(146,'2022-04-12 07:54:22',6,6,'用戶名6','評論內(nèi)容6','回復(fù)內(nèi)容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 '創(chuàng)建時(shí)間',
? `xiangmubianhao` varchar(200) DEFAULT NULL COMMENT '項(xiàng)目編號',
? `xiangmumingcheng` varchar(200) DEFAULT NULL COMMENT '項(xiàng)目名稱',
? `xiangmuleixing` varchar(200) DEFAULT NULL COMMENT '項(xiàng)目類型',
? `jiage` float DEFAULT NULL COMMENT '價(jià)格',
? `fengmian` varchar(200) DEFAULT NULL COMMENT '封面',
? `xiangxijieshao` longtext COMMENT '詳細(xì)介紹',
? `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 '最近點(diǎn)擊時(shí)間',
? `clicknum` int(11) DEFAULT '0' COMMENT '點(diǎn)擊次數(shù)',
? PRIMARY KEY (`id`),
? UNIQUE KEY `xiangmubianhao` (`xiangmubianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='服務(wù)項(xiàng)目';
/*!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','項(xiàng)目名稱1','項(xiàng)目類型1',1,'upload/fuwuxiangmu_fengmian1.jpg','詳細(xì)介紹1','門店賬號1','門店名稱1',1,1,'2022-04-12 15:54:21',1),(42,'2022-04-12 07:54:21','2222222222','項(xiàng)目名稱2','項(xiàng)目類型2',2,'upload/fuwuxiangmu_fengmian2.jpg','詳細(xì)介紹2','門店賬號2','門店名稱2',2,2,'2022-04-12 15:54:21',2),(43,'2022-04-12 07:54:21','3333333333','項(xiàng)目名稱3','項(xiàng)目類型3',3,'upload/fuwuxiangmu_fengmian3.jpg','詳細(xì)介紹3','門店賬號3','門店名稱3',3,3,'2022-04-12 15:54:21',3),(44,'2022-04-12 07:54:21','4444444444','項(xiàng)目名稱4','項(xiàng)目類型4',4,'upload/fuwuxiangmu_fengmian4.jpg','詳細(xì)介紹4','門店賬號4','門店名稱4',4,4,'2022-04-12 15:54:21',4),(45,'2022-04-12 07:54:21','5555555555','項(xiàng)目名稱5','項(xiàng)目類型5',5,'upload/fuwuxiangmu_fengmian5.jpg','詳細(xì)介紹5','門店賬號5','門店名稱5',5,5,'2022-04-12 15:54:21',5),(46,'2022-04-12 07:54:21','6666666666','項(xiàng)目名稱6','項(xiàng)目類型6',6,'upload/fuwuxiangmu_fengmian6.jpg','詳細(xì)介紹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 '創(chuàng)建時(shí)間',
? `mendianzhanghao` varchar(200) NOT NULL COMMENT '門店賬號',
? `mima` varchar(200) NOT NULL COMMENT '密碼',
? `mendianmingcheng` varchar(200) NOT NULL COMMENT '門店名稱',
? `fuzeren` varchar(200) DEFAULT NULL COMMENT '負(fù)責(zé)人',
? `lianxidianhua` varchar(200) DEFAULT NULL COMMENT '聯(lián)系電話',
? `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','負(fù)責(zé)人1','13823888881','upload/mendian_dianputupian1.jpg','店鋪地址1',100),(22,'2022-04-12 07:54:21','門店賬號2','123456','門店名稱2','負(fù)責(zé)人2','13823888882','upload/mendian_dianputupian2.jpg','店鋪地址2',100),(23,'2022-04-12 07:54:21','門店賬號3','123456','門店名稱3','負(fù)責(zé)人3','13823888883','upload/mendian_dianputupian3.jpg','店鋪地址3',100),(24,'2022-04-12 07:54:21','門店賬號4','123456','門店名稱4','負(fù)責(zé)人4','13823888884','upload/mendian_dianputupian4.jpg','店鋪地址4',100),(25,'2022-04-12 07:54:21','門店賬號5','123456','門店名稱5','負(fù)責(zé)人5','13823888885','upload/mendian_dianputupian5.jpg','店鋪地址5',100),(26,'2022-04-12 07:54:21','門店賬號6','123456','門店名稱6','負(fù)責(zé)人6','13823888886','upload/mendian_dianputupian6.jpg','店鋪地址6',100);
/*!40000 ALTER TABLE `mendian` ENABLE KEYS */;
UNLOCK TABLES;
