小程序开发说明
开发语言：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=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-16 09:01:03′,11,’宇宙银河系金星1号’,’金某’,’13823888881′,’是’),(2,’2022-04-16 09:01:03′,12,’宇宙银河系木星1号’,’木某’,’13823888882′,’是’),(3,’2022-04-16 09:01:03′,13,’宇宙银河系水星1号’,’水某’,’13823888883′,’是’),(4,’2022-04-16 09:01:03′,14,’宇宙银河系火星1号’,’火某’,’13823888884′,’是’),(5,’2022-04-16 09:01:03′,15,’宇宙银河系土星1号’,’土某’,’13823888885′,’是’),(6,’2022-04-16 09:01:03′,16,’宇宙银河系月球1号’,’月某’,’13823888886′,’是’);
/*!40000 ALTER TABLE `address` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `caipinfenlei`
—
DROP TABLE IF EXISTS `caipinfenlei`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `caipinfenlei` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`caipinfenlei` varchar(200) NOT NULL COMMENT ‘菜品分类’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT=’菜品分类’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `caipinfenlei`
—
LOCK TABLES `caipinfenlei` WRITE;
/*!40000 ALTER TABLE `caipinfenlei` DISABLE KEYS */;
INSERT INTO `caipinfenlei` VALUES (41,’2022-04-16 09:01:03′,’菜品分类1′),(42,’2022-04-16 09:01:03′,’菜品分类2′),(43,’2022-04-16 09:01:03′,’菜品分类3′),(44,’2022-04-16 09:01:03′,’菜品分类4′),(45,’2022-04-16 09:01:03′,’菜品分类5′),(46,’2022-04-16 09:01:03′,’菜品分类6′);
/*!40000 ALTER TABLE `caipinfenlei` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `caipinxinxi`
—
DROP TABLE IF EXISTS `caipinxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `caipinxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`caipinbianhao` varchar(200) DEFAULT NULL COMMENT ‘菜品编号’,
`dianpuxinxi` varchar(200) DEFAULT NULL COMMENT ‘店铺信息’,
`caipinmingcheng` varchar(200) NOT NULL COMMENT ‘菜品名称’,
`caipinfenlei` varchar(200) NOT NULL COMMENT ‘菜品分类’,
`kouwei` varchar(200) DEFAULT NULL COMMENT ‘口味’,
`fenliang` varchar(200) DEFAULT NULL COMMENT ‘份量’,
`tupian` varchar(200) DEFAULT NULL COMMENT ‘图片’,
`shangjiariqi` date DEFAULT NULL COMMENT ‘上架日期’,
`caipinjieshao` longtext COMMENT ‘菜品介绍’,
`shangjiazhanghao` varchar(200) DEFAULT NULL COMMENT ‘商家账号’,
`shangjiaxingming` varchar(200) DEFAULT NULL COMMENT ‘商家姓名’,
`price` float DEFAULT NULL COMMENT ‘价格’,
`onelimittimes` int(11) DEFAULT ‘-1’ COMMENT ‘单限’,
`alllimittimes` int(11) DEFAULT ‘-1’ COMMENT ‘库存’,
PRIMARY KEY (`id`),
UNIQUE KEY `caipinbianhao` (`caipinbianhao`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8 COMMENT=’菜品信息’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `caipinxinxi`
—
LOCK TABLES `caipinxinxi` WRITE;
/*!40000 ALTER TABLE `caipinxinxi` DISABLE KEYS */;
INSERT INTO `caipinxinxi` VALUES (51,’2022-04-16 09:01:03′,’1111111111′,’店铺信息1′,’菜品名称1′,’菜品分类1′,’清淡’,’大份’,’upload/caipinxinxi_tupian1.jpg’,’2022-04-16′,’菜品介绍1′,’商家账号1′,’商家姓名1′,99.9,1,99),(52,’2022-04-16 09:01:03′,’2222222222′,’店铺信息2′,’菜品名称2′,’菜品分类2′,’清淡’,’大份’,’upload/caipinxinxi_tupian2.jpg’,’2022-04-16′,’菜品介绍2′,’商家账号2′,’商家姓名2′,99.9,2,99),(53,’2022-04-16 09:01:03′,’3333333333′,’店铺信息3′,’菜品名称3′,’菜品分类3′,’清淡’,’大份’,’upload/caipinxinxi_tupian3.jpg’,’2022-04-16′,’菜品介绍3′,’商家账号3′,’商家姓名3′,99.9,3,99),(54,’2022-04-16 09:01:03′,’4444444444′,’店铺信息4′,’菜品名称4′,’菜品分类4′,’清淡’,’大份’,’upload/caipinxinxi_tupian4.jpg’,’2022-04-16′,’菜品介绍4′,’商家账号4′,’商家姓名4′,99.9,4,99),(55,’2022-04-16 09:01:03′,’5555555555′,’店铺信息5′,’菜品名称5′,’菜品分类5′,’清淡’,’大份’,’upload/caipinxinxi_tupian5.jpg’,’2022-04-16′,’菜品介绍5′,’商家账号5′,’商家姓名5′,99.9,5,99),(56,’2022-04-16 09:01:03′,’6666666666′,’店铺信息6′,’菜品名称6′,’菜品分类6′,’清淡’,’大份’,’upload/caipinxinxi_tupian6.jpg’,’2022-04-16′,’菜品介绍6′,’商家账号6′,’商家姓名6′,99.9,6,99);
/*!40000 ALTER TABLE `caipinxinxi` 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 ‘caipinxinxi’ 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 ‘会员价’,
`shangjiazhanghao` 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 ‘配置参数名称’,
`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/picture1.jpg’),(2,’picture2′,’upload/picture2.jpg’),(3,’picture3′,’upload/picture3.jpg’);
/*!40000 ALTER TABLE `config` ENABLE KEYS */;
UNLOCK TABLES;
—
— Table structure for table `dianpuxinxi`
—
DROP TABLE IF EXISTS `dianpuxinxi`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dianpuxinxi` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT ‘主键’,
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT ‘创建时间’,
`dianpumingcheng` varchar(200) DEFAULT NULL COMMENT ‘店铺名称’,
`tupian` varchar(200) DEFAULT NULL COMMENT ‘图片’,
`jingyingfanwei` longtext COMMENT ‘经营范围’,
`dianpuxiangqing` longtext COMMENT ‘店铺详情’,
`shangjiazhanghao` varchar(200) DEFAULT NULL COMMENT ‘商家账号’,
`shangjiaxingming` varchar(200) DEFAULT NULL COMMENT ‘商家姓名’,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COMMENT=’店铺信息’;
/*!40101 SET character_set_client = @saved_cs_client */;
—
— Dumping data for table `dianpuxinxi`
—
LOCK TABLES `dianpuxinxi` WRITE;
/*!40000 ALTER TABLE `dianpuxinxi` DISABLE KEYS */;
INSERT INTO `dianpuxinxi` VALUES (31,’2022-04-16 09:01:03′,’店铺名称1′,’upload/dianpuxinxi_tupian1.jpg’,’经营范围1′,’店铺详情1′,’商家账号1′,’商家姓名1′),(32,’2022-04-16 09:01:03′,’店铺名称2′,’upload/dianpuxinxi_tupian2.jpg’,’经营范围2′,’店铺详情2′,’商家账号2′,’商家姓名2′),(33,’2022-04-16 09:01:03′,’店铺名称3′,’upload/dianpuxinxi_tupian3.jpg’,’经营范围3′,’店铺详情3′,’商家账号3′,’商家姓名3′),(34,’2022-04-16 09:01:03′,’店铺名称4′,’upload/dianpuxinxi_tupian4.jpg’,’经营范围4′,’店铺详情4′,’商家账号4′,’商家姓名4′),(35,’2022-04-16 09:01:03′,’店铺名称5′,’upload/dianpuxinxi_tupian5.jpg’,’经营范围5′,’店铺详情5′,’商家账号5′,’商家姓名5′),(36,’2022-04-16 09:01:03′,’店铺名称6′,’upload/dianpuxinxi_tupian6.jpg’,’经营范围6′,’店铺详情6′,’商家账号6′,’商家姓名6′);
/*!40000 ALTER TABLE `dianpuxinxi` ENABLE KEYS */;
UNLOCK TABLES;