基于微信小程序的美容院管理系統(tǒng)設(shè)計與實現(xiàn)-計算機畢業(yè)設(shè)計源碼+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
小程序運行軟件：微信開發(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)建時間',
? `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=1647526986518 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-03-17 14:18:36',11,'宇宙銀河系金星1號','金某','13823888881','是'),(2,'2022-03-17 14:18:36',12,'宇宙銀河系木星1號','木某','13823888882','是'),(3,'2022-03-17 14:18:36',13,'宇宙銀河系水星1號','水某','13823888883','是'),(4,'2022-03-17 14:18:36',14,'宇宙銀河系火星1號','火某','13823888884','是'),(5,'2022-03-17 14:18:36',15,'宇宙銀河系土星1號','土某','13823888885','是'),(6,'2022-03-17 14:18:36',16,'宇宙銀河系月球1號','月某','13823888886','是'),(1647526986517,'2022-03-17 14:23:05',1647526949400,'廣東省','小小','13613613666','否');
/*!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)建時間',
? `tablename` varchar(200) DEFAULT 'chanpinxinxi' 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 '單價',
? `discountprice` float DEFAULT NULL COMMENT '會員價',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1647526971517 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 `chanpinfenlei`
--
DROP TABLE IF EXISTS `chanpinfenlei`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chanpinfenlei` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',
? `chanpinfenlei` varchar(200) NOT NULL COMMENT '產(chǎn)品分類',
? PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1647526872417 DEFAULT CHARSET=utf8 COMMENT='產(chǎn)品分類';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `chanpinfenlei`
--
LOCK TABLES `chanpinfenlei` WRITE;
/*!40000 ALTER TABLE `chanpinfenlei` DISABLE KEYS */;
INSERT INTO `chanpinfenlei` VALUES (51,'2022-03-17 14:18:36','產(chǎn)品分類1'),(52,'2022-03-17 14:18:36','產(chǎn)品分類2'),(53,'2022-03-17 14:18:36','產(chǎn)品分類3'),(54,'2022-03-17 14:18:36','產(chǎn)品分類4'),(55,'2022-03-17 14:18:36','產(chǎn)品分類5'),(56,'2022-03-17 14:18:36','產(chǎn)品分類6'),(1647526872416,'2022-03-17 14:21:12','111');
/*!40000 ALTER TABLE `chanpinfenlei` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `chanpinfuwu`
--
DROP TABLE IF EXISTS `chanpinfuwu`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chanpinfuwu` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',
? `fuwubianhao` varchar(200) DEFAULT NULL COMMENT '服務(wù)編號',
? `fuwumingcheng` varchar(200) DEFAULT NULL COMMENT '服務(wù)名稱',
? `fuwuleixing` varchar(200) DEFAULT NULL COMMENT '服務(wù)類型',
? `tupian` varchar(200) DEFAULT NULL COMMENT '圖片',
? `fuwuneirong` longtext COMMENT '服務(wù)內(nèi)容',
? `fuwujieshao` longtext COMMENT '服務(wù)介紹',
? PRIMARY KEY (`id`),
? UNIQUE KEY `fuwubianhao` (`fuwubianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1647526859650 DEFAULT CHARSET=utf8 COMMENT='產(chǎn)品服務(wù)';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `chanpinfuwu`
--
LOCK TABLES `chanpinfuwu` WRITE;
/*!40000 ALTER TABLE `chanpinfuwu` DISABLE KEYS */;
INSERT INTO `chanpinfuwu` VALUES (31,'2022-03-17 14:18:36','1111111111','服務(wù)名稱1','服務(wù)類型1','upload/chanpinfuwu_tupian1.jpg','服務(wù)內(nèi)容1','服務(wù)介紹1'),(32,'2022-03-17 14:18:36','2222222222','服務(wù)名稱2','服務(wù)類型2','upload/chanpinfuwu_tupian2.jpg','服務(wù)內(nèi)容2','服務(wù)介紹2'),(33,'2022-03-17 14:18:36','3333333333','服務(wù)名稱3','服務(wù)類型3','upload/chanpinfuwu_tupian3.jpg','服務(wù)內(nèi)容3','服務(wù)介紹3'),(34,'2022-03-17 14:18:36','4444444444','服務(wù)名稱4','服務(wù)類型4','upload/chanpinfuwu_tupian4.jpg','服務(wù)內(nèi)容4','服務(wù)介紹4'),(35,'2022-03-17 14:18:36','5555555555','服務(wù)名稱5','服務(wù)類型5','upload/chanpinfuwu_tupian5.jpg','服務(wù)內(nèi)容5','服務(wù)介紹5'),(36,'2022-03-17 14:18:36','6666666666','服務(wù)名稱6','服務(wù)類型6','upload/chanpinfuwu_tupian6.jpg','服務(wù)內(nèi)容6','服務(wù)介紹6'),(1647526859649,'2022-03-17 14:20:59','1647526796396','護膚','洗臉','upload/1647526847319.jpg','健美容產(chǎn)品所取代乃是化妝品的大勢所趨。二十世紀的化妝品市場將會是生物技術(shù)和基因技術(shù)的天下。美容化妝品市場在經(jīng)歷了礦物質(zhì)，羊脂油，純植物，化工合成品這四代的演化發(fā)展...','<p><span style=\"background-color: rgb(255, 255, 255); color: rgb(51, 51, 51);\">健</span><span style=\"background-color: rgb(255, 255, 255); color: rgb(247, 49, 49);\">美容產(chǎn)品</span><span style=\"background-color: rgb(255, 255, 255); color: rgb(51, 51, 51);\">所取代乃是化妝品的大勢所趨。二十世紀的化妝品市場將會是生物技術(shù)和基因技術(shù)的天下。美容化妝品市場在經(jīng)歷了礦物質(zhì)，羊脂油，純植物，化工合成品這四代的演化發(fā)展...</span></p>');
/*!40000 ALTER TABLE `chanpinfuwu` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `chanpinxinxi`
--
DROP TABLE IF EXISTS `chanpinxinxi`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `chanpinxinxi` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',
? `chanpinbianhao` varchar(200) DEFAULT NULL COMMENT '產(chǎn)品編號',
? `chanpinmingcheng` varchar(200) DEFAULT NULL COMMENT '產(chǎn)品名稱',
? `chanpinfenlei` varchar(200) DEFAULT NULL COMMENT '產(chǎn)品分類',
? `tupian` varchar(200) DEFAULT NULL COMMENT '圖片',
? `pinpai` varchar(200) DEFAULT NULL COMMENT '品牌',
? `guige` varchar(200) DEFAULT NULL COMMENT '規(guī)格',
? `chanpinxiangqing` longtext COMMENT '產(chǎn)品詳情',
? `price` float DEFAULT NULL COMMENT '價格',
? PRIMARY KEY (`id`),
? UNIQUE KEY `chanpinbianhao` (`chanpinbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1647526898760 DEFAULT CHARSET=utf8 COMMENT='產(chǎn)品信息';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `chanpinxinxi`
--
LOCK TABLES `chanpinxinxi` WRITE;
/*!40000 ALTER TABLE `chanpinxinxi` DISABLE KEYS */;
INSERT INTO `chanpinxinxi` VALUES (61,'2022-03-17 14:18:36','1111111111','產(chǎn)品名稱1','產(chǎn)品分類1','upload/chanpinxinxi_tupian1.jpg','品牌1','規(guī)格1','產(chǎn)品詳情1',99.9),(62,'2022-03-17 14:18:36','2222222222','產(chǎn)品名稱2','產(chǎn)品分類2','upload/chanpinxinxi_tupian2.jpg','品牌2','規(guī)格2','產(chǎn)品詳情2',99.9),(63,'2022-03-17 14:18:36','3333333333','產(chǎn)品名稱3','產(chǎn)品分類3','upload/chanpinxinxi_tupian3.jpg','品牌3','規(guī)格3','產(chǎn)品詳情3',99.9),(64,'2022-03-17 14:18:36','4444444444','產(chǎn)品名稱4','產(chǎn)品分類4','upload/chanpinxinxi_tupian4.jpg','品牌4','規(guī)格4','產(chǎn)品詳情4',99.9),(65,'2022-03-17 14:18:36','5555555555','產(chǎn)品名稱5','產(chǎn)品分類5','upload/chanpinxinxi_tupian5.jpg','品牌5','規(guī)格5','產(chǎn)品詳情5',99.9),(66,'2022-03-17 14:18:36','6666666666','產(chǎn)品名稱6','產(chǎn)品分類6','upload/chanpinxinxi_tupian6.jpg','品牌6','規(guī)格6','產(chǎn)品詳情6',99.9),(1647526898759,'2022-03-17 14:21:38','1647526834078','雅詩蘭黛','111','upload/1647526887551.jpg','安安','250g','<p><span style=\"background-color: rgb(255, 255, 255); color: rgb(51, 51, 51);\">健</span><span style=\"background-color: rgb(255, 255, 255); color: rgb(247, 49, 49);\">美容產(chǎn)品</span><span style=\"background-color: rgb(255, 255, 255); color: rgb(51, 51, 51);\">所取代乃是化妝品的大勢所趨。二十世紀的化妝品市場將會是生物技術(shù)和基因技術(shù)的天下。美容化妝品市場在經(jīng)歷了礦物質(zhì)，羊脂油，純植物，化工合成品這四代的演化發(fā)展...</span></p>',398);
/*!40000 ALTER TABLE `chanpinxinxi` 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/1647526931665.jpg'),(2,'picture2','upload/picture2.jpg'),(3,'picture3','upload/picture3.jpg');
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `discusschanpinxinxi`
--
DROP TABLE IF EXISTS `discusschanpinxinxi`;
/*!40101 SET @saved_cs_client? ? ?= @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `discusschanpinxinxi` (
? `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
? `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '創(chuàng)建時間',
? `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=1647527157021 DEFAULT CHARSET=utf8 COMMENT='產(chǎn)品信息評論表';
/*!40101 SET character_set_client = @saved_cs_client */;
