基于SSM java酒店管理系统mysql版本

介绍：
spring，springmvc，mybatis，mysql，eclipse

截图：

数据库表：
CREATE TABLE account (
id int(11) NOT NULL AUTO_INCREMENT,
name varchar(32) NOT NULL,
password varchar(32) NOT NULL,
realName varchar(32) DEFAULT NULL,
idCard varchar(32) CHARACTER SET utf32 DEFAULT NULL,
mobile varchar(16) DEFAULT NULL,
address varchar(128) DEFAULT NULL,
status int(1) DEFAULT ‘0’,
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

---

– Records of account

---

INSERT INTO account VALUES (‘1’, ‘李四’, ‘123456’, ‘李四’, ‘62225225666552’, ‘13656565656’, ‘上海 浦东’, ‘0’);
INSERT INTO account VALUES (‘2’, ‘张三’, ‘123’, ‘张三五’, ‘4622987745565656’, ‘13912233333’, ‘北京 三里屯 酒吧’, ‘0’);
INSERT INTO account VALUES (‘3’, ‘李四1’, ‘123’, ‘李四1’, ‘6565656565656’, ‘13999999999’, ‘南京’, ‘0’);
INSERT INTO account VALUES (‘4’, ‘王麻子’, ‘123’, ‘大刀王五’, ‘110110120121110110’, ‘13656565656’, ‘北京 朝阳区 群众’, ‘-1’);
INSERT INTO account VALUES (‘5’, ‘小明’, ‘123456’, ‘张小明’, ‘31012002522555’, ‘13545455454’, ‘江苏 南京’, ‘0’);
INSERT INTO account VALUES (‘6’, ‘xia’, ‘123456’, null, null, ‘17615042024’, null, ‘0’);
INSERT INTO account VALUES (‘7’, ‘李胜’, ‘123456’, ‘李胜’, null, ‘17615042024’, null, ‘0’);
INSERT INTO account VALUES (‘8’, ‘zhangmaowen’, ‘123456’, ‘张茂’, ‘3412223234780’, ‘17615042024’, ‘大连’, ‘0’);

---

– Table structure for authority

---

DROP TABLE IF EXISTS authority;
CREATE TABLE authority (
id int(11) NOT NULL AUTO_INCREMENT,
roleId int(11) NOT NULL,
menuId int(11) NOT NULL,
PRIMARY KEY (id),
KEY roleId (roleId),
KEY menuId (menuId),
CONSTRAINT authority_ibfk_1 FOREIGN KEY (roleId) REFERENCES role (id),
CONSTRAINT authority_ibfk_2 FOREIGN KEY (menuId) REFERENCES menu (id)
) ENGINE=InnoDB AUTO_INCREMENT=437 DEFAULT CHARSET=utf8;