开发语言：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','
不管你想要怎样的生活，你都要去努力争取，不多尝试一些事情怎么知道自己适合什么、不适合什么呢? 你说你喜欢读书，让我给你列书单，你还问我哪里有那么多时间看书;你说自己梦想的职业是广告文案，问我如何成为一个文案，应该具备哪些素质;你说你计划晨跑，但总是因为学习、工作辛苦或者身体不舒服第二天起不了床;你说你一直梦想一个人去长途旅行，但是没钱，父母觉得危险。其实，我已经厌倦了你这样说说而已的把戏，我觉得就算我告诉你如何去做，你也不会照做，因为你根本什么都不做。21
','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','
菜品介绍8
','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','<img src=\"http://localhost:8080/springbootdq294/upload/1680677624492.jpg\"><img src=\"http://localhost:8080/springbootdq294/upload/1680677626696.jpg\">1212','2023-04-05 14:56:58'); /
!40000 ALTER TABLE caipinxinxi ENABLE KEYS */;
UNLOCK TABLES;
