#
# Table structure for table tb_room #
DROP TABLE IF EXISTS `tb_room`; CREATE TABLE `tb_room` ( `RMID` varchar(12) NOT NULL, `RMAREA` varchar(10) default NULL, `RMFLOOR` varchar(10) NOT NULL, `RMPRCTPRICE` decimal(14,2) NOT NULL, `RMTELPHONE` varchar(24) default NULL, `RMSTATE` tinyint(3) unsigned NOT NULL, `RMAVAILABLE` tinyint(1) NOT NULL, `RMCATALOG` varchar(32) NOT NULL, `RMPICTURE` varchar(100) NOT NULL,
`RMPRCTDISCOUNT` decimal(14,2) NOT NULL default '100.00', PRIMARY KEY USING BTREE (`RMID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `tb_room` VALUES ('8101','8','1',260,'101',2,1,'标准间','public/images/rooms/standardroom.gif',100);
INSERT INTO `tb_room` VALUES ('8102','8','1',260,'100',0,1,'标准间','public/images/rooms/standardroom.gif',100);
INSERT INTO `tb_room` VALUES ('8103','8','1',260,'103',2,1,'标准间','public/images/rooms/standardroom.gif',100);
INSERT INTO `tb_room` VALUES ('8104','8','1',260,'104',0,1,'标准间
','public/images/rooms/standardroom.gif',100);
INSERT INTO `tb_room` VALUES ('8106','8','1',268,'123',2,1,'单人间','public/images/rooms/single.gif',100);
INSERT INTO `tb_room` VALUES ('8109','8','1',320,'126',0,1,'标准间','public/images/rooms/standardroom.gif',100);
INSERT INTO `tb_room` VALUES ('8118','8','1',260,'127',0,1,'单人间','public/images/rooms/single.gif',100);
INSERT INTO `tb_room` VALUES ('8208','8','2',320,'128',0,1,'标准间','public/images/rooms/standardroom.gif',100);
INSERT INTO `tb_room` VALUES ('8209','8','2',260,'129',0,1,'单人间','public/images/rooms/single.gif',100);
INSERT INTO `tb_room` VALUES ('8308','8','3',320,'130',0,1,'标准间','public/images/rooms/standardroom.gif',100);
INSERT INTO `tb_room` VALUES ('9101','9','1',300,'9101',0,1,'超级豪华间','public/images/rooms/single.gif',100); #
# Table structure for table tb_roomcatalog #
DROP TABLE IF EXISTS `tb_roomcatalog`; CREATE TABLE `tb_roomcatalog` ( `RCID` varchar(32) NOT NULL, `RCNAME` varchar(12) NOT NULL,
`RCBEDNUMBER` int(10) unsigned NOT NULL, `RCPREPRICE` decimal(14,2) NOT NULL,
`RCPREDISCOUNT` decimal(14,2) default '100.00',
`RCHOURBASEPRICE` decimal(14,2) default NULL, `RCPERHOURPRICE` decimal(14,2) default NULL, PRIMARY KEY USING BTREE (`RCID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `tb_roomcatalog` VALUES
('402881e51a5472f8011a547548440001','单人间',1,200,20,50,50); INSERT INTO `tb_roomcatalog` VALUES
('402881e5267907ec0126790f5ec40003','总统套房',3,50000,300,3000,300); INSERT INTO `tb_roomcatalog` VALUES
('402881e6255344820125538694350001','豪华间',2,360,0,200,100); INSERT INTO `tb_roomcatalog` VALUES
('402881e625576bea0125578a63ba0002','超级豪华间',3,1188,100,200,200); INSERT INTO `tb_roomcatalog` VALUES ('RC889','标准间',2,260,100,150,40);
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
5系统测试
系统测试分为白盒测试和黑盒测试，白盒进行基本功能测试；黑盒对源码进行分析，找出源码中的逻辑错误。
6公共类设计
1.客户信息类 2.客房类型信息类 3.客房信息类
4.操作员信息类 5.入住登记信息类 6.入住登记订单类 7.结账信息类
7模块讲解
1. 登陆界面
2.酒店管理系统主页