小型酒店管理系统的设计与开发毕业论文

玉林师范学院本科生毕业论文（设计）小型酒店管理系统的设计与开发ThedesignanddevelopoftheSmallHotelManagementSystem院系数学与计算机科学系专业计算机科学与技术班级2008级（专升本）姓名刘芳学号200804202101指导教师单位数学与计算机科学系数学与计算机科学系指导教师姓名周培春指导教师职称讲师小型酒店管理系统的设计与开发计算机科学与技术2008级专升本刘芳指导教师周培春摘要当今社会，酒店种类和客流的不断增加，对于管理造成了困难。采用计算机来管理酒店和住客的信息，提高了查询的速度，节约了人力和物力资源，达到了预期的要求。本系统根据小型酒店管理的现状及未来的发展方向，结合有关小型酒店管理当中的管理学实践，设计了小型酒店管理系统。本系统是用于小型酒店服管理的系统软件。系统数据的管理采用了操作系统的最新管理方式，用户操作将会更简单、更直观、更方便。系统中各业务管理模块可以单机独立运行。使用本系统，可以大幅度提高酒店服务管理的工作效率。该系统应充分利用信息技术提高小型酒店客房的管理水平、服务水平。小型酒店管理系统要实现住宿登记、宿费提醒、追加押金、调房登记、退房结账、查询统计等等功能。其中宿费提醒可以在住宿费超过押金时预警，提示前台要客人补交押金，该功能可明显提高对住宿人员宿费的有效管理。将动态实时的住宿登记、客房调整、追加押金等有机地联系在一起，对小型酒店客房进行全方位的管理。关键词：酒店管理系统;VB;ACCESS2003;数据库ThedesignoftheSmallHotelManagementSystemComputerScienceandTechnology2008-2008liuFangSupervisor:ZhouPeichunAbstractAtpresent,thesmallhotel’scategoryflowswithincreasingoftheguestscontinuously,resultedinthedifficultytothemanagement.Usingthecomputertomanagethehotelandtheresidentinformation,enhancedtheinquiryspeed,savedtheworkforceandtheresourcesandhasmettheanticipatedrequirements.Inthissystem,wedesignsthesmallhotelmanagementsystemwhichaccordstothepresentsituationofthesmallhotelservicemanagementandthewayitdevelopsinthefutureandsmallhotelmanagementstudypractice.Thissystemisasoftwarewhichisusedforthesmallhotelservicemanagement.Themanagementofthesystemdatausestheoperatingsystemnewestmanagementmethod,sotheuseroperationwillbesimpler.Thevariousbusinessmanagementmodulesinthissystemmayrunsindependently.Theseadvantagescanincreasethebiggestefficiencyoftheguesthousemanagement,isalsoaguesthousetoservescientificandregulartoturnthetermofthemanagement.Thissystemmaymakefulluseofinformationtechnologytoincreasethemanagementlevel,servicelevelofthehotel.Thesystemwillrealizethefunctionsuchasthelodgingsregistration,thelodgingallowancereminder,supplementsthedeposit,theaccentroomregistration,returnsahousetiestheaccount,inquirystatistics.Thedynamicreal-timelodgingsregistration,theguestroomadjustment,thesalesreportform,willsupplementthedepositandsoonorganicallytorelateintogether,willcarryonthemanagementwelltothesmallhotel’sroom.Keywords:Hotelmanagementsystem;VB;ACCESS2003;Database目录1前言...................................................................................................................................11.1系统开发的背景......................................................................................................11.2国内外研究现状......................................................................................................11.3本课题研究意义......................................................................................................21.4相关技术介绍..........................................................................................................31.4.1VisualBasic简介...........................................................................................31.4.2ADO访数据库技术介绍...............................................................................41.5系统运行环境..........................................................................................................41.6系统开发技术..........................................................................................................42系统分析...........................................................................................................................42.1系统的可行性研究.................................................................................................42.1.1技术可行性....................................................................................................52.1.2经济可行性....................................................................................................52.2系统需求分析..........................................................................................................52.3系统的功能框架......................................................................................................52.4系统业务流程图......................................................................................................63系统结构分析和设计........................................................................................................73.1关系模型设计..........................................................................................................74数据库设计........................................................................................................................94.1MicrosoftofficeAccess2003简介............................................................................94.2数据库表结构设计..................................................................................................94.2.1用户信息表（tb_user）..............................................................................104.2.2登记信息表（tb_djb）................................................................................104.2.3客房基础信息表（tb_kf）..........................................................................114.2.4退房登记信息表（tb_tfd）.........................................................................115系统详细设计与实现........................................................................