开发语言：Java
框架：springboot
JDK版本：JDK1.8
服务器：tomcat7
数据库：mysql 5.7（一定要5.7版本）
数据库工具：Navicat11
开发软件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
浏览器：谷歌浏览器
数据库：
DROP TABLE IF EXISTS `aboutus`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `aboutus` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`title` varchar(200) NOT NULL COMMENT '标题',
`subtitle` varchar(200) DEFAULT NULL COMMENT '副标题',
`content` longtext NOT NULL COMMENT '内容',
`picture1` longtext COMMENT '图片1',
`picture2` longtext COMMENT '图片2',
`picture3` longtext COMMENT '图片3',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='关于我们';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `aboutus`
--
LOCK TABLES `aboutus` WRITE;
/*!40000 ALTER TABLE `aboutus` DISABLE KEYS */;
INSERT INTO `aboutus` VALUES (1,'2023-04-05 06:45:30','关于我们','ABOUT US','<p>不管你想要怎样的生活，你都要去努力争取，不多尝试一些事情怎么知道自己适合什么、不适合什么呢? 你说你喜欢读书，让我给你列书单，你还问我哪里有那么多时间看书;你说自己梦想的职业是广告文案，问我如何成为一个文案，应该具备哪些素质;你说你计划晨跑，但总是因为学习、工作辛苦或者身体不舒服第二天起不了床;你说你一直梦想一个人去长途旅行，但是没钱，父母觉得危险。其实，我已经厌倦了你这样说说而已的把戏，我觉得就算我告诉你如何去做，你也不会照做，因为你根本什么都不做。21</p>','upload/aboutus_picture1.jpg','upload/aboutus_picture2.jpg','upload/aboutus_picture3.jpg');
/*!40000 ALTER TABLE `aboutus` 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`),
UNIQUE KEY `caipinfenlei` (`caipinfenlei`)
) ENGINE=InnoDB AUTO_INCREMENT=49 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,'2023-04-05 06:45:30','菜品分类1'),(42,'2023-04-05 06:45:30','菜品分类2'),(43,'2023-04-05 06:45:30','菜品分类3'),(44,'2023-04-05 06:45:30','菜品分类4'),(45,'2023-04-05 06:45:30','菜品分类5'),(46,'2023-04-05 06:45:30','菜品分类6'),(47,'2023-04-05 06:45:30','菜品分类7'),(48,'2023-04-05 06:45:30','小吃');
/*!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 '创建时间',
`dianpumingcheng` varchar(200) NOT NULL COMMENT '店铺名称',
`caipinmingcheng` varchar(200) NOT NULL COMMENT '菜品名称',
`caipinfenlei` varchar(200) NOT NULL COMMENT '菜品分类',
`tupian` longtext COMMENT '图片',
`kouwei` varchar(200) NOT NULL COMMENT '口味',
`jiage` float NOT NULL COMMENT '价格',
`shuliang` int(11) NOT NULL COMMENT '数量',
`zhanghao` varchar(200) DEFAULT NULL COMMENT '账号',
`shangjiaxingming` varchar(200) DEFAULT NULL COMMENT '商家姓名',
`lianxidianhua` varchar(200) DEFAULT NULL COMMENT '联系电话',
`caipinjieshao` longtext COMMENT '菜品介绍',
`clicktime` datetime DEFAULT NULL COMMENT '最近点击时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1680677629165 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,'2023-04-05 06:45:30','店铺名称1','菜品名称1','菜品分类1','upload/caipinxinxi_tupian1.jpg,upload/caipinxinxi_tupian2.jpg,upload/caipinxinxi_tupian3.jpg','口味1',1,1,'账号1','商家姓名1','13823888881','菜品介绍1','2023-04-05 14:45:30'),(52,'2023-04-05 06:45:30','店铺名称2','菜品名称2','菜品分类2','upload/caipinxinxi_tupian2.jpg,upload/caipinxinxi_tupian3.jpg,upload/caipinxinxi_tupian4.jpg','口味2',2,2,'账号2','商家姓名2','13823888882','菜品介绍2','2023-04-05 14:45:30'),(53,'2023-04-05 06:45:30','店铺名称3','菜品名称3','菜品分类3','upload/caipinxinxi_tupian3.jpg,upload/caipinxinxi_tupian4.jpg,upload/caipinxinxi_tupian5.jpg','口味3',3,3,'账号3','商家姓名3','13823888883','菜品介绍3','2023-04-05 14:45:30'),(54,'2023-04-05 06:45:30','店铺名称4','菜品名称4','菜品分类4','upload/caipinxinxi_tupian4.jpg,upload/caipinxinxi_tupian5.jpg,upload/caipinxinxi_tupian6.jpg','口味4',4,4,'账号4','商家姓名4','13823888884','菜品介绍4','2023-04-05 14:45:30'),(55,'2023-04-05 06:45:30','店铺名称5','菜品名称5','菜品分类5','upload/caipinxinxi_tupian5.jpg,upload/caipinxinxi_tupian6.jpg,upload/caipinxinxi_tupian7.jpg','口味5',5,5,'账号5','商家姓名5','13823888885','菜品介绍5','2023-04-05 14:45:30'),(56,'2023-04-05 06:45:30','店铺名称6','菜品名称6','菜品分类6','upload/caipinxinxi_tupian6.jpg,upload/caipinxinxi_tupian7.jpg,upload/caipinxinxi_tupian8.jpg','口味6',6,6,'账号6','商家姓名6','13823888886','菜品介绍6','2023-04-05 14:45:30'),(57,'2023-04-05 06:45:30','店铺名称7','菜品名称7','菜品分类7','upload/caipinxinxi_tupian7.jpg,upload/caipinxinxi_tupian8.jpg,upload/caipinxinxi_tupian9.jpg','口味7',7,7,'账号7','商家姓名7','13823888887','菜品介绍7','2023-04-05 14:54:58'),(58,'2023-04-05 06:45:30','店铺名称8','菜品名称8','菜品分类8','upload/caipinxinxi_tupian8.jpg,upload/caipinxinxi_tupian9.jpg,upload/caipinxinxi_tupian10.jpg','口味8',8,8,'1','商家姓名8','13823888888','<p>菜品介绍8</p>','2023-04-05 14:52:25'),(1680677629164,'2023-04-05 06:53:48','贝贝美食','烤翅','小吃','upload/1680677601248.jpg,upload/1680677603325.jpg,upload/1680677605631.jpg','微辣',55,98,'1','王慧','15214121411','<p><img src=\"http://localhost:8080/springbootdq294/upload/1680677624492.jpg\"></p><p><img src=\"http://localhost:8080/springbootdq294/upload/1680677626696.jpg\"></p><p>1212</p>','2023-04-05 14:56:58');
/*!40000 ALTER TABLE `caipinxinxi` ENABLE KEYS */;
UNLOCK TABLES;
如需定做或者获取更多资料，请联系QQ：375279829
客服QQ