网上航空订票系统设计与实现

单位代码01学号1403010001分类号TP315密级毕业设计说明书网上航空订票系统系统的设计与实现院（系）名称信息工程学院专业名称14计科专升本学生姓名郑智杰指导教师杜献峰2016年5月15日黄河科技学院毕业设计说明书第I页网上航空订票系统系统的设计与实现摘要随着人们生活质量的提升，物质文化需求的提高及各类交通工具也应运而生。现阶段出外旅行及出差的人越来越多，而飞机快速、价低、便捷等优点开始成为越来越多人的选择。从而一个好的航空信息管理系统变得越来越重要。管理信息系统的实施在技术上已逐步成熟、越来越深入而广泛的应用，管理信息系统是一个不断发展的新型学科，就要高效率地建立与自身特点相适应的管理信息系统，该系统是完成一个基于票务管理、飞机航线航班管理、帮助出行等特殊服务以及查询业务的航空信息管理系统。使用C#语言进行代码的编写，对于底层平台的依赖更少，其组件具有更强的实用性；系统框架使用MVC框架，MVC架构完全支持松耦合，高可维护性的开发模式。数据库使用SQLServer2014版本进行数据的管理，SQLServer的数据库服务器具有快速、可靠和易于使用、稳定性高、可移植性强的特点。系统最终达到的效效果远远高于用户的需求，快捷方便的为用户服务，既能提高工作人员的效率，又降低人为出错的几率。数据方便统计与管理，大大节约了数据存储的成本。关键词：C#，MVC，SQLServer黄河科技学院毕业设计说明书第II页TheDesignandimplementationofonlineairlinebookingsystemAuthor:ZhengZhijieTutor:DuXianfengAbstractWiththeenhancementofpeople'squalityoflife,andtoimprovethematerialandculturalneedsofalltypesofvehicleshaveemerged.Presenttotravelonbusinessandmoreandmorepeople,andtheplanefast,lowprice,convenienceandotheradvantagesbecamemoreandmorepeopletochoosefrom.Thusagoodaeronauticalinformationmanagementsystembecomesincreasinglyimportant.Implementationofmanagementinformationsystemhasgraduallymaturedtechnically,morein-depthandextensiveapplicationofnewmanagementinformationsystemisanevolvingdiscipline,itisnecessarytoestablishefficientmanagementinformationsystemwithitsowncharacteristics,thesystemisbasedonthecompletionofticketingmanagement,managementofaircraftflightroutes,travelassistanceandotherspecialservicesandqueryingbusinessaviationinformationmanagementsystem.UseC#languagetowritecode,andlessdependenceontheunderlyingplatform,theassemblyhasamorepractical;systemframeworkusingMVCframework,MVCarchitecturefullysupportslooselycoupled,maintainabledevelopmentmodel.UseversionofSQLServer2014databasetomanagethedata,thedatabaseserverSQLServerhasafast,reliableandeasytouse,highstability,portabilityfeatures.Systemandultimatelyachievetheeffectismuchhigherthantheefficiencyoftheuser'sneeds,fastandconvenientservicesforusers,bothtoimprovetheefficiencyofthestaff,butalsoreducethechanceofhumanerror.Tofacilitatedatamanagementandstatistics,asignificantreductioninthecostofdatastorage.Keywords:C#，MVC，SQLServer黄河科技学院毕业设计说明书第III页目录1引言..................................................................................................................................11.1项目背景.....................................................................................................................11.2研究现状.....................................................................................................................21.3项目意义.....................................................................................................................22需求分析..............................................................................................................................32.1系统环境需求.............................................................................................................32.2功能需求分析.............................................................................................................33系统功能设计......................................................................................................................53.1概念结构设计..............................................................................................................53.1.1概念模型...........................................................................................................53.1.2物理模型...........................................................................................................73.2数据库分析..................................................................................................................83.2.1数据库描述.......................................................................................................83.2.2数据表设计.......................................................................................................83.2.3数据库优化方法.............................................................................................124系统功能实现....................................................................................................................154.1系统登陆与注册界面实现.......................................................................................154.2网站首页及机票展示界面实现...............................................................................184.3提交订单及订单列表界面实现...............................................................................234.4账户充值及资产动态界面实现...............................................................................295系统测试............................................................................................................................355．1测试方法................................................................................................................35黄河科技学院毕业设计说明书第IV页5．2测试过程................................................................................................................355.2.1登录界面测试................................................................................................355.2.2系统功能测试.................................