【正文】 ，企鵝畢業(yè)設(shè)計網(wǎng) :736858727 摘 要 旅游網(wǎng)站建設(shè)是面向現(xiàn)實需求的一個實用系統(tǒng)。其設(shè)計的目的是為游客和旅游網(wǎng)站提供一個友好的、直接的交流平臺。本系統(tǒng)主要分為六大模塊：旅游咨詢信息、旅游線路信息、熱點旅游線路信息、線路查詢、留言信息以及權(quán)限管理。該系統(tǒng)的主要功能：提供給管理者一個簡單的界面，可以合理計劃安排導(dǎo)游的工作和及時了解游客的要求和信息；提供給游客一個清新的界面選擇自己向往的旅游勝 地。本系統(tǒng)采用 JSP 進行開發(fā)，結(jié)合 SQL SEVER 來創(chuàng)建數(shù)據(jù)庫和程序跟蹤與管理信息。本系統(tǒng)的設(shè)計過程完全按照軟件工程的要求開發(fā)的 ,主要分為以下幾個步驟 :首先進行可行性研究；第二步進行詳細調(diào)查，需求分析；第三步進行系統(tǒng)總體結(jié)構(gòu)設(shè)計，完成系統(tǒng)所需的數(shù)據(jù)庫設(shè)計；第四步進行系統(tǒng)詳細設(shè)計，最后進行軟件編碼和系統(tǒng)測試。 關(guān)鍵詞： 總體設(shè)計； 數(shù)據(jù)庫設(shè)計； 詳細設(shè)計； JSP ； SQL SERVER Abstract The traveling website construction is faces the realistic demand an utility system. Its design39。s goal is in a friendly way provides one for the tourist and the traveling website, the direct exchange platform. This system mainly divides into six big modules: Traveling consultation information, tourist route information, hot spot tourist route information, line inquiry, message information as well as jurisdiction management. This system39。s major function: Provides for the superintendent a simple contact surface, may plan reasonably arranges tour guide39。s work and understands tourist39。s request and the information promptly。 Provides tourist attraction which a fresh contact surface chooses itself for the tourist to yearn. This system uses JSP to carry on the development, unifies SQL SEVER to found the database and the program tracking and the management information. This system39。s design process defers to the software engineering pletely the request development, mainly divides into the following several steps: First conducts the feasibility study。 Second step carries on the close investigation, the demand analysis。 Third step carries on the system gross structure design, pletes database design which the system needs。 Fourth step carries on the system detailed design, finally carries on the software code and the system test. Key word: System design Database design Detailed design JSP SQL SEVER 目 錄 摘 要 .......................................................................................................................... 1 Abstract.......................................................................................................................... 2 1. 緒論 ........................................................................................................................... 5 選題背景 ............................................................................................................ 6 選題依據(jù) ............................................................................................................ 6 旅游系統(tǒng)現(xiàn)狀 ..................................................................................................... 6 ................................................................................................................ 8 JSP介紹 ............................................................................................................ 8 JSP版本簡介 .................................................................................................... 8 JSP語言的基本特點 ......................................................................................... 9 可視化設(shè)計 ............................................................................................ 10 ......................................................................................... 11 ................................................................................................... 11 ......................................................................................... 12 JDBC數(shù)據(jù)訪問接口 ................................................................................ 13 JDBC的體系結(jié)構(gòu) ................................................................................ 13 JDBC訪問后臺數(shù)據(jù)庫的技術(shù)實現(xiàn)方法 ................................................. 14 旅游系統(tǒng)軟件開發(fā)方法 ..................................................................................... 14 3. 項目定義 .................................................................................................................. 16 系統(tǒng)分析 .......................................................................................................... 16 問題定義 .......................................................................................................... 16 ..................................................................................... 17 設(shè)計要求 ............................................................................................... 17 可行性分析 ...................................................................................................... 18 需求分析 ........................................................................................................ 19 .................................................................................................................... 21 系統(tǒng)設(shè)計 .......................................................................................................... 21 ............................................................................................ 22 .......................................................................................................... 23 、 ER模型簡介 .................................................................................................. 24 、本系統(tǒng)的 ER圖及數(shù)據(jù)庫表的結(jié)構(gòu) ................................................................. 25 模塊功能實現(xiàn) ................................................................................................... 28 程序流程圖 ................................................................................