公交查詢系統(tǒng)—數(shù)據(jù)庫(kù)課程設(shè)計(jì)分析方案-文庫(kù)吧資料
2025-05-10 12:17本頁(yè)面
【正文】 selectid2=idfromstationwherename=input2查找直達(dá)線路selectoutput1=from(selectbus_namefrombus_stationwherestation_id=id1a,(selectbus_namefrombus_stationwherestation_id=id2b=若不存在直達(dá)線路,則搜尋一次換乘路線ifnotexists(select*frombuswherename=output1begin查找中間站點(diǎn)selectstationID1=input1能直達(dá)的站點(diǎn)集合c(selectdistinctstation_idfrombus_stationwherebus_namein(selectbus_namefrombus_stationwherestation_id=id1c,input2能直達(dá)的站點(diǎn)集合d(selectdistinctstation_idfrombus_stationwherebus_namein(selectbus_namefrombus_stationwherestation_id=id2d=selectoutput1=from(selectbus_namefrombus_stationwherestation_id=id1a,(=stationID1b=selectoutput2=from(selectbus_namefrombus_stationwherestation_id=id2a,(=stationID1b=end若不存在直達(dá)和一次換乘線路,則搜尋二次換乘路線ifnotexists(select*frombuswherename=output1andnotexists(select*frombuswherename=output2begin查找中間線路selectoutput2=from(selectdistinctbus_namefrombus_stationwherestation_idin(selectstation_idfrombus_stationwherebus_namein(selectbus_namefrombus_stationwherestation_id=id1a,(selectdistinctbus_namefrombus_stationwherestation_idin(selectstation_idfrombus_stationwherebus_namein(selectbus_namefrombus_stationwherestation_id=id2b=查找起點(diǎn)到中間線路的公交車selectstationID1=from(selectdistinctstation_idfrombus_stationwherebus_namein(selectbus_namefrombus_stationwherestation_id=id1a,(selectstation_idfrombus_stationwherebus_name=output2b=selectoutput1=from(selectbus_namefrombus_stationwherestation_id=id1c,(selectbus_namefrombus_stationwherestation_id=stationID1d=查找中間線路到終點(diǎn)的公交車selectstationID2=from(selectdistinctstation_idfrombus_stationwherebus_namein(selectbus_namefrombus_stationwherestation_id=id2a,(selectstation_idfrombus_stationwherebus_name=output2b=selectoutput3=from(selectbus_namefrombus_stationwherestation_id=id2c,(selectbus_namefrombus_stationwherestation_id=stationID2d=endselectoutput4=namefromstationwhereid=stationID1selectoutput5=namefromstationwhereid=stationID2end五、軟件功能設(shè)計(jì)軟件共實(shí)現(xiàn)了3個(gè)大功能，即站點(diǎn)查詢、線路查詢、站站查詢，其完成情況如下：一）：檢查用戶是否輸入了站點(diǎn)或線路信息，如果沒有錄入，則提示：請(qǐng)輸入站點(diǎn)！或請(qǐng)輸入線路名！二）：檢查用戶是否輸入的站點(diǎn)或線路是否存在，如果不存在，則提示：此站點(diǎn)不存在！或此線路不存在！三）：如果信息都填寫正確，則根據(jù)選定的查詢條件進(jìn)行查找，查找的具體實(shí)現(xiàn)為： 1）站點(diǎn)查詢：返回經(jīng)過此站點(diǎn)的所有線路，并提供一條線路經(jīng)過的所有站點(diǎn)。dropprocedurebusline_infogocreateprocedurebusline_infoinputvarchar(5,outputvarchar(700outputasb
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1