首页 > 代码库 > 12306-票
12306-票
| ylbtech-dbs:12306-票 |
| A，数据库关系图(Database Diagram) 返回顶部 |
| B，数据库设计脚本(Database Design Script)返回顶部 |
3,查询余票
2,查询车次
--1/2，出发站和目的站在同一次列车时间表上
--2/2，起始站序<目的站序
2.2,
--2，查询车次，假设：菏泽-->曹县--菏泽-->曹县select tn.trainNumberCode,tn.trainNumberType,tn.departureStationId,(select Station from Station where stationId=tn.departureStationId)‘departureStation‘,tn.destinationStationId,(select Station from Station where stationId=tn.destinationStationId)‘destinationStation‘,tn.departureTime,tn.destinationTime from TrainNumber tn where tn.trainNumberId in(select t.trainNumberId from Timetable tinner join Timetable t2 on t.trainNumberId=t2.trainNumberIdwhere t.sortCode<t2.sortCodeand t.stationId=(select stationId from Station where station=‘菏泽‘)and t2.stationId=(select stationId from Station where station=‘曹县‘))
2.1,
--2，查询车次，假设：菏泽-->曹县--菏泽-->曹县select * from TrainNumber tn where tn.trainNumberId in(select t.trainNumberId from Timetable tinner join Timetable t2 on t.trainNumberId=t2.trainNumberIdwhere t.sortCode<t2.sortCodeand t.stationId=(select stationId from Station where station=‘菏泽‘)and t2.stationId=(select stationId from Station where station=‘曹县‘))select * from TrainNumber tn where tn.trainNumberId in(select t.trainNumberId from Timetable tinner join Timetable t2 on t.trainNumberId=t2.trainNumberIdwhere t.sortCode<t2.sortCodeand t.stationId=(select stationId from Station where station=‘菏泽‘)and t2.stationId=(select stationId from Station where station=‘定陶‘))select * from TrainNumber tn where tn.trainNumberId in(select t.trainNumberId from Timetable tinner join Timetable t2 on t.trainNumberId=t2.trainNumberIdwhere t.sortCode<t2.sortCodeand t.stationId=(select stationId from Station where station=‘定陶‘)and t2.stationId=(select stationId from Station where station=‘曹县‘))--曹县-->菏泽select * from TrainNumber tn where tn.trainNumberId in(select t.trainNumberId from Timetable tinner join Timetable t2 on t.trainNumberId=t2.trainNumberIdwhere t.sortCode<t2.sortCodeand t.stationId=(select stationId from Station where station=‘曹县‘)and t2.stationId=(select stationId from Station where station=‘菏泽‘))
1，查询列车时刻表
1.1，
use TrainTicketgogo--1，Z01列次时刻表select t.[type],t.sortCode‘站序‘,s.station‘站名‘,CONVERT(varchar(8),t.departureTime,108)‘到时‘,t.destinationTime‘发时‘ from Timetable tinner join Station s on t.stationId=s.stationIdwhere trainNumberId=‘F681391E-8FBB-49FC-8159-AE7FA5FF5A36‘order by sortCode
0，
| C，功能实现代码(Function Implementation Code)返回顶部 |
1，
2，
 | 作者：ylbtech 出处：http://ylbtech.cnblogs.com/ 本文版权归作者和博客园共有，欢迎转载，但未经作者同意必须保留此段声明，且在文章页面明显位置给出原文连接，否则保留追究法律责任的权利。 |
12306-票
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。