【原创】基于SSM的酒店预约管理系统(酒店管理系统毕业设计)
项目类型: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;