【正文】 查詢 SQL 里 flightinfo 表來實(shí)現(xiàn)的，具體的截圖如下： 第 16 頁 共 23 頁 圖 55 航班查詢 航班查詢關(guān)鍵代碼： sql=select * from Flight_Info where flighttype like39。flighttypeamp。 and startcity like39。startcityamp。 and endcity like39。endcityamp。 and takeofftime like39。takeofftimeamp。 and landtime like39。landtimeamp。 sql,conn if not or not then i=1 while not i=i+1 這個(gè)模塊為用戶提供了根據(jù)自己需要的航班進(jìn)行的網(wǎng)上 訂票的功能，界面友好。點(diǎn)擊航班后，可以查詢該航班是否已經(jīng)出售，同時(shí)還可以查看機(jī)票的價(jià)格，艙位等級(jí)等等。 具體的截圖如下： 第 17 頁 共 23 頁 圖 55 航班信息 圖 56 網(wǎng)上訂票 網(wǎng)上訂票的核心代碼： % if (flag)ok then flightid=(id) seatid=(id1) sql=SELECT * FROM Flight_Info INNER JOIN Price_Info ON = WHERE =39。flightidamp。AND ( =amp。) sql,conn if not or not then 第 18 頁 共 23 頁 i=1 while not i=i+1 % flightid = (flightid) seatid=(seatid) cmd1=UPDATE Price_Info SET flag = 1 WHERE (flightid = 39。flightidamp。) AND (seatid = amp。) set rs1=() =adOpenStatic cmd1,conn 這個(gè)模塊為用戶提供了航班的退訂。用戶可以找到自己想要退掉的機(jī)票，用戶可以根據(jù)這些關(guān)鍵字來找到退票的依據(jù)：航班號(hào)，座位號(hào)，艙位等級(jí)，機(jī)票價(jià)格和預(yù)訂的時(shí)間作為參考。這里設(shè)置了一個(gè) FLAG 作為退票和訂票的參數(shù)設(shè)置。 網(wǎng)上退票的截圖如下： 圖 57 網(wǎng)上退票 網(wǎng)上訂票的核心代碼： if (flag)=ok then flightid = (flightid) 第 19 頁 共 23 頁 seatid=(seatid) bid = (bid) cmd1=UPDATE Price_Info SET flag = 0 WHERE flightid = 39。flightidamp。 AND (seatid = amp。) set rs1=() =adOpenStatic cmd1,conn cmd2=Delete from Book_Info WHERE bid =amp。 set rs2=() =adOpenStatic cmd2,conn SCRIPT language=JavaScriptalert(39。)。/script () 本系統(tǒng)在設(shè)計(jì)和開發(fā)過程中，也遇到了不少的問題，就其中較特殊問題分析及解決方案描述如下： 查詢航班的時(shí)候連接到數(shù)據(jù)庫的時(shí)候出現(xiàn)了亂碼，找不到對應(yīng)的頁面，顯示出航班信息為無，解決的辦法：把數(shù)據(jù)庫服務(wù)器的名字改為本機(jī)的名字，然后找到相應(yīng)的接口。 結(jié) 論 經(jīng)過緊張而有序的畢業(yè)設(shè)計(jì)，民航售票管理系統(tǒng)主體功能已全面實(shí)現(xiàn)。但是也有需要進(jìn)一步改進(jìn)的地方，如：航班查詢的搜索條件也應(yīng)該更加多一點(diǎn)，網(wǎng)上訂票的時(shí)候能顯示出同一航班不同座位的價(jià)格，網(wǎng)上訂 票的時(shí)候能進(jìn)行第三方的匯款的電子支付，網(wǎng)上退票的時(shí)候能根據(jù)座位的價(jià)格收一定的定金，使得界面更加穩(wěn)定，更易操作，更能適應(yīng)各種網(wǎng)站的運(yùn)行環(huán)境，安全性和可操作性更高。使我體會(huì)到系統(tǒng)的設(shè)計(jì)階段有舉足輕重的地位，設(shè)計(jì)的階段的質(zhì)量 第 20 頁 共 23 頁 優(yōu)劣，直接影響到以后系統(tǒng)質(zhì)量。詳細(xì)設(shè)計(jì)中的相關(guān)類的設(shè)計(jì)和函數(shù)的定義，對 編碼階段鋪墊，使編碼水到渠成。本人相信這對以后工作將會(huì)大有益處的。 參考文獻(xiàn) [1] 方睿 .網(wǎng)絡(luò)數(shù)據(jù)庫原理及應(yīng)用 [M].成都：四川大學(xué)出版社 ,2021。 [3] 石志國 .ASP動(dòng)態(tài)網(wǎng)站編程 [M].北京：清華大學(xué)出版社 ,2021。 [5] 李曉黎 ,張巍 .ASP+SQL Server網(wǎng)絡(luò)應(yīng)用系統(tǒng)開發(fā)與實(shí)例 [M].北京：人民郵電出版社 ,2021。 [7] 張勝 .Dreamweaver 8+ASP動(dòng)態(tài)網(wǎng)站建設(shè)基礎(chǔ)與實(shí)踐教程 [M].北京：電子工業(yè)出版社 ,2021。在此向他表示我最衷心的感謝！ 在論文完成過程中，本人還得到了王翔老師和全班同學(xué)的熱心幫助，本人向他們表示深深的謝意！ 最后向在百忙之中評(píng)審本文的各位專家、老師表示衷心的感謝！ 作者簡介 姓 名：謝珂 性別：男 出生年月： 民族：漢 Email:. 第 22 頁 共 23 頁 聲 明 本論文的工作是 2021 年 2 月至 2021 年 6 月在成都信息工程學(xué)院網(wǎng)絡(luò)工程系完成的。除非另有說明，本文的工作是原始性工作。 （ 2）學(xué)?？梢圆捎糜坝?、縮印或其他復(fù)制方式保存學(xué)位論文。 （ 4）學(xué)?？稍试S學(xué)位論文被查閱或借閱。 除非另有科研合同和其他法律文書的制約，本論文的科研成果屬于成都信息工程學(xué)院。 and the herald shall proclaim in the agora theoffence for which he is going to be beaten. The warden of the agoraand the guardians of the law shall obtain information from experiencedpersons about the rogueries and adul terations of the sellers, andshall write up what the seller ought and ought not to do in each case。 for is not he a benefactor who reduces the inequalitiesand inmensurabilities of goods to equality and mon measure?And this is what the power of money acplishes, and the merchant maybe said to be appointed for this purpose. The hireling and thetavernkeeper, and many other occupations, some of them more andothers less seemly alike have this object。 wherefore all that relates to retail trade, andmerchandise, and the keeping of taverns, is denounced and numberedamong dishonourable things. For if what I trust may never be andwill not be, we were to pel, if I may venture to say a ridiculousthing, the be st men everywhere to keep taverns for a time, or carry onretail trade, or do anything of that sort。 and if all such occupations were managed onincorrupt principles, they would be honoured as we honour a motheror a nurse. But now that a man goes to desert places and builds bouseswhich can only be reached be long journeys, for the sa ke of retailtrade, and receives strangers who are in need at the welerestingplace, and gives them peace and calm when they are tossed bythe storm, or cool shade in the heat。 one of whom corruptsthe soul of man with luxury, while the other drives him by pain intoutter shamelessne ss. What remedy can a city of sense find against thisdisease? In the first place, they must have as few retail traders aspossible。 and in the third place, they must devise some way wherebythe followers of these occupations themselves will not readily fallinto habits of unbridled shamelessness and meanness. After this preface let our law run as follows, and may fortunefavour us:No landowner among the Mages, w hose city the God isrestoring and resettlingno one, that is, of the 5040 families,shall bee a retail trader either voluntarily or involuntarily。 and in general for his elderswho are freemen, and whom he serves as a freeman. Now it isdifficult to determine accur ately the things w hich are worthy orunworthy of a freeman, but let those who have obtained the prize ofvirtue give judgment about them in accordance with their feelings ofright and wrong. He who in any way shares in the illiberality ofretail trades ma y be indicted for dishonouring his race by any one wholikes, before those who have been judged to be the first in virtue。s house by anunworthy occupation, let him be imprisoned for a year and abstain fromthat sort of thing。 andevery time that he is convicted let the lengt h of his imprisonmentbe doubled. This shall be the second law:He who engages in retailtrade must be either a metic or a stranger. And a third law shallbe:In order that the retail trader who dwells in our city may be asgood or as little bad as possible, the guardians of the law shallremember that they are not only guardians of those who may be easilywatched and prevented from being lawless or bad, because they a rewellborn and