项目类型:SSM源码
用户类型:2个角色(管理员+用户)
主要技术:SSM+MySQL+Bootstrap
开发工具:Eclipse/Idea均可使用,有两个不同的版本
数据库:MySQL
数据库表:8张
项目介绍:后端采用SSM框架。前端使用的是Bootstrap的一个网站模板。通过2种角色使用,实现了包括了酒店信息管理、酒店客房预约、行程信息填写、数据统计等多个不同的模块。根据用户的行程信息,即绿码、黄码等情况进行预定,也会有不同的反应。
演示视频在底部目录
文末获取联系
00完整的程序目录
01管理员端功能介绍
1.0用户注册
1.1用户登录
1.2后台首页
1.3酒店楼层信息管理
1.4员工管理
1.5客房类型管理
1.6酒店客房信息录入
1.7客房详情页面
1.8入住审核
1.9风险地区查看
1.10用户行程信息查看
1.11酒店数据统计
02用户端功能介绍
2.1个人资料修改
2.2行程信息录入
2.3客房预定
2.4预约记录管理(包括换房、退房、支付费用)
2.5客房更换
03项目结构
Eclipse版本目录
Idea版本目录
04数据库设计
05演示视频
00完整的程序目录
文章图片
01管理员端功能介绍 1.0用户注册
文章图片
1.1用户登录
文章图片
1.2后台首页
文章图片
1.3酒店楼层信息管理
文章图片
1.4员工管理
文章图片
1.5客房类型管理
文章图片
1.6酒店客房信息录入
文章图片
1.7客房详情页面
文章图片
1.8入住审核
文章图片
1.9风险地区查看
文章图片
1.10用户行程信息查看
文章图片
1.11酒店数据统计
文章图片
02用户端功能介绍
2.1个人资料修改
文章图片
2.2行程信息录入
文章图片
2.3客房预定
文章图片
文章图片
2.4预约记录管理(包括换房、退房、支付费用)
文章图片
2.5客房更换
文章图片
03项目结构
Eclipse版本目录
文章图片
Idea版本目录
文章图片
04数据库设计
文章图片
05演示视频 【原创】基于SSM的酒店管理系统(毕业设计源代码)
-- ----------------------------
-- 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,
`password` 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;
-- ----------------------------
-- Table structure for area
-- ----------------------------
DROP TABLE IF EXISTS `area`;
CREATE TABLE `area`(
`id` int(11) NOT NULL AUTO_INCREMENT,
`sheng` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`shi` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`qu` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`type` varchar(255) 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;
-- ----------------------------
-- Table structure for floor
-- ----------------------------
DROP TABLE IF EXISTS `floor`;
CREATE TABLE `floor`(
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for healthy
-- ----------------------------
DROP TABLE IF EXISTS `healthy`;
CREATE TABLE `healthy`(
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`idCard` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`mobile` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`froms` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`place` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`home` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`sta` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`stb` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for record
-- ----------------------------
DROP TABLE IF EXISTS `record`;
CREATE TABLE `record`(
`id` int(11) NOT NULL AUTO_INCREMENT,
`roomId` int(11) DEFAULT NULL,
`roomType` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`checkinPrice` double(10, 2) DEFAULT NULL,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`idCard` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`mobile` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`arriveDate` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`leaveDate` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`orderId` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`iszf` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`arrivetime` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`room` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 48 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for room
-- ----------------------------
DROP TABLE IF EXISTS `room`;
CREATE TABLE `room`(
`id` int(11) NOT NULL AUTO_INCREMENT,
`photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`sn` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`roomType` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`floorId` varchar(222) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`price` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '价格',
`wifi` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否有wifi',
`water` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '是否有热水',
`mianji` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '面积',
`bed` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '床位数量',
`detail` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '介绍',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for type
-- ----------------------------
DROP TABLE IF EXISTS `type`;
CREATE TABLE `type`(
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`price` double(10, 2) DEFAULT NULL,
`liveNum` int(11) DEFAULT NULL,
`bedNum` int(11) DEFAULT NULL,
`descs` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`(
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`realName` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`idCard` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`mobile` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
`health` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '1绿码 2 红码',
`status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '1正常 ',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;
【原创JavaWeb项目|【原创】基于SSM的酒店预约管理系统(酒店管理系统毕业设计)】
推荐阅读
- asp.net|基于ASP.NET的Web酒品销售商城平台系统
- 毕业设计|【毕业设计】微信小程序 - 商城购物系统
- 大数据|【毕业设计】行人口罩佩戴检测系统 - 深度学习 机器视觉
- 【小小的项目|【基于Java和Socket等技术的聊天室系统的设计与实现-----这或许就是QQ的原型之一吧!(效果+源码+论文+视频介绍等获取~!)】
- java精品项目下载|java-第23期基于ssm培训教务管理系统【毕业设计】
- 毕业设计|毕设项目 - 基于SSM的毕业设计管理系统(含源码+论文)
- 区块链|基于fabric区块链的java链码编写,毕业设计选题研究Hyperledger fabric联盟链项目开发经验
- 大数据|【毕业设计】基于HMM隐马尔科夫的股票预测 - 机器学习 股票预测 python
- 毕业设计|【毕业设计】信用卡欺诈检测系统 - python 大数据