四川师范大学本科毕业设计宾馆酒店预定系统的设计与实现学生姓名学号所在系计算机科学与技术系专业名称计算机科学与技术班级指导教师四川师范大学二○一二年五月宾馆酒店预定系统设计学生:指导老师:群内容摘要:宾馆酒店预定系统是典型的信息管理系统的一部分,主要包括后台数据库的建立和维护以及前端应用程序的开发两个方面。本系统采用SQLServer2008作为后台数据库,VisualStudio2008作为前台系统开发平台。利用VS提供的各种面向对象的开发工具,开发一个基于B/S体系结构的中小型宾馆酒店预定系统。后台实现了对酒店客房信息、用户账号、个人信息的管理以及实时查询酒店收入情况等功能,前台实现了为客户办理房间入住、退房手续并可添加VIP用户等功能。本系统基本满足了酒店对客户管理的需求。关键词:宾馆酒店预定系统SQLServer2008VisualStudio2008B/SDesignforHotelManagementSystemAbstract:Thehotelmanagementsystemisapartofthetypicalinformationmanagementsystem,whichmainlyincludesthesettingandmaintenanceofdatabaseandthedevelopingofthefrontendapplication.ThissystemusesSQLServer2008asthebackgrounddatabase,VisualStudio2008asadevelopmentplatformofforegroundsystem.Itusesallsortsofobject-orienteddevelopmenttoolswhichVSprovidesanddevelopsasmallandmedium-sizedhotelmanagementsystembasedonB/Sarchitecture.Thebackgroundofthehotelmainlyrealizedthefunctionsofthemanagementofthehotelroomsinformation,useraccountsandpersonalinformationandrealtimeinquiryoftheincomewhilefrontdeskdealwithroomoccupancyandcheckoutforclientsandcanaddVIPusers.Thesystemsatisfytheinquiryofthecustomermanagementbasically.Keywords:HotelManagementSystemSQLserver2008VS2008B/S目录1绪论................................................................11.1开发背景.........................................................11.2系统目标.........................................................12系统解决方案........................................................22.2SQLServer2008简介.............................................22.3程序运行环境.....................................................33系统分析............................................................33.1系统可行性分析...................................................33.1.1经济可行性分析...............................................33.1.2技术可行性分析...............................................33.1.3法律可行性分析...............................................33.2系统需求分析.....................................................44系统设计.............................................................44.1系统模块设计.....................................................44.2系统结构图.......................................................44.3系统功能图.......................................................55数据库设计..........................................................55.1E-R模型.........................................................55.2数据库的具体实现.................................................76系统主要/关键技术说明...............................................96.1公共模块.........................................................96.1.1实现与数据库连接.............................................96.1.2配置相关文件.................................................96.1.3登陆模块....................................................136.2系统模块........................................................156.2.1管理员模块..................................................156.2.2房间信息模块..................................