基于微信小程序的美容院管理系统-计算机毕业设计源码+LW文档(服務產品分類畢業設計)
admin
开发语言：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=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 '创建时间',
`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 '购买数量',
`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 '创建时间',
`chanpinfenlei` varchar(200) NOT NULL COMMENT '产品分类',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1647526872417 DEFAULT CHARSET=utf8 COMMENT='产品分类';
/!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','产品分类1'),(52,'2022-03-17 14:18:36','产品分类2'),(53,'2022-03-17 14:18:36','产品分类3'),(54,'2022-03-17 14:18:36','产品分类4'),(55,'2022-03-17 14:18:36','产品分类5'),(56,'2022-03-17 14:18:36','产品分类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 '创建时间',
`fuwubianhao` varchar(200) DEFAULT NULL COMMENT '服务编号',
`fuwumingcheng` varchar(200) DEFAULT NULL COMMENT '服务名称',
`fuwuleixing` varchar(200) DEFAULT NULL COMMENT '服务类型',
`tupian` varchar(200) DEFAULT NULL COMMENT '图片',
`fuwuneirong` longtext COMMENT '服务内容',
`fuwujieshao` longtext COMMENT '服务介绍',
PRIMARY KEY (`id`),
UNIQUE KEY `fuwubianhao` (`fuwubianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1647526859650 DEFAULT CHARSET=utf8 COMMENT='产品服务';
/!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','服务名称1','服务类型1','upload/chanpinfuwu_tupian1.jpg','服务内容1','服务介绍1'),(32,'2022-03-17 14:18:36','2222222222','服务名称2','服务类型2','upload/chanpinfuwu_tupian2.jpg','服务内容2','服务介绍2'),(33,'2022-03-17 14:18:36','3333333333','服务名称3','服务类型3','upload/chanpinfuwu_tupian3.jpg','服务内容3','服务介绍3'),(34,'2022-03-17 14:18:36','4444444444','服务名称4','服务类型4','upload/chanpinfuwu_tupian4.jpg','服务内容4','服务介绍4'),(35,'2022-03-17 14:18:36','5555555555','服务名称5','服务类型5','upload/chanpinfuwu_tupian5.jpg','服务内容5','服务介绍5'),(36,'2022-03-17 14:18:36','6666666666','服务名称6','服务类型6','upload/chanpinfuwu_tupian6.jpg','服务内容6','服务介绍6'),(1647526859649,'2022-03-17 14:20:59','1647526796396','护肤','洗脸','upload/1647526847319.jpg','健美容产品所取代乃是化妆品的大势所趋。二十世纪的化妆品市场将会是生物技术和基因技术的天下。美容化妆品市场在经历了矿物质，羊脂油，纯植物，化工合成品这四代的演化发展...','<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);\">美容产品</span><span style=\"background-color: rgb(255, 255, 255); color: rgb(51, 51, 51);\">所取代乃是化妆品的大势所趋。二十世纪的化妆品市场将会是生物技术和基因技术的天下。美容化妆品市场在经历了矿物质，羊脂油，纯植物，化工合成品这四代的演化发展...</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 '创建时间',
`chanpinbianhao` varchar(200) DEFAULT NULL COMMENT '产品编号',
`chanpinmingcheng` varchar(200) DEFAULT NULL COMMENT '产品名称',
`chanpinfenlei` varchar(200) DEFAULT NULL COMMENT '产品分类',
`tupian` varchar(200) DEFAULT NULL COMMENT '图片',
`pinpai` varchar(200) DEFAULT NULL COMMENT '品牌',
`guige` varchar(200) DEFAULT NULL COMMENT '规格',
`chanpinxiangqing` longtext COMMENT '产品详情',
`price` float DEFAULT NULL COMMENT '价格',
PRIMARY KEY (`id`),
UNIQUE KEY `chanpinbianhao` (`chanpinbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=1647526898760 DEFAULT CHARSET=utf8 COMMENT='产品信息';
/!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','产品名称1','产品分类1','upload/chanpinxinxi_tupian1.jpg','品牌1','规格1','产品详情1',99.9),(62,'2022-03-17 14:18:36','2222222222','产品名称2','产品分类2','upload/chanpinxinxi_tupian2.jpg','品牌2','规格2','产品详情2',99.9),(63,'2022-03-17 14:18:36','3333333333','产品名称3','产品分类3','upload/chanpinxinxi_tupian3.jpg','品牌3','规格3','产品详情3',99.9),(64,'2022-03-17 14:18:36','4444444444','产品名称4','产品分类4','upload/chanpinxinxi_tupian4.jpg','品牌4','规格4','产品详情4',99.9),(65,'2022-03-17 14:18:36','5555555555','产品名称5','产品分类5','upload/chanpinxinxi_tupian5.jpg','品牌5','规格5','产品详情5',99.9),(66,'2022-03-17 14:18:36','6666666666','产品名称6','产品分类6','upload/chanpinxinxi_tupian6.jpg','品牌6','规格6','产品详情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);\">美容产品</span><span style=\"background-color: rgb(255, 255, 255); color: rgb(51, 51, 51);\">所取代乃是化妆品的大势所趋。二十世纪的化妆品市场将会是生物技术和基因技术的天下。美容化妆品市场在经历了矿物质，羊脂油，纯植物，化工合成品这四代的演化发展...</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 '配置参数名称',
`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/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 '创建时间',
`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=1647527157021 DEFAULT CHARSET=utf8 COMMENT='产品信息评论表';
/!40101 SET character_set_client = @saved_cs_client /;
