【正文】 民航訂票管理系統(tǒng)摘要 民航訂票管理系統(tǒng)是在網(wǎng)絡(luò)環(huán)境下實現(xiàn)用戶訂票業(yè)務(wù)的管理系統(tǒng)。系統(tǒng)改變了傳統(tǒng)的手工訂票、送票方式，具有廣泛的 實用性。民航訂票管理系統(tǒng)分為前臺操作和后臺處理，以數(shù)據(jù) 庫為 核心。整個系 統(tǒng)圍繞訂票交易流程而設(shè)計?？傮w上，其功能貫穿 2 條線：一條線貫穿著客 戶注冊、查詢、訂票、更改客戶信息等操作流程；另一條線管理著航空公司的注冊， 飛機、航線的添加、修改及刪除，公司信息的修改及注銷等。該系統(tǒng)正確、完整、及時地收集、加工、整理在整個訂票業(yè)務(wù)流程中所發(fā)生的各類訂票請求以及相關(guān)的機票信息。經(jīng)過一系列的需求分析，可以確定系統(tǒng)由用戶模塊和航空公司模 塊兩部分組成。系 統(tǒng)采用了基于 JSP＋WEB 技術(shù)平臺，利用 MySQL 作服務(wù)器數(shù)據(jù)庫，Tomcat 做服務(wù)器，Dreamweaver 做頁面開發(fā)工具，并使用 Jsp、Html、JavaScript、JavaBean 等語言實現(xiàn)了用戶注冊、用戶登錄、航班查詢、機票 預(yù)訂、 訂單管理、航班管理、用戶管理等功能，構(gòu)建了一個 B/S模式的 WEB 應(yīng) 用程序。經(jīng)測試 ，系 統(tǒng)界面友好，各功能可以正常使用且用戶操作簡潔。關(guān)鍵詞 民航訂票；JSP；MySQL；B/S 模式Aviation Booking Management SystemAbstract Aviation booking management system is the management system that it realizes booking a ticket under the work system changes traditional handicraft to book a ticket and send a ticket, having broad practicability. Aviation booking management system divides into the onstage operation and the background processing, taking database as the core. The overall system revolves the order form transaction flow to design. In the overall, its function passes through two coarse threads: A coarse thread passing through the customer registration, the inquiry, booking ticket, and changing the customer information and so on。 the other coarse thread manages the pany to register, the airplane and airline to add, modify and delete, and the pany information to modify and cancel. This system collects, processes and sorts all kinds of booking request information and related ticket information which occured in the entire order form service flow correctly, pletely and timely.Through a process of need analysis,it can make sure that the system is made up by customer mold piece and airline mold system bases on the JSP+WEB technique terrace, making use of MySQL to act as a server database, the Tomcat does a server, the Dreamweaver does page development tool, and using Jsp, Html, JavaScript, the design language of JavaBean etc. to carry out customer registration, customer logging, flight searching, ticket reservation, order management, flight management, customer management etc. function, setting up a B/S mode WEB application testing, system interface works friendly and each function works normally, the customer operation is simple and direct. Key words Aviation booking；JSP；MySQL；B/S model目錄第一章　 引言 ............................................................5　 前言 ...................................................................................................................5 系統(tǒng)設(shè)計的背景 ................................................................................................6 航空訂票系統(tǒng)的基本任務(wù) ................................................................................6 航空訂票系統(tǒng)的目標(biāo) ........................................................................................6 國內(nèi)外相關(guān)領(lǐng)域的發(fā)展情況 ............................................................................7第二章 系統(tǒng)開發(fā)相關(guān)知識的概述 ...........................................8 B/S 架構(gòu)技術(shù) .....................................................................................................8 JSP 技術(shù)簡介 .....................................................................................................9 HTML 語言概述 ..............................................................................................10 JAVA 語言概述 .................................................................................................11 JAVASCRIPT 腳本語言概述 ..............................................................................12 JAVABEAN 技術(shù)簡介 .......................................................................................12第三章 系統(tǒng)需求分析 ....................................................13 需求概述 ............................................................................................................13 問題分析 ............................................................................................................13 需求描述 ......................................................................................................14 數(shù)據(jù)需求分析 ..............................................................................................14 性能需求分析 ..............................................................................................14 功能需求分析 ..............................................................................................15 可行性研究 ........................................................................................................16 經(jīng)濟可行性 ..................................................................................................16 技術(shù)可行性 ..................................................................................................16 操作可行性 ..................................................................................................16第四章 系統(tǒng)總體設(shè)計 ...................................................17 系統(tǒng)開發(fā)工具介紹 ..........................................................................................17 JDK...............................................................................................................17 MySql 和 Apache Tomcat ...........................................................................17 MyEclipse ..................................................................................................18 系統(tǒng)功能分析 ..................................................................................................18 數(shù)據(jù)庫設(shè)計 ......................................................................................................19 數(shù)據(jù)庫需求分析 ..........................................................................................20 數(shù)據(jù)庫概念結(jié)構(gòu)設(shè)計 ..................................................................................21 數(shù)據(jù)庫邏輯結(jié)構(gòu)設(shè)計 ..................................................................................23 數(shù)據(jù)庫結(jié)構(gòu)的實現(xiàn) ......................................................................................25第五章 系統(tǒng)詳細設(shè)計 .........