【正文】 民航訂票管理系統(tǒng)摘要 民航訂票管理系統(tǒng)是在網(wǎng)絡(luò)環(huán)境下實(shí)現(xiàn)用戶訂票業(yè)務(wù)的管理系統(tǒng)。系統(tǒng)改變了傳統(tǒng)的手工訂票、送票方式，具有廣泛的 實(shí)用性。民航訂票管理系統(tǒng)分為前臺(tái)操作和后臺(tái)處理，以數(shù)據(jù) 庫(kù)為 核心。整個(gè)系 統(tǒng)圍繞訂票交易流程而設(shè)計(jì)?？傮w上，其功能貫穿 2 條線：一條線貫穿著客 戶注冊(cè)、查詢、訂票、更改客戶信息等操作流程；另一條線管理著航空公司的注冊(cè)， 飛機(jī)、航線的添加、修改及刪除，公司信息的修改及注銷(xiāo)等。該系統(tǒng)正確、完整、及時(shí)地收集、加工、整理在整個(gè)訂票業(yè)務(wù)流程中所發(fā)生的各類(lèi)訂票請(qǐng)求以及相關(guān)的機(jī)票信息。經(jīng)過(guò)一系列的需求分析，可以確定系統(tǒng)由用戶模塊和航空公司模 塊兩部分組成。系 統(tǒng)采用了基于 JSP＋WEB 技術(shù)平臺(tái)，利用 MySQL 作服務(wù)器數(shù)據(jù)庫(kù)，Tomcat 做服務(wù)器，Dreamweaver 做頁(yè)面開(kāi)發(fā)工具，并使用 Jsp、Html、JavaScript、JavaBean 等語(yǔ)言實(shí)現(xiàn)了用戶注冊(cè)、用戶登錄、航班查詢、機(jī)票 預(yù)訂、 訂單管理、航班管理、用戶管理等功能，構(gòu)建了一個(gè) B/S模式的 WEB 應(yīng) 用程序。經(jīng)測(cè)試 ，系 統(tǒng)界面友好，各功能可以正常使用且用戶操作簡(jiǎn)潔。關(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è)計(jì)的背景 ................................................................................................6 航空訂票系統(tǒng)的基本任務(wù) ................................................................................6 航空訂票系統(tǒng)的目標(biāo) ........................................................................................6 國(guó)內(nèi)外相關(guān)領(lǐng)域的發(fā)展情況 ............................................................................7第二章 系統(tǒng)開(kāi)發(fā)相關(guān)知識(shí)的概述 ...........................................8 B/S 架構(gòu)技術(shù) .....................................................................................................8 JSP 技術(shù)簡(jiǎn)介 .....................................................................................................9 HTML 語(yǔ)言概述 ..............................................................................................10 JAVA 語(yǔ)言概述 .................................................................................................11 JAVASCRIPT 腳本語(yǔ)言概述 ..............................................................................12 JAVABEAN 技術(shù)簡(jiǎn)介 .......................................................................................12第三章 系統(tǒng)需求分析 ....................................................13 需求概述 ............................................................................................................13 問(wèn)題分析 ............................................................................................................13 需求描述 ......................................................................................................14 數(shù)據(jù)需求分析 ..............................................................................................14 性能需求分析 ..............................................................................................14 功能需求分析 ..............................................................................................15 可行性研究 ........................................................................................................16 經(jīng)濟(jì)可行性 ..................................................................................................16 技術(shù)可行性 ..................................................................................................16 操作可行性 ..................................................................................................16第四章 系統(tǒng)總體設(shè)計(jì) ...................................................17 系統(tǒng)開(kāi)發(fā)工具介紹 ..........................................................................................17 JDK...............................................................................................................17 MySql 和 Apache Tomcat ...........................................................................17 MyEclipse ..................................................................................................18 系統(tǒng)功能分析 ..................................................................................................18 數(shù)據(jù)庫(kù)設(shè)計(jì) ......................................................................................................19 數(shù)據(jù)庫(kù)需求分析 ..........................................................................................20 數(shù)據(jù)庫(kù)概念結(jié)構(gòu)設(shè)計(jì) ..................................................................................21 數(shù)據(jù)庫(kù)邏輯結(jié)構(gòu)設(shè)計(jì) ..................................................................................23 數(shù)據(jù)庫(kù)結(jié)構(gòu)的實(shí)現(xiàn) ......................................................................................25第五章 系統(tǒng)詳細(xì)設(shè)計(jì) .........