【正文】 I 中文摘要 世界多極化和經(jīng)濟(jì)全球化的趨勢在曲折中發(fā)展，科技進(jìn)步日新月異，綜合國力競爭日趨激烈。 電子信息產(chǎn)品制造業(yè)經(jīng)濟(jì)運(yùn)行狀況良好，產(chǎn)業(yè)規(guī)模迅速擴(kuò)大。 在計算機(jī)技術(shù)高速發(fā)展的今天，我國有必要引入高效的計算機(jī)系統(tǒng) 來改善 一些旅行社和酒店的機(jī)票預(yù)定 ，提高 工作效率，協(xié)助處理機(jī)票預(yù)定工作。 網(wǎng)上機(jī)票預(yù)訂管理系統(tǒng)的產(chǎn)生和發(fā)展正好滿足人們的這種需求。 機(jī)票預(yù)定系統(tǒng)是為機(jī)場工作人員和客戶提供訂票退票等與機(jī)票相關(guān)內(nèi)容和管理的系統(tǒng)，它具有開放體系結(jié)構(gòu)的、易擴(kuò)充的、易維護(hù)的、具有良好人機(jī)界面的優(yōu)點 .它除克服了存儲乘客信息少，查詢效率低下 等問題外，更重要的是其安全性，可靠性，實現(xiàn)航空公司的機(jī)票銷售的自動化。它為企業(yè)的決策層提供準(zhǔn)確、精細(xì)、迅速的機(jī)票銷售信息，為乘客出行提供方便，便于機(jī)場工作人員對機(jī)票信息進(jìn)行管理，提高了機(jī)場工作人員對機(jī)票管理的工作效率。 根據(jù)航空公司管理的實際要求 , 系統(tǒng)采用 JSP， Tomcat， Servlet，利用 SQL Server 2020作為數(shù)據(jù)庫管理工具，模塊復(fù)用率高、系統(tǒng)維護(hù)代價小，方便、靈活、高效。 關(guān)鍵詞 ： 數(shù)據(jù)庫 ； SQL 語言 ； Java 語言； 數(shù)據(jù)庫組件 ； JSP ] II ABSTRACT The trends toward world multipolarization and economic globalization are developing amidst twists and turns. Science and technology are advancing rapidly. Competition in overall national strength is being increasingly fierce. The manufacturing industry of electronic and information products made good performance which led to an expansion of the scale of the industry. Currently, the ticket of some travel agencies of our country and cabarets schedules to still stay around the artificial processing stage, this already serious check and supervision work efficiency. The machine ticket schedule to the system is a system that provides to book the related contents of the ticket dishonor bill etc. and tickets and manage for the staff member and customers in the airport, it has the system structure of open of, easy enlargement of, easy maintenance of, have the advantage of the good manmachine in addition to overing saving passenger39。s information little, the search efficiency lowly etc. problem outside, more important its safety, credibility, carry out the automation of the ticket of the airline provides the accurate, fine and quick ticket sale information for the decision layer of the business enterprise, going to provide the convenience for passenger39。s, the easy to airport staff member carries on the management to the ticket information, raising the staff member in the airport to the work efficiency that ticket manage. In accordance with the actual request of the managernent of airways , The System uses JSP， Tomcat, Servletand using the SQL Server 2020 as a database management tool, it is small of the cost in system maintenance, it is convenient, flexible and efficient. Key words: Database, language of SQL, language of Java, JSP III 目錄 第 1 章 緒論 ......................................................................................................................................................................1 課題背景 ..............................................................................................................................................................1 開發(fā)技術(shù) ..................................................................................................................................................................2 Jsp技術(shù) ................................................................................................................... 2 . Servlet 技術(shù) .............................................................................................................. 2 . JavaBean 技術(shù) .......................................................................................................... 3 . 開發(fā)工具 .................................................................................................................................................................4 Eclipse ...................................................................................................................... 4 . SQL Server 2020 ....................................................................................................... 4 . Tomcat ..................................................................................................................... 5 第 2章 系統(tǒng)需求分析 ........................................................................................................................................................6 系統(tǒng)可行性分析 ......................................................................................................................................................6 . 技術(shù)可 行性 .............................................................................................................. 6 . 經(jīng)濟(jì)可行性 .............................................................................................................. 6 . 操作可行性 .............................................................................................................. 7 社會可行性 ...............................................................................................................................................................7 . 系統(tǒng)功能需求分析 .................................................................................................................................................8 . 系統(tǒng)性能需求分析 ...............................................................................................................................................8 數(shù)據(jù)需求 ............................................................................................................................................................... 10 數(shù)據(jù)錄入處理的準(zhǔn)確性與及時性 ...............................................................................10 數(shù)據(jù)的一致性與完整性 .............................................................................................10 數(shù)據(jù)的共享與獨立性 ................................................................................................10 安全需求 ............................................................................................................................................................... 10 第 3章 系統(tǒng)設(shè)計 ......................................................................................................................................................