基于微信小程序的美容院管理系统设计与实现-计算机毕业设计源码+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 */;

资源下载：

下载地址： http://yemao.in/life?utm_source=sishubiji&utm_term=基于微信小程序的美容院管理系统设计与实现-计算机毕业设计源码+LW文档