基于微信小程序的食堂窗口自助點(diǎn)餐系統(tǒng)設(shè)計(jì)與實(shí)現(xiàn)-計(jì)算機(jī)畢業(yè)設(shè)計(jì)源碼+LW文檔
小程序開發(fā)說明
開發(fā)語言：Java
框架：ssm
JDK版本：JDK1.8
服務(wù)器：tomcat7
數(shù)據(jù)庫：mysql 5.7（一定要5.7版本）
數(shù)據(jù)庫工具：Navicat11
開發(fā)軟件：eclipse/myeclipse/idea
Maven包：Maven3.3.9
瀏覽器：谷歌瀏覽器
小程序框架：uniapp
小程序開發(fā)軟件：HBuilder X
小程序運(yùn)行軟件：微信開發(fā)者
數(shù)據(jù)庫：
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 '創(chuàng)建時(shí)間',
? `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 '是否默認(rèn)地址[是/否]',
? 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 '創(chuàng)建時(shí)間',
? `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 '創(chuàng)建時(shí)間',
? `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 '價(jià)格',
? `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 '創(chuàng)建時(shí)間',
? `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 '購買數(shù)量',
? `price` float DEFAULT NULL COMMENT '單價(jià)',
? `discountprice` float DEFAULT NULL COMMENT '會員價(jià)',
? `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 '配置參數(shù)名稱',
? `value` varchar(100) DEFAULT NULL COMMENT '配置參數(shù)值',
? 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 '創(chuàng)建時(shí)間',
? `dianpumingcheng` varchar(200) DEFAULT NULL COMMENT '店鋪名稱',
? `tupian` varchar(200) DEFAULT NULL COMMENT '圖片',
? `jingyingfanwei` longtext COMMENT '經(jīng)營范圍',
? `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','經(jīng)營范圍1','店鋪詳情1','商家賬號1','商家姓名1'),(32,'2022-04-16 09:01:03','店鋪名稱2','upload/dianpuxinxi_tupian2.jpg','經(jīng)營范圍2','店鋪詳情2','商家賬號2','商家姓名2'),(33,'2022-04-16 09:01:03','店鋪名稱3','upload/dianpuxinxi_tupian3.jpg','經(jīng)營范圍3','店鋪詳情3','商家賬號3','商家姓名3'),(34,'2022-04-16 09:01:03','店鋪名稱4','upload/dianpuxinxi_tupian4.jpg','經(jīng)營范圍4','店鋪詳情4','商家賬號4','商家姓名4'),(35,'2022-04-16 09:01:03','店鋪名稱5','upload/dianpuxinxi_tupian5.jpg','經(jīng)營范圍5','店鋪詳情5','商家賬號5','商家姓名5'),(36,'2022-04-16 09:01:03','店鋪名稱6','upload/dianpuxinxi_tupian6.jpg','經(jīng)營范圍6','店鋪詳情6','商家賬號6','商家姓名6');
/*!40000 ALTER TABLE `dianpuxinxi` ENABLE KEYS */;
UNLOCK TABLES;
