思路
通过定义泛型接口DAO，让继承该接口的类的方法中能够直接生成其他的类对象。创建菜品、客户、管理员类、订单类，再分别创建这三个类的管理类。最后分别创建一个管理员菜单类和一个客户菜单类实现上述菜单功能。
/*
Navicat MySQL Data Transfer
Source Server : localhost_3306
Source Server Version : 50625
Source Host : localhost:3306
Source Database : sudi
Target Server Type : MYSQL
Target Server Version : 50625
File Encoding : 65001
Date: 2021-01-15 15:56:16
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for sudi_address
-- ----------------------------
DROP TABLE IF EXISTS `sudi_address`;
CREATE TABLE `sudi_address` (
`addressId` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '地址编号',
`userId` bigint(20) NOT NULL COMMENT '用户编号',
`defaulted` tinyint(1) DEFAULT NULL COMMENT '是否首选(1表示是，0表示否)',
`address` varchar(255) NOT NULL COMMENT '用户住址',
PRIMARY KEY (`addressId`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sudi_address
-- ----------------------------
INSERT INTO `sudi_address` VALUES ('1', '10', '0', '四川大学11栋302');
INSERT INTO `sudi_address` VALUES ('2', '10', '1', '四川大学18栋118');
-- ----------------------------
-- Table structure for sudi_comment
-- ----------------------------
DROP TABLE IF EXISTS `sudi_comment`;
CREATE TABLE `sudi_comment` (
`commentId` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '评论编号',
`orderDetailId` bigint(20) DEFAULT NULL COMMENT '订单细则编号',
`userId` bigint(20) DEFAULT NULL COMMENT '用户编号(冗余)',
`commentScore` decimal(5,2) DEFAULT NULL COMMENT '评论评分',
`commentContent` varchar(255) DEFAULT NULL COMMENT '评论内容',
`commentTime` datetime DEFAULT NULL COMMENT '评论时间',
PRIMARY KEY (`commentId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sudi_comment
-- ----------------------------
INSERT INTO `sudi_comment` VALUES ('1', '1', '10', '4.00', '这个不错，还可以', '2021-01-15 15:44:44');
INSERT INTO `sudi_comment` VALUES ('2', '2', '10', '4.50', '这个也不错', '2021-01-15 15:44:55');
INSERT INTO `sudi_comment` VALUES ('3', '3', '10', '2.00', '茄子太咸了，无法下口', '2021-01-15 15:45:26');
-- ----------------------------
-- Table structure for sudi_complaint
-- ----------------------------
DROP TABLE IF EXISTS `sudi_complaint`;
CREATE TABLE `sudi_complaint` (
`complaintId` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '投诉编号',
`userId` bigint(20) DEFAULT NULL COMMENT '用户编号',
`orderId` varchar(20) DEFAULT NULL COMMENT '订单编号',
`complaintType` int(11) DEFAULT NULL COMMENT '投诉类型(1表示投诉配送员;2表示投诉菜品;3表示其他)',
`target` varchar(120) DEFAULT NULL COMMENT '投诉对象',
`complaintContent` varchar(255) DEFAULT NULL COMMENT '投诉内容',
`complaintTime` datetime DEFAULT NULL COMMENT '投诉时间',
PRIMARY KEY (`complaintId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sudi_complaint
-- ----------------------------
INSERT INTO `sudi_complaint` VALUES ('1', '10', 'D2021011515402986473', '2', '干煸茄子(不辣)', '茄子太咸了，无法下口，老板注意一下', '2021-01-15 15:46:00');
-- ----------------------------
-- Table structure for sudi_deliver
-- ----------------------------
DROP TABLE IF EXISTS `sudi_deliver`;
CREATE TABLE `sudi_deliver` (
`deliverId` varchar(16) NOT NULL COMMENT '配送员编号',
`userId` bigint(20) NOT NULL COMMENT '用户编号',
`realName` varchar(30) DEFAULT NULL COMMENT '真实姓名',
`imageUrl` varchar(255) DEFAULT NULL COMMENT '证件照片路径',
`orderCount` int(11) DEFAULT '0' COMMENT '接单总数',
`faultCount` int(11) DEFAULT '0' COMMENT '差评总数',
`finishCount` int(11) DEFAULT '0' COMMENT '结单总数',
`joinDate` date DEFAULT NULL COMMENT '入职日期',
`leaveDate` date DEFAULT NULL COMMENT '离职日期',
`remark` varchar(255) DEFAULT NULL COMMENT '备注（特别说明）',
PRIMARY KEY (`deliverId`),
KEY `userId` (`userId`),
CONSTRAINT `userId` FOREIGN KEY (`userId`) REFERENCES `sudi_user` (`userId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sudi_deliver
-- ----------------------------
INSERT INTO `sudi_deliver` VALUES ('2021011515343045', '2', '李四', 'food/4bdb079c-bf99-4a95-b0c8-3a8d7f3cbf69.jpg', '1', '0', '1', '2021-01-15', null, '精神小伙');
-- ----------------------------
-- Table structure for sudi_food
-- ----------------------------
DROP TABLE IF EXISTS `sudi_food`;
CREATE TABLE `sudi_food` (
`foodId` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜品编号',
`foodName` varchar(80) NOT NULL COMMENT '菜品名称',
`foodTypeId` bigint(20) NOT NULL COMMENT '菜品类别编号',
`foodIngredient` varchar(255) DEFAULT '暂无信息' COMMENT '菜品配料',
`foodVegon` varchar(60) DEFAULT '暂无信息' COMMENT '菜品荤素描述',
`foodCookWay` varchar(60) DEFAULT '暂无信息' COMMENT '菜品烹饪方式',
`foodFaultCount` int(11) DEFAULT '0' COMMENT '菜品差评数',
`foodDesc` varchar(255) DEFAULT '暂无信息' COMMENT '菜品描述',
`foodImage` varchar(255) DEFAULT NULL COMMENT '菜品图片路径',
`foodSaleCount` int(11) DEFAULT '0' COMMENT '菜品销量',
`foodViewCount` int(11) DEFAULT '0' COMMENT '菜品浏览量',
`foodScore` decimal(5,2) DEFAULT '2.50' COMMENT '平均分',
`commentCount` int(11) DEFAULT '0' COMMENT '评论数',
`recommend` int(11) DEFAULT '2' COMMENT '是否推荐（1表示是；2表示否）',
`hotSale` int(11) DEFAULT '2' COMMENT '是否热销（1表示是；2表示否）',
`foodStatus` int(11) DEFAULT '3' COMMENT '菜品状态（1表示上架中；2表示下架；3表示未完善）',
`lastModifyBy` varchar(60) DEFAULT NULL COMMENT '上次修改人',
`lastModifyTime` datetime DEFAULT NULL COMMENT '上次修改时间',
`dayStock` int(11) DEFAULT NULL,
PRIMARY KEY (`foodId`),
KEY `foodTypeId` (`foodTypeId`),
CONSTRAINT `sudi_food_ibfk_1` FOREIGN KEY (`foodTypeId`) REFERENCES `sudi_foodtype` (`typeId`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sudi_food
-- ----------------------------
INSERT INTO `sudi_food` VALUES ('14', '糖醋排骨', '3', '排骨、菠萝、红萝卜', '荤菜', '糖醋', '0', '下饭首选！', 'food/bad65b29-e72d-496d-95c5-61b488863e5e.jpg', '1', '14', '3.25', '1', '2', '1', '1', 'admin', '2021-01-14 16:31:49', '10');
INSERT INTO `sudi_food` VALUES ('15', '香煎猪扒', '3', '猪扒', '荤菜', '香煎', '0', ' 香煎猪扒是一种小吃，主料是猪里脊，配料是鸡蛋等，调料为孜然粉、五香粉、料酒，通过煎制的做法制作而成。\n 猪瘦肉的营养非常全面，不但为人类提供优质蛋白质和必需的脂肪酸，还提供大量的钙、磷、铁、硫胺素、核黄素和尼克酸等营养元素。猪瘦肉的营养优势在于它含有丰富的B族维生素，能调节新陈代谢，维持皮肤和肌肉的健康，增强免疫系统和神经系统的功能，预防贫血发生，而且猪瘦肉中的血红蛋白比植物中的更好吸收。\n', 'food/9b434094-6fb5-48b7-95cd-890cfc778d9a.jpg', '4', '21', '2.50', '0', '2', '1', '1', 'admin', '2021-01-14 16:32:35', '400');
INSERT INTO `sudi_food` VALUES ('16', '炒饭', '6', '高丽菜、胡萝卜、肉丝、东北大米', '半荤半素', '烹炒', '0', '一碗顶十碗', 'food/9b853d37-89dc-4c17-9520-ecdb0fc09381.jpg', '18', '6', '4.13', '2', '1', '1', '1', 'admin', '2021-01-14 16:34:14', '111');
INSERT INTO `sudi_food` VALUES ('17', '干煸茄子', '7', '茄子、肉末', '半荤半素', '干煸', '1', '茄子、肉末', 'food/08cae093-ff22-4ad3-a3a5-f74b3f106bb4.jpg', '65', '8', '2.25', '4', '1', '1', '1', 'admin', '2021-01-14 16:33:33', '111');
INSERT INTO `sudi_food` VALUES ('18', '炒河粉', '6', '河粉、牛肉、芽菜、葱花、老抽、味精、生抽、糖适量混合待用', '半荤半素', '炒', '1', '炒河粉能够有以下好处：①补充能量：含碳水化合物，糖类，能迅速为身体提供能量。②安神除烦：碳水化合物可以补充大脑消耗的葡萄糖，缓解脑部葡萄糖供养不足而出现的疲惫、易怒、头晕、失眠、夜间出汗、注意力涣散、健忘、极度口渴、沮丧、化紊乱，甚至出现幻觉。', 'food/4c0a77b6-a4bb-4da6-ac25-a7f4a3462ac6.jpg', '24', '46', '2.50', '1', '1', '1', '1', 'admin', '2021-01-14 16:33:45', '111');
INSERT INTO `sudi_food` VALUES ('23', '八宝饭', '6', '大米 ', '其他', '煮', '0', '八宝饭顾名思义，有八种食材做成的一道蒸米饭。食材的具体选择上，每个人做的都有点差异的，我这里用的八宝是：黑糯米，白糯米。红豆沙馅，蜜枣，莲子，腰果，葡萄干，小红枣。', 'food/aad8b62e-5737-41cd-a0d5-4638617b506c.jpg', '0', '1', '2.50', '0', '1', '1', '1', 'admin', '2021-01-14 16:33:55', '111');
INSERT INTO `sudi_food` VALUES ('29', '四喜丸子', '4', '猪肉馅650克、鸡蛋1个、马蹄4个、馒头半个、葱姜末', '素菜', '煮', '0', '一次不妨多做些，炸好晾凉后入冰箱冷冻起来，需要时直接拿来红烧或者炖白菜都非常方便', 'food/df8382b8-b30e-4cb4-b720-8792cd68b5ba.jpg', '0', '1', '2.50', '0', '2', '2', '1', 'admin', '2021-01-14 16:38:34', '200');
INSERT INTO `sudi_food` VALUES ('30', '虾仁饺子', '4', ' 小麦淀粉200克，虾仁100克', '半荤半素', '蒸', '0', '\n1． 制作馅料：先将虾仁切碎后和什锦菜、葱花混合，加入适量的盐、味精、胡椒粉、麻油、黄酒拌匀，腌制30分钟。\n\n2． 制作面团：将小麦淀粉倒在盆内，烧好开水，冲入小麦淀粉盆内，一边冲一边用筷子搅拌，而且要拌匀，将粉烫熟成透明状。稍凉后开始制作饺子皮。\n\n3． 将馅料包入饺子皮内，包好捏成三角饺子形状，放到笼屉内。\n\n4． 锅内放入清水，开大火，水开后放上笼屉蒸10 分钟即可', 'food/88925112-a65a-4c15-a71b-8ffbd78c3333.jpg', '0', '0', '2.50', '0', '1', '2', '1', 'admin', '2021-01-15 15:46:27', '201');
-- ----------------------------
-- Table structure for sudi_foodattr
-- ----------------------------
DROP TABLE IF EXISTS `sudi_foodattr`;
CREATE TABLE `sudi_foodattr` (
`foodattrId` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜品规格集编号',
`foodattrName` varchar(60) DEFAULT NULL COMMENT '菜品规格集名称',
PRIMARY KEY (`foodattrId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sudi_foodattr
-- ----------------------------
INSERT INTO `sudi_foodattr` VALUES ('1', '规格');
-- ----------------------------
-- Table structure for sudi_foodsku
-- ----------------------------
DROP TABLE IF EXISTS `sudi_foodsku`;
CREATE TABLE `sudi_foodsku` (
`skuId` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜品sku编号',
`foodId` bigint(20) NOT NULL COMMENT '菜品编号',
`skuName` varchar(255) NOT NULL COMMENT '菜品sku名称',
`skuPrice` decimal(5,2) DEFAULT NULL COMMENT '菜品sku价格',
`skuSale` int(11) DEFAULT '0' COMMENT '菜品sku销量',
`skuStock` int(11) DEFAULT '0' COMMENT '菜品sku供应量',
PRIMARY KEY (`skuId`),
KEY `foodId` (`foodId`),
CONSTRAINT `sudi_foodsku_ibfk_1` FOREIGN KEY (`foodId`) REFERENCES `sudi_food` (`foodId`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sudi_foodsku
-- ----------------------------
INSERT INTO `sudi_foodsku` VALUES ('1', '14', '糖醋排骨(大份)', '46.00', '1', '0');
INSERT INTO `sudi_foodsku` VALUES ('2', '14', '糖醋排骨(中份)', '43.00', '0', '0');
INSERT INTO `sudi_foodsku` VALUES ('3', '14', '糖醋排骨(小份)', '83.00', '0', '0');
INSERT INTO `sudi_foodsku` VALUES ('4', '14', '糖醋排骨(test)', '76.00', '56', '0');
INSERT INTO `sudi_foodsku` VALUES ('6', '15', '香煎猪扒(番茄酱)', '45.00', '1', '30');
INSERT INTO `sudi_foodsku` VALUES ('7', '15', '香煎猪扒(甜辣酱)', '10.00', '3', '20');
INSERT INTO `sudi_foodsku` VALUES ('8', '15', '香煎猪扒(黑胡椒酱)', '10.00', '0', '23');
INSERT INTO `sudi_foodsku` VALUES ('9', '15', '香煎猪扒(千岛酱)', '12.00', '0', '20');
INSERT INTO `sudi_foodsku` VALUES ('10', '15', '香煎猪扒(猪扒测试)', '13.00', '0', '3');
INSERT INTO `sudi_foodsku` VALUES ('11', '16', '炒饭(牛肉丁)', '8.00', '1', '30');
INSERT INTO `sudi_foodsku` VALUES ('12', '16', '炒饭(猪肉丁)', '6.00', '12', '30');
INSERT INTO `sudi_foodsku` VALUES ('13', '16', '炒饭(火腿肠)', '5.00', '5', '50');
INSERT INTO `sudi_foodsku` VALUES ('14', '17', '干煸茄子(辣)', '3.50', '0', '50');
INSERT INTO `sudi_foodsku` VALUES ('15', '17', '干煸茄子(不辣)', '3.50', '65', '30');
INSERT INTO `sudi_foodsku` VALUES ('16', '18', '炒河粉(大份)', '12.00', '1', '100');
INSERT INTO `sudi_foodsku` VALUES ('17', '18', '炒河粉(中份)', '10.00', '23', '100');
INSERT INTO `sudi_foodsku` VALUES ('18', '18', '炒河粉(小份)', '8.00', '0', '100');
INSERT INTO `sudi_foodsku` VALUES ('38', '29', '四喜丸子(大份)', '12.00', '0', '0');
INSERT INTO `sudi_foodsku` VALUES ('39', '29', '四喜丸子(小份)', '10.00', '0', '0');
INSERT INTO `sudi_foodsku` VALUES ('40', '30', '虾仁饺子(大份)', '15.00', '0', '0');
INSERT INTO `sudi_foodsku` VALUES ('41', '30', '虾仁饺子(中份)', '12.00', '0', '0');
INSERT INTO `sudi_foodsku` VALUES ('42', '30', '虾仁饺子(虾仁饺子(小份))', '10.00', '0', '0');
-- ----------------------------
-- Table structure for sudi_foodtype
-- ----------------------------
DROP TABLE IF EXISTS `sudi_foodtype`;
CREATE TABLE `sudi_foodtype` (
`typeId` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜品类别编号',
`typeName` varchar(60) NOT NULL COMMENT '菜品类别名',
`typeDesc` varchar(255) DEFAULT NULL COMMENT '菜品类别介绍',
`lastModifyBy` varchar(60) DEFAULT NULL COMMENT '上次修改人',
`lastModifyTime` datetime DEFAULT NULL COMMENT '上次修改日期',
`typeStatus` int(11) DEFAULT NULL COMMENT '状态（1表示使用中；2表示下架）',
`typeImage` varchar(255) DEFAULT NULL COMMENT '菜品类别大图',
PRIMARY KEY (`typeId`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sudi_foodtype
-- ----------------------------
INSERT INTO `sudi_foodtype` VALUES ('3', '中餐', '123', 'admin', '2021-01-14 15:03:05', '1', 'food/6afa07d6-384f-47da-a4c2-e5c11a386891.jpg');
INSERT INTO `sudi_foodtype` VALUES ('4', '面食', 'gullugluglglglglg', 'admin', '2021-01-14 15:03:13', '1', 'food/cb9edbac-2351-46c5-961a-e5e8eac5d8d5.jpg');
INSERT INTO `sudi_foodtype` VALUES ('5', '麻辣烫', 'defaulteddddd', 'admin', '2021-01-14 15:03:21', '1', 'food/965d60ae-7fab-4140-8991-a7b063bcc165.jpg');
INSERT INTO `sudi_foodtype` VALUES ('6', '主食', 'rice', 'admin', '2021-01-14 15:03:27', '1', 'food/37e07d40-da23-4e61-a704-5da7a5fab52a.jpg');
INSERT INTO `sudi_foodtype` VALUES ('7', '小炒', '小炒', 'admin', '2021-01-14 15:03:34', '1', 'food/897b3b20-7312-4a5e-b658-fc1ebfe48b6c.jpg');
INSERT INTO `sudi_foodtype` VALUES ('9', '点心', '点心，蛋糕，面包类食物', 'admin', '2021-01-14 16:31:29', '1', 'food/c8ab98d1-ccdb-4a4b-8eb7-9762f9ae6ff4.jpg');
-- ----------------------------
-- Table structure for sudi_foodvalue
-- ----------------------------
DROP TABLE IF EXISTS `sudi_foodvalue`;
CREATE TABLE `sudi_foodvalue` (
`foodvalueId` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '菜品规格编号',
`foodattrId` bigint(20) NOT NULL COMMENT '菜品规格集编号',
`foodId` bigint(20) NOT NULL COMMENT '菜品编号',
`foodvalueName` varchar(60) NOT NULL COMMENT '菜品规格名',
PRIMARY KEY (`foodvalueId`),
KEY `foodattrId` (`foodattrId`),
KEY `foodId` (`foodId`),
CONSTRAINT `sudi_foodvalue_ibfk_1` FOREIGN KEY (`foodattrId`) REFERENCES `sudi_foodattr` (`foodattrId`),
CONSTRAINT `sudi_foodvalue_ibfk_2` FOREIGN KEY (`foodId`) REFERENCES `sudi_food` (`foodId`)
) ENGINE=InnoDB AUTO_INCREMENT=64 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sudi_foodvalue
-- ----------------------------
INSERT INTO `sudi_foodvalue` VALUES ('22', '1', '14', '大份');
INSERT INTO `sudi_foodvalue` VALUES ('23', '1', '14', '中份');
INSERT INTO `sudi_foodvalue` VALUES ('24', '1', '14', '小份');
INSERT INTO `sudi_foodvalue` VALUES ('25', '1', '14', 'test');
INSERT INTO `sudi_foodvalue` VALUES ('27', '1', '15', '番茄酱');
INSERT INTO `sudi_foodvalue` VALUES ('28', '1', '15', '甜辣酱');
INSERT INTO `sudi_foodvalue` VALUES ('29', '1', '15', '黑胡椒酱');
INSERT INTO `sudi_foodvalue` VALUES ('30', '1', '15', '千岛酱');
INSERT INTO `sudi_foodvalue` VALUES ('31', '1', '15', '猪扒测试');
INSERT INTO `sudi_foodvalue` VALUES ('32', '1', '16', '牛肉丁');
INSERT INTO `sudi_foodvalue` VALUES ('33', '1', '16', '猪肉丁');
INSERT INTO `sudi_foodvalue` VALUES ('34', '1', '16', '火腿肠');
INSERT INTO `sudi_foodvalue` VALUES ('35', '1', '17', '辣');
INSERT INTO `sudi_foodvalue` VALUES ('36', '1', '17', '不辣');
INSERT INTO `sudi_foodvalue` VALUES ('37', '1', '18', '大份');
INSERT INTO `sudi_foodvalue` VALUES ('38', '1', '18', '中份');
INSERT INTO `sudi_foodvalue` VALUES ('39', '1', '18', '小份');
INSERT INTO `sudi_foodvalue` VALUES ('59', '1', '29', '大份');
INSERT INTO `sudi_foodvalue` VALUES ('60', '1', '29', '小份');
INSERT INTO `sudi_foodvalue` VALUES ('61', '1', '30', '大份');
INSERT INTO `sudi_foodvalue` VALUES ('62', '1', '30', '中份');
INSERT INTO `sudi_foodvalue` VALUES ('63', '1', '30', '小份');
-- ----------------------------
-- Table structure for sudi_menu
-- ----------------------------
DROP TABLE IF EXISTS `sudi_menu`;
CREATE TABLE `sudi_menu` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '菜单编号',
`pid` int(11) DEFAULT '0' COMMENT '父级菜单编号（为空默认为0）',
`title` varchar(100) DEFAULT NULL COMMENT '菜单名称',
`href` varchar(255) DEFAULT NULL COMMENT '菜单路径',
`spread` int(11) DEFAULT '0' COMMENT '是否展开（0表示否，1表示是）',
`icon` varchar(60) DEFAULT NULL COMMENT '菜单图标',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sudi_menu
-- ----------------------------
INSERT INTO `sudi_menu` VALUES ('1', '0', '系统管理', null, '1', null);
INSERT INTO `sudi_menu` VALUES ('2', '1', '用户管理', '/sudi/backstage/userManage.html', '1', 'fa fa-user-o');
INSERT INTO `sudi_menu` VALUES ('3', '1', '角色管理', '/sudi/backstage/roleManage.html', '0', 'fa fa-vcard-o');
INSERT INTO `sudi_menu` VALUES ('4', '1', '菜单管理', '/sudi/backstage/menuManage.html', '0', 'fa fa-th-list');
INSERT INTO `sudi_menu` VALUES ('5', '6', '菜品管理', '', '1', 'fa fa-gears');
INSERT INTO `sudi_menu` VALUES ('6', '0', '食堂管理', '', '1', 'fa fa-building');
INSERT INTO `sudi_menu` VALUES ('7', '6', '配送员管理', '/sudi/backstage/deliverManage.html', '0', 'fa fa-shopping-bag');
INSERT INTO `sudi_menu` VALUES ('8', '0', '用户前台', '', '1', '');
INSERT INTO `sudi_menu` VALUES ('9', '8', '个人中心', '/sudi/userInfo.html', '0', 'fa fa-user');
INSERT INTO `sudi_menu` VALUES ('10', '5', '菜品类别管理', '/sudi/backstage/foodtypeManage.html', '0', 'fa fa-inbox');
INSERT INTO `sudi_menu` VALUES ('11', '5', '菜品规格组管理', '/sudi/backstage/foodattrManage.html', '1', 'fa fa-sitemap');
INSERT INTO `sudi_menu` VALUES ('12', '5', '菜品SPU管理', '/sudi/backstage/foodManage.html', '1', 'fa fa-cutlery');
INSERT INTO `sudi_menu` VALUES ('13', '5', '菜品SKU管理', '/sudi/backstage/foodSkuManage.html', '1', 'fa fa-tasks');
INSERT INTO `sudi_menu` VALUES ('14', '8', '点餐中心', '/sudi/reception/foodCenter.html', '1', 'fa fa-align-center');
INSERT INTO `sudi_menu` VALUES ('15', '6', '优惠券管理', '', '1', 'fa fa-ticket');
INSERT INTO `sudi_menu` VALUES ('16', '15', '优惠券类别管理', '/sudi/backstage/ticketTypeManage.html', '1', 'fa fa-bars');
INSERT INTO `sudi_menu` VALUES ('17', '15', '领取记录管理', '/sudi/backstage/ticketManage.html', '1', 'fa fa-credit-card');
INSERT INTO `sudi_menu` VALUES ('18', '8', '我的购物车', '/sudi/reception/shopcart.html', '1', 'fa fa-shopping-cart');
INSERT INTO `sudi_menu` VALUES ('19', '8', '优惠券商城', '/sudi/reception/ticketShop.html', '1', 'fa fa-ticket');
INSERT INTO `sudi_menu` VALUES ('20', '6', '订单分配管理', '/sudi/backstage/orderAllocationManage.html', '1', 'fa fa-clipboard');
INSERT INTO `sudi_menu` VALUES ('21', '0', '配送员面板(数据配送员可见)', '', '1', '');
INSERT INTO `sudi_menu` VALUES ('22', '21', '待配送订单', '/sudi/backstage/orderDeliverManage.html', '1', 'fa fa-map');
INSERT INTO `sudi_menu` VALUES ('23', '21', '配送记录', '/sudi/backstage/deliverRecord.html', '1', 'fa fa-list-alt');
INSERT INTO `sudi_menu` VALUES ('24', '6', '投诉中心', '/sudi/backstage/complaintManage.html', '1', 'fa fa-commenting-o');
-- ----------------------------
-- Table structure for sudi_order
-- ----------------------------
DROP TABLE IF EXISTS `sudi_order`;
CREATE TABLE `sudi_order` (
`orderId` varchar(20) NOT NULL COMMENT '订单编号(D+时间戳+5位随机数)',
`userId` bigint(20) DEFAULT NULL COMMENT '用户编号',
`address` varchar(255) DEFAULT NULL COMMENT '地址(冗余)',
`realName` varchar(30) DEFAULT NULL COMMENT '收货人姓名',
`phone` varchar(20) DEFAULT NULL COMMENT '收货人手机号',
`totalCount` int(11) DEFAULT NULL COMMENT '总菜品计数',
`totalPrice` decimal(5,2) DEFAULT NULL COMMENT '应付金额',
`actualPrice` decimal(5,2) DEFAULT NULL COMMENT '实付金额',
`ticketId` bigint(20) DEFAULT NULL COMMENT '优惠券编号',
`cheap` decimal(5,2) DEFAULT '0.00' COMMENT '优惠金额',
`deliverId` varchar(16) DEFAULT NULL COMMENT '配送员编号',
`deliverName` varchar(60) DEFAULT NULL COMMENT '配送员姓名(冗余)',
`deliverPhone` varchar(20) DEFAULT NULL COMMENT '配送员电话(冗余)',
`orderTime` datetime DEFAULT NULL COMMENT '下单时间',
`finishTime` datetime DEFAULT NULL COMMENT '送达时间',
`orderStatus` int(11) DEFAULT NULL COMMENT '订单状态(1表示出餐中；2表示配送中；3表示已完成；4表示未支付；5表示已取消)',
`complaint` int(11) DEFAULT '2' COMMENT '是否投诉(1表示是；2表示否)',
PRIMARY KEY (`orderId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sudi_order
-- ----------------------------
INSERT INTO `sudi_order` VALUES ('D2021011515402986473', '10', '四川大学11栋302', '李四', '11111111111', '3', '55.50', '55.50', null, '0.00', '2021011515343045', '李四', '12345678901', '2021-01-15 15:40:29', '2021-01-15 15:44:02', '3', '1');
-- ----------------------------
-- Table structure for sudi_orderdetail
-- ----------------------------
DROP TABLE IF EXISTS `sudi_orderdetail`;
CREATE TABLE `sudi_orderdetail` (
`orderDetailId` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '订单细则编号',
`orderId` varchar(20) DEFAULT NULL COMMENT '订单编号',
`skuId` bigint(20) DEFAULT NULL COMMENT '菜品SKU编号',
`amount` int(11) DEFAULT NULL COMMENT '条目计数',
`itemPrice` decimal(5,2) DEFAULT NULL COMMENT '条目价格',
`comment` int(2) DEFAULT NULL COMMENT '是否评价(1表示已评价；2表示未评价)',
PRIMARY KEY (`orderDetailId`),
KEY `orderId` (`orderId`),
CONSTRAINT `sudi_orderdetail_ibfk_1` FOREIGN KEY (`orderId`) REFERENCES `sudi_order` (`orderId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sudi_orderdetail
-- ----------------------------
INSERT INTO `sudi_orderdetail` VALUES ('1', 'D2021011515402986473', '1', '1', '46.00', '1');
INSERT INTO `sudi_orderdetail` VALUES ('2', 'D2021011515402986473', '12', '1', '6.00', '1');
INSERT INTO `sudi_orderdetail` VALUES ('3', 'D2021011515402986473', '15', '1', '3.50', '1');
-- ----------------------------
-- Table structure for sudi_role
-- ----------------------------
DROP TABLE IF EXISTS `sudi_role`;
CREATE TABLE `sudi_role` (
`roleId` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '角色编号',
`roleName` varchar(60) DEFAULT NULL COMMENT '角色名称',
`roleDesc` varchar(255) DEFAULT NULL COMMENT '角色描述',
`lastModifyBy` varchar(60) DEFAULT NULL COMMENT '上次修改人',
`lastModifyTime` datetime DEFAULT NULL COMMENT '上次修改时间',
PRIMARY KEY (`roleId`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sudi_role
-- ----------------------------
INSERT INTO `sudi_role` VALUES ('1', '普通用户', '普通用户的权限限于前台', 'admin', '2020-11-12 21:27:23');
INSERT INTO `sudi_role` VALUES ('2', '配送员', '负责餐品的配送服务', 'admin', '2020-11-14 16:27:22');
INSERT INTO `sudi_role` VALUES ('3', '食堂管理员', '负责食堂日常事务的管理和维护', 'admin', '2020-11-14 16:27:49');
INSERT INTO `sudi_role` VALUES ('4', '系统管理员', '负责系统的权责划分和用户的角色授予', 'admin', '2020-11-14 16:28:23');
INSERT INTO `sudi_role` VALUES ('5', '测试角色', '全权限，开发测试专用', 'admin', '2020-11-14 17:02:40');
-- ----------------------------
-- Table structure for sudi_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sudi_role_menu`;
CREATE TABLE `sudi_role_menu` (
`roleId` bigint(20) DEFAULT NULL COMMENT '角色编号',
`menuId` int(11) DEFAULT NULL COMMENT '菜单编号'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sudi_role_menu
-- ----------------------------
INSERT INTO `sudi_role_menu` VALUES ('4', '1');
INSERT INTO `sudi_role_menu` VALUES ('4', '2');
INSERT INTO `sudi_role_menu` VALUES ('4', '3');
INSERT INTO `sudi_role_menu` VALUES ('4', '4');
INSERT INTO `sudi_role_menu` VALUES ('4', '8');
INSERT INTO `sudi_role_menu` VALUES ('4', '9');
INSERT INTO `sudi_role_menu` VALUES ('5', '1');
INSERT INTO `sudi_role_menu` VALUES ('5', '2');
INSERT INTO `sudi_role_menu` VALUES ('5', '3');
INSERT INTO `sudi_role_menu` VALUES ('5', '4');
INSERT INTO `sudi_role_menu` VALUES ('5', '6');
INSERT INTO `sudi_role_menu` VALUES ('5', '5');
INSERT INTO `sudi_role_menu` VALUES ('5', '10');
INSERT INTO `sudi_role_menu` VALUES ('5', '11');
INSERT INTO `sudi_role_menu` VALUES ('5', '12');
INSERT INTO `sudi_role_menu` VALUES ('5', '13');
INSERT INTO `sudi_role_menu` VALUES ('5', '7');
INSERT INTO `sudi_role_menu` VALUES ('5', '15');
INSERT INTO `sudi_role_menu` VALUES ('5', '16');
INSERT INTO `sudi_role_menu` VALUES ('5', '17');
INSERT INTO `sudi_role_menu` VALUES ('5', '20');
INSERT INTO `sudi_role_menu` VALUES ('5', '24');
INSERT INTO `sudi_role_menu` VALUES ('5', '25');
INSERT INTO `sudi_role_menu` VALUES ('5', '8');
INSERT INTO `sudi_role_menu` VALUES ('5', '9');
INSERT INTO `sudi_role_menu` VALUES ('5', '14');
INSERT INTO `sudi_role_menu` VALUES ('5', '18');
INSERT INTO `sudi_role_menu` VALUES ('5', '19');
INSERT INTO `sudi_role_menu` VALUES ('5', '21');
INSERT INTO `sudi_role_menu` VALUES ('5', '22');
INSERT INTO `sudi_role_menu` VALUES ('5', '23');
INSERT INTO `sudi_role_menu` VALUES ('1', '8');
INSERT INTO `sudi_role_menu` VALUES ('1', '9');
INSERT INTO `sudi_role_menu` VALUES ('1', '14');
INSERT INTO `sudi_role_menu` VALUES ('1', '18');
INSERT INTO `sudi_role_menu` VALUES ('1', '19');
INSERT INTO `sudi_role_menu` VALUES ('2', '8');
INSERT INTO `sudi_role_menu` VALUES ('2', '9');
INSERT INTO `sudi_role_menu` VALUES ('2', '21');
INSERT INTO `sudi_role_menu` VALUES ('2', '22');
INSERT INTO `sudi_role_menu` VALUES ('2', '23');
INSERT INTO `sudi_role_menu` VALUES ('3', '6');
INSERT INTO `sudi_role_menu` VALUES ('3', '5');
INSERT INTO `sudi_role_menu` VALUES ('3', '10');
INSERT INTO `sudi_role_menu` VALUES ('3', '11');
INSERT INTO `sudi_role_menu` VALUES ('3', '12');
INSERT INTO `sudi_role_menu` VALUES ('3', '13');
INSERT INTO `sudi_role_menu` VALUES ('3', '7');
INSERT INTO `sudi_role_menu` VALUES ('3', '20');
INSERT INTO `sudi_role_menu` VALUES ('3', '8');
INSERT INTO `sudi_role_menu` VALUES ('3', '9');
-- ----------------------------
-- Table structure for sudi_shopcart
-- ----------------------------
DROP TABLE IF EXISTS `sudi_shopcart`;
CREATE TABLE `sudi_shopcart` (
`shopcartId` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '购物车细则编号',
`skuId` bigint(20) DEFAULT NULL COMMENT '菜品SKU编号',
`userId` bigint(20) DEFAULT NULL COMMENT '用户编号',
`numCount` int(11) DEFAULT NULL COMMENT '购买数量',
PRIMARY KEY (`shopcartId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sudi_shopcart
-- ----------------------------
-- ----------------------------
-- Table structure for sudi_ticket
-- ----------------------------
DROP TABLE IF EXISTS `sudi_ticket`;
CREATE TABLE `sudi_ticket` (
`ticketId` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '优惠券编号',
`ticketTypeId` bigint(20) DEFAULT NULL COMMENT '优惠券类别编号',
`userId` bigint(20) DEFAULT NULL COMMENT '领取用户编号',
`endTime` date DEFAULT NULL COMMENT '失效时间',
`ticketStatus` int(11) DEFAULT NULL COMMENT '优惠券状态(1表示未使用；2表示已使用；3表示已过期；4表示作废;5表示积分已返还)',
`startTime` date DEFAULT NULL COMMENT '领取时间',
PRIMARY KEY (`ticketId`),
KEY `ticketTypeId` (`ticketTypeId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sudi_ticket
-- ----------------------------
-- ----------------------------
-- Table structure for sudi_tickettype
-- ----------------------------
DROP TABLE IF EXISTS `sudi_tickettype`;
CREATE TABLE `sudi_tickettype` (
`ticketTypeId` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '优惠券类别编号',
`ticketName` varchar(120) DEFAULT NULL COMMENT '优惠券名称',
`requirement` decimal(5,2) DEFAULT NULL COMMENT '满减门槛',
`cheap` decimal(5,2) DEFAULT NULL COMMENT '优惠额度',
`ticketNum` int(11) DEFAULT NULL COMMENT '供应数量',
`receive` int(11) DEFAULT '0' COMMENT '已领取数',
`liveTime` int(11) DEFAULT NULL COMMENT '领取后有效天数',
`lastModifyBy` varchar(60) DEFAULT NULL COMMENT '上次修改人',
`lastModifyTime` datetime NOT NULL COMMENT '上次修改时间',
`ticketTypeStatus` int(11) DEFAULT '2' COMMENT '优惠券类别状态(1表示上架；2表示下架)',
`needScore` int(11) DEFAULT NULL COMMENT '兑换所需积分',
PRIMARY KEY (`ticketTypeId`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sudi_tickettype
-- ----------------------------
INSERT INTO `sudi_tickettype` VALUES ('1', 'test', '100.00', '10.00', '9898', '4', '7', 'admin', '2020-12-01 17:11:27', '1', '50');
INSERT INTO `sudi_tickettype` VALUES ('2', '感恩回馈', '40.00', '5.00', '1000', '405', '8', 'admin', '2020-11-29 14:24:52', '1', '60');
INSERT INTO `sudi_tickettype` VALUES ('3', '可怜的优惠券', '20.00', '2.00', '2', '2', '7', 'admin', '2021-01-14 17:59:44', '1', '10');
-- ----------------------------
-- Table structure for sudi_user
-- ----------------------------
DROP TABLE IF EXISTS `sudi_user`;
CREATE TABLE `sudi_user` (
`userId` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '用户编号',
`username` varchar(60) NOT NULL COMMENT '用户名',
`password` varchar(60) NOT NULL COMMENT '密码',
`phone` varchar(20) NOT NULL COMMENT '用户手机号',
`email` varchar(60) DEFAULT NULL COMMENT '用户邮箱',
`gender` int(11) DEFAULT '0' COMMENT '用户性别（1表示男，2表示女，0表示未知）',
`birthday` date DEFAULT NULL COMMENT '用户出生日期',
`registerDate` date DEFAULT NULL COMMENT '注册日期',
`score` int(11) DEFAULT '0' COMMENT '积分',
`lastLoginTime` datetime DEFAULT NULL COMMENT '上次登入时间',
`lastLogoutTime` datetime DEFAULT NULL COMMENT '上次登出时间',
`loginCount` int(11) DEFAULT '0' COMMENT '登录次数',
PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sudi_user
-- ----------------------------
INSERT INTO `sudi_user` VALUES ('1', 'admin', 'admin', '18750916277', '328092067@qq.com', '1', '2020-11-04', '2020-11-03', '130', '2021-01-15 15:46:12', '2021-01-15 15:47:21', '587');
INSERT INTO `sudi_user` VALUES ('2', 'deliver', '123456', '12345678901', '', '1', '2020-11-01', '2020-11-10', '0', '2021-01-15 15:43:35', '2021-01-15 15:44:07', '6');
INSERT INTO `sudi_user` VALUES ('3', 'manager', '123456', '18750916277', '328092067@qq.com', '1', '1999-04-12', '2020-11-10', '0', '2021-01-15 15:42:32', '2021-01-15 15:43:31', '5');
INSERT INTO `sudi_user` VALUES ('4', 'grant', '123456', '11111111111', '', '0', '1999-04-12', '2020-11-11', '0', '2020-11-20 16:27:59', '2020-11-20 16:27:38', '2');
INSERT INTO `sudi_user` VALUES ('5', 'test4', '123456', '11111111111', '', '0', null, '2020-11-11', '4', '2021-01-14 17:26:18', '2021-01-14 17:27:25', '7');
INSERT INTO `sudi_user` VALUES ('7', 'test6', '123456', '11111111111', '', '0', null, '2020-11-11', '0', null, null, '0');
INSERT INTO `sudi_user` VALUES ('8', 'test7', '123456', '11111111111', '', '0', null, '2020-11-11', '0', null, null, '0');
INSERT INTO `sudi_user` VALUES ('9', 'test8', '123456', '11111111111', '', '0', null, '2020-11-11', '0', '2020-11-17 12:58:25', '2020-11-17 12:58:33', '1');
INSERT INTO `sudi_user` VALUES ('10', 'test9', '123456', '11111111111', '2118119173@qq.com', '1', '1994-10-15', '2020-11-11', '11', '2021-01-15 15:47:29', '2021-01-15 15:46:08', '3');
INSERT INTO `sudi_user` VALUES ('12', '新增用户', '123456', '12345678900', '', '0', null, '2020-11-12', '0', null, null, '0');
INSERT INTO `sudi_user` VALUES ('13', 'sss', '123', '111', null, '0', null, null, '0', null, null, '0');
INSERT INTO `sudi_user` VALUES ('14', 'konijiwa', '123123', '12312312311', null, '0', null, '2020-11-19', '0', '2020-11-19 15:19:01', null, '1');
-- ----------------------------
-- Table structure for sudi_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sudi_user_role`;
CREATE TABLE `sudi_user_role` (
`userId` bigint(20) DEFAULT NULL COMMENT '用户编号',
`roleId` bigint(20) DEFAULT NULL COMMENT '角色编号'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sudi_user_role
-- ----------------------------
INSERT INTO `sudi_user_role` VALUES ('1', '1');
INSERT INTO `sudi_user_role` VALUES ('1', '5');
INSERT INTO `sudi_user_role` VALUES ('7', '2');
INSERT INTO `sudi_user_role` VALUES ('8', '2');
INSERT INTO `sudi_user_role` VALUES ('13', '2');
INSERT INTO `sudi_user_role` VALUES ('9', '2');
INSERT INTO `sudi_user_role` VALUES ('14', '1');
INSERT INTO `sudi_user_role` VALUES ('4', '1');
INSERT INTO `sudi_user_role` VALUES ('4', '4');
INSERT INTO `sudi_user_role` VALUES ('14', '2');
INSERT INTO `sudi_user_role` VALUES ('5', '1');
INSERT INTO `sudi_user_role` VALUES ('10', '1');
INSERT INTO `sudi_user_role` VALUES ('2', '2');
INSERT INTO `sudi_user_role` VALUES ('3', '1');
INSERT INTO `sudi_user_role` VALUES ('3', '3');