【正文】 驗 證更 新 數(shù) 據(jù)T查 詢 瀏 覽條 件無 記 錄 顯 示顯 示 記 錄TF解 決 方 案 網(wǎng) 站 信 息結(jié) 束F 數(shù)據(jù)流程圖 用 戶 管 理 員查 詢?yōu)g 覽更 新各 個 解 決方 案 庫網(wǎng) 站 信 息庫 數(shù)據(jù)字典 可行性分析 本系統(tǒng)就其開發(fā) ,應(yīng)用到維護都可是長期的滿足用戶的需要 : 1)技術(shù) :采用現(xiàn)在廣為流行網(wǎng)站開發(fā)技術(shù) ASP 為開發(fā)工具 ,后臺數(shù)據(jù)庫用了 SQL 數(shù)據(jù)庫技術(shù) ,這樣以 來在技術(shù)方面已達到了先進的水平 . 2)財政 :本系統(tǒng)在開發(fā)的時候就立足于經(jīng)濟實用的角度 ,所以無論是從開發(fā)商到用戶在財政上都可以接受 ,所在在財政方面是大眾性的 . 3)時間 :本系統(tǒng)在二周內(nèi)完全可以完成 ,更新時也較為方便快捷 . 4)資源 :本系統(tǒng)無論從開發(fā)人員到技術(shù)都是相當?shù)膶I(yè) ,同時工作人員也在信息收集方面也查閱了大量的相關(guān)資料 ,使之能夠充分的表現(xiàn)其性能的優(yōu)越性 . 3 數(shù)據(jù)庫設(shè)計 數(shù)據(jù)庫概要設(shè)計 本系統(tǒng)一共設(shè)有 1 個數(shù)據(jù)庫 ,數(shù)據(jù)庫中有 6 張數(shù)據(jù)庫表 ,分別為 : Admin:管理員 信息表 , trip_infor:旅游信息表 trip_solhomeland:國內(nèi)旅游表 Trip_solhomelandinfor:國內(nèi)旅游方案信息表 trip_solovferseas:國外旅游表 trip_solverseasinfor:國外旅游方案信息 其中 trip_solhomeland 與 tripsohomelaninfor 建有關(guān)聯(lián) ,trip_solveseas trip 與 trip_solveseasinfor 建有關(guān)聯(lián) ER 圖 名稱 別名 何處使用 /如何使用 描述 管理員名 無 進入后臺管理時 /輸入管理員名 后臺權(quán)限所設(shè)置 管理員口令 無 進入后臺管理時 /輸入管理員名 后臺權(quán)限所設(shè)置 國內(nèi) /外 無 查詢解決方案時 /選擇相關(guān)的信息 旅游區(qū)域的大體劃分 城市 無 查詢解決方案時 /選擇相關(guān)的信息 選擇具體的城市 (國內(nèi) /外 ) 費用 無 查詢解決方案時 /選擇相關(guān)的信息 選擇費用的要求 (國內(nèi) /外 ) 旅行類型 無 查詢解決方案時 /選擇相關(guān)的信息 選擇旅游景點的特征 用 戶管 理 員數(shù) 據(jù) 庫使 用更 新MNMN數(shù) 據(jù) 庫 表 名數(shù) 據(jù) 庫 表 名 33 關(guān)系模型 1)用戶 (用戶編號 ,用戶名 ) 2)管理員 (管理員編號 ,管理員名 ,管理口令 ) 3)數(shù)據(jù)庫 (數(shù)據(jù)庫 表 號 ,數(shù)據(jù)庫表信息 ) 4)使用 (用戶編號 ,數(shù)據(jù)庫表編號 ,數(shù)據(jù)庫表名 ) 5)更新 (管理員信號 ,數(shù)據(jù)庫表編號 ,數(shù)據(jù)庫表名 ) 4 詳細設(shè)計 邏輯設(shè)計 系統(tǒng)功能設(shè)計 本系統(tǒng)的功能設(shè)計具體如下 : 1)用戶瀏覽 :用戶可以通過網(wǎng)頁的瀏覽可以了解本公司的具體情況及一些旅游知識并可以找到全部的解決方案 . 2)用戶查詢 :用戶可以通過輸入或選擇相應(yīng)的條件找到所要 求的解決方案 ,這樣可以為用戶提供快捷 ,方便 ,省時的服務(wù) . 3)管理員后臺管理 :管理員通過自己的管理員名及口令 ,進入到網(wǎng)站的后臺管理 ,這樣可以及時方便的為用戶提供最新的旅游資訊 . 人機界面設(shè)計 本系統(tǒng)在人機界面設(shè)計時充分考慮到了使用者的方便性 ,盡量體現(xiàn)人性化的設(shè)計 ,所在在不同時不同人使用時都設(shè)計了不同的交互方式及一些提示信息提示 . 1)管理員登陸界面 : 2)用戶查詢初始界面 : 3)用戶查詢選擇條件界面 : 4)用戶查詢輸入關(guān)鍵字界面 5 系統(tǒng)實現(xiàn) 系統(tǒng)開發(fā)環(huán)境 系統(tǒng)采用 ASP 的開發(fā)環(huán)境 ,制作成網(wǎng)站的形式 ,而后臺數(shù)據(jù)庫用的是 SQL. 52 數(shù)據(jù)庫的物理設(shè)計 53 查詢及視圖設(shè)計 54 程序設(shè)計 55 系統(tǒng)運行與維護 為了使系統(tǒng)能夠針對廣大用戶，所以采用了網(wǎng)站的方式， 6 課程設(shè)計總結(jié) 61 系統(tǒng)設(shè)計的方法和特點 62 課程設(shè)計體會 Christopher Tolkien AINULINDAL? The Music of the Ainur There was Eru, the One, who in Arda is called Il 鷙 atar。 and he made first the Ainur, the Holy Ones, that were the offspring of his thought, and they were with him before aught else was made. And he spoke to them, propounding to them themes of music。 for each prehended only that part of me mind of Il 鷙 atar from which he came, and in the understanding of their brethren they grew but slowly. Yet ever as they listened they came to deeper understanding, and increased in unison and harmony. And it came to pass that Il 鷙 atar called together all the Ainur and declared to them a mighty theme, unfolding to them things greater and more wonderful than he had yet revealed。Of the theme that I have declared to you, I will now that ye make in harmony together a Great Music . And since I have kindled you with the Flame Imperishable, ye shall show forth your powers in adorning this theme, each with his own thoughts and devices, if he will. But I win sit and hearken, and be glad that through you great beauty has been wakened into song.39。 and a sound arose of endless interchanging melodies woven in harmony that passed beyond hearing into the depths and into the heights, and the places of the dwelling of Il 鷙 atar were filled to overflowing, and the music and the echo of the music went out into the Void, and it was not void. Never since have the A inur made a ny music like to this music, though it has been said that a greater still shall be made before Il鷙 atar by the choirs of the Ainur and the Children of Il 鷙 atar after the end of days. Then the themes of Il鷙 atar shall be played aright, and ta ke Being in the moment of their utterance, for all shall then understand fully his intent in their part, and each shall know the prehension of eac h, and Il 鷙 atar shall give to their thoughts the secret fire, being well pleased. But now Il 鷙 atar sat and hearkened, and for a great while it seemed good to him, for in the music there were no flaws. But as the theme progressed, it came into the heart of Melkor to interweave matters of his own imagining that were not in accord with the theme of Il 鷙 atar, for he sought therein to increase the power and glory of the part assigned to himself. To Melkor among the A inur had be en given the greatest gifts of power and knowledge, and he had a share in all the gifts of his brethren. He had gone often alone into the void places seeking the I mperishable Flame。 but some began to attune their music to his rather than to the thought w hich they had at first. Then the discord of Melkor spread ever wider, and the melodies which had been heard before foundered in a sea of turbulent sound. But Il 鷙 atar sat and hearkened until it seemed that about his throne there was a raging storm, as of dark waters that made war one upon another in an endless wrath that would not be assuaged. Then Il 鷙 atar arose, and the Ainur perceived that he smiled。 and he lifted up his right hand, and behold! a third theme grew amid the confusion, and it was unlike the others. For it seemed at first soft and sweet, a mere rippling of gentle sounds in delicate melodies。 but it was loud, and vain, and endlessly repeated。Mighty are the Ainur, and mightiest among them is Melkor 。 Then the Ainur were afraid, and they did not yet prehend the words that were said to them。 and the Ainur followed him. But w hen they were e into the Void, Il 鷙 atar said to them: 39。 And he showed to them a vision, giving to them sight where before was only hearing。Behold your Music! This is your minstrelsy。 And many other things Il 鷙 atar spoke to the Ainur at that time, and because of their memory of his words, and the knowledge that each has of the music that he himself made, the Ainur know much of wha t was, and is, and is to e, and few things are unseen by them. Yet some things there are that they cannot see, neither alone nor ta king counsel togethe