您的位置首页百科知识

飞机订票系统

飞机订票系统

这个很简单呀只要用一个表唤橡就可以先在宴链埋数据库里建个表(假设名为Flight)添加字段F_Date(飞行日期)F_Flight(航班号)F_StartCity(起始站)F_EndCity(终点站)F_ETD(预计起飞时间)F_ETA(预计到达时间)以SQL语句为例(假设所要查询或录入的数据为@XXXX)航班信息录入:Insert into [Flight] ([F_Date],[F_Flight],[F_StartCity],[F_EndCity],[F_ETD],[F_ETA]) VALUES (@date,@flight,@startCity,@endCity,@ETD,@ETA)航班信息浏览:select * from Flight查询航线:1.select * from Flight where F_Flight=@flight2.select * from Flight where F_StartCity=@startCity3.select * from Flight where F_EndCity=@endCity4.select * from Flight where F_Date=@date把数据查询出来填到ListView或晌蚂DataGridView里就好了