公交查詢系統(tǒng)—數(shù)據(jù)庫(kù)課程設(shè)計(jì)分析方案(編輯修改稿)
2025-05-31 12:17 本頁(yè)面
【文章內(nèi)容簡(jiǎn)介】 romsysobjectswherename=39。busline_info39。dropprocedurebusline_infogocreateprocedurebusline_info@inputvarchar(5,@outputvarchar(700outputasbeginselect@output=linefrombusline=@inputendgo站點(diǎn)間的點(diǎn)到點(diǎn)路線查詢：ifexists(selectnamefromsysobjectswherename=39。station_station39。dropprocedurestation_stationgocreateprocedurestation_station@input1varchar(30,@input2varchar(30,@output1varchar(5output,@output2varchar(5output,@output3varchar(5output,@output4varchar(30output,@output5varchar(30outputasbegindeclare@stationID1int,@stationID2int換乘過(guò)程中的中間站點(diǎn)declare@id1int,@id2int記錄起點(diǎn)和終點(diǎn)的IDselect@id1=idfromstationwherename=@input1select@id2=idfromstationwherename=@input2查找直達(dá)線路select@output1=from(selectbus_namefrombus_stationwherestation_id=@id1a,(selectbus_namefrombus_stationwherestation_id=@id2b=若不存在直達(dá)線路,則搜尋一次換乘路線ifnotexists(select*frombuswherename=@output1begin查找中間站點(diǎn)select@stationID1=@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=select@output1=from(selectbus_namefrombus_stationwherestation_id=@id1a,(=@stationID1b=select@output2=from(selectbus_namefrombus_stationwherestation_id=@id2a,(=@stationID1b=end若不存在直達(dá)和一次換乘線路,則搜尋二次換乘路線ifnotexists(select*frombuswherename=@output1andnotexists(select*frombuswherename=@output2begin查找中間線路select@output2=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)到中間線路的公交車select@stationID1=from(selectdistinctstation_idfrombus_stationwherebus_namein(selectbus_namefrombus_stationwherestation_id=@id1a,(selectstation_idfrombus_stationwherebus_name=@output2b=select@output1=from(selectbus_namefrombus_stationwherestation_id=@id1c,(selectbus_namefrombus_stationwherestation_id=@stationID1d=查找中間線路到終點(diǎn)的公交車select@stationID2=from(selectdistinctstation_idfrombus_stationwherebus_namein(selectbus_namefrombus_statio
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1