摘要随着酒店业的发展，传统的手工记账已不适应现代酒店管理的需要，及时、准确、全方位的网络化信息管理已成为必需。并且，随着信息技术的日新月异，酒店客房预定系统也得到了不断的完善和发展。酒店客房预定系统以标准的酒店管理模式为蓝本，借助先进的设计思想，高效的设计方法完成。基于WEB的即浏览器/服务器（Browser/Server）体系结构，采用稳定可靠的WINDOWSXP作为服务器应用平台，并利用MSSQLSERVER数据库与WINDOWSXP系统集成好的特点，采用MSSQLSERVER数据库作为后台数据的管理支持，选用Microsoft公司的Visualstudio.net2003作为开发工具，利用其提供的集成开发环境及各种控件，尤其是对ADO.NET的支持完成对数据库的各种操作，达到酒店客房预定的目的。设计时首先建立系统应用原型，然后对原形系统进行不断修正和改进，直到形成用户满意的实际可行系统。关键词：网上酒店客房预定、B/S、数据库、ADO.NET、ASP.NETAbstractWiththedevelopmentofhotelindustry,thetraditionalonekeepaccountsbyhandcannotmeettheneedsofmodernhotelmanagement.Theinstantly,accurate,omni-directionalnetworkedinformationmanagementalreadybecomeindispensable.And,withthechangeoftheinformationtechnology,TheHotelGuestRoomReservationSystemhasgotconstantperfectionanddevelopment.TheHotelGuestRoomReservationSystemregardthestandardhotelmanagementmodeasblueprint,andfulfillitselfbymeansofadvanceddesignideas,andmoreefficientmethod.OnthebasisofWeb(Browser/server)structure,itadoptsthestableanddependableWindowsXPoperationsystemastheserverapplicationbase,takesadvantageofthegoodintegrationcharacteristicsoftheMSSQLServerdatabaseandtheWindowsXPsystem,makesuseoftheMSSQLServerdatabaseasmanagementsupportingofthebackgrounddata,picksuptheVisualstudio.net2003ofMicrosoftasthedevelopedtool,whichprovidingintegrateddevelopingcircumstanceandsortsofcontrols,especiallysupportingfortheADO.NETtocompleteallkindsofoperationsonthedatabase,soastomanagethehotel.Wemustestablishthesystemapplicationprototypeatfirst,then,proceedtoimproveandrevisetheoriginalshapesystemcontinuously,tillformtherealandfeasiblesystemwhichissatisfiedwithusers.KeyWords：WebHotelGuestRoomReservation、B/S、Database、ADO.NET、ASP.NET目录摘要-----------------------------------------------------------------------1Abstract--------------------------------------------------------------------2１.绪论-----------------------------------------------------------------3２.系统需求分析-----------------------------------------------------------42．1现行业务描述--------------------------------------------------------------------------------------------------42．2现行系统存在的问题-------------------------------------------------------------------------------------------42．3解决方案----------------------------------------------------------------------------------------------------------52．4可行性分析-------------------------------------------------------------------------------------------------------52．4．1Browser/Server系统结构----------------------------------------------------------------52．4．2ASP.NET----------------------------------------------------------------------------------------72．4．2C#（C-Sharp）--------------------------------------------------------------------------------7３.数据库设计-------------------------------------------------------------93．1数据库的产生和构成-------------------------------------------------------------------------------------------93．1．1数据库系统的产生-------------------------------------------...
