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