数据.sql

这是一个网上订票系统

insert into aircompany values('东方航空','http://www.ce-air.com/cea/zh_CN/homepage');
insert into aircompany values('南方航空','http://www.cs-air.com/');
insert into aircompany values('国际航空','http://www.airchina.com.cn/');
insert into aircompany values('四川航空','http://www.scal.com.cn/');
insert into aircompany values('海南航空','http://www.hnair.com/hnairweb/Default.aspx');

insert into airline values('3U915','四川航空','成都','北京','08:20','12:20','05月25日');
insert into airline values('MU8001','东方航空','广州','上海','08:20','11:20','05月25日');
insert into airline values('CZ3101','南方航空','广州','上海','08:20','12:20','05月25日');
insert into airline values('CA1310','国际航空','广州','北京','08:20','14:20','05月25日');
insert into airline values('CA1330','国际航空','广州','大连','08:20','15:20','05月25日');
insert into airline values('CZ3105','南方航空','广州','天津','08:20','14:20','05月25日');

insert into airline values('3U915','四川航空','成都','北京','08:20','12:20','05月26日');
insert into airline values('MU8001','东方航空','广州','上海','08:20','11:20','05月26日');
insert into airline values('CZ3101','南方航空','广州','上海','08:20','12:20','05月26日');
insert into airline values('CA1310','国际航空','广州','北京','08:20','14:20','05月26日');
insert into airline values('CA1330','国际航空','广州','大连','08:20','15:20','05月26日');
insert into airline values('CZ3105','南方航空','广州','天津','08:20','14:20','05月26日');

insert into airline values('3U915','四川航空','成都','北京','08:20','12:20','05月27日');
insert into airline values('MU8001','东方航空','广州','上海','08:20','11:20','05月27日');
insert into airline values('CZ3101','南方航空','广州','上海','08:20','12:20','05月27日');
insert into airline values('CA1310','国际航空','广州','北京','08:20','14:20','05月27日');
insert into airline values('CA1330','国际航空','广州','大连','08:20','15:20','05月27日');
insert into airline values('CZ3105','南方航空','广州','天津','08:20','14:20','05月27日');



insert into passenger values('1001','张三','男','乐山市市区','561502','3U915');
insert into passenger values('1002','李四','女','广州市天河区','510642','MU8001');
insert into passenger values('1003','王五','女','广州市东山区','510664','CZ3101');
insert into passenger values('1004','黄六','男','广州市黄埔区','510246','CA1310');
insert into passenger values('1005','刘七','男','广州市从化','510752','CA1330');

insert into ticket values('10000001','3U915','05月25日','08:20','下','张三','1001','600','四川航空');
insert into ticket values('10000002','MU8001','05月25日','08:20','下','李四','1002','700','东方航空');
insert into ticket values('10000003','MU8001','05月25日','08:20','下','李四','1002','700','东方航空');
insert into ticket values('10000004','CZ3101','05月25日','08:20','下','王五','1003','700','南方航空');
insert into ticket values('10000005','CA1310','05月25日','08:20','中','黄六','1004','900','国际航空');
insert into ticket values('10000006','CA1330','05月25日','08:20','上','刘七','1005','1500','国际航空');
insert into ticket values('10000007','CA1330','05月25日','08:20','上','刘七','1005','1500','国际航空');
insert into ticket values('10000008','CA1330','05月25日','08:20','上','刘七','1005','1500','国际航空');


insert into bill values('100001','3U915','张三','1','600','600','北京','四川航空');
insert into bill values('100002','MU8001','李四','2','700','1400','上海','东方航空');
insert into bill values('100003','CZ3101','王五','1','700','700','上海','南方航空');
insert into bill values('100004','CA1310','黄六','1','900','900','北京','国际航空');
insert into bill values('100005','CA1330','刘七','3','1500','4500','大连','国际航空');

insert into  planetype values('波音757','300','3U915');
insert into  planetype values('波音767','330','MU8001');
insert into  planetype values('波音757','320','CZ3101');
insert into  planetype values('空客204','350','CA1310');
insert into  planetype values('波音777','310','CA1330');


insert into speakfor values('10000001','1001');
insert into speakfor values('10000002','1002');
insert into speakfor values('10000003','1002');
insert into speakfor values('10000004','1003');
insert into speakfor values('10000005','1004');
insert into speakfor values('10000006','1005');
insert into speakfor values('10000007','1005');
insert into speakfor values('10000008','1005');

insert into payment values('1001','100001');
insert into payment values('1002','100002');
insert into payment values('1003','100003');
insert into payment values('1004','100004');
insert into payment values('1005','100005');