java+ssm的酒店管理系统

于 2023-11-17 09:28:21 发布
阅读量82 收藏
点赞数 3
分类专栏： SSM毕业设计 文章标签： java 开发语言
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/ldddss233323/article/details/134447477
版权

源码编号：D29

项目名称：基于SSM的酒店管理系统

项目类型：Java web(SSM框架）​

用户类型：三角色（用户、酒店员工、管理员）

主要技术：Java、JSP、SSM、Layui

运行环境：win10/win7、JDK1.8及以上

运行工具：IDEA/Eclipse

数  据  库：MySQL5.5及以上版本

运行服务器：Tomcat7.0及以上版本

是否基于Maven环境:是

数据库表数量：10张表

是否有代码注释：有注释

是否有毕业论文：有

是否有PPT:有

携带服务：远程调试服务和指导服务（远程调试、问题答疑和指导）

适用场景：Java毕业设计学习参考。

项目简介：酒店管理系统主要分为前台和后台，主要的功能模块由注册、登录、酒店列表、预订房间、用户下单、反馈、论坛交流、人员信息管理、酒店信息管理、酒店事务管理、以及论坛管理、系统管理等功能模块组成。

项目视频

基于SSM的酒店管理系统

项目内容

项目骨架

数据库

首页

注册

登录

酒店详情

预订房间

下单

论坛列表

评论帖子

用户中心

新增酒店

人员信息列表

入住信息列表

帖子信息列表

新增资讯

编辑房间

住宿预约订单

费用结算

以下是部分论文截图

论文页数：39页，字数10638字

目录

摘要

研究现状

需求分析

系统设计

系统实现

系统测试

以下是数据库设计

/*
 Navicat Premium Data Transfer

 Source Server         : 1
 Source Server Type    : MySQL
 Source Server Version : 50722
 Source Host           : localhost:3306
 Source Schema         : db_hotel

 Target Server Type    : MySQL
 Target Server Version : 50722
 File Encoding         : 65001

 Date: 12/03/2023 21:58:13
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for t_board
-- ----------------------------
DROP TABLE IF EXISTS `t_board`;
CREATE TABLE `t_board`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `create_time` datetime(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_board
-- ----------------------------
INSERT INTO `t_board` VALUES (1, '今天有新的酒店发布了', '今天有新的酒店发布了', '2023-02-21 15:20:56');
INSERT INTO `t_board` VALUES (2, '今天有新的酒店发布了', '今天有新的酒店发布了', '2023-02-21 15:20:56');

-- ----------------------------
-- Table structure for t_comment
-- ----------------------------
DROP TABLE IF EXISTS `t_comment`;
CREATE TABLE `t_comment`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `t_id` int(11) DEFAULT NULL,
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `u_id` int(11) DEFAULT NULL,
  `create_time` datetime(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `t_id`(`t_id`) USING BTREE,
  INDEX `u_id`(`u_id`) USING BTREE,
  CONSTRAINT `t_comment_ibfk_1` FOREIGN KEY (`t_id`) REFERENCES `t_tiezi` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `t_comment_ibfk_2` FOREIGN KEY (`u_id`) REFERENCES `t_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_comment
-- ----------------------------
INSERT INTO `t_comment` VALUES (1, 1, '32323232', 3, '2023-02-21 15:26:16');

-- ----------------------------
-- Table structure for t_cost
-- ----------------------------
DROP TABLE IF EXISTS `t_cost`;
CREATE TABLE `t_cost`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ruzhu_id` int(11) DEFAULT NULL,
  `h_id` int(11) DEFAULT NULL,
  `room_id` int(11) DEFAULT NULL,
  `total_price` decimal(10, 2) DEFAULT NULL,
  `create_time` datetime(0) DEFAULT NULL,
  `days` int(1) DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for t_feedback
-- ----------------------------
DROP TABLE IF EXISTS `t_feedback`;
CREATE TABLE `t_feedback`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `note` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `create_time` datetime(0) DEFAULT NULL,
  `u_id` int(11) DEFAULT NULL,
  `h_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_feedback
-- ----------------------------
INSERT INTO `t_feedback` VALUES (1, '这个酒店不错啊', '2023-02-21 15:20:16', 3, 2);
INSERT INTO `t_feedback` VALUES (2, '这个酒店不错啊', '2023-02-21 15:20:16', 3, 2);

-- ----------------------------
-- Table structure for t_hotel
-- ----------------------------
DROP TABLE IF EXISTS `t_hotel`;
CREATE TABLE `t_hotel`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `category` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `detail` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `create_time` datetime(0) DEFAULT NULL,
  `photo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `parking` 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;

-- ----------------------------
-- Records of t_hotel
-- ----------------------------
INSERT INTO `t_hotel` VALUES (2, '宿州大酒店', '三星级酒店', '17766091168', '<img src=\"/upload/20232210430b071b49f4664b0b2db5218513c8asuzhou.jpg\" alt=\"20232210430b071b49f4664b0b2db5218513c8asuzhou.jpg\">', '2023-02-21 10:33:53', '1676975630.jpg', '宿州大街101号', '东部停车场1号');

-- ----------------------------
-- Table structure for t_orders
-- ----------------------------
DROP TABLE IF EXISTS `t_orders`;
CREATE TABLE `t_orders`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `orders_no` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `u_id` int(11) DEFAULT NULL,
  `h_id` int(11) DEFAULT NULL,
  `create_date` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `create_time` datetime(0) DEFAULT NULL,
  `r_id` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_orders
-- ----------------------------
INSERT INTO `t_orders` VALUES (4, '20230222000210133', 3, 2, '2023-02-22', '233232', '2023-02-21 16:02:10', 1, 1);

-- ----------------------------
-- Table structure for t_room
-- ----------------------------
DROP TABLE IF EXISTS `t_room`;
CREATE TABLE `t_room`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `flag` int(11) DEFAULT NULL,
  `room_no` varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `price` decimal(10, 2) DEFAULT NULL,
  `h_id` int(11) DEFAULT NULL,
  `detail` longtext CHARACTER SET utf8 COLLATE utf8_general_ci,
  `photo` 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;

-- ----------------------------
-- Records of t_room
-- ----------------------------
INSERT INTO `t_room` VALUES (1, '普通双人房', 2, '101', '223', 129.00, 2, '非常不错呢', '1676988176.png');
INSERT INTO `t_room` VALUES (2, '双人间', 3, '102', '223', 200.00, 2, '豪华双人间', '1676988206.png');

-- ----------------------------
-- Table structure for t_ruzhu
-- ----------------------------
DROP TABLE IF EXISTS `t_ruzhu`;
CREATE TABLE `t_ruzhu`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `h_id` int(11) DEFAULT NULL,
  `r_id` int(11) DEFAULT NULL,
  `cno` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `realname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `create_time` datetime(0) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_ruzhu
-- ----------------------------
INSERT INTO `t_ruzhu` VALUES (1, 2, 1, '343443222122', '李双江', '2023-02-22 16:07:18', 1);
INSERT INTO `t_ruzhu` VALUES (2, 2, 1, '343443222122', '李双江', '2023-02-22 16:07:18', 1);

-- ----------------------------
-- Table structure for t_tiezi
-- ----------------------------
DROP TABLE IF EXISTS `t_tiezi`;
CREATE TABLE `t_tiezi`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `create_time` datetime(0) DEFAULT NULL,
  `u_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `u_id`(`u_id`) USING BTREE,
  CONSTRAINT `t_tiezi_ibfk_1` FOREIGN KEY (`u_id`) REFERENCES `t_user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_tiezi
-- ----------------------------
INSERT INTO `t_tiezi` VALUES (1, '有没有好一点的酒店', '<p>有没有好一点的酒店有没有好一点的酒店有没有好一点的酒店有没有好一点的酒店</p>', '2023-02-21 15:04:14', 3);

-- ----------------------------
-- Table structure for t_user
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `realname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `sex` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `tx` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `create_time` datetime(0) DEFAULT NULL,
  `role` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES (1, '管理员', 'admin', '男', '1', '1676974112.jpg', NULL, 3);
INSERT INTO `t_user` VALUES (2, '张三', '17766091168', '男', '1', '1676962242.jpg', '2023-02-21 06:50:43', 2);
INSERT INTO `t_user` VALUES (3, '逍遥游', '1', '男', '1', '1676979432.png', '2023-02-21 11:37:19', 1);

SET FOREIGN_KEY_CHECKS = 1;


 

ldddss233323
关注
专栏目录
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值