基于微信小程序的美容院管理系统设计与实现-计算机毕业设计源码+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=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','健美容产品所取代乃是化妆品的大势所趋。二十世纪的化妆品市场将会是生物技术和基因技术的天下。美容化妆品市场在经历了矿物质，羊脂油，纯植物，化工合成品这四代的演化发展...','
健美容产品所取代乃是化妆品的大势所趋。二十世纪的化妆品市场将会是生物技术和基因技术的天下。美容化妆品市场在经历了矿物质，羊脂油，纯植物，化工合成品这四代的演化发展...
');
/!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','
健美容产品所取代乃是化妆品的大势所趋。二十世纪的化妆品市场将会是生物技术和基因技术的天下。美容化妆品市场在经历了矿物质，羊脂油，纯植物，化工合成品这四代的演化发展...
',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 */;
