基于SSM酒店管理系统mysql版本(前后台)

2021/7/23 2:07:47

本文主要是介绍基于SSM酒店管理系统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;





这篇关于基于SSM酒店管理系统mysql版本(前后台)的文章就介绍到这儿,希望我们推荐的文章对大家有所帮助,也希望大家多多支持为之网!


扫一扫关注最新编程教程