Java餐厅点餐系统sql语句以及前后端代码

最新推荐文章于 2023-09-06 09:30:00 发布
北屿北屿北屿
最新推荐文章于 2023-09-06 09:30:00 发布
阅读量3.7k
点赞数 5
分类专栏：相关代码资源文章标签： sql java 数据库
本文链接：https://blog.csdn.net/m0_53555859/article/details/122014860
版权
Java餐厅点餐系统sql以及前后端代码

sql语句

(全部复制执行即可)
/*
 Navicat MySQL Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 50615
 Source Host           : localhost:3306
 Source Schema         : order2

 Target Server Type    : MySQL
 Target Server Version : 50615
 File Encoding         : 65001

 Date: 18/12/2021 16:17:50
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for dinnertable
-- ----------------------------
DROP TABLE IF EXISTS `dinnertable`;
CREATE TABLE `dinnertable`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tableName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `tableStatus` int(11) NULL DEFAULT 0,
  `orderDate` datetime NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of dinnertable
-- ----------------------------
INSERT INTO `dinnertable` VALUES (1, '百合', 1, '2021-12-18 16:02:49');
INSERT INTO `dinnertable` VALUES (2, '玫瑰', 0, NULL);
INSERT INTO `dinnertable` VALUES (3, '牡丹', 0, NULL);
INSERT INTO `dinnertable` VALUES (4, '樱花', 0, NULL);
INSERT INTO `dinnertable` VALUES (5, '睡莲', 0, NULL);

-- ----------------------------
-- Table structure for food
-- ----------------------------
DROP TABLE IF EXISTS `food`;
CREATE TABLE `food`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `foodName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `foodType_id` int(11) NULL DEFAULT NULL,
  `price` double NULL DEFAULT NULL,
  `mprice` double NULL DEFAULT NULL,
  `remark` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `img` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `fk_food_foodType_id`(`foodType_id`) USING BTREE,
  CONSTRAINT `fk_food_foodType_id` FOREIGN KEY (`foodType_id`) REFERENCES `foodtype` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 26 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of food
-- ----------------------------
INSERT INTO `food` VALUES (1, '麻辣香锅', 2, 100, 80, '好辣呀', 'upload/malaxiangguo.jpg');
INSERT INTO `food` VALUES (2, '白灼虾', 1, 20, 18, '好吃的不行', 'upload/baizhuoxia.jpg');
INSERT INTO `food` VALUES (3, '荷兰豆', 2, 20, 18, '用黄油做的', 'upload/helandou.jpg');
INSERT INTO `food` VALUES (4, '红烧肉', 4, 39, 35, '很肥，会胖', 'upload/hongshaorou.jpg');
INSERT INTO `food` VALUES (5, '白切鸡', 1, 200, 180, '白切鸡白切鸡', 'upload/baiqieji.jpg');
INSERT INTO `food` VALUES (6, '火腿白菜', 1, 30, 26, '水煮的', 'upload/huotuibaicai.jpg');
INSERT INTO `food` VALUES (7, '烤乳猪', 3, 45, 45, '天妇罗天妇罗', 'upload/kaoruzhu.JPG');
INSERT INTO `food` VALUES (8, '青椒鸡丁', 2, 180, 160, '很嫩', 'upload/qingjiaojiding.jpg');
INSERT INTO `food` VALUES (9, '北京烤鸭', 2, 22, 20, '北京烤鸭', 'upload/beijingkaoya .jpg');
INSERT INTO `food` VALUES (10, '香锅肉丸', 3, 100, 80, '香锅肉丸香锅肉丸', 'upload/xiangguorouwan.jpg');
INSERT INTO `food` VALUES (11, '猪头肉', 2, 66, 60, '红烧鱼排红烧鱼排', 'upload/zhutourou.jpg');
INSERT INTO `food` VALUES (12, '风味茄子', 4, 66, 60, '风味茄子风味茄子', 'upload/fengweiqiezi.jpg');
INSERT INTO `food` VALUES (13, '红烧鱼排', 2, 22, 20, '红烧鱼排', 'upload/hongshaoyupai.jpg');
INSERT INTO `food` VALUES (14, '煎牛排', 3, 100, 80, '煎牛排煎牛排煎牛排', 'upload/jianniupai.jpg');
INSERT INTO `food` VALUES (15, '辣子鸡丁', 4, 66, 60, '辣子鸡丁辣子鸡丁辣子', 'upload/lazijiding.jpg');
INSERT INTO `food` VALUES (16, '罗宋汤', 4, 66, 60, '风味茄子风味茄子', 'upload/luosongtang.jpg');
INSERT INTO `food` VALUES (23, '红烧', 1, 12.5, 10.5, 'qqqq', 'upload/hsr.jpg');
INSERT INTO `food` VALUES (24, '红烧', 1, 12.5, 10.5, 'qqqq', 'upload/hsr.jpg');
INSERT INTO `food` VALUES (25, '红烧', 1, 12.5, 1231, 'qqq', 'upload/hsr.jpg');

-- ----------------------------
-- Table structure for foodtype
-- ----------------------------
DROP TABLE IF EXISTS `foodtype`;
CREATE TABLE `foodtype`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `typeName` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of foodtype
-- ----------------------------
INSERT INTO `foodtype` VALUES (1, '粤菜');
INSERT INTO `foodtype` VALUES (2, '川菜');
INSERT INTO `foodtype` VALUES (3, '湘菜');
INSERT INTO `foodtype` VALUES (4, '东北菜');

-- ----------------------------
-- Table structure for orderdetail
-- ----------------------------
DROP TABLE IF EXISTS `orderdetail`;
CREATE TABLE `orderdetail`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `orderId` bigint(19) NULL DEFAULT NULL,
  `food_id` int(11) NULL DEFAULT NULL,
  `foodCount` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `orderDetail_order_id`(`orderId`) USING BTREE,
  INDEX `orderDetail_food_id`(`food_id`) USING BTREE,
  CONSTRAINT `orderDetail_food_id` FOREIGN KEY (`food_id`) REFERENCES `food` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of orderdetail
-- ----------------------------
INSERT INTO `orderdetail` VALUES (1, 1, 3, 1);
INSERT INTO `orderdetail` VALUES (2, 591214429488545792, 7, 1);
INSERT INTO `orderdetail` VALUES (3, 591214429488545792, 8, 1);
INSERT INTO `orderdetail` VALUES (4, 591214429488545792, 5, 2);
INSERT INTO `orderdetail` VALUES (5, 591214429488545792, 4, 2);
INSERT INTO `orderdetail` VALUES (6, 591214522300104704, 7, 1);
INSERT INTO `orderdetail` VALUES (7, 591214522300104704, 8, 1);
INSERT INTO `orderdetail` VALUES (8, 591214522300104704, 5, 2);
INSERT INTO `orderdetail` VALUES (9, 591214522300104704, 4, 2);
INSERT INTO `orderdetail` VALUES (10, 920769017709330432, 2, 100);
INSERT INTO `orderdetail` VALUES (11, 920972754625232896, 5, 1);
INSERT INTO `orderdetail` VALUES (12, 920976615737917440, 5, 1);
INSERT INTO `orderdetail` VALUES (13, 921070092232425472, 4, 1);
INSERT INTO `orderdetail` VALUES (14, 921070092232425472, 6, 20);
INSERT INTO `orderdetail` VALUES (15, 921075047555137536, 6, 1);
INSERT INTO `orderdetail` VALUES (16, 921077111811211264, 5, 1);
INSERT INTO `orderdetail` VALUES (17, 921087637580677120, 3, 1);
INSERT INTO `orderdetail` VALUES (18, 921087637580677120, 6, 1);
INSERT INTO `orderdetail` VALUES (19, 921087637580677120, 1, 1);
INSERT INTO `orderdetail` VALUES (20, 921088243250757632, 6, 1);
INSERT INTO `orderdetail` VALUES (21, 921088243250757632, 3, 1);
INSERT INTO `orderdetail` VALUES (22, 921088243250757632, 1, 1);
INSERT INTO `orderdetail` VALUES (23, 921097685304344576, 4, 1);
INSERT INTO `orderdetail` VALUES (24, 921117574496780288, 2, 1);
INSERT INTO `orderdetail` VALUES (25, 921794644876984320, 4, 2);
INSERT INTO `orderdetail` VALUES (26, 921794644876984320, 6, 1);

-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders`  (
  `id` bigint(19) NOT NULL,
  `table_id` int(11) NULL DEFAULT NULL,
  `orderDate` datetime NULL DEFAULT NULL,
  `totalPrice` double NULL DEFAULT NULL,
  `orderStatus` int(11) NULL DEFAULT 0,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `order_table_id`(`table_id`) USING BTREE,
  CONSTRAINT `order_table_id` FOREIGN KEY (`table_id`) REFERENCES `dinnertable` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = COMPACT;

-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES (1, 1, '2016-06-20 14:10:01', 20, 0);
INSERT INTO `orders` VALUES (591214429488545792, 2, '2019-06-20 10:35:04', 703, 1);
INSERT INTO `orders` VALUES (591214522300104704, 2, '2019-06-20 10:35:27', 703, 0);
INSERT INTO `orders` VALUES (920768209404035072, 1, '2021-12-15 20:04:08', 39, 0);
INSERT INTO `orders` VALUES (920769017709330432, 1, '2021-12-15 20:07:21', 2000, 0);
INSERT INTO `orders` VALUES (920972754625232896, 1, '2021-12-16 09:36:56', 200, 0);
INSERT INTO `orders` VALUES (920976615737917440, 2, '2021-12-16 09:52:16', 200, 0);
INSERT INTO `orders` VALUES (921070092232425472, 2, '2021-12-16 16:03:43', 639, 0);
INSERT INTO `orders` VALUES (921075047555137536, 3, '2021-12-16 16:23:24', 30, 0);
INSERT INTO `orders` VALUES (921077111811211264, 4, '2021-12-16 16:31:36', 200, 0);
INSERT INTO `orders` VALUES (921087637580677120, 4, '2021-12-16 17:13:26', 150, 1);
INSERT INTO `orders` VALUES (921088243250757632, 5, '2021-12-16 17:15:50', 150, 1);
INSERT INTO `orders` VALUES (921097685304344576, 1, '2021-12-16 17:53:21', 39, 1);
INSERT INTO `orders` VALUES (921117574496780288, 1, '2021-12-16 19:12:23', 20, 1);
INSERT INTO `orders` VALUES (921794644876984320, 1, '2021-12-18 16:02:49', 108, 0);

SET FOREIGN_KEY_CHECKS = 1;