民航售票管理系统数据库设计与实现 大学论文.doc

民航售票管理系统 ──数据库设计与实现 摘 要：现在人们更多的使用飞机作为出行交通工具，因此机票票务市场也在快速发展。人们希望机票销售手段也能相应地有所调整，并对如何能经济、方便和及时地购买到自己所需要的机票表现出极大的关注。随着社会的不断进步，国内外航空事业的飞速发展，各航空公司对票务管理的要求也在不断的提高，本系统就是针对这种日益增长的需求也进行开发的。 本文针对航空公司的订票实际情况，按照软件工程的结构化设计思想，经过项目的可 行性研究和需求分析，总体设计，详细设计，以及编码实现和调试等步骤设计开发站网上订票系统。并运用数据流图和数据字典，E-R 图和数据库逻辑结构，层次图， 系统流程图，以及程序流程图，对该系统的数据需求，数据库，系统软件结构，系统流 程，以及处理过程等进行了分析和设计。 本系统前台主要使用JSP作为开发语言，后台使用SqlServer作为数据库管理系统，开发环境是MyEclipse，服务器采用tomcat，开发出的一个基于Web技术的B/S结构的机票售票系统。 关键词：机票售票 JSP B/S结构 Abstract：Now more people use the plane as travel transport, so the ticket market also in fast development. People want to ticket sales approach can also be adjusted accordingly, and how can the economic, convenient and timely to buy what they need to ticket showed great concern. With the constant progress of the society, the rapid development of aviation industry at home and abroad, the airline ticket management requirements are constantly improve, this system is aimed at the growing demand for development also. This article in view of the actual situation of the airline tickets, according to the software engineering structured design thought, after the project can do study and needs analysis, overall design, detailed design, as well as code realization and debugging and other steps designed and developed tickets online system fire station. And the use of a data flow graph and data dictionary, e-r chart and database logic structure, the hierarchical graph, the system flow diagram, and program flow chart, the system of data requirements, database, software system structure, system flow process, as well as the process of analysis and design。 This system mainly used as a receptionist JSP language development, use as a background SqlServer database management system, the development environment is MyEclipse, server using tomcat, developed a Web technology based on B/S structure of the ticket counter system。 Key words： Ticket reservation ;JSP;B / S structur 1 引言 1.1 课题背景 随着旅游业的逐渐的成熟发达，航空客运量大幅度的提高，国内国际的旅