數(shù)據(jù)庫原理與應(yīng)用之鐵路客車售票系統(tǒng)數(shù)據(jù)庫設(shè)計-閱讀頁
2025-07-15 02:05本頁面
【正文】 ,39。,39。,39。,39。, 2316)insert into(TrainNum,TicketID,StartTime,ReachTime,StartStation,ReachStation,mileage)values(39。,9,39。,39。,39。,39。, 2403)insert into(TrainNum,TicketID,StartTime,ReachTime,StartStation,ReachStation,mileage)values(39。,10,39。,39。,39。, 39。 ,2655)insert into(TrainNum,TicketID,StartTime,ReachTime,StartStation,ReachStation,mileage)values(39。,11,39。,39。,39。, 39。 ,2665)insert into(TrainNum,TicketID,StartTime,ReachTime,StartStation,ReachStation,mileage)values(39。,12,39。,39。,39。, 39。 ,2782)insert into(TrainNum,TicketID,StartTime,ReachTime,StartStation,ReachStation,mileage)values(39。,13,39。,39。,39。, 39。 ,2895)insert into(TrainNum,TicketID,StartTime,ReachTime,StartStation,ReachStation,mileage)values(39。,14,39。,39。,39。, 39。 ,3088)insert into(TrainNum,TicketID,StartTime,ReachTime,StartStation,Reach13 / 24Station,mileage)values(39。,15,39。,39。,39。, 39。 ,3294)insert into(TrainNum,TicketID,StartTime,ReachTime,StartStation,ReachStation,mileage)values(39。,16,39。,39。,39。, 39。 ,3451)insert into(TrainNum,TicketID,StartTime,ReachTime,StartStation,ReachStation,mileage)values(39。,17,39。,39。,39。, 39。 ,146)insert into(TrainNum,TicketID,StartTime,ReachTime,StartStation,ReachStation,mileage)values(39。,18,39。,39。,39。, 39。 ,502)insert into(TrainNum,TicketID,StartTime,ReachTime,StartStation,ReachStation,mileage)values(39。,19,39。,39。,39。, 39。 ,524)insert into(TrainNum,TicketID,StartTime,ReachTime,StartStation,ReachStation,mileage)values(39。,20,39。,39。,39。, 39。 ,543)insert into(TrainNum,TicketID,StartTime,ReachTime,StartStation,ReachStation,mileage)values(39。,21,39。,39。,39。, 39。 ,584)insert into(TrainNum,TicketID,StartTime,ReachTime,StartStation,ReachStation,mileage)values14 / 24(39。,22,39。,39。,39。, 39。 ,609)insert into(TrainNum,TicketID,StartTime,ReachTime,StartStation,ReachStation,mileage)values(39。,23,39。,39。,39。, 39。 ,689). 將普通列車價格加入 putongliechejiage 表中insert into (PtlcjgID,mileage1,mileage2,putong,pukuai,tekuai,kongtiaofeilv,ZuoweiType)values(1,611,640,34,41,48,8,39。)insert into (PtlcjgID,mileage1,mileage2,putong,pukuai,tekuai,kongtiaofeilv,ZuoweiType)values(2,641,670,36,43,50,9,39。)insert into (PtlcjgID,mileage1,mileage2,putong,pukuai,tekuai,kongtiaofeilv,ZuoweiType)values(3,671,700,37,44,51,9,39。). 將普通列車臥鋪價格加入 putongliechewopujiage 表中insert into (PtlcwpjgID,mileage1,mileage2,shang,zhong,xia,kongtiaofeilv,TrainType,zuoweiType)values(1,641,670,98,102,105,9,39。, 39。)insert into (PtlcwpjgID,mileage1,mileage2,shang,zhong,xia,kongtiaofeilv,TrainType,zuoweiType)values(2,671,700,101,104,108,9,39。 ,39。 )15 / 24insert into (PtlcwpjgID,mileage1,mileage2,shang,zhong,xia,kongtiaofeilv,TrainType,zuoweiType)values(3,701,740,107,110,114,9,39。 ,39。 ). 將空調(diào)列車價格加入 kongtiaoliechejiage 表中insert into (KtlcjgID,mileage1,mileage2,putong,pukuai,tekuai)values(1,641,670,68,79,90)insert into (KtlcjgID,mileage1,mileage2,putong,pukuai,tekuai)values(2,671,700,70,81,92)insert into (KtlcjgID,mileage1,mileage2,putong,pukuai,tekuai)values(3,701,740,73,85,97). 將空調(diào)列車臥鋪價格加入 kongtiaoliechewopujiage 表中insert into (KtlcwpjgID,mileage1,mileage2,shang,zhong,xia,TrainType,ZuoweiType)values(1,641,670,157,163,168,39。 ,39。)insert into (KtlcwpjgID,mileage1,mileage2,shang,zhong,xia,TrainType,ZuoweiType)values(2,671,700,162,167,173,39。 ,39。)insert into (KtlcwpjgID,mileage1,mileage2,shang,zhong,xia,TrainType,ZuoweiType)values(3,701,740,170,175,181,39。 ,39。)16 / 24. 將訂票記錄加入 dingpiao 表中insert into (DingpiaoID,TrainNum,StartStation,ReachStation,ZuoweiType,CountTickets,TotalPrice,StartTime,time,zuowei,UserID)values(1,39。,39。,39。 ,39。, 1,173,39。,39。,39。,1)insert into (DingpiaoID,TrainNum,StartStation,ReachStation,ZuoweiType,CountTickets,TotalPrice,StartTime,time,zuowei,UserID)values(2,39。,39。,39。 ,39。, 1,173,39。,39。,39。,1)5. 結(jié)果數(shù)據(jù)處理. 表 users 中查詢17 / 24. 表 ticketsinf 中查詢. 表 putongliechejiage 中查詢18 / 24. 表 putongliechewopujiage 中查詢. 表 kongtiaoliechejiage 中查詢. 表 kongtiaoliechewopujiage 中查詢. 表 dingpiao 中查詢19 / 24. 車次查詢. 臥鋪票價查詢. 硬座票價查詢20 / 246. 結(jié)束語該數(shù)據(jù)庫課程設(shè)計基本按照計劃進(jìn)行，基本滿足了需求功能。另外，在實現(xiàn)各種功能模塊，編寫 SQL 語句有些繁瑣，應(yīng)該力求用最少的代碼實現(xiàn)同樣的功能，提高代碼運(yùn)行效率。有些功能（比如：退票模塊） ，主鍵應(yīng)該是車票上的條形編碼才對
職業(yè)教育相關(guān)推薦
鄂ICP備17016276號-1