久久99精品久久久久久琪琪,久久人人爽人人爽人人片亞洲,熟妇人妻无码中文字幕,亚洲精品无码久久久久久久

基于java航空售票系統(范文)

時間:2019-05-12 21:36:23下載本文作者:會員上傳
簡介:寫寫幫文庫小編為你整理了多篇相關的《基于java航空售票系統(范文)》,但愿對你工作學習有幫助,當然你在寫寫幫文庫還可以找到更多《基于java航空售票系統(范文)》。

第一篇:基于java航空售票系統(范文)

public FlightBook()

//構造函數

{

super(“航空訂票”);this.setSize(600,400);this.setLocation(300,240);this.setResizable(false);this.setVisible(true);this.setLayout(new BorderLayout());JPanel panel=new JPanel(new GridLayout(11,1));this.add(panel,BorderLayout.WEST);this.setBackground(Color.blue);

button_ask=new JButton(“查詢”);panel.add(button_ask);button_ask.addActionListener(this);

button_book=new JButton(“訂票”);panel.add(button_book);button_book.addActionListener(this);

button_cancel=new JButton(“退票”);panel.add(button_cancel);button_cancel.addActionListener(this);

text_user=new JTextArea();this.add(text_user,BorderLayout.CENTER);

frame_cx=new JFrame(“輸入”);

//查詢輸入框

frame_cx.setSize(280,120);frame_cx.setResizable(false);frame_cx.setBackground(Color.LIGHT_GRAY);frame_cx.setLayout(new FlowLayout());frame_cx.add(new JLabel(“終點站:”));text_field1=new JTextField(20);frame_cx.add(text_field1);button_ok1=new JButton(“ok”);frame_cx.add(button_ok1);button_ok1.addActionListener(this);frame_cx.addWindowListener(this);

frame_dp=new JFrame(“輸入”);

//訂票輸入框

frame_dp.setSize(350,150);frame_dp.setResizable(false);frame_dp.setBackground(Color.LIGHT_GRAY);frame_dp.setLayout(new FlowLayout());frame_dp.add(new JLabel(“ 航班號:”));text_field2=new JTextField(20);frame_dp.add(text_field2);frame_dp.add(new JLabel(“ 訂票數:”));text_field3=new JTextField(20);frame_dp.add(text_field3);button_ok2=new JButton(“確定”);frame_dp.add(button_ok2);

button_ok2.addActionListener(this);frame_dp.addWindowListener(this);

frame_tp=new JFrame(“輸入”);

//退票輸入框

frame_tp.setSize(350,150);frame_tp.setResizable(false);frame_tp.setBackground(Color.LIGHT_GRAY);frame_tp.setLayout(new FlowLayout());frame_tp.add(new JLabel(“ 日期 :”));text_field4=new JTextField(20);frame_tp.add(text_field4);frame_tp.add(new JLabel(“ 航班號:”));text_field5=new JTextField(20);frame_tp.add(text_field5);button_ok3=new JButton(“正確”);frame_tp.add(button_ok3);button_ok3.addActionListener(this);frame_tp.addWindowListener(this);

dialog_cx=new JDialog(this,“提示”,true);

//提示查詢輸入航線未開通錯誤

dialog_cx.setSize(240,80);label=new JLabel(“此站點未開通航線,請重新輸入!”);dialog_cx.add(label);dialog_cx.setLayout(new FlowLayout(FlowLayout.CENTER));

dialog_cx.addWindowListener(this);

frame_dpsx=new JFrame(“訂票手續”);

//訂票手續

frame_dpsx.setSize(250,200);frame_dpsx.setResizable(false);frame_dpsx.setBackground(Color.LIGHT_GRAY);frame_dpsx.setLayout(new FlowLayout(FlowLayout.CENTER));frame_dpsx.add(new JLabel(“ 姓名 :”));text_fielddp_name=new JTextField(10);frame_dpsx.add(text_fielddp_name);frame_dpsx.add(new JLabel(“ 航班號 :”));text_fielddp_hbh=new JTextField(10);frame_dpsx.add(text_fielddp_hbh);frame_dpsx.add(new JLabel(“ 訂票數 :”));text_fielddp_number=new JTextField(10);frame_dpsx.add(text_fielddp_number);frame_dpsx.add(new JLabel(“聯系方式 :”));text_fielddp_lxfs=new JTextField(10);frame_dpsx.add(text_fielddp_lxfs);button_tj=new JButton(“提交”);frame_dpsx.add(button_tj);button_tj.addActionListener(this);

frame_djsx=new JFrame(“登記手續”);

//登記手續

frame_djsx.setSize(250,200);frame_djsx.setResizable(false);

frame_djsx.setBackground(Color.LIGHT_GRAY);frame_djsx.setLayout(new FlowLayout(FlowLayout.CENTER));frame_djsx.add(new JLabel(“ 姓名 :”));text_fielddj_name=new JTextField(10);frame_djsx.add(text_fielddj_name);frame_djsx.add(new JLabel(“ 航班號 :”));text_fielddj_hbh=new JTextField(10);frame_djsx.add(text_fielddj_hbh);frame_djsx.add(new JLabel(“ 訂票數 :”));text_fielddj_number=new JTextField(10);frame_djsx.add(text_fielddj_number);frame_djsx.add(new JLabel(“聯系方式 :”));text_fielddj_lxfs=new JTextField(10);frame_djsx.add(text_fielddj_lxfs);button_wc=new JButton(“完成”);frame_djsx.add(button_wc);button_wc.addActionListener(this);

frame_tpsx=new JFrame(“退票手續”);

//退票手續

frame_tpsx.setSize(250,200);frame_tpsx.setResizable(false);frame_tpsx.setBackground(Color.LIGHT_GRAY);frame_tpsx.setLayout(new FlowLayout(FlowLayout.CENTER));frame_tpsx.add(new JLabel(“ 姓名 :”));text_fieldtp_name=new JTextField(10);frame_tpsx.add(text_fieldtp_name);frame_tpsx.add(new JLabel(“ 航班號 :”));

text_fieldtp_hbh=new JTextField(10);frame_tpsx.add(text_fieldtp_hbh);frame_tpsx.add(new JLabel(“ 退票數 :”));text_fieldtp_number=new JTextField(10);frame_tpsx.add(text_fieldtp_number);frame_tpsx.add(new JLabel(“聯系方式 :”));text_fieldtp_lxfs=new JTextField(10);frame_tpsx.add(text_fieldtp_lxfs);button_cg=new JButton(“成功”);frame_tpsx.add(button_cg);button_cg.addActionListener(this);

dialog_dpwk=new JDialog(this,“提示”,true);

//提示訂票輸入未開通航線錯誤

dialog_dpwk.setSize(350,80);label=new JLabel(“此站點未開通航線,請查詢后重新輸入!”);dialog_dpwk.add(label);dialog_dpwk.setLayout(new FlowLayout(FlowLayout.CENTER));dialog_dpwk.addWindowListener(this);

dialog_dpyk=new JDialog(this,“提示”,true);

//提示訂票輸入票額不足錯誤

dialog_dpyk.setSize(350,150);label1=new JLabel(“此站點已滿員或余票不足,請查詢后重新輸入!”);dialog_dpyk.add(label1);

錯誤

} label2=new JLabel(“ 若需要,可登記排隊候補”);dialog_dpyk.add(label2);button_sq=new JButton(“登記”);button_sq.addActionListener(this);dialog_dpyk.add(button_sq);dialog_dpyk.setLayout(new FlowLayout(FlowLayout.CENTER));dialog_dpyk.addWindowListener(this);

dialog_tpts=new JDialog(this,“提示”,true);

//提示退票輸入日期和航班號矛盾dialog_tpts.setSize(350,80);label=new JLabel(“您輸入的日期無此航班號,請查詢后重新輸入!”);dialog_tpts.add(label);dialog_tpts.setLayout(new FlowLayout(FlowLayout.CENTER));dialog_tpts.addWindowListener(this);

d=new JDialog(this,“提示”,true);

//當退票滿足客戶,提示聯系該客戶

d.setSize(350,150);d.setLayout(new FlowLayout(FlowLayout.CENTER));d.addWindowListener(this);

this.addWindowListener(this);this.setVisible(true);4.1.2 軟件的查詢、訂票和退票模塊

查詢截圖:

查詢成功截圖:

訂票截圖:

退票截圖:

public void actionPerformed(ActionEvent e){ String s=e.getActionCommand();if(s==“查詢”){ frame_cx.setLocation(this.getX()+100,this.getY()+100);frame_cx.setVisible(true);}

if(s==“訂票”){ frame_dp.setLocation(this.getX()+100,this.getY()+100);frame_dp.setVisible(true);}

if(s==“退票”){ frame_tp.setLocation(this.getX()+100,this.getY()+100);frame_tp.setVisible(true);}

if(s==“ok”){ if(text_field1.getText().toString().trim().equals(“北京”)){ text_user.append(“地點:”+F_name[0]+“ 航班號:”+H_number[0]+“ 飛機號:”+F_number[0]+“ 時間:”+time[0]+“ ”+Price[0]+“ 余票量:”+Count[0]+“n”);

價格:

} else if(text_field1.getText().toString().trim().equals(“香港”)){ text_user.append(“地點:”+F_name[1]+“ 航班號:”+H_number[1]+“ 飛機號:”+F_number[1]+“ 時間:”+time[1]+“ 價格:”+Price[1]+“ 余票量:”+Count[1]+“n”);} else if(text_field1.getText().toString().trim().equals(“澳門”)){ text_user.append(“地點:”+F_name[2]+“ 航班號:”+H_number[2]+“ 飛機號:”+F_number[2]+“ 時間:”+time[2]+“ ”+Price[2]+“ 余票量:”+Count[2]+“n”);} else if(text_field1.getText().toString().trim().equals(“紐約”)){ text_user.append(“地點:”+F_name[3]+“ 航班號:”+H_number[3]+“ 飛機號:”+F_number[3]+“ 時間:”+time[3]+“ ”+Price[3]+“ 余票量:”+Count[3]+“n”);} else if(text_field1.getText().toString().trim().equals(“悉尼”)){ text_user.append(“地點:”+F_name[4]+“ 航班號:”+H_number[4]+“ 飛機號:”+F_number[4]+“ 時間:”+time[4]+“ ”+Price[4]+“ 余票量:”+Count[4]+“n”);} else {

dialog_cx.setLocation(this.getX()+100,this.getY()+100);

dialog_cx.setVisible(true);}

價格:價格:價格: } frame_cx.setVisible(false);if(s==“確定”){

String Hnumber=text_field2.getText().toString().trim();int Dcount=Integer.parseInt(text_field3.getText().toString().trim());if(Hnumber.equals(“CAC”)||Hnumber.equals(“cac”)){

if(Dcount<=Count[0]){ Count[0]-=Dcount;

frame_dpsx.setLocation(this.getX()+100,this.getY()+100);frame_dpsx.setVisible(true);

} else { dialog_dpyk.setLocation(this.getX()+100,this.getY()+100);dialog_dpyk.setVisible(true);

} else if(Hnumber.equals(“CFC”)||Hnumber.equals(“cfc”)&&Dcount<=Count[1]){

if(Dcount<=Count[1]){ Count[0]-=Dcount;}

frame_dpsx.setLocation(this.getX()+100,this.getY()+100);frame_dpsx.setVisible(true);

} else { dialog_dpyk.setLocation(this.getX()+100,this.getY()+100);dialog_dpyk.setVisible(true);} } else if(Hnumber.equals(“CDA”)||Hnumber.equals(“cda”)&&Dcount<=Count[2])

{

if(Dcount<=Count[2]){ Count[0]-=Dcount;

frame_dpsx.setLocation(this.getX()+100,this.getY()+100);frame_dpsx.setVisible(true);

} else { dialog_dpyk.setLocation(this.getX()+100,this.getY()+100);dialog_dpyk.setVisible(true);} } else if(Hnumber.equals(“CCX”)||Hnumber.equals(“ccx”)&&Dcount<=Count[3])

{

if(Dcount<=Count[3]){ Count[0]-=Dcount;

frame_dpsx.setLocation(this.getX()+100,this.getY()+100);frame_dpsx.setVisible(true);

} else { dialog_dpyk.setLocation(this.getX()+100,this.getY()+100);dialog_dpyk.setVisible(true);} } else if(Hnumber.equals(“MCM”)||Hnumber.equals(“mcm”)&&Dcount<=Count[4])

{

if(Dcount<=Count[4]){ Count[0]-=Dcount;

frame_dpsx.setLocation(this.getX()+100,this.getY()+100);frame_dpsx.setVisible(true);

} else { dialog_dpyk.setLocation(this.getX()+100,this.getY()+100);dialog_dpyk.setVisible(true);

}

if(e.getActionCommand()==“提交”){ frame_dpsx.setVisible(false);else {

} frame_dp.setVisible(false);dialog_dpwk.setLocation(this.getX()+100,this.getY()+100);dialog_dpwk.setVisible(true);} } }

if(e.getActionCommand()==“登記”){ dialog_dpyk.setVisible(false);frame_djsx.setLocation(this.getX()+100,this.getY()+100);frame_djsx.setVisible(true);}

if(e.getActionCommand()==“完成”){ int Wait_number=Integer.parseInt(text_fielddj_number.getText().toString().trim());Wait_name[Wait_i]=text_fielddj_name.getText().toString().trim();Wait_hbh[Wait_i]=text_fielddj_hbh.getText().toString().trim();Wait_count[Wait_i]=Wait_number;Wait_xl[Wait_i]=Wait_i;Wait_lxfs[Wait_i]=text_fielddj_lxfs.getText().toString().trim();frame_djsx.setVisible(false);text_user.append(“登記姓名 :”+Wait_name[Wait_i]+“ 登記航班號 :”+Wait_hbh[Wait_i]+“ 登記訂票數量 :”+Wait_count[Wait_i]+“ 聯系方式 ”+Wait_lxfs[Wait_i]+“n”);Wait_i++;}

if(e.getActionCommand()==“正確”){ String a=text_field4.getText().toString().trim();String b=text_field5.getText().toString().trim();if(a.equals(“周三

:”)&&b.equals(“cfc”)||b.equals(“CFC”)||b.equals(“ccx”)||b.equals(“CCX”)){

} else if(a.equals(“周日

”)&&b.equals(“cda”)||b.equals(“CDA”)||b.equals(“mcm”)||b.equals(“MCM”)){ frame_tpsx.setLocation(this.getX()+100,this.getY()+100);frame_tpsx.setLocation(this.getX()+100,this.getY()+100);frame_tpsx.setVisible(true);frame_tpsx.setVisible(true);} else if(a.equals(“周五”)&&b.equals(“cac”)||b.equals(“CAC”)){ frame_tpsx.setLocation(this.getX()+100,this.getY()+100);frame_tpsx.setVisible(true);} else { dialog_tpts.setLocation(this.getX()+100,this.getY()+100);dialog_tpts.setVisible(true);}

frame_tp.setVisible(false);

}

if(e.getActionCommand()==“成功”){

int i=0;int j=0;String c=text_fieldtp_hbh.getText().toString().trim();int Numb=Integer.parseInt(text_fieldtp_number.getText().toString().trim());frame_tpsx.setVisible(false);if(c.equals(“cac”)||c.equals(“CAC”)){

Count[0]+=Numb;

if(Wait_i>0){

for(i=0;i

if(Wait_hbh[i].equals(“cac”)||Wait_hbh[i].equals(“CAC”)&&Wait_count[i]<=Count[0])

{

j=i+1;

label=new JLabel(j+“號客戶:

”+Wait_name[i]+“ 滿足訂票要求,聯系方式是:”+Wait_lxfs[i]);d.add(label);d.setLocation(this.getX()+100,this.getY()+100);d.setVisible(true);} }

}

} else if(c.equals(“cfc”)||c.equals(“CFC”)){ Count[1]+=Numb;if(Wait_i>0){

for(i=0;i

if(Wait_hbh[i].equals(“cfc”)||Wait_hbh[i].equals(“CFC”)&&Wait_count[i]<=Count[0])

{

j=i+1;

label=new JLabel(j+“號客戶:

”+Wait_name[i]+“ 滿足訂票要求,聯系方式是:”+Wait_lxfs[i]);d.add(label);d.setLocation(this.getX()+100,this.getY()+100);d.setVisible(true);} }

}

} else if(c.equals(“cda”)||c.equals(“CDA”)){ Count[2]+=Numb;if(Wait_i>0){

for(i=0;i

if(Wait_hbh[i].equals(“cda”)||Wait_hbh[i].equals(“CDA”)&&Wait_count[i]<=Count[0])

{

j=i+1;

label=new JLabel(j+“號客戶:

”+Wait_name[i]+“ 滿足訂票要求,聯系方式是:”+Wait_lxfs[i]);d.add(label);d.setLocation(this.getX()+100,this.getY()+100);d.setVisible(true);} }

}

} else if(c.equals(“ccx”)||c.equals(“CCX”)){ Count[3]+=Numb;if(Wait_i>0){

for(i=0;i

if(Wait_hbh[i].equals(“ccx”)||Wait_hbh[i].equals(“CCX”)&&Wait_count[i]<=Count[0])

{

j=i+1;

label=new JLabel(j+“號客戶:

”+Wait_name[i]+“ 滿足訂票要求,聯系方式是:”+Wait_lxfs[i]);d.add(label);d.setLocation(this.getX()+100,this.getY()+100);d.setVisible(true);} }

}

} else if(c.equals(“mcm”)||c.equals(“MCM”)){ Count[4]+=Numb;if(Wait_i>0){

for(i=0;i

if(Wait_hbh[i].equals(“mcm”)||Wait_hbh[i].equals(“MCM”)&&Wait_count[i]<=Count[0])

{

j=i+1;

label=new JLabel(j+“號客戶:

”+Wait_name[i]+“ 滿足訂票要求,聯系方式是:”+Wait_lxfs[i]);d.add(label);d.setLocation(this.getX()+100,this.getY()+100);d.setVisible(true);} }

} } } }

第二篇:航空售票管理系統

#include #include #include #include #include #define N 100 using namespace std;

typedef struct node//定義信息結構體 {

char num[10];// 航班號

int hour;//起飛時間小時

int minitues;//起飛時間分鐘

char start[10];//起始

char end[10];//終點

float prize;//經濟艙票價

int last;//剩余座位 }FLIGHT;

typedef struct Order//訂單信息 {

char name[10];//乘客姓名

char num[10];//航班號

int count;//訂票數量 }Order;

class flight//定義類 {

private: FLIGHT stu[N];//每個元素對應一條信息

Order psg[N];//訂單

int len;//航班總數

int lenp;//訂票者總數 public:

flight();

~flight();void input();//錄入信息

void show();//瀏覽

void sall();//售票

void back();//退票

void search();// 信息查詢

void search2();// 信息查詢(起點終點)

char menu();//菜單

};

flight stud;

char filename[]=“flight.txt”;

flight::flight(){}//構造函數 flight::~flight(){}//析構函數

bool CheckTime(int h1,int m1,int h2,int m2)//判斷兩個時間前后

{ if(h1

return true;else if(h1==h2){

if(m1

return true;

else

return false;} else

return false;} void flight::show()//瀏覽 {

system(“cls”);//清屏

cout<<“

所有航班信息如下:”<

起飛時間

起點

終點

經濟艙票價

剩余座位

備注”<

for(int i=0;i

printf(“%-10s%-2.2d:%-2.2d

%-10s%-10s%-12.2f%-10d”,stu[i].num,stu[i].hour,stu[i].minitues,stu[i].start,stu[i].end,stu[i].prize,stu[i].last);

time_t t;

struct tm *tm;

t=time(NULL);//獲取當前系統時間

tm=localtime(&t);

if(CheckTime(stud.stu[i].hour,stud.stu[i].minitues,tm->tm_hour,tm->tm_min)==true)//如果起飛時間在當前時間之前 輸出此次航班已發出

cout<<“此次航班已發出”<

else

cout<

} cout<<“_______________________________________________________________________________”<

void flight::back()//退票 {

char name[20];

char s[20];

system(“cls”);//清屏

cout<<“請輸入退票的航班編號:”;cin>>s;

for(int i=0;i

if(strcmp(stud.stu[i].num,s)==0)

break;//存在 結束循環

if(i==stud.len)//這二者相等說明查找完所有信息也沒找到輸入信息,說明輸入航班編號不存在{

cout<<“對不起!沒有你輸入航班編號的相關信息。n”;

system(“pause”);//任意鍵繼續

return;}

time_t t;

struct tm *tm;

t=time(NULL);//獲取當前系統時間

tm=localtime(&t);if(CheckTime(stud.stu[i].hour,stud.stu[i].minitues,tm->tm_hour,tm->tm_min)==true)

{

cout<<“對不起!該航班已經起飛。不能退票。n”;

system(“pause”);//任意鍵繼續

return;} int j=i;

cout<<“請輸入您的姓名:”;cin>>name;for(i=0;i

if(strcmp(stud.psg[i].name,name)==0 && strcmp(stud.psg[i].num,s)==0)//查詢這個名字是否相同

{

stud.stu[j].last+=stud.psg[i].count;//退票

stud.psg[i]=stud.psg[stud.lenp-1];///刪除這個訂單

stud.lenp--;//訂單數減一

cout<<“退票成功!n”;

system(“pause”);//任意鍵繼續

return;

} } cout<<“對不起!您沒有定該航班的票。n”;

system(“pause”);//任意鍵繼續

}

void flight::sall()//售票 {

char s[20];

system(“cls”);//清屏

cout<<“請輸入要購買的航班編號:”;cin>>s;

for(int i=0;i

if(strcmp(stud.stu[i].num,s)==0)

break;//存在 結束循環

if(i==stud.len)//這二者相等說明查找完所有信息也沒找到輸入信息,說明輸入航班編號不存在{

cout<<“對不起!沒有你輸入航班編號的相關信息。n”;

system(“pause”);//任意鍵繼續

return;}

if(stud.stu[i].last<=0)//沒有票了

{

cout<<“對不起!該航班票已售完。n”;

system(“pause”);//任意鍵繼續

return;}

time_t t;

struct tm *tm;

t=time(NULL);//獲取當前系統時間

tm=localtime(&t);if(CheckTime(stud.stu[i].hour,stud.stu[i].minitues,tm->tm_hour,tm->tm_min)==true)

{

cout<<“對不起!該航班已經起飛。n”;

system(“pause”);//任意鍵繼續

return;}

int j=i;i=stud.lenp;strcpy(stud.psg[i].num,stud.stu[i].num);cout<<“請輸入購票數量:”;cin>>stud.psg[i].count;

while(stud.psg[i].count>stud.stu[i].last){

cout<<“余票不足,請重新輸入:”;

cin>>stud.psg[i].count;

} cout<<“請輸入您的姓名:”;cin>>stud.psg[i].name;

stud.stu[j].last-=stud.psg[i].count;//剩余票數

stud.lenp++;cout<<“購票成功!n”;system(“pause”);//任意鍵繼續 }

void flight::input()//錄入信息 {

system(“cls”);//清屏

for(int i=stud.len;i

{

cout<<“請輸入航班號:”;

cin>>stud.stu[i].num;

cout<<“請輸入起飛時間(格式: 12:30):”;

char ch;

cin>>stud.stu[i].hour>>ch>>stud.stu[i].minitues;

cout<<“請輸入起點:”;

cin>>stud.stu[i].start;

cout<<“請輸入終點:”;

cin>>stud.stu[i].end;

cout<<“請輸入經濟艙票價:”;

cin>>stud.stu[i].prize;

cout<<“請輸入剩余座位:”;

cin>>stud.stu[i].last;

stud.len++;//個數加1

cout<<“一條航班信息錄入完成,是否繼續錄入?(y/n):”;

while(1)

{

cin>>ch;

if(ch=='y' || ch=='Y' || ch=='n' || ch=='N')

break;

else

cout<<“輸入錯誤請重新輸入:”;

}

if(ch=='n' || ch=='N')

break;

} }

void flight::search()// 信息查詢 {

char s[20];

system(“cls”);//清屏

cout<<“請輸入要查詢的航班編號:”;cin>>s;

for(int i=0;i

if(strcmp(stud.stu[i].num,s)==0)

break;//存在 結束循環

if(i==stud.len)//這二者相等說明查找完所有信息也沒找到輸入信息,說明輸入航班編號不存在{

cout<<“對不起!沒有你輸入航班編號的相關信息。n”;

system(“pause”);//任意鍵繼續

return;}

cout<<“

查詢結果如下:”<

起飛時間

起點

終點

經濟艙票價

剩余座位

備注”<

printf(“%-10s%-2.2d:%-2.2d

%-10s%-10s%-12.2f%-10d”,stu[i].num,stu[i].hour,stu[i].minitues,stu[i].start,stu[i].end,stu[i].prize,stu[i].last);

time_t t;

struct tm *tm;

t=time(NULL);//獲取當前系統時間

tm=localtime(&t);

if(CheckTime(stud.stu[i].hour,stud.stu[i].minitues,tm->tm_hour,tm->tm_min)==true)//如果起飛時間在當前時間之前 輸出此次航班已發出

cout<<“此次航班已發出”<

else

cout<

cout<<“_______________________________________________________________________________”<

void flight::search2()// 信息查詢(按線路){

char s1[20],s2[20];

system(“cls”);//清屏

cout<<“請輸入要查詢的線路起點:”;cin>>s1;

cout<<“請輸入要查詢的線路終點:”;cin>>s2;

for(int i=0;i

if(strcmp(stud.stu[i].start,s1)==0 && strcmp(stud.stu[i].end,s2)==0)

break;//存在 結束循環

if(i==stud.len)//這二者相等說明查找完所有信息也沒找到輸入信息,說明輸入航班編號不存在{

cout<<“對不起!沒有你輸入線路的相關信息。n”;

system(“pause”);//任意鍵繼續

return;}

cout<<“

查詢結果如下:”<

起飛時間

起點

終點

經濟艙票價

剩余座位

備注”<

for(i=0;i

if(strcmp(stud.stu[i].start,s1)==0 && strcmp(stud.stu[i].end,s2)==0)

{

printf(“%-10s%-2.2d:%-2.2d

%-10s%-10s%-12.2f%-10d”,stu[i].num,stu[i].hour,stu[i].minitues,stu[i].start,stu[i].end,stu[i].prize,stu[i].last);

time_t t;

struct tm *tm;

t=time(NULL);//獲取當前系統時間

tm=localtime(&t);

if(CheckTime(stud.stu[i].hour,stud.stu[i].minitues,tm->tm_hour,tm->tm_min)==true)//如果起飛時間在當前時間之前 輸出此次航班已發出

cout<<“此次航班已發出”<

else

cout<

} cout<<“_______________________________________________________________________________”<

char flight::menu()//菜單 { char c;

system(“cls”);//清屏

cout<<“nnnn

╔═══════════════════════════╗n”;cout<<“

1、錄入航班信息

║n”;

cout<<“

╠═══════════════════════════╣n”;cout<<“

2、瀏覽航班信息

║n”;cout<<“

╠═══════════════════════════╣n”;

cout<<“

3、查詢路線(按編號)

║n”;

cout<<“

╠═══════════════════════════╣n”;cout<<“

4、查詢路線(按線路)

║n”;

cout<<“

╠═══════════════════════════╣n”;cout<<“

5、售票

║n”;

cout<<“

╠═══════════════════════════╣n”;cout<<“

6、退票

║n”;

cout<<“

╠═══════════════════════════╣n”;cout<<“

0、退出系統

║n”;

cout<<“

╚═══════════════════════════╝n”;cout<<“

請選擇:”;

cin>>c;

return c;}

int main(){

while(1)

{

char ch;

ch=stud.menu();//獲取選擇

switch(ch)

{

case '1': stud.input();break;//錄入航班信息

case '2': stud.show();break;//瀏覽航班信息

case '3': stud.search();break;// 查詢路線

case '4': stud.search2();break;// 查詢路線(按線路)

case '5': stud.sall();break;// 售票

case '6': stud.back();

break;// 退票

case '0': exit(0);//退出

}

}

return 0;}

第三篇:航空售票系統系統實施報告

航 空 售 票 管 理 系 統

實 施 報 告

組員:

目錄

第一章 引言 ················································································································· 4

1.1編寫目的··········································································································· 4 1.2參考文獻··········································································································· 4 1.3術語和縮寫詞...................................................................................................4 第二章

軟件概述 ····································································································· 5

2.1軟件用途··········································································································· 5 2.2軟件運行··········································································································· 5 2.3系統配置·········································································································· 7 2.4軟件結構·········································································································· 7 2.5軟件性能·········································································································· 8 2.6輸入、處理、輸出·························································································· 8

2.6.1輸入········································································································· 8 2.6.2輸出········································································································· 9

第三章

軟件使用過程 ····························································································· 10

3.1軟件安裝········································································································· 10 3.2運行步驟········································································································· 10 3.3運行說明········································································································· 10

3.3.1控制輸入······························································································· 10 3.3.2管理信息······························································································· 10 3.4.3輸入輸出文件······················································································· 10 3.4.4輸出報告······························································································· 10 3.5出錯處理········································································································· 10 3.6非常規過程····································································································· 11 第四章 軟件維護過程 ······························································································· 12

4.1程序設計的約定····························································································· 12 4.2出錯及糾正方法····························································································· 12 4.3專用維護程序································································································· 12 4.4 源程序清單···································································································· 12

第一章 引言

1.1編寫目的

開發目標:開發出一個操作簡便,界面友好,靈活實用,安全可靠,功能齊全的的航空售票管理信息系統。

航空售票管理信息系統對航空相關單位進行包括機票訂購在內的許多信息管理有著極其重要的作用,就一般的實用軟件來說,它的設計內容繁多、功能重疊、操作復雜,比如訂票和修改票務信息某些功能模塊重疊等。本開發小組正是通過廣泛調研,對同類的相關系統掌握了一定的資料的基礎上,制定開發出來的。為了更好的完善本系統,在實施管理階段特制定本實施報告,以求徹底完善本系統。

1.2參考文獻

[1]張翼英等 《Visual Basic課程設計》 清華大學出版社 出版日期:2008-1 [2]《信息系統開發方法》清華大學出版社 姜旭平

1.3術語和縮寫詞

在本文檔中,所有專門術語的定義以及縮寫詞的原意如下: ①程序流程圖:

程序流程圖又稱程序框圖,獨立于任何一種設計語言,比較直觀和清晰的描述了過程的控制流程。

②N-S圖:

N-S圖是為了改變流程圖描述程序邏輯時過大的隨意性與靈活性,其規定了五種圖形構建,包括:順序型,選擇型,while重復,until重復型,多分枝選擇型。

③PAD圖:

PAD圖是problem analysis diagram的英文縮寫,是日本日立公司提出。它使用結構化程序設計思想表現程序的邏輯結構的圖形工具。

④PDL語言:

PDL語言是procedure design language的英文縮寫。PDL是所有非正文形式的過程設計工具的統稱。PDL具有“非純粹”的編寫語言的特點。

第二章

軟件概述

2.1軟件用途

現在應用在大中型企業的管理信息系統中,幾乎都包括了工資管理模塊。有些環境中是由作為大型ERP軟件中的一個模塊引進的,有些是作為企業的財務系統的一部分。這些根據規范的西方的管理制度設計的工資管理軟件,在很多時候還不能完全解決中國特色的中小企業的問題,本文介紹的就是要為高校解決他們在工資管理方面的問題,主要實現系統用戶管理、員工基本信息管理、工資標準設定以及工資結算和查詢等一般工資管理系統應具有的主要功能,以便完成課程實踐的目的。

2.2軟件運行

學生成績管理系統主要有:登陸界面、員工信息管理,工資標準管理 主要運行如下所示:

a : 登陸界面

輸入姓名、密碼,點擊登陸界面顯示圖 b : 航線信息界面

圖2.5 c :機票信息界面

圖2.8 2.3系統配置

本軟件要求在PC 及其兼容機上運行,要求奔騰II以上CPU,64兆以上內存,10G 以上硬盤。

軟件需要有WINDOWS 7操作系統環境。.4軟件結構

航空售票管理系統的結構圖如下:

航空訂票管理系統訂票信息管理客戶信息管理航線信息管理系統管理訂票信息查詢訂票信息修改添加訂票信息客戶基本信息管理客戶類別信息管理航線基本信息管理客機信息管理艙位信息管理密碼管理用戶管理客戶信息查詢客戶信息修改客戶信息添加客戶類別信息修改客戶類別信息添加航線信息查詢航線信息修改航線信息添加客機信息查詢客機信息修改客機信息添加艙位信息修改艙位信息添加

圖2.12 2.5軟件性能

A:用戶管理模塊能在普通用戶與管理員之間加以區分,分別實現其對應的功能,方法簡單,性能較好。

B:查詢模塊中我們對教職工按照姓名和工號兩種方法進行查詢,有效的考慮了重名的各種情況,達到一定的性能指標。

C:工資模塊:我們將職稱工資管理和其他工資管理等幾種情況

D:密碼管理:我們起初編寫了一份密碼表,只有按照密碼表上的輸入才能對工資管理系統進行相關操作,性能較好。.6輸入、輸出 2.6.1輸入 本系統采用文本文框進行信息的輸入以及成績的輸入。

我們將創建模塊,顯示模塊,存盤功能模塊,讀入功能模塊,統計功能模塊等的輸入項

2.6.2輸出

本系統采用文本文框進行信息的輸出以及成績的輸出。

我們將創建模塊,顯示模塊,存盤功能模塊,讀入功能模塊,統計功能模塊等的輸出項

第三章 軟件使用過程

3.1軟件安裝

本系統采用vb.net進行設計與實現,完成設計后進行發布就可以在沒有安裝vb.net環境的計算機中使用,安裝方便簡潔,只需要在安裝的計算機中添加數據庫即可。

3.2運行步驟

首先選擇要登錄的角色,然后進入相應的界面進行操作。

3.3運行說明

對于本系統我們設計時進行了權限的分配,比如普通用戶登陸后只能進行自己工資的查詢而不能進行工資的修改,管理員登陸后既可以進行查詢又可以進行修改。

3.3.1控制輸入

按照軟件的說明,將測試數據加入到軟件中

3.3.2管理信息

軟件運行過程中的密碼鍵入:通過文本框進行輸入。

3.4.3輸入輸出文件

軟件運行過程中通過文本框進行文件的輸入輸出。

3.4.4輸出報告

若輸入要輸出的條件正確的話會彈出相應的提示框提示是否成功或者正確等。

3.5出錯處理

軟件運行過程中可能雛形的出物及處理如下:(1)輸入信息出錯

在數據庫內找不到輸入的信息,輸入信息有誤,導致操作失敗。(2)出錯處理對策

檢查重新輸入的信息是否符合要求。(3)數據庫連接錯誤

這類錯誤主要是數據庫設置不正確,或sql server異常引起的,我們只要取消本次操作,提醒用戶檢查數據庫問題就可。

3.6非常規過程

如果出現不可能處理的問題,可以直接與公司的技術支持人員聯系。

第四章 軟件維護過程

4.1程序設計的約定

本軟件程序是一個單一的運行軟件,各個軟件子模塊的預定如下:

航空售票管理系統主要以管理航空售票信息為目的,設置了嚴密的權限管理。用戶管理:設置了權限管理功能

查詢管理:包括查詢航線和航班等基本信息。可以顯示單獨一條記錄,也可以顯示所有信息。

更新管理:當有需要時,管理員可以進行工資和信息的刪除操作 密碼管理:管理員和個人可以根據需求修改密碼。

4.2出錯及糾正方法

可能由于輸入的數據不符合軟件的要求,軟件將可能提出錯誤,并提醒您按照軟件的要求運行程序;可能出現的問題如下:

<1>若輸入密碼格式不對,應提示:您輸入的密碼錯誤。

4.3專用維護程序

本軟件提供您一個專用維護軟件,以便在軟件出現意想不到的問題時可以使您迅速發現您在軟件運行時的失誤,保證您的分析結果不會受到損失,盡管您的軟件可能永遠不會出現使用維護本軟件的時候,希望您在使用分析錯誤!未找到索引項。軟件的時候,可以瀏覽以下本軟件的使用。軟件的使用如下:

A:輸入正確的用戶名與密碼登陸。

B:若是普通用戶,請選擇登陸普通用戶界面。C:若是管理員,請選擇登陸管理員界面。

4.4 源程序清單

登錄界面代碼:

Imports System.Data Imports System.Data.SqlClient Public Class 登錄

Inherits System.Windows.Forms.Form Dim count As Integer = 0 Dim my_class As New class1 #Region “ Windows 窗體設計器生成的代碼” Public Sub New()MyBase.New()'該調用是Windows 窗體設計器所必需的。InitializeComponent()'在InitializeComponent()調用之后添加任何初始化

End Sub '窗體重寫dispose 以清理組件列表。

Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)If disposing Then If Not(components Is Nothing)Then components.Dispose()End If End If MyBase.Dispose(disposing)End Sub 'Windows 窗體設計器所必需的

Private components As System.ComponentModel.IContainer '注意: 以下過程是Windows 窗體設計器所必需的'可以使用Windows 窗體設計器修改此過程。

'不要使用代碼編輯器修改它。

Friend WithEvents Button2 As System.Windows.Forms.Button Friend WithEvents Button1 As System.Windows.Forms.Button Friend WithEvents TextBox2 As System.Windows.Forms.TextBox Friend WithEvents TextBox1 As System.Windows.Forms.TextBox Friend WithEvents Label3 As System.Windows.Forms.Label Friend WithEvents Label2 As System.Windows.Forms.Label Friend WithEvents Label1 As System.Windows.Forms.Label Private Sub InitializeComponent()Dim resources As System.ComponentModel.ComponentResourceManager = New System.ComponentModel.ComponentResourceManager(GetType(登錄))Me.Button2 = New System.Windows.Forms.Button Me.Button1 = New System.Windows.Forms.Button Me.TextBox2 = New System.Windows.Forms.TextBox Me.TextBox1 = New System.Windows.Forms.TextBox Me.Label3 = New System.Windows.Forms.Label Me.Label2 = New System.Windows.Forms.Label Me.Label1 = New System.Windows.Forms.Label Me.SuspendLayout()'Button2 Me.Button2.Font = New System.Drawing.Font(“宋體”, 12.0!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(134, Byte))Me.Button2.Location = New System.Drawing.Point(306, 299)Me.Button2.Name = “Button2” Me.Button2.Size = New System.Drawing.Size(112, 32)Me.Button2.TabIndex = 13 Me.Button2.Text = “取 消” 'Button1 Me.Button1.Font = New System.Drawing.Font(“宋體”, 12.0!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(134, Byte))Me.Button1.Location = New System.Drawing.Point(72, 299)Me.Button1.Name = “Button1” Me.Button1.Size = New System.Drawing.Size(112, 32)Me.Button1.TabIndex = 12 Me.Button1.Text = “確 定” 'TextBox2 Me.TextBox2.Location = New System.Drawing.Point(208, 235)Me.TextBox2.Name = “TextBox2” Me.TextBox2.PasswordChar = Global.Microsoft.VisualBasic.ChrW(42)Me.TextBox2.Size = New System.Drawing.Size(240, 21)Me.TextBox2.TabIndex = 11 'TextBox1' Me.TextBox1.Location = New System.Drawing.Point(208, 163)Me.TextBox1.Name = “TextBox1” Me.TextBox1.Size = New System.Drawing.Size(240, 21)Me.TextBox1.TabIndex = 10 'Label3 Me.Label3.Font = New System.Drawing.Font(“宋體”, 12.0!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(134, Byte))Me.Label3.Location = New System.Drawing.Point(48, 234)Me.Label3.Name = “Label3” Me.Label3.Size = New System.Drawing.Size(136, 22)Me.Label3.TabIndex = 9 Me.Label3.Text = “ 密 碼” '

'Label2 ' Me.Label2.Font = New System.Drawing.Font(“宋體”, 12.0!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(134, Byte))Me.Label2.Location = New System.Drawing.Point(48, 163)Me.Label2.Name = “Label2” Me.Label2.Size = New System.Drawing.Size(136, 21)Me.Label2.TabIndex = 8 Me.Label2.Text = “ 用戶名” '

'Label1 ' Me.Label1.BackColor = System.Drawing.SystemColors.ButtonHighlight Me.Label1.Font = New System.Drawing.Font(“華文彩云”, 36.0!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(134, Byte))Me.Label1.ForeColor = System.Drawing.SystemColors.InactiveCaption Me.Label1.Location = New System.Drawing.Point(55, 9)Me.Label1.Name = “Label1” Me.Label1.Size = New System.Drawing.Size(393, 120)Me.Label1.TabIndex = 7 Me.Label1.Text = “蘭州航空公司 管理信息系統” '

'登錄 ' Me.AutoScaleBaseSize = New System.Drawing.Size(6, 14)Me.BackgroundImage = CType(resources.GetObject(“$this.BackgroundImage”), System.Drawing.Image)Me.ClientSize = New System.Drawing.Size(504, 390)Me.Controls.Add(Me.Button2)Me.Controls.Add(Me.Button1)Me.Controls.Add(Me.TextBox2)Me.Controls.Add(Me.TextBox1)Me.Controls.Add(Me.Label3)Me.Controls.Add(Me.Label2)Me.Controls.Add(Me.Label1)Me.Icon = CType(resources.GetObject(“$this.Icon”), System.Drawing.Icon)Me.Name = “登錄” Me.Text = “Form7” Me.ResumeLayout(False)Me.PerformLayout()End Sub #End Region Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)Handles Button1.Click Dim user As String Dim pw As String Dim temp1 As String Dim temp2 As String Dim con As String Dim singe As Integer = 1 user = TextBox1.Text username = TextBox1.Text pw = TextBox2.Text con = “select * from users where id='” + user + “' and password='” + pw + “'” Dim ds As New DataSet ds = class1.query(con)Try If ds.Tables(0).Rows.Count > 0 Then class1.dr = ds.Tables(0).Rows(0)temp1 = class1.dr(0)temp2 = class1.dr(1)主窗口.Show()End If Catch ex As Exception MessageBox.Show(ex.Message)End Try 'con = “insert into log(id)select id from permission where id='” + temp1 + “'” 'If(Trim(user)= Trim(temp1)And Trim(pw)= Trim(temp2)And(user <> “" Or pw <> ”“))Then ' Me.Hide()' class1.insert(con)' singe = 1 'ElseIf(user = ”“ And pw = ”“)Then ' MessageBox.Show(”用戶名和密碼為空!“, ”提示“)' TextBox1.Focus()' singe = 0 'ElseIf(Trim(user)<> Trim(temp1)Or Trim(pw)<> Trim(temp2))Then ' MessageBox.Show(”沒有這個用戶或密碼錯誤,請重新輸入!“, ”提示“)' TextBox1.SelectAll()' TextBox1.Focus()' singe = 0 'End If 'count = count + 1 'If(count = 3 And singe = 0)Then ' MessageBox.Show(”三次錯誤,退出本系統“, ”提示“)' End 'End If End Sub Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)Handles Button2.Click End Sub Private Sub Form7_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)Handles MyBase.Load class1.init()Label1.BackColor = Color.Transparent Label2.BackColor = Color.Transparent Label3.BackColor = Color.Transparent Button1.BackColor = Color.Transparent Button2.BackColor = Color.Transparent End Sub End Class 訂票界面代碼:

Public Class 訂票

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)Handles Button1.Click Dim i As Integer If TextBox1.Text = ”“ Then i = MsgBox(”客戶號不能為空“, MsgBoxStyle.OkCancel, ”警告“)Else Dim conn As String = ”data source=.;connect timeout=5;User ID=sa;Password='123';initial catalog=Ticket;“ Dim objconn1 As New SqlConnection(conn)objconn1.Open()Dim 客戶號 As New SqlParameter(”@客戶號“, SqlDbType.Int, 4)Dim 客戶姓名 As New SqlParameter(”@客戶姓名“, SqlDbType.Char, 10)Dim 起飛地 As New SqlParameter(”@起飛地“, SqlDbType.VarChar, 50)Dim 目的地 As New SqlParameter(”@目的地“, SqlDbType.VarChar, 50)Dim 票價 As New SqlParameter(”@票價“, SqlDbType.Int, 4)Dim 飛行時間 As New SqlParameter(”@飛行時間“, SqlDbType.Int, 4)Dim 航空公司 As New SqlParameter(”@航空公司“, SqlDbType.VarChar, 50)Dim strin As String strin = ”insert into flyernb(客戶號,客戶姓名,起飛地,目的地,票價,飛行時間,航空公司)values(@客戶號,@客戶姓名,@起飛地,@目的地,@票價,@飛行時間,@航空公司)“ Dim objcmd1 As New SqlCommand(strin, objconn1)objcmd1.Parameters.Add(客戶號)objcmd1.Parameters.Add(客戶姓名)objcmd1.Parameters.Add(起飛地)objcmd1.Parameters.Add(目的地)objcmd1.Parameters.Add(票價)objcmd1.Parameters.Add(飛行時間)objcmd1.Parameters.Add(航空公司)客戶號.Value = TextBox1.Text 客戶姓名.Value = TextBox2.Text 起飛地.Value = ComboBox2.Text()目的地.Value = ComboBox3.Text()票價.Value = TextBox5.Text 飛行時間.Value = TextBox6.Text 航空公司.Value = ComboBox1.Text objcmd1.ExecuteNonQuery()objconn1.Close()objcmd1.Dispose()MsgBox(”訂票成功!“)TextBox1.Text = ”“ TextBox2.Text = ”“ TextBox5.Text = ”“ TextBox6.Text = ”“ ComboBox2.Text = ”“ ComboBox3.Text()= ”“ ComboBox1.Text()= ”“ End If End Sub Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)Handles Button2.Click Me.Close()End Sub End Class 退票界面代碼:

Public Class 退票

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)Handles Button1.Click Dim i As Integer i = MsgBox(”確定要退票嗎?“, MsgBoxStyle.OkCancel, ”警告“)If i = MsgBoxResult.Cancel Then Close()Else Dim conn As String = ”data source=.;connect timeout=300;User ID=sa;Password='123';initial catalog=Ticket;“ Dim objconn1 As New SqlConnection(conn)'objconn1.Open()Dim strsql As String = ”delete from flyernb where 客戶號='“ & Trim(TextBox1.Text)& ”'“ objconn1.Open()Dim objcmd As New SqlCommand(strsql, objconn1)objcmd.ExecuteNonQuery()objconn1.Close()objcmd.Dispose()MsgBox(”刪除成功!“)TextBox1.Text = ”“ End If End Sub Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)Handles Button2.Click Me.Close()End Sub End Class 用戶權限設置代碼:

Public Class 退票

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)Handles Button1.Click Dim i As Integer i = MsgBox(”確定要退票嗎?“, MsgBoxStyle.OkCancel, ”警告“)If i = MsgBoxResult.Cancel Then Close()Else Dim conn As String = ”data source=.;connect timeout=300;User ID=sa;Password='123';initial catalog=Ticket;“ Dim objconn1 As New SqlConnection(conn)'objconn1.Open()Dim strsql As String = ”delete from flyernb where 客戶號='“ & Trim(TextBox1.Text)& ”'“ objconn1.Open()Dim objcmd As New SqlCommand(strsql, objconn1)objcmd.ExecuteNonQuery()objconn1.Close()objcmd.Dispose()MsgBox(”刪除成功!“)TextBox1.Text = ”“ End If End Sub Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)Handles Button2.Click Me.Close()End Sub End Class 航線信息代碼:

Public Class 航線信息

Inherits System.Windows.Forms.Form #Region ” Windows 窗體設計器生成的代碼“ Public Sub New()MyBase.New()'該調用是Windows 窗體設計器所必需的。InitializeComponent()'在InitializeComponent()調用之后添加任何初始化

End Sub '窗體重寫dispose 以清理組件列表。

Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)If disposing Then If Not(components Is Nothing)Then components.Dispose()End If End If MyBase.Dispose(disposing)End Sub 'Windows 窗體設計器所必需的

Private components As System.ComponentModel.IContainer '注意: 以下過程是Windows 窗體設計器所必需的'可以使用Windows 窗體設計器修改此過程。

'不要使用代碼編輯器修改它。

Friend WithEvents GroupBox1 As System.Windows.Forms.GroupBox Friend WithEvents Label1 As System.Windows.Forms.Label Friend WithEvents Label2 As System.Windows.Forms.Label Friend WithEvents Label3 As System.Windows.Forms.Label Friend WithEvents Label4 As System.Windows.Forms.Label Friend WithEvents Label5 As System.Windows.Forms.Label Friend WithEvents Label6 As System.Windows.Forms.Label Friend WithEvents Label7 As System.Windows.Forms.Label Friend WithEvents Label8 As System.Windows.Forms.Label Friend WithEvents Label9 As System.Windows.Forms.Label Friend WithEvents Label10 As System.Windows.Forms.Label Friend WithEvents TextBox1 As System.Windows.Forms.TextBox Friend WithEvents TextBox2 As System.Windows.Forms.TextBox Friend WithEvents TextBox3 As System.Windows.Forms.TextBox Friend WithEvents TextBox4 As System.Windows.Forms.TextBox Friend WithEvents TextBox5 As System.Windows.Forms.TextBox Friend WithEvents TextBox6 As System.Windows.Forms.TextBox Friend WithEvents TextBox7 As System.Windows.Forms.TextBox Friend WithEvents TextBox8 As System.Windows.Forms.TextBox Friend WithEvents ComboBox1 As System.Windows.Forms.ComboBox Friend WithEvents Button1 As System.Windows.Forms.Button Friend WithEvents Button2 As System.Windows.Forms.Button Friend WithEvents Label11 As System.Windows.Forms.Label Friend WithEvents TextBox10 As System.Windows.Forms.TextBox Friend WithEvents TextBox9 As System.Windows.Forms.TextBox Private Sub InitializeComponent()Dim resources As System.ComponentModel.ComponentResourceManager = New System.ComponentModel.ComponentResourceManager(GetType(航線信息))Me.GroupBox1 = New System.Windows.Forms.GroupBox Me.TextBox10 = New System.Windows.Forms.TextBox Me.TextBox9 = New System.Windows.Forms.TextBox Me.Label11 = New System.Windows.Forms.Label Me.ComboBox1 = New System.Windows.Forms.ComboBox Me.TextBox8 = New System.Windows.Forms.TextBox Me.TextBox7 = New System.Windows.Forms.TextBox Me.TextBox6 = New System.Windows.Forms.TextBox Me.TextBox5 = New System.Windows.Forms.TextBox Me.TextBox4 = New System.Windows.Forms.TextBox Me.TextBox3 = New System.Windows.Forms.TextBox Me.TextBox2 = New System.Windows.Forms.TextBox Me.TextBox1 = New System.Windows.Forms.TextBox Me.Label10 = New System.Windows.Forms.Label Me.Label9 = New System.Windows.Forms.Label Me.Label8 = New System.Windows.Forms.Label Me.Label7 = New System.Windows.Forms.Label Me.Label6 = New System.Windows.Forms.Label Me.Label5 = New System.Windows.Forms.Label Me.Label4 = New System.Windows.Forms.Label Me.Label3 = New System.Windows.Forms.Label Me.Label2 = New System.Windows.Forms.Label Me.Label1 = New System.Windows.Forms.Label Me.Button1 = New System.Windows.Forms.Button Me.Button2 = New System.Windows.Forms.Button Me.GroupBox1.SuspendLayout()Me.SuspendLayout()'

'GroupBox1' Me.GroupBox1.Controls.Add(Me.TextBox10)Me.GroupBox1.Controls.Add(Me.TextBox9)Me.GroupBox1.Controls.Add(Me.Label11)Me.GroupBox1.Controls.Add(Me.ComboBox1)Me.GroupBox1.Controls.Add(Me.TextBox8)Me.GroupBox1.Controls.Add(Me.TextBox7)Me.GroupBox1.Controls.Add(Me.TextBox6)Me.GroupBox1.Controls.Add(Me.TextBox5)Me.GroupBox1.Controls.Add(Me.TextBox4)Me.GroupBox1.Controls.Add(Me.TextBox3)Me.GroupBox1.Controls.Add(Me.TextBox2)Me.GroupBox1.Controls.Add(Me.TextBox1)Me.GroupBox1.Controls.Add(Me.Label10)Me.GroupBox1.Controls.Add(Me.Label9)Me.GroupBox1.Controls.Add(Me.Label8)Me.GroupBox1.Controls.Add(Me.Label7)Me.GroupBox1.Controls.Add(Me.Label6)Me.GroupBox1.Controls.Add(Me.Label5)Me.GroupBox1.Controls.Add(Me.Label4)Me.GroupBox1.Controls.Add(Me.Label3)Me.GroupBox1.Controls.Add(Me.Label2)Me.GroupBox1.Controls.Add(Me.Label1)Me.GroupBox1.Font = New System.Drawing.Font(”宋體“, 10.5!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(134, Byte))Me.GroupBox1.Location = New System.Drawing.Point(8, 8)Me.GroupBox1.Name = ”GroupBox1“ Me.GroupBox1.Size = New System.Drawing.Size(488, 344)Me.GroupBox1.TabIndex = 0 Me.GroupBox1.TabStop = False Me.GroupBox1.Text = ”航線信息“ '

'TextBox10 ' Me.TextBox10.Location = New System.Drawing.Point(376, 182)Me.TextBox10.Name = ”TextBox10“ Me.TextBox10.Size = New System.Drawing.Size(100, 23)Me.TextBox10.TabIndex = 22 '

'TextBox9 ' Me.TextBox9.Location = New System.Drawing.Point(128, 32)Me.TextBox9.Name = ”TextBox9“ Me.TextBox9.Size = New System.Drawing.Size(100, 23)Me.TextBox9.TabIndex = 21 '

'Label11 Me.Label11.Location = New System.Drawing.Point(24, 32)Me.Label11.Name = ”Label11“ Me.Label11.Size = New System.Drawing.Size(100, 23)Me.Label11.TabIndex = 20 Me.Label11.Text = ”航線編號“ 'ComboBox1 Me.ComboBox1.Location = New System.Drawing.Point(376, 29)Me.ComboBox1.Name = ”ComboBox1“ Me.ComboBox1.Size = New System.Drawing.Size(104, 22)Me.ComboBox1.TabIndex = 18 'TextBox8 ' Me.TextBox8.Location = New System.Drawing.Point(128, 272)Me.TextBox8.Multiline = True Me.TextBox8.Name = ”TextBox8“ Me.TextBox8.ScrollBars = System.Windows.Forms.ScrollBars.Both Me.TextBox8.Size = New System.Drawing.Size(336, 56)Me.TextBox8.TabIndex = 17 'TextBox7 Me.TextBox7.Location = New System.Drawing.Point(130, 237)Me.TextBox7.Name = ”TextBox7“ Me.TextBox7.Size = New System.Drawing.Size(100, 23)Me.TextBox7.TabIndex = 16 'TextBox6 Me.TextBox6.Location = New System.Drawing.Point(376, 237)Me.TextBox6.Name = ”TextBox6“ Me.TextBox6.Size = New System.Drawing.Size(100, 23)Me.TextBox6.TabIndex = 15 'TextBox5 Me.TextBox5.Location = New System.Drawing.Point(128, 182)Me.TextBox5.Name = ”TextBox5“ Me.TextBox5.Size = New System.Drawing.Size(100, 23)Me.TextBox5.TabIndex = 14 'TextBox4 Me.TextBox4.Location = New System.Drawing.Point(128, 131)Me.TextBox4.Name = ”TextBox4“ Me.TextBox4.Size = New System.Drawing.Size(100, 23)Me.TextBox4.TabIndex = 13 'TextBox3 ' Me.TextBox3.Location = New System.Drawing.Point(376, 125)Me.TextBox3.Name = ”TextBox3“ Me.TextBox3.Size = New System.Drawing.Size(100, 23)Me.TextBox3.TabIndex = 12 'TextBox2 Me.TextBox2.Location = New System.Drawing.Point(376, 72)Me.TextBox2.Name = ”TextBox2“ Me.TextBox2.Size = New System.Drawing.Size(100, 23)Me.TextBox2.TabIndex = 11'

'TextBox1 Me.TextBox1.Location = New System.Drawing.Point(128, 72)Me.TextBox1.Name = ”TextBox1“ Me.TextBox1.Size = New System.Drawing.Size(100, 23)Me.TextBox1.TabIndex = 10 'Label10' Me.Label10.Location = New System.Drawing.Point(24, 288)Me.Label10.Name = ”Label10“ Me.Label10.Size = New System.Drawing.Size(88, 23)Me.Label10.TabIndex = 9 Me.Label10.Text = ”備注信息“ 'Label9 Me.Label9.Location = New System.Drawing.Point(24, 240)Me.Label9.Name = ”Label9“ Me.Label9.Size = New System.Drawing.Size(100, 23)Me.Label9.TabIndex = 8 Me.Label9.Text = ”頭等艙價格“ 'Label8 Me.Label8.Location = New System.Drawing.Point(270, 237)Me.Label8.Name = ”Label8“ Me.Label8.Size = New System.Drawing.Size(100, 23)Me.Label8.TabIndex = 7 Me.Label8.Text = ”公務艙價格“ 'Label7 Me.Label7.Location = New System.Drawing.Point(270, 185)Me.Label7.Name = ”Label7“ Me.Label7.Size = New System.Drawing.Size(100, 23)Me.Label7.TabIndex = 6 Me.Label7.Text = ”經濟艙價格“ 'Label6 Me.Label6.Location = New System.Drawing.Point(22, 185)Me.Label6.Name = ”Label6“ Me.Label6.Size = New System.Drawing.Size(100, 23)Me.Label6.TabIndex = 5 Me.Label6.Text = ”客機編號“ 'Label5 Me.Label5.Location = New System.Drawing.Point(24, 131)Me.Label5.Name = ”Label5“ Me.Label5.Size = New System.Drawing.Size(100, 23)Me.Label5.TabIndex = 4 Me.Label5.Text = ”出發時間“ 'Label4 Me.Label4.Location = New System.Drawing.Point(270, 128)Me.Label4.Name = ”Label4“ Me.Label4.Size = New System.Drawing.Size(100, 23)Me.Label4.TabIndex = 3 Me.Label4.Text = ”到達時間“ 'Label3' Me.Label3.Location = New System.Drawing.Point(270, 35)Me.Label3.Name = ”Label3“ Me.Label3.Size = New System.Drawing.Size(100, 23)Me.Label3.TabIndex = 2 Me.Label3.Text = ”航班日期“ 'Label2 Me.Label2.Location = New System.Drawing.Point(270, 80)Me.Label2.Name = ”Label2“ Me.Label2.Size = New System.Drawing.Size(100, 23)Me.Label2.TabIndex = 1 Me.Label2.Text = ”到達城市“ 'Label1' Me.Label1.Location = New System.Drawing.Point(24, 77)Me.Label1.Name = ”Label1“ Me.Label1.Size = New System.Drawing.Size(88, 24)Me.Label1.TabIndex = 0 Me.Label1.Text = ”出發城市“'

'Button1 ' Me.Button1.Font = New System.Drawing.Font(”宋體“, 10.5!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(134, Byte))Me.Button1.Location = New System.Drawing.Point(104, 360)Me.Button1.Name = ”Button1“ Me.Button1.Size = New System.Drawing.Size(104, 40)Me.Button1.TabIndex = 1 Me.Button1.Text = ”保存“ 'Button2 Me.Button2.Font = New System.Drawing.Font(”宋體“, 10.5!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(134, Byte))Me.Button2.Location = New System.Drawing.Point(280, 360)Me.Button2.Name = ”Button2“ Me.Button2.Size = New System.Drawing.Size(104, 40)Me.Button2.TabIndex = 2 Me.Button2.Text = ”返回“ '

'航線信息

' Me.AutoScaleBaseSize = New System.Drawing.Size(6, 14)Me.ClientSize = New System.Drawing.Size(504, 414)Me.Controls.Add(Me.Button2)Me.Controls.Add(Me.Button1)Me.Controls.Add(Me.GroupBox1)Me.Icon = CType(resources.GetObject(”$this.Icon“), System.Drawing.Icon)Me.Name = ”航線信息“ Me.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent Me.Text = ”航線信息“ Me.GroupBox1.ResumeLayout(False)Me.GroupBox1.PerformLayout()Me.ResumeLayout(False)End Sub #End Region Private Sub 航線信息_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)Handles MyBase.Load ct = 31 class1.init()TextBox9.Focus()If(mytemp = 0)Then Button1.Text = ”添加“ Else Button1.Text = ”修改“ End If Dim ds As DataSet Dim con As String Dim count, i As Integer con = ”select * from airlineinfo“ ds = class1.query(con)count = ds.Tables(0).Rows.Count For i = 0 To count-2 class1.dr = ds.Tables(0).Rows(i)ComboBox1.Items.Add(Trim(CStr(class1.dr(”航班日期“))))Next End Sub Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)Handles Button1.Click Dim con As String Dim con1 As String Dim ano, dd, dt, at, pno, cp, cap, fp As String Dim dc, ac, am As String Dim signe As Integer = 1 ano = TextBox9.Text dc = TextBox1.Text ac = TextBox2.Text dd = ComboBox1.Text pno = TextBox10.Text dt = TextBox3.Text at = TextBox4.Text cp = TextBox5.Text cap = TextBox6.Text fp = TextBox7.Text am = TextBox8.Text con = ”select * from airlineinfo where 航線編號='“ + TextBox9.Text + ”'“ Dim ds As DataSet Try ds = class1.query(con)Catch ex As Exception MessageBox.Show(ex.Message)End Try Try If(ds.Tables(0).Rows.Count > 0 And mytemp = 0)Then class1.dr = ds.Tables(0).Rows(0)If class1.dr(”航線編號“)> 0 Then MsgBox(”已存在該航線!“)TextBox9.Focus()signe = 0 End If End If Catch ex As Exception MessageBox.Show(ex.Message)End Try If TextBox9.Text = ”“ Then MsgBox(”航線編號不能為空!“)TextBox9.Focus()ElseIf(signe = 1 Or mytemp = 1)Then con1 = ”delete from airlineinfo where 航線編號='“ + TextBox9.Text + ”'“ con = ”insert into airlineinfo values('“ + ano + ”','“ + dc + ”','“ + ac + ”','“ + dd + ”','“ + dt + ”','“ + at + ”','“ + pno + ”','“ + cp + ”','“ + cap + ”','“ + fp + ”','“ + am + ”')“ Try class1.delete(con1)Catch ex As Exception MessageBox.Show(ex.Message)End Try Try class1.update(con)If(mytemp = 0)Then MsgBox(”添加成功!“)End If If(mytemp = 1)Then MsgBox(”修改成功!“)End If Catch ex As Exception MessageBox.Show(ex.Message)End Try TextBox1.Text = ”“ TextBox2.Text = ”“ TextBox3.Text = ”“ TextBox4.Text = ”“ TextBox5.Text = ”“ TextBox6.Text = ”“ TextBox7.Text = ”“ TextBox8.Text = ”“ TextBox9.Text = ”“ ComboBox1.Text = ”“ TextBox10.Text = ”“ End If End Sub Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)Handles Button2.Click Me.Close()End Sub Private Sub GroupBox1_Enter(ByVal sender As System.Object, ByVal e As System.EventArgs)Handles GroupBox1.Enter End Sub End Class 添加用戶代碼:

Public Class 添加用戶

Inherits System.Windows.Forms.Form #Region ” Windows 窗體設計器生成的代碼“ Public Sub New()MyBase.New()'該調用是Windows 窗體設計器所必需的。InitializeComponent()'在InitializeComponent()調用之后添加任何初始化

End Sub '窗體重寫dispose 以清理組件列表。

Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)If disposing Then If Not(components Is Nothing)Then components.Dispose()End If End If MyBase.Dispose(disposing)End Sub

'Windows 窗體設計器所必需的

Private components As System.ComponentModel.IContainer '注意: 以下過程是Windows 窗體設計器所必需的'可以使用Windows 窗體設計器修改此過程。

'不要使用代碼編輯器修改它。

Friend WithEvents Label1 As System.Windows.Forms.Label Friend WithEvents Label2 As System.Windows.Forms.Label Friend WithEvents Label3 As System.Windows.Forms.Label Friend WithEvents Label4 As System.Windows.Forms.Label Friend WithEvents TextBox1 As System.Windows.Forms.TextBox Friend WithEvents TextBox2 As System.Windows.Forms.TextBox Friend WithEvents TextBox3 As System.Windows.Forms.TextBox Friend WithEvents TextBox4 As System.Windows.Forms.TextBox Friend WithEvents Button1 As System.Windows.Forms.Button Friend WithEvents Button2 As System.Windows.Forms.Button Private Sub InitializeComponent()Dim resources As System.ComponentModel.ComponentResourceManager = New System.ComponentModel.ComponentResourceManager(GetType(添加用戶))Me.Label1 = New System.Windows.Forms.Label Me.Label2 = New System.Windows.Forms.Label Me.Label3 = New System.Windows.Forms.Label Me.Label4 = New System.Windows.Forms.Label Me.TextBox1 = New System.Windows.Forms.TextBox Me.TextBox2 = New System.Windows.Forms.TextBox Me.TextBox3 = New System.Windows.Forms.TextBox Me.TextBox4 = New System.Windows.Forms.TextBox Me.Button1 = New System.Windows.Forms.Button Me.Button2 = New System.Windows.Forms.Button Me.SuspendLayout()'Label1' Me.Label1.Font = New System.Drawing.Font(”宋體“, 10.5!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(134, Byte))Me.Label1.Location = New System.Drawing.Point(55, 33)Me.Label1.Name = ”Label1“ Me.Label1.Size = New System.Drawing.Size(100, 23)Me.Label1.TabIndex = 0 Me.Label1.Text = ”用戶名“ '

'Label2 Me.Label2.Font = New System.Drawing.Font(”宋體“, 10.5!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(134, Byte))Me.Label2.Location = New System.Drawing.Point(55, 84)Me.Label2.Name = ”Label2“ Me.Label2.Size = New System.Drawing.Size(100, 23)Me.Label2.TabIndex = 1 Me.Label2.Text = ”姓名“ 'Label3 Me.Label3.Font = New System.Drawing.Font(”宋體“, 10.5!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(134, Byte))Me.Label3.Location = New System.Drawing.Point(55, 121)Me.Label3.Name = ”Label3“ Me.Label3.Size = New System.Drawing.Size(100, 23)Me.Label3.TabIndex = 2 Me.Label3.Text = ”新密碼“ 'Label4 Me.Label4.Font = New System.Drawing.Font(”宋體“, 10.5!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(134, Byte))Me.Label4.Location = New System.Drawing.Point(55, 168)Me.Label4.Name = ”Label4“ Me.Label4.Size = New System.Drawing.Size(100, 23)Me.Label4.TabIndex = 3 Me.Label4.Text = ”確認密碼“ 'TextBox1 Me.TextBox1.Location = New System.Drawing.Point(224, 32)Me.TextBox1.Name = ”TextBox1“ Me.TextBox1.Size = New System.Drawing.Size(100, 21)Me.TextBox1.TabIndex = 4 'TextBox2 Me.TextBox2.Location = New System.Drawing.Point(224, 72)Me.TextBox2.Name = ”TextBox2“ Me.TextBox2.Size = New System.Drawing.Size(100, 21)Me.TextBox2.TabIndex = 5 'TextBox3 Me.TextBox3.Location = New System.Drawing.Point(224, 120)Me.TextBox3.Name = ”TextBox3“ Me.TextBox3.PasswordChar = Global.Microsoft.VisualBasic.ChrW(42)Me.TextBox3.Size = New System.Drawing.Size(100, 21)Me.TextBox3.TabIndex = 6 'TextBox4 Me.TextBox4.Location = New System.Drawing.Point(224, 168)Me.TextBox4.Name = ”TextBox4“ Me.TextBox4.PasswordChar = Global.Microsoft.VisualBasic.ChrW(42)Me.TextBox4.Size = New System.Drawing.Size(100, 21)Me.TextBox4.TabIndex = 7'

'Button1 ' Me.Button1.Font = New System.Drawing.Font(”宋體“, 10.5!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(134, Byte))Me.Button1.Location = New System.Drawing.Point(48, 208)Me.Button1.Name = ”Button1“ Me.Button1.Size = New System.Drawing.Size(88, 40)Me.Button1.TabIndex = 8 Me.Button1.Text = ”確定“ 'Button2 Me.Button2.Font = New System.Drawing.Font(”宋體“, 10.5!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(134, Byte))Me.Button2.Location = New System.Drawing.Point(240, 208)Me.Button2.Name = ”Button2“ Me.Button2.Size = New System.Drawing.Size(88, 40)Me.Button2.TabIndex = 9 Me.Button2.Text = ”取消“ '添加用戶 ' Me.AutoScaleBaseSize = New System.Drawing.Size(6, 14)Me.ClientSize = New System.Drawing.Size(392, 270)Me.Controls.Add(Me.Button2)Me.Controls.Add(Me.Button1)Me.Controls.Add(Me.TextBox4)Me.Controls.Add(Me.TextBox3)Me.Controls.Add(Me.TextBox2)Me.Controls.Add(Me.TextBox1)Me.Controls.Add(Me.Label4)Me.Controls.Add(Me.Label3)Me.Controls.Add(Me.Label2)Me.Controls.Add(Me.Label1)Me.Icon = CType(resources.GetObject(”$this.Icon“), System.Drawing.Icon)Me.Name = ”添加用戶“ Me.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent Me.Text = ”添加用戶“ Me.ResumeLayout(False)Me.PerformLayout()End Sub #End Region Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)Handles Button1.Click class1.init()Dim con As String Dim user, name As String Dim pw1, pw2 As String Dim ds As DataSet Dim signe As Integer = 1 user = TextBox1.Text name = TextBox2.Text pw1 = TextBox3.Text pw2 = TextBox4.Text con = ”select * from users where id='“ + TextBox1.Text + ”'“ ds = class1.query(con)Try If(ds.Tables(0).Rows.Count > 0)Then class1.dr = ds.Tables(0).Rows(0)If class1.dr(”id“)<> ”“ Then MsgBox(”已存在用戶!“)TextBox1.SelectAll()TextBox1.Focus()TextBox2.Clear()TextBox3.Clear()TextBox4.Clear()signe = 0 End If End If Catch ex As Exception MessageBox.Show(ex.Message)End Try If(TextBox3.Text <> TextBox4.Text)Then MessageBox.Show(”密碼不一致,請重新確認“, ”提示“)TextBox3.SelectAll()TextBox3.Focus()TextBox4.Clear()signe = 0 End If If Trim(TextBox1.Text)= ”“ Then MsgBox(”用戶名不能為空!“)Exit Sub TextBox1.Focus()ElseIf(signe = 1)Then con = ”insert into users values('“ + user + ”','“ + pw2 + ”','“ + name + ”','null')“ class1.insert(con)MsgBox(”添加成功!")End If End Sub Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)Handles Button2.Click Me.Close()End Sub Private Sub 添加用戶_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)Handles MyBase.Load ct = 0 End Sub

End Class

第四篇:航空售票系統數據庫分析表

flight

1.用戶表:user

用戶編號:userid int 自動增長 主鍵 用戶名 username varchar(20)密碼

password varchar(20)類型

usertype varchar(10)登錄時間 logintime datetime 2.航空公司表 company

公司編號 companyid int 自動增長 主鍵 航空公司名稱 companyname varchar(50)3.機場表 airport

機場編號:airportid int 自動增長 主鍵 機場代碼:airportcode varchar(20)機場名稱:airportname varchar(50)4.航班信息表 flight

航班編號:flightid nt 自動增長 主鍵 航班代號:flightcode varchar(20)所屬航空公司:company int 日期:flightdate datetime 起飛時間:flytime datetime 到達時間:landtime datetime 起飛機場:flyairport int 到達機場:landairport int 頭等艙價格:firstprice money 公務艙價格:secondprice money 經濟艙價格:thirdprice money 機型:planetype varchar(20)

第五篇:航空售票系統+C++課程設計源代碼

#include #include #define M 5//每種飛機票的總數目 #define N 3//飛機票的總數目 class Plane {private: char name[40];//終點站名

int number;//航班號

int Number;//飛機號

int week;//星期幾飛行

int day;//日期

int left;//余票額

int n;//與數組flag一起確定客戶訂票狀態 public:

int flag[20];//訂票狀態數組,-1為預訂票,1為已定票,0為初始化狀態

Plane()//構造函數

{

name[0]='

主站蜘蛛池模板: 妇女bbbb插插插视频| 国产精品午夜福利视频234区| 国产亚洲综合一区二区三区| 亚洲日韩乱码中文无码蜜桃臀网站| 国产传媒麻豆剧精品av国产| 免费看成人啪啪| 欧美日韩精品一区二区性色a+v| 人妻少妇88久久中文字幕| 粗壮挺进人妻水蜜桃成熟漫画| 永久免费无码av在线网站| 大雞巴亂倫有声小说| 国产成人无码精品久久久露脸| 欧美成人精品一区二区综合| 无码中文字幕色专区| 国产麻豆一精品一av一免费| 一本一道波多野结衣一区| 免费永久看黄在线观看| 亚洲av不卡无码国产| 免费国产在线精品一区二区三区| 国产精品久久久久久tv| 国产内射爽爽大片| 久久在精品线影院精品国产| 精品毛片乱码1区2区3区| 欧美日韩精品一区二区在线播放| 成人小说亚洲一区二区三区| 日韩在线一区二区不卡视频| 18禁止午夜福利体验区| 国产网曝门亚洲综合在线| 亚洲欭美日韩颜射在线| 国产美女精品视频线免费播放软件| 久久久久久a亚洲欧洲av| 香蕉久久精品日日躁夜夜躁夏| 欧美成人看片一区二三区图文| 无码免费午夜福利看片| 99精品久久99久久久久| 日韩av无码中文无码电影| 极品粉嫩嫩模大尺度无码视频| 国产精品女视频一区二区| 亚洲熟女av综合网五月| 无码熟熟妇丰满人妻啪啪| 久久精品国产99久久6|