基于微信小程序的食堂窗口自助点餐系统设计与实现-计算机毕业设计源码+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=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;