數(shù)據(jù)庫課程設(shè)計民航售票系統(tǒng)方案(存儲版)
【正文】 Limingyu5Liufum59641384劉復(fù)明男15968792586Liufum6Morexia55922648慕容筱筱女2515988624952Morexia7ZxMao12357954毛澤西男2616986362289ZxMao8Zhangxy98625478張筱嫣女3416895588826Zhangxy9Liuguis65599522劉貴生男6818895269744Liuguis10Lilei02258746李雷男5318986526489Lilei11Lihuiz25025068李慧珍女3518986009530Lihuiz12Zhanggf07145689張國鋒男3918599655789Zhanggf13Ligui86868699李貴男3713565485856Ligui14Hanmm999988866韓梅梅女2518988665598Hanmm9表313 座艙表Cabin2CnoCtypeCnumCpri1Cpri21頭等艙1010245122商務(wù)艙308884443經(jīng)濟艙60588294表314 航班表Flight2FnoFtypeCity1City2Time1Time2FtimABX98AE86成都廣東6HDFE45666成都廈門7HEER32A380成都南京6HWER56777武漢北京5HEE1A380武漢重慶1HHY678AE86北京成都7HGRR33778北京香港10HJKIRQ777香港上海7HQADFT778臺北武漢6HSDAE0AE86上海臺北7H表315 航空公司表Airline2AnoAnaAmanAtel1東方航空公司不敗887765897892西南航空公司西毒668858782353霸天虎航空公司威震天96875566345表316 機票表Ticket2TnoTnaTtelTpos000001崔斯特13907568077420202197610151216000002瑪麗莎19545091912420202198212231345000003韓梅梅18988665598420202198506154546000004王子軒13871092635420202198904235699000005慕容筱筱15988624952420202198510181217000006張國鋒18599655789420202197103021415000007張國華18595687444420202197103021416000008李斯特1898654569842020219761015136000009劉復(fù)明1596879258642020219760109161x000010李明宇13923569877420202196512171018000011毛澤西16986362289420202198405161416000012毛澤南18986359786420202198506071416000013李雷18986526489420202195711251615000014李明翰18987659536420202196512171118000015李云13998765896420202195711251715000016瑪拉莎13945091910420202198212232345000017慕容筱幽13965428536420202198510181317000018李貴13565485856420202197309281678000019韓梅18985699999420202198506154346表317 票務(wù)表Twork2WnoNatureUnoTnoCnoFnoAnoPri1Sell10000011ABX98110242Sell20000021DFE45310243Sell140000031ABX9815124Sell30000041DFE45310245Back60000052EER3218886Sell120000063WER5625887Sell120000072EER3218888Sell10000083EE135889Back50000092HY678344410Sell40000101ABX981102411Back70000113JKIRQ129412Back70000123JKIRQ158813Sell100000132GRR33288814Back40000141QADFT251215Sell100000152SDAE0144416Back20000161QADFT2102417Sell60000173EE1329418Sell130000181DFE453102419Sell140000192HY6783888表318 公告欄表Notice2NnoMnoNsayNtim11請您不要在公共場合吸煙……請去吸煙室。20100627103請不要在機場門口乘坐黑車，以免上當(dāng)受騙。,00099922,39。,20,15,3,39。goupdate Usersset Uage=nullwhere Uno=15go刪除實例：use minhanggodelete Userswhere Uno=15godelete Ticketwhere Tno=20godelete Tworkwhere Wno=20go查詢實例：/*查詢到廣州的航班（條件查詢）*/select*from Flightwhere City2=39。圖37 查詢實例5/*查詢年齡在歲以上的會員（條件查詢）*/select Uno,Una1,Una2,Uage from Userswhere Uage30圖38 查詢實例6/*查詢年齡姓李并且名字個字的會員（條件查詢）*/select Uno,Una1,Una2 from Userswhere Una2 like 39。,Cpri2 as 39。=,39。=Ctype,39。=count(Usex) from Usersgroup by Usex圖321 查詢實例19/*列出已售出和退回的票的數(shù)量（分組查詢、計算查詢）*/select 39。 then 39。=avg(Cpri2)from Cabin圖323 查詢實例21/*創(chuàng)建所有航班信息視圖*/alter view HBasselect distinct ,Ftype,Ctype,City1,City2,Time1,Time2,Ftim,39。,Una2 as 39。,Umes as 39。when Umes like39。when Umes like 39。end from Usersgoselect*from HY圖325 會員信息視圖/*創(chuàng)建機票信息視圖*/alter view JPasselect as39。=Time1, as 39。from Ticketinner join Twork on =inner join Users on =inner join Flight on =goselect*from JP圖326 機票信息視圖/*由成都出發(fā)的航班視圖*/create view CHBasselect Fno as39。,Time1 as 39。,Pna as 39。,Nsay as 39。,39。,39。,39。,39。,39。 from Userswhere Una1=na1 and Una2=na2 and Umes=mes and Uage=age and Usex=sexgoexec Users_find_sec39。,39。圖341 查找會員聯(lián)系電話存儲過程/*更改Flight的Fno，則Twork也更改觸發(fā)器*/alter trigger T_Flighton Flightfor updateasif update(Fno)beginupdate Tworkset Fno=from Tworkinner join Flight on =where =end圖342 觸發(fā)器數(shù)據(jù)庫安全：/*創(chuàng)建一個登陸*/exec sp_addlogin39。gouse minhanggrant select,updateon Twork to Fgo/*收回F的update
公司管理相關(guān)推薦
鄂ICP備17016276號-1