项目介绍:酒店信息管理系统以Java语言开发。使用的是MySQL数据库存储信息。开发方式以MVC模式进行。后端框架以SSM为核心技术。为了满足酒店日常工作的实际需求,拟定3类角色使用。管理员处理维护整个网站的数据。用户以在线预订宾馆入住为主。员工则以处理宾馆日常事务主。基本的功能包括宾馆客房管理、餐饮服务、库存管理等主要核心模块。
项目类型:SSM源码
用户类型:3个角色(管理员+员工+用户)
主要技术:SSM+MySQL+Jquery(前端Bootstrap)
开发工具:Eclipse/Idea均可使用,有两个不同的版本
数据库:MySQL
数据库表:10张
🍅演示视频在底部🍅
🍅文末获取联系🍅
目录
01管理员端功能介绍
1.0系统后台
1.1用户管理模块
1.2员工管理模块
1.3通知管理模块
1.4客房管理模块
1.5酒店物资管理模块
1.6酒店物资出入库审核模块
1.7餐品管理模块
02用户端
2.1 用户端首页
2.2酒店客房查询模块
2.3餐品查询页面
2.4新闻通知页面
2.5客房预订页面
2.6餐品点餐页面
03员工端
3.1 餐饮订单管理模块
3.2 客房订单管理模块
3.3酒店物资出入库模块
04项目结构
05数据库设计
06完整的程序目录
07演示视频
【原创】基于SSM的酒店信息管理系统(毕业设计源代码)
-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '账号',
`password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
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, '1', '1');
-- ----------------------------
-- Table structure for churuku
-- ----------------------------
DROP TABLE IF EXISTS `churuku`;
CREATE TABLE `churuku` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`eid` int(11) DEFAULT NULL COMMENT '操作员工id',
`rno` varchar(111) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '订单号',
`ctime` varchar(111) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '操作时间',
`state` int(255) DEFAULT NULL COMMENT '审核状态',
`pid` int(255) DEFAULT NULL COMMENT '物品id',
`type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '操作类型',
`donum` int(11) DEFAULT NULL COMMENT '处理数量',
`yongtu` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用途信息',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of churuku
-- ----------------------------
INSERT INTO `churuku` VALUES (3, 59, '20221107180725663', '2022-11-07 18:07', 2, 17, '出库', 1600, '操作50');
INSERT INTO `churuku` VALUES (4, 59, '20221108235813478', '2022-11-08 23:58', 0, 13, '出库', 222, '22');
INSERT INTO `churuku` VALUES (5, 59, '20230420234347933', '2023-04-20 23:43', 0, 13, '出库', 400, '2');
-- ----------------------------
-- Table structure for employee
-- ----------------------------
DROP TABLE IF EXISTS `employee`;
CREATE TABLE `employee` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
`password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
`email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '邮箱',
`times` varchar(33) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '注册时间',
`job` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '职位',
`sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '性别',
`phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '手机',
`img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '头像',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 60 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of employee
-- ----------------------------
INSERT INTO `employee` VALUES (59, '张三', '1', '1', '2022-11-07 12:14', '1', '男', '1', '2022-12-23/6faf957a-03a6-4584-9538-914d36f66fe4.jpg');
-- ----------------------------
-- Table structure for hotel
-- ----------------------------
DROP TABLE IF EXISTS `hotel`;
CREATE TABLE `hotel` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`mtype` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '客房类型',
`mname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '客房号',
`price` double(10, 2) DEFAULT NULL COMMENT '价格/晚',
`detail` varchar(2552) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '介绍',
`floor` int(255) DEFAULT NULL COMMENT '楼层',
`breakfast` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否有早餐',
`wifi` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否有wifi',
`mianji` double(255, 0) DEFAULT NULL COMMENT '房间面积',
`state` int(255) DEFAULT NULL COMMENT '入住状态',
`img` 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 hotel
-- ----------------------------
INSERT INTO `hotel` VALUES (4, '总统套房', '201', 22.00, '<p><img src=\"/mav/ueditor/jsp/upload/image/20221108/1667897264133044614.jpg\" title=\"1667897264133044614.jpg\" alt=\"hotel_2.jpg\"/></p><p>平安宾馆</p><p><img src=\"/mav/ueditor/jsp/upload/image/20221108/1667897285600088606.jpg\" title=\"1667897285600088606.jpg\" alt=\"hotel_5.jpg\" width=\"585\" height=\"457\"/></p>', 2, '有早餐', '单独WIFI', 2, 0, '2022-11-08/69a31345-930d-4ba3-8354-f9294f0f67f2.jpg');
INSERT INTO `hotel` VALUES (5, '总统套房', '502', 20.00, '<p>22</p>', 5, '有早餐', '单独WIFI', 50, 0, '2022-12-23/e06af8ee-39c5-47ed-8731-669219fcaee2.jpg');
INSERT INTO `hotel` VALUES (6, '双人标间', '303', 389.00, '<p><img src=\"/mav/ueditor/jsp/upload/image/20221223/1671780080027018011.jpg\" title=\"1671780080027018011.jpg\" alt=\"hotel_2.jpg\"/></p>', 3, '有早餐', '单独WIFI', 50, 0, '2022-11-09/fffdef51-24fc-47e1-9d93-ffd67873977c.jpg');
INSERT INTO `hotel` VALUES (7, '总统套房', '503', 200.00, '', 5, '有早餐', '单独WIFI', 18, 1, '2023-08-17/db17c445-cd05-4974-acb6-0ca6b766031a.jpg');
-- ----------------------------
-- Table structure for hotelorder
-- ----------------------------
DROP TABLE IF EXISTS `hotelorder`;
CREATE TABLE `hotelorder` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`uid` int(22) DEFAULT NULL COMMENT '住客id',
`hid` int(22) DEFAULT NULL COMMENT '客房id',
`dates` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '入住/离店时间',
`tianshu` int(255) DEFAULT NULL COMMENT '入住天数',
`arrive` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '预计到店时间',
`nums` int(255) DEFAULT NULL COMMENT '入住人数',
`yuyueren` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '预约人',
`phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系电话',
`rno` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '订单号',
`state` int(255) DEFAULT NULL COMMENT '订单状态',
`ctime` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '创建时间',
`money` double(255, 2) DEFAULT NULL COMMENT '金额',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of hotelorder
-- ----------------------------
INSERT INTO `hotelorder` VALUES (7, 33, 6, '2023-08-17 入住 2023-08-19 退房 ', 2, '17日下午', 1, '张总', '18020815141', '20230817194225185', 2, '2023-08-17 19:42', 44.00);
INSERT INTO `hotelorder` VALUES (8, 33, 7, '2023-08-18 入住 2023-08-19 退房 ', 1, '1', 1, '1', '1', '20230817203637934', 1, '2023-08-17 20:36', 22.00);
-- ----------------------------
-- Table structure for meal
-- ----------------------------
DROP TABLE IF EXISTS `meal`;
CREATE TABLE `meal` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id\r\n\r\n\r\n\r\n',
`mname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '餐饮名称',
`mtype` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '类型',
`price` double(11, 2) DEFAULT NULL COMMENT '价格',
`detail` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '详情',
`img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '图片',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of meal
-- ----------------------------
INSERT INTO `meal` VALUES (2, '肯德基', '小吃', 22.00, '<p><img src=\"/mav/ueditor/jsp/upload/image/20221223/1671780155803059749.jpg\" title=\"1671780155803059749.jpg\" alt=\"thumb_map_single_restaurant.jpg\"/></p>', '2023-08-17/08da2f7f-8adf-49cd-8e0d-eb47d9bd73e0.jpg');
INSERT INTO `meal` VALUES (3, '至尊牛排', '小吃', 25.00, NULL, '2023-08-17/1ab6f863-b9d6-4bd5-8101-4633318ff330.jpg');
INSERT INTO `meal` VALUES (4, '维他奶', '饮料', 5.00, '<p>维他奶</p><p><img src=\"/mav/ueditor/jsp/upload/image/20230817/1692263656436043462.jpeg\" title=\"1692263656436043462.jpeg\" alt=\"6f2f11d3dee745848fd89cc88abdc645.jpeg\"/></p>', '2023-08-17/7f61e7d1-c703-4479-b5ae-1739476b9874.jpeg');
-- ----------------------------
-- Table structure for mealorder
-- ----------------------------
DROP TABLE IF EXISTS `mealorder`;
CREATE TABLE `mealorder` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`mid` int(11) DEFAULT NULL COMMENT '餐品id',
`uid` int(11) DEFAULT NULL COMMENT '用户id',
`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '下单人',
`phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '联系电话',
`num` int(11) DEFAULT NULL COMMENT '总数',
`beizhu` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '备注',
`rno` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '订单编号',
`state` int(255) DEFAULT NULL COMMENT '订单状态',
`room` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '送达客房号',
`ctime` varchar(111) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '下单时间',
`money` double(255, 2) DEFAULT NULL COMMENT '金额',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of mealorder
-- ----------------------------
INSERT INTO `mealorder` VALUES (1, 2, 33, '2', '2', 1, '2', '20221108224315710', 1, '2', '2022-11-08 22:43', 60.00);
INSERT INTO `mealorder` VALUES (2, 2, 33, '2', '2', 1, '2123', '20221108235515897', 1, '202', '2022-11-08 23:55', 20.00);
-- ----------------------------
-- Table structure for news
-- ----------------------------
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '标题',
`content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '新闻内容',
`img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '图片',
`times` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '发布时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of news
-- ----------------------------
INSERT INTO `news` VALUES (3, '通知信息', '关于酒店的通知', '2022-09-17/f577730a-2f3c-44bc-ad7d-fdb814f1bb57.jpg', '2022-09-17 17:42');
INSERT INTO `news` VALUES (4, '通知内容', '今日将进行酒店清洗', '2022-09-17/05449b95-4f5e-431c-a63c-13f655943234.png', '2022-09-17 17:43');
INSERT INTO `news` VALUES (5, '检查卫生的通知', '近期将检查卫生', '2022-09-17/fade6f84-9c52-4434-b754-4afd28823975.png', '2022-09-17 20:11');
-- ----------------------------
-- Table structure for product
-- ----------------------------
DROP TABLE IF EXISTS `product`;
CREATE TABLE `product` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`names` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '宾馆用品名称',
`price` double(10, 2) DEFAULT NULL COMMENT '价格',
`type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用品类型',
`snums` int(11) DEFAULT 0 COMMENT '库存数量',
`img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '图片',
`endnums` int(255) DEFAULT NULL COMMENT '预警值',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of product
-- ----------------------------
INSERT INTO `product` VALUES (13, '厨具', 2.00, '日常消耗品', 500, '2022-12-23/82e55110-e676-4a33-95c5-79e9e35dc64e.jpg', 50);
INSERT INTO `product` VALUES (14, '锅子', 3.00, '日常消耗品', 500, '2022-12-23/0486d23a-503c-4bea-a552-c076853b3187.jpg', 600);
INSERT INTO `product` VALUES (15, '炉子', 23.00, '日常消耗品', 500, '2022-12-23/50aa1799-90f6-4f61-8fb5-85c1efa695e4.jpg', 300);
INSERT INTO `product` VALUES (17, '毛巾', 3.00, '3', 1100, '2022-09-19/e61b508b-dba7-429a-bb42-1e2dc7744627.png', 100);
INSERT INTO `product` VALUES (18, '三星五费都可能翻车', 220.00, '日常消耗品', 0, '2022-11-07/a3f0f58c-f226-4019-8f7e-5eca162ad92b.jpg', 22);
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '姓名',
`password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '密码',
`email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '邮箱',
`times` varchar(33) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '注册时间',
`address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '籍贯',
`sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '性别',
`phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '手机',
`img` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '头像',
`userno` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '账号',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 39 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (33, '1', '1', '1', '2022-10-25 13:05', '2', '男', '1', '2023-08-17/b5e62e99-c433-44c3-b8cb-0a38b9fcc6f9.jpg', '1');
INSERT INTO `user` VALUES (34, '1', '1', '2', '2022-10-25 13:05', '2', '男', '2', '2023-08-17/06b6018d-b613-4e7b-adb6-e1e00d78f76e.jpg', '2');
INSERT INTO `user` VALUES (38, '7', '7', '7', '2022-10-26 22:20', '4', '男', '7', '2022-10-26/a82a21f1-46dd-45e4-84a1-c5ae9b613dac.jpg', '7');
SET FOREIGN_KEY_CHECKS = 1;