【原创】基于JavaWeb的在线点餐系统(网上点餐系统毕业设计)

 项目介绍:在线点餐系统分为网站和后台管理,角色上来说分为客户、商户和管理员三个角色。其中网站主要是面向客户的,客户可以在网站商家、餐品,如果想要把餐品添加至购物车,则需要注册登录以后才可以进入到个人中心,个人中心里主要有购物车、我的订单、修改密码等等。网站的后台,管理员端登录以后进入到在线点餐系统的主界面,主要有用户管理、餐饮管理、等等。商家端则有上架餐品的功能,并可以为自己店内的订单进行发货配送。。

项目类型:JavaWeb源码 

用户类型:3个角色(管理员+商家+用户)

主要技术:Jsp+Servlet+MySQL+Bootstrap

开发工具:Eclipse/Idea均可使用,有两个不同的版本

数据库:MySQL

数据库表:11张

🍅演示视频在底部🍅

🍅文末获取联系🍅

目录

01用户端功能介绍

1.0网站首页

1.1餐品详情

1.2网站公告查看

1.3购物车页面

1.4个人订单管理

1.5个人中心

02餐饮商家端功能介绍

2.1 营业数据统计

2.2个人资料修改

2.3店内餐品信息管理模块

2.4销售订单管理

03管理员端功能介绍

3.1 用户管理模块

3.2 用户管理模块

3.3 公告管理模块

3.4 评论管理模块

04项目结构

05数据库设计

06演示视频

【原创】基于JavaWeb的在线点餐系统



SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES (1, 'admin', '学长', '123456');

-- ----------------------------
-- Table structure for board
-- ----------------------------
DROP TABLE IF EXISTS `board`;
CREATE TABLE `board`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `content` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `editor` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `times` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of board
-- ----------------------------
INSERT INTO `board` VALUES (1, '点餐须知', '<p>点餐需知:<br/></p><p>点餐时,及时下单支付。</p><p><img src=\"/food_order_web/ueditor/jsp/upload/image/20231201/1701433204847035932.png\" title=\"1701433204847035932.png\" alt=\"banner-8.png\"/></p>', '9c7a2c5c-7935-4683-8d60-07961ea964c1.png', '管理员', '2023-03-23 14:48');
INSERT INTO `board` VALUES (2, '点餐时需要注意的事项', '<p>点餐时需要注意的事项</p>', '9a3dcc6a-d0ed-48fd-94dc-c43303b3a5fc.png', '管理员', '2023-12-01 21:27');
INSERT INTO `board` VALUES (3, '系统升级说明', '<p>系统升级说明</p>', 'b610c5d3-4dda-4ceb-a75d-e4cfb7c2ab6f.png', '系统升级说明', '2023-12-01 21:27');

-- ----------------------------
-- Table structure for cart
-- ----------------------------
DROP TABLE IF EXISTS `cart`;
CREATE TABLE `cart`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `gid` int(11) DEFAULT NULL,
  `nums` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for category
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES (2, '水果');
INSERT INTO `category` VALUES (3, '饮料');
INSERT INTO `category` VALUES (4, '盖浇饭');
INSERT INTO `category` VALUES (6, '海鲜');

-- ----------------------------
-- Table structure for collection
-- ----------------------------
DROP TABLE IF EXISTS `collection`;
CREATE TABLE `collection`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `gid` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of collection
-- ----------------------------
INSERT INTO `collection` VALUES (3, 6, 1);
INSERT INTO `collection` VALUES (4, 6, 24);
INSERT INTO `collection` VALUES (5, 6, 23);
INSERT INTO `collection` VALUES (6, 4, 23);

-- ----------------------------
-- Table structure for comments
-- ----------------------------
DROP TABLE IF EXISTS `comments`;
CREATE TABLE `comments`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `uid` int(11) DEFAULT NULL,
  `gid` int(11) DEFAULT NULL,
  `times` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of comments
-- ----------------------------
INSERT INTO `comments` VALUES (2, '味道很不错,已经点了很多次了', 4, 22, '2023-03-23 14:48');
INSERT INTO `comments` VALUES (3, '味道很不错,已经点了很多次了', 4, 22, '2023-03-23 14:48');
INSERT INTO `comments` VALUES (4, '味道很不错,已经点了很多次了', 4, 22, '2023-03-23 14:48');
INSERT INTO `comments` VALUES (5, '味道很不错,已经点了很多次了', 4, 22, '2023-03-23 14:48');

-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cid` int(11) DEFAULT NULL,
  `mid` int(11) DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `price` decimal(10, 2) DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '配料成分',
  `detail` text CHARACTER SET utf8 COLLATE utf8_general_ci,
  `times` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `totals` int(11) DEFAULT 0 COMMENT '总售出',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 29 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of goods
-- ----------------------------
INSERT INTO `goods` VALUES (20, 3, 6, '西米露', '947c2154-bc14-4017-8369-67bdc94d31c7.png', 55.00, '西米露', '<p>西米露</p>', '2023-03-23 14:48', 2);
INSERT INTO `goods` VALUES (21, 3, 6, '橙汁', '02d18541-3768-45f0-825f-33a4f3582e28.png', 55.00, '橙汁', '<p>橙汁</p>', '2023-03-23 14:48', 1);
INSERT INTO `goods` VALUES (22, 4, 6, '蔬菜沙拉', '015af727-e225-48c8-9738-c13700eb715c.png', 22.00, '蔬菜沙拉   ', '<p>蔬菜沙拉</p><p><img src=\"http://localhost:8080/food_order_web/ueditor/jsp/upload/image/20231201/1701436016303013880.png\" title=\"1701436016303013880.png\" alt=\"blog-4.png\" width=\"712\" height=\"578\"/></p><p><br/></p><p><img src=\"/food_order_web/ueditor/jsp/upload/image/20231201/1701436074147089027.png\" title=\"1701436074147089027.png\" alt=\"blog-5.png\" width=\"653\" height=\"569\"/></p><p><br/></p><p><br/></p>', '2023-12-01 21:05', 1);
INSERT INTO `goods` VALUES (23, 6, 6, '海鲜大咖', '119ed8bd-ac2e-496d-bf34-33d7e759b32f.jpg', 599.00, '海虹,大虾,粉丝扇贝,鲍鱼 ', '<p><img src=\"/food_order_web/ueditor/jsp/upload/image/20220323/1648018096617007063.jpeg\" title=\"1648018096617007063.jpeg\" alt=\"0ec29cbe4accf3e0c8a7148c9bea348f.jpeg\"/></p>', '2023-03-23 14:48', 2);
INSERT INTO `goods` VALUES (24, 4, 6, '肯德基', '9322b84f-30d2-459c-8f80-d15fa6ecfc07.jpg', 3.00, ' 3', '<p>33<br/></p>', '2023-03-23 14:48', 2);
INSERT INTO `goods` VALUES (25, 4, 6, '至尊披萨', '35bb0b97-6c4b-4c5c-8c20-da73829811ad.png', 44.00, '披萨', '<p>至尊披萨</p>', '2023-03-23 14:48', 0);
INSERT INTO `goods` VALUES (29, 6, 6, '龙虾', '60096a92-5f90-4426-ba8a-077714e6f553.jpeg', 300.00, '波士顿大龙虾  !!!! ', '<p><img src=\"/food_order_web/ueditor/jsp/upload/image/20220317/1647528669541029843.jpeg\" title=\"1647528669541029843.jpeg\" alt=\"9d1e5986b0bf5547bfe8f2cd5778e901.jpeg\"/></p>', '2023-03-23 14:48', 5);

-- ----------------------------
-- Table structure for merchant
-- ----------------------------
DROP TABLE IF EXISTS `merchant`;
CREATE TABLE `merchant`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `realname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `times` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `room_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '餐厅名称',
  `room_star` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '餐厅星级',
  `room_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '餐厅地址',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of merchant
-- ----------------------------
INSERT INTO `merchant` VALUES (6, '李管家', '1', '1', '2023-03-23 14:48', '8946b494-a3f8-4c67-947f-085be17c0af3.png', '李胖子肉蟹煲', '二星级', '江苏省南京市秦淮区');

-- ----------------------------
-- Table structure for order_detail
-- ----------------------------
DROP TABLE IF EXISTS `order_detail`;
CREATE TABLE `order_detail`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ordernum` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '订单编号',
  `gid` int(11) DEFAULT NULL COMMENT '商品id',
  `nums` int(11) DEFAULT NULL COMMENT '数量',
  `total_money` decimal(11, 0) DEFAULT NULL COMMENT '总价',
  `state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '0' COMMENT '0已下单 1 已送出  3 已签收',
  `times` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of order_detail
-- ----------------------------
INSERT INTO `order_detail` VALUES (1, '20220323144857535', 26, 1, 300, '2', '2023-03-23 14:48');
INSERT INTO `order_detail` VALUES (2, '20220323144857535', 23, 1, 599, '2', '2023-03-23 14:48');
INSERT INTO `order_detail` VALUES (3, '20220324191649716', 25, 1, 300, '2', '2023-03-23 14:48');
INSERT INTO `order_detail` VALUES (4, '20230322211608886', 25, 1, 300, '2', '2023-03-23 14:48');
INSERT INTO `order_detail` VALUES (5, '20230322211608886', 24, 1, 3, '1', '2023-03-23 14:48');
INSERT INTO `order_detail` VALUES (6, '20230322211929762', 25, 1, 300, '1', '2023-03-23 14:48');
INSERT INTO `order_detail` VALUES (7, '20230424012940829', 24, 1, 300, '1', '2023-03-23 14:48');
INSERT INTO `order_detail` VALUES (8, '20230424012940829', 24, 1, 3, '1', '2023-03-23 14:48');
INSERT INTO `order_detail` VALUES (9, '20230424012940829', 23, 1, 599, '1', '2023-03-23 14:48');
INSERT INTO `order_detail` VALUES (10, '20231201215557588', 20, 1, 55, '1', '2023-12-01');
INSERT INTO `order_detail` VALUES (11, '20231201215557588', 21, 1, 55, '1', '2023-12-01');
INSERT INTO `order_detail` VALUES (12, '20231201215942525', 22, 1, 22, '1', '2023-12-01');
INSERT INTO `order_detail` VALUES (13, '20231201215942525', 20, 1, 55, '2', '2023-12-01');

-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ordernum` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '订单编号',
  `times` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '下单时间',
  `totals_money` decimal(11, 0) DEFAULT NULL COMMENT '总金额',
  `totals` int(11) DEFAULT NULL COMMENT '总数',
  `uid` int(11) DEFAULT NULL COMMENT '用户id',
  `state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT '0' COMMENT '0已下单 1 已送出  3 已签收',
  `pay` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '支付方式',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of orders
-- ----------------------------
INSERT INTO `orders` VALUES (1, '20220323144857535', '2023-03-23 14:48', 899, 2, 4, '0', '支付宝');
INSERT INTO `orders` VALUES (2, '20220324191649716', '2023-03-23 14:48', 300, 1, 4, '0', '支付宝');
INSERT INTO `orders` VALUES (3, '20230322211608886', '2023-03-23 14:48', 303, 2, 6, '0', '支付宝');
INSERT INTO `orders` VALUES (4, '20230322211929762', '2023-03-23 14:48', 300, 1, 6, '0', '支付宝');
INSERT INTO `orders` VALUES (5, '20230424012940829', '2023-03-23 14:48', 902, 3, 6, '0', '支付宝');
INSERT INTO `orders` VALUES (6, '20231201215557588', '2023-12-01 21:55', 110, 2, 4, '0', '支付宝');
INSERT INTO `orders` VALUES (7, '20231201215942525', '2023-12-01 21:59', 77, 2, 4, '0', '支付宝');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `realname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `times` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (4, '张浩天', '1', '男', '1', '2023-03-23 14:48', '1299a7bf-53bb-4011-98d3-dab1df1156c0.png');
INSERT INTO `user` VALUES (6, '张三', '2', '男', '2', '2023-03-23 14:48', '4325a66e-c458-4e35-b3a8-0cbb816382eb.png');

SET FOREIGN_KEY_CHECKS = 1;

  • 0
    点赞
  • 12
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

那条学长V

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值