这是一份数据库酒店管理的代码【简易版】

这是一份数据库酒店管理的代码
代码中有数据取自网络
若侵联删 此外还有别的数据库代码 什么二手车交易，图书馆管理系统等 需要看的话 评论一下 其实都大同小异 只是有一些数据的名称和数据比较难取 可能去看看现实中的项目都需要什么数据
你的酒店有几个楼？（可改宿舍等）

/*
Navicat MySQL Data Transfer

Source Server         : MYSQL
Source Server Version : 50643
Source Host           : 127.0.0.1:3306
Source Database       : hhh

Target Server Type    : MYSQL
Target Server Version : 50643
File Encoding         : 65001

Date: 2021-11-28 12:27:12
*/
create database hhh;
use hhh;

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for tb_admin
-- ----------------------------
DROP TABLE IF EXISTS `tb_admin`;
CREATE TABLE `tb_admin` (
  `username` varchar(20) NOT NULL COMMENT '编号',
  `password` varchar(20) NOT NULL DEFAULT '123456' COMMENT '密码',
  `buildingNO` varchar(5) NOT NULL COMMENT '宿舍楼号',
  PRIMARY KEY (`username`),
  KEY `FK_admin_building` (`buildingNO`),
  CONSTRAINT `FK_admin_building` FOREIGN KEY (`buildingNO`) REFERENCES `tb_building` (`buildingNO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='管理员表';

-- ----------------------------
-- Records of tb_admin
-- ----------------------------
INSERT INTO `tb_admin` VALUES ('admin', '123456', '20');
INSERT INTO `tb_admin` VALUES ('admin2', '123456', '20');
INSERT INTO `tb_admin` VALUES ('admin3', '123456', '21');
INSERT INTO `tb_admin` VALUES ('admin4', '123456', '21');
INSERT INTO `tb_admin` VALUES ('admin5', '123456', '22');
INSERT INTO `tb_admin` VALUES ('admin6', '123456', '22');

-- ----------------------------
-- Table structure for tb_building
-- ----------------------------
DROP TABLE IF EXISTS `tb_building`;
CREATE TABLE `tb_building` (
  `buildingNO` varchar(5) NOT NULL COMMENT '酒店楼楼号',
  `buildingName` varchar(10) DEFAULT NULL COMMENT '酒店楼名字',
  PRIMARY KEY (`buildingNO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='酒店楼表';

-- ----------------------------
-- Records of tb_building
-- ----------------------------
INSERT INTO `tb_building` VALUES ('20', '酒店20栋');
INSERT INTO `tb_building` VALUES ('21', '酒店21栋');
INSERT INTO `tb_building` VALUES ('22', '酒店22栋');

-- ----------------------------
-- Table structure for tb_room
-- ----------------------------
DROP TABLE IF EXISTS `tb_room`;
CREATE TABLE `tb_room` (
  `roomNO` varchar(5) NOT NULL COMMENT '房间号',
  `roomName` varchar(10) DEFAULT NULL COMMENT '房间名',
  `buildingNO` varchar(5) DEFAULT NULL COMMENT '酒店楼楼号',
  PRIMARY KEY (`roomNO`),
  KEY `FK_room_building` (`buildingNO`),
  CONSTRAINT `FK_room_building` FOREIGN KEY (`buildingNO`) REFERENCES `tb_building` (`buildingNO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='房间表';

-- ----------------------------
-- Records of tb_room
-- ----------------------------
INSERT INTO `tb_room` VALUES ('20101', '20栋101', '20');
INSERT INTO `tb_room` VALUES ('20102', '20栋102', '20');
INSERT INTO `tb_room` VALUES ('20103', '20栋103', '20');
INSERT INTO `tb_room` VALUES ('20104', '20栋104', '20');
INSERT INTO `tb_room` VALUES ('20105', '20栋105', '20');
INSERT INTO `tb_room` VALUES ('20106', '20栋106', '20');
INSERT INTO `tb_room` VALUES ('21101', '21栋101', '21');
INSERT INTO `tb_room` VALUES ('21102', '21栋102', '21');
INSERT INTO `tb_room` VALUES ('21103', '21栋103', '21');
INSERT INTO `tb_room` VALUES ('21104', '21栋104', '21');
INSERT INTO `tb_room` VALUES ('21105', '21栋105', '21');
INSERT INTO `tb_room` VALUES ('21106', '21栋106', '21');
INSERT INTO `tb_room` VALUES ('22101', '22栋101', '22');
INSERT INTO `tb_room` VALUES ('22102', '22栋102', '22');
INSERT INTO `tb_room` VALUES ('22103', '22栋103', '22');
INSERT INTO `tb_room` VALUES ('22104', '22栋204', '22');
INSERT INTO `tb_room` VALUES ('22105', '22栋205', '22');
INSERT INTO `tb_room` VALUES ('22106', '22栋206', '22');

-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
  `username` varchar(20) NOT NULL COMMENT '编号',
  `sex` varchar(2) NOT NULL COMMENT '性别',
  `buildingNO` varchar(5) NOT NULL COMMENT '酒店楼楼号',
  `roomNO` varchar(5) NOT NULL COMMENT '房间号',
  `money` int(5) DEFAULT NULL COMMENT '账号余额',
  PRIMARY KEY (`username`),
  KEY `FK_user_building` (`buildingNO`),
  KEY `FK_user_room` (`roomNO`),
  CONSTRAINT `FK_user_building` FOREIGN KEY (`buildingNO`) REFERENCES `tb_building` (`buildingNO`),
  CONSTRAINT `FK_user_room` FOREIGN KEY (`roomNO`) REFERENCES `tb_room` (`roomNO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of tb_user
-- ----------------------------
INSERT INTO `tb_user` VALUES ('0117101', '男', '20', '20101', '200');
INSERT INTO `tb_user` VALUES ('0117103', '男', '21', '21101', '200');
INSERT INTO `tb_user` VALUES ('0117106', '男', '22', '22101', '200');
INSERT INTO `tb_user` VALUES ('0117201', '男', '20', '20102', '200');
INSERT INTO `tb_user` VALUES ('0117203', '男', '21', '21102', '200');
INSERT INTO `tb_user` VALUES ('0117206', '男', '22', '22102', '200');
INSERT INTO `tb_user` VALUES ('0217101', '男', '20', '20103', '200');
INSERT INTO `tb_user` VALUES ('0217103', '男', '21', '21103', '200');
INSERT INTO `tb_user` VALUES ('0217106', '男', '22', '22103', '200');
INSERT INTO `tb_user` VALUES ('0217201', '男', '20', '20104', '200');
INSERT INTO `tb_user` VALUES ('0217203', '男', '21', '21104', '200');
INSERT INTO `tb_user` VALUES ('0217206', '男', '22', '22104', '200');
INSERT INTO `tb_user` VALUES ('0317101', '男', '20', '20105', '200');
INSERT INTO `tb_user` VALUES ('0317103', '男', '21', '21105', '200');
INSERT INTO `tb_user` VALUES ('0317106', '男', '22', '22105', '200');

黑窗口的运行图我就不放上来了 我试过可以在黑窗口处直接导入的
还有我用的是机房（学校的电脑 MySQL56的好像是）
欢迎指正
谢谢