計(jì)算機(jī)學(xué)院《面向?qū)ο蟪绦蛟O(shè)計(jì)》課程設(shè)計(jì)報(bào)告學(xué)號(hào)xxxxxx《面向?qū)ο蟪绦蛟O(shè)計(jì)》課程設(shè)計(jì)報(bào)告題目：xx專業(yè)：xx班級(jí)：x姓名：xx指導(dǎo)教師：x成績(jī)：xxxx年x月x日目錄TOC\o"1-3"\h\u171961設(shè)計(jì)內(nèi)容及要求 ④user（用戶信息表）（2）數(shù)據(jù)庫(kù)設(shè)計(jì)說(shuō)明 destine(訂票人信息表)在該信息表中包含以下字段：destine_id(訂票人身份證號(hào)碼)、flight_no(航班號(hào))、destine_count(訂票數(shù)量)、destine_date(定票日期)、destine_status(訂票狀態(tài))、destine_id(訂票人身份證號(hào)碼)、destine_phone(訂票人聯(lián)系電話)、destine_address(訂票人地址)、destine_sex(訂票人性別)、destine_age(訂票人年齡)等字段。flight(航班信息表)在該信息表中包含以下字段：flight_no(航班號(hào))、begin_from(起飛地點(diǎn))、end_address(降落地點(diǎn))、begin_time(起飛時(shí)間)、end_time(降落時(shí)間)ticket_price(機(jī)票價(jià)格)等字段。（3）數(shù)據(jù)庫(kù)ER圖圖SEQ圖\*ARABIC8數(shù)據(jù)庫(kù)ER圖4.5程序系統(tǒng)的組織結(jié)構(gòu)（1）系統(tǒng)組織結(jié)構(gòu)圖服務(wù)器端的組織結(jié)構(gòu)圖航空訂票管理系統(tǒng)航空訂票管理系統(tǒng)管理員身份驗(yàn)證超級(jí)管理員一般管理員查詢所有信息數(shù)據(jù)輸入查尋內(nèi)容輸出數(shù)據(jù)航班信息管理訂票人信息管理添加數(shù)據(jù)查詢數(shù)據(jù)刪除數(shù)據(jù)修改數(shù)據(jù)添加數(shù)據(jù)刪除數(shù)據(jù)修改數(shù)據(jù)查詢數(shù)據(jù)輸入新航班數(shù)據(jù)保存航班數(shù)據(jù)刪除航班數(shù)據(jù)刷新數(shù)據(jù)刷新輸出數(shù)據(jù)修改航班數(shù)據(jù)更新航班數(shù)據(jù)刷新航班數(shù)據(jù)輸入查詢數(shù)據(jù)輸出數(shù)據(jù)輸入訂票人數(shù)據(jù)保存訂票人數(shù)據(jù)刪除訂票人數(shù)據(jù)刷新數(shù)據(jù)刷新輸出數(shù)據(jù)修改訂票人數(shù)據(jù)更新訂票人數(shù)據(jù)刷新航班數(shù)據(jù)輸入查詢數(shù)據(jù)輸出數(shù)據(jù)系統(tǒng)層次結(jié)構(gòu)圖（服務(wù)器）端）圖SEQ圖\*ARABIC9系統(tǒng)層次結(jié)構(gòu)圖6系統(tǒng)運(yùn)行效果與操作圖SEQ圖\*ARABIC10主操作界面代碼如下：packageflight;importjava.awt.GridLayout;importjavax.swing.*;importjava.awt.event.*;publicclassRegisterextendsJFrameimplementsActionListener{JTextFielduser;JPasswordFieldpsw1,psw2;JLabela,b,c;JButtonok,no;publicRegister(){a=newJLabel("訂票"); a.setBounds(70,70,60,25); b=newJLabel("管理"); b.setBounds(77,130,60,25);c=newJLabel("退出");c.setBounds(60,190,60,25); user=newJTextField(20); user.setBounds(130,70,180,25); psw1=newJPasswordField(20); psw1.setBounds(130,130,180,25);psw2=newJPasswordField(20); psw2.setBounds(130,190,180,25);add(a); add(user); add(b); add(psw1);add(c);add(psw2);setLayout(null); setBounds(100,200,500,350);setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); setResizable(false); setVisible(true);}publicvoidactionPerformed(ActionEvente){Stringa,b,c;if(e.getSource()==ok){a=user.getText();b=psw1.getText();c=psw2.getText();dispose();//關(guān)閉窗口System.exit(0);//退出程序}}圖SEQ圖\*ARABIC11用戶登錄界面代碼如下：publicclassAdminLoginextendsJFrameimplementsActionListener{databasedatalink;JTextFieldinput1;JPasswordFieldinput2;JLabelprompt1;JLabelprompt2;JButtonok;publicAdminLogin(){ super("管理員登陸"); setSize(400,100); Dimensionsize=Toolkit.getDefaultToolkit().getScreenSize();setLocation((size.width-getWidth())/2,(size.height-getHeight())/2); setLayout(newFlowLayout()); prompt1=newJLabel("賬號(hào):"); prompt2=newJLabel(" 密碼:"); input1=newJTextField(8); input2=newJPasswordField(8); ok=newJButton("確定"); ok.setSize(50,100);ok.addActionListener(this); add(prompt1); add(input1); add(prompt2); add(input2); add(ok); datalink=newdatabase(); setVisible(true);}publicvoidactionPerformed(ActionEvente){if(e.getSource()==ok){if(input1.getText().length()==0||input2.getText().length()==0){ JOptionPane.showMessageDialog(this,"請(qǐng)輸入用戶名或密碼！","提示錯(cuò)誤",JOptionPane.ERROR_MESSAGE); }else{try{booleanb=true;Connectioncon=datalink.getCon();Statementstm=datalink.getStm();ResultSetrs=stm.executeQuery("SELECT*FROMadmin_info");if(rootPaneCheckingEnabled){while(rs.next()){Stringus=input1.getText();Stringps=input2.getText();if(us.equals(rs.getString("admtor"))&&ps.equals(rs.getString("admpsw"))){newManager();this.dispose();b=false;}InetAddressaddress=InetAddress.getLocalHost();StringIP_name=address.getHostAddress();CalendarE=Calendar.getInstance();intyear=E.get(Calendar.YEAR);intmonth=E.get(Calendar.MONTH)+1;intday=E.get(Calendar.DAY_OF_MONTH);inthour=E.get(Calendar.HOUR_OF_DAY);FileWriterout;out=newFileWriter("D:\\Adminfile.txt");out=newFileWriter("D:\\Adminfile.txt");out.write("登陸用戶："+input1.getText()+"密碼："+ps+"登陸時(shí)間"+year+"-"+month+"-"+day+""+hour+"IP:"+IP_name);out.close();}if(b){JOptionPane.showMessageDialog(this,"請(qǐng)輸入正確的用戶名或密碼！","提示錯(cuò)誤",JOptionPane.ERROR_MESSAGE); }//con.close();}}catch(IOExceptionex){Logger.getLogger(Login.class.getName()).log(Level.SEVERE,null,ex);}catch(SQLExceptionex){Logger.getLogger(AdminLogin.class.getName()).log(Level.SEVERE,null,ex);}}}}publicstaticvoidmain(String[]args){newAdminLogin();}}圖SEQ圖\*ARABIC12按班次查詢航班圖SEQ圖\*ARABIC13按終始站查詢圖12和圖13代碼如下：publicclassFTableextendsAbstractTableModel{privateObject[][]data;privateString[]head={"航班號(hào)","航班公司","始發(fā)站","終點(diǎn)站","最大乘客數(shù)","現(xiàn)有乘客數(shù)","起飛時(shí)間","普通艙","商務(wù)艙"};publicFTable(List<ticktInfo>list){data=newObject[list.size()][];for(inti=0;i<list.size();i++){ticktInfof=list.get(i);data[i]=newObject[]{f.getFlightID(),f.getCompany(),f.getSstation(),f.getEstation(),getStartTime(),f.getMax(),f.getCurrent(),f.getPutongcang(),f.getShangwucang()};}}publicintgetColumnCount(){returnhead.length;}publicintgetRowCount(){returndata.length;}publicStringgetColumnName(intcol){returnhead[col];}publicObjectgetValueAt(introw,intcol){returndata[row][col];}publicClassgetColumnClass(intc){returngetValueAt(0,c).getClass();}}圖SEQ圖\*ARABIC14添加航班代碼如下：publicclassAddFextendsJFrameimplementsActionListener{String[]title={"航班號(hào)","航班公司","起飛地點(diǎn)","到達(dá)地點(diǎn)","起飛時(shí)間","最大乘客數(shù)","現(xiàn)有乘客數(shù)","普通艙","商務(wù)艙"};JTextFieldtxt1=newJTextField(20);JTextFieldtxt2=newJTextField(20);JTextFieldtxt3=newJTextField(20);JTextFieldtxt4=newJTextField(20);JTextFieldtxt5=newJTextField(20);JTextFieldtxt6=newJTextField(10);JTextFieldtxt7=newJTextField(10);JTextFieldtxt8=newJTextField(10);JTextFieldtxt9=newJTextField(10);JButtonOK=newJButton("保存");JButtonCancel=newJButton("取消");ticktInfoflight;ArrayListplst=null;booleansuccess;publicAddF(){Dimensionsize=Toolkit.getDefaultToolkit().getScreenSize();setLocation((size.width-getWidth())/3,(size.height-getHeight())/3);Containercon=getContentPane();con.setLayout(newGridLayout(9,1));JPanelp[]=newJPanel[9];for(inti=0;i<9;i++){p[i]=newJPanel(newFlowLayout(FlowLayout.LEFT));p[i].add(newJLabel(title[i]+":"));}p[0].add(txt1);p[1].add(txt2);p[2].add(txt3);p[3].add(txt4);p[4].add(txt5);p[5].add(txt6);p[6].add(txt7);p[7].add(txt8);p[8].add(txt9);for(inti=0;i<9;i++){con.add(p[i]);}JPanelbottom=newJPanel();bottom.add(OK);bottom.add(Cancel);con.add(bottom);OK.addActionListener(this);Cancel.addActionListener(this);setTitle("航班信息添加窗口");setSize(800,500);setVisible(true);}publicvoidactionPerformed(ActionEvente){if(e.getSource()==OK){Stringa=txt1.getText();Stringb=txt2.getText();Stringc=txt3.getText();Stringd=txt4.getText();Stringe1=txt5.getText();Stringf=txt6.getText();Stringg=txt7.getText();Stringh=txt8.getText();Stringj=txt9.getText();Solution.AddFlight(a,b,c,d,e1,f,g,h,j);dispose();}elseif(e.getSource()==Cancel){dispose();}}publicstaticvoidmain(String[]args){newAddF();}}圖SEQ圖\*ARABIC15刪除航班代碼如下：publicclassDeletFextendsJFrameimplementsActionListener{String[]title={"航班號(hào)","航班公司","起飛地點(diǎn)","到達(dá)地點(diǎn)","起飛時(shí)間","最大乘客數(shù)","現(xiàn)有乘客數(shù)","普通艙","商務(wù)艙"};JTextFieldtxt1=newJTextField(20);JTextFieldtxt2=newJTextField(20);JTextFieldtxt3=newJTextField(20);JTextFieldtxt4=newJTextField(20);JTextFieldtxt5=newJTextField(20);JTextFieldtxt6=newJTextField(10);JTextFieldtxt7=newJTextField(10);JTextFieldtxt8=newJTextField(10);JTextFieldtxt9=newJTextField(10);JButtonOK=newJButton("保存");JButtonCancel=newJButton("取消");ticktInfoflight;ArrayListplst=null;booleansuccess;publicAddF(){Dimensionsize=Toolkit.getDefaultToolkit().getScreenSize();setLocation((size.width-getWidth());Containercon=getContentPane();con.setLayout(newGridLayout(9,1));JPanelp[]=newJPanel[9];for(inti=0;i<9;i++){p[i]=newJPanel(newFlowLayout(FlowLayout.LEFT));p[i].delete(newJLabel(title[i]+":"));}p[0].delete(txt1);p[1].delete(txt2);p[2].delete(txt3);p[3].delete(txt4);p[4].delelte(txt5);p[5].delete(txt6);for(inti=0;i<6;i++){con.add(p[i]);}JPanelbottom=newJPanel();bottom.delete(OK);bottom.delete(Cancel);con.delete(bottom);OK.deleteActionListener(this);Cancel.deleteActionListener(this);setTitle("航班信息刪除窗口:”);setVisible(true);setSize(800,500);}publicvoidactionPerformed(ActionEvente){if(e.getSource()==OK){Stringa=txt1.getText();Stringb=txt2.getText();Stringc=txt3.getText();Stringd=txt4.getText();Stringe1=txt5.getText();Stringf=txt6.getText();Stringg=txt7.getText();Stringh=txt8.getText();Stringj=txt9.getText();Solution.AddFlight(a,b,c,d,e1,f,g,h,j);dispose();}elseif(e.getSource()==Cancel){dispose();}}publicstaticvoidmain(String[]args){ newdeleteF();}}圖SEQ圖\*ARABIC16乘客購(gòu)票信息圖SEQ圖\*ARABIC17購(gòu)票成功代碼如下：classClientInfoextendsJFrameimplementsActionListener{Stringtitle[]={"航班號(hào)","起點(diǎn)","終點(diǎn)","起飛日期","姓名","身份證","聯(lián)系電話","郵箱","座位號(hào)","購(gòu)買(mǎi)票數(shù)"};JTextFieldtxtFid=newJTextField(10);JTextFieldtxtStart=newJTextField(10);JTextFieldtxtEnd=newJTextField(10);JTextFieldtxtTime=newJTextField(10);JTextFieldtxtName=newJTextField(10);JTextFieldtxtID=newJTextField(20);JTextFieldtxtTelNum=newJTextField(20);JTextFieldtxtEmail=newJTextField(20);JTextFieldtxtSeatNum=newJTextField(10);JTextFieldtxtCount=newJTextField(10);JButtonbtnOK=newJButton("確定");JButtonbtnCancel=newJButton("取消");publicClientInfo(){Containercon=getContentPane();con.setLayout(newGridLayout(11,1));JPanelp[]=newJPanel[10];for(inti=0;i<10;i++){p[i]=newJPanel(newFlowLayout(FlowLayout.LEFT));p[i].add(newJLabel(title[i]+":"));}p[0].add(txtFid);p[1].add(txtStart);p[2].add(txtEnd);p[3].add(txtTime);p[4].add(txtName);p[5].add(txtID);p[6].add(txtTelNum);p[7].add(txtEmail);p[8].add(txtSeatNum);p[9].add(txtCount);for(inti=0;i<10;i++){con.add(p[i]);}JPanelbottom=newJPanel();bottom.add(btnOK);bottom.add(btnCancel);con.add(bottom);btnOK.addActionListener(this);btnCancel.addActionListener(this);Dimensionsize=Toolkit.getDefaultToolkit().getScreenSize();setLocation((size.width-getWidth());setTitle("乘客訂票信息填寫(xiě)窗口");setSize(450,600);setVisible(true);}publicvoidactionPerformed(ActionEvente){if(e.getSource()==btnOK){try{Stringa=txtName.getText();Stringb=txtID.getText();Stringc=txtTelNum.getText();Stringd=txtEmail.getText();Stringe1=txtSeatNum.getText();Stringf=txtFid.getText();Stringg=txtStart.getText();Stringh=txtEnd.getText();Stringi=txtTime.getText();Solution.AddClientInfo(a,b,c,d,e1,f,g,h,i);databaselink=newdatabase();Connectioncon=link.getCon();Statementstm=link.getStm();Stringsql="selectmax,currentfromflight_infowhereflightID="+"'"+txtFid.getText().trim()+"'"+"";try{intmax=0,cur=0;intudrem=0; ResultSetrs=stm.executeQuery(sql); Strings1=txtFid.getText().trim(); intct=Integer.parseInt(txtCount.getText().trim());while(rs.next()){max=rs.getInt("max");cur=rs.getInt("current");}if(cur>0){if(cur-ct>0){udrem=cur-ct;Stringstr1="updateflight_infosetmax="+"'"+max+"'"+",current="+"'"+udrem+"'"+"whereflightID="+"'"+s1+"'"+"";stm.executeUpdate(str1);JOptionPane.showConfirmDialog(this,"訂票成功","購(gòu)票提示",JOptionPane.YES_NO_OPTION);dispose();}else{udrem=cur-ct;JOptionPane.showConfirmDialog(this,"剩余票數(shù)為："+String.valueOf(udrem)+"張","購(gòu)票提示",JOptionPane.YES_NO_OPTION);}}else{JOptionPane.showConfirmDialog(this,"票已售完","提示錯(cuò)誤",JOptionPane.YES_NO_OPTION);}con.close();dispose();}catch(Exceptionex){JOptionPane.showConfirmDialog(this,"訂票失敗","購(gòu)票提示",JOptionPane.YES_NO_OPTION);}}catch(Exceptionex){}}elseif(e.getSource()==btnCancel){dispose();}}publicstaticvoidmain(String[]args){newClientInfo();}}圖SEQ圖\*ARABIC18退出系統(tǒng)代碼如下：publicclassLoginextendsJFrameimplementsActionListener{JTextFielduser;JPasswordFieldpsw;JLabela,b;publicLogin(Strings){ super(s); cno.addActionListener(this); cno.setBounds(230,180,60,30); add(a); add(user); add(b); add(psw); add(cfg); add(cno); setLayout(null); setBounds(200,200,430,280); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); setResizable(false); setVisible(true); }publicvoidactionPerformed(ActionEvente){ if(e.getSource()==cno) { newRegister();this.dispose(); } }publicstaticvoidmain(Stringargs[]){ newLogin("用戶退出");}參考文獻(xiàn)：[1]《信息系統(tǒng)分析與設(shè)計(jì)》，陳禹主編，楊善林梁昌勇左美云副主編高等教育出版社，2005.[2]《信息系統(tǒng)開(kāi)發(fā)方法教程》，陳佳主編，清華大學(xué)出版社，1999.[3]《信息系統(tǒng)設(shè)計(jì)原理與應(yīng)用》，劉魯，北京航空航天大學(xué)出版社，1995.[4]《企業(yè)管理信息系統(tǒng)開(kāi)發(fā)的理論和方法》，葛世倫，代逸生，清華出版社，1996年（中文著作）.[5]《java案例開(kāi)發(fā)集錦（第二版）》，袁然，鄭自國(guó)，來(lái)為國(guó)，電子工業(yè)出版社，2008年[6]閆建紅.基于UML的機(jī)票預(yù)定系統(tǒng)的開(kāi)發(fā)研究[J].太原師范學(xué)院學(xué)報(bào)(自然科學(xué)版),2005,(03).基于C8051F單片機(jī)直流電動(dòng)機(jī)反饋控制系統(tǒng)的設(shè)計(jì)與研究基于單片機(jī)的嵌入式Web服務(wù)器的研究MOTOROLA單片機(jī)MC68HC（8）05PV8/A內(nèi)嵌EEPROM的工藝和制程方法及對(duì)良率的影響研究基于模糊控制的電阻釬焊單片機(jī)溫度控制系統(tǒng)的研制基于MCS-51系列單片機(jī)的通用控制模塊的研究基于單片機(jī)實(shí)現(xiàn)的供暖系統(tǒng)最佳啟停自校正（STR）調(diào)節(jié)器單片機(jī)控制的二級(jí)倒立擺系統(tǒng)的研究基于增強(qiáng)型51系列單片機(jī)的TCP/IP協(xié)議棧的實(shí)現(xiàn)基于單片機(jī)的蓄電池自動(dòng)監(jiān)測(cè)系統(tǒng)基于32位嵌入式單片機(jī)系統(tǒng)的圖像采集與處理技術(shù)的研究基于單片機(jī)的作物營(yíng)養(yǎng)診斷專家系統(tǒng)的研究基于單片機(jī)的交流伺服電機(jī)運(yùn)動(dòng)控制系統(tǒng)研究與開(kāi)發(fā)基于單片機(jī)的泵管內(nèi)壁硬度測(cè)試儀的研制基于單片機(jī)的自動(dòng)找平控制系統(tǒng)研究基于C8051F040單片機(jī)的嵌入式系統(tǒng)開(kāi)發(fā)基于單片機(jī)的液壓動(dòng)力系統(tǒng)狀態(tài)監(jiān)測(cè)儀開(kāi)發(fā)模糊Smith智能控制方法的研究及其單片機(jī)實(shí)現(xiàn)一種基于單片機(jī)的軸快流CO〈,2〉激光器的手持控制面板的研制基于雙單片機(jī)沖床數(shù)控系統(tǒng)的研究基于CYGNAL單片機(jī)的在線間歇式濁度儀的研制基于單片機(jī)的噴油泵試驗(yàn)臺(tái)控制器的研制基于單片機(jī)的軟起動(dòng)器的研究和設(shè)計(jì)基于單片機(jī)控制的高速快走絲電火花線切割機(jī)床短循環(huán)走絲方式研究基于單片機(jī)的機(jī)電產(chǎn)品控制系統(tǒng)開(kāi)發(fā)基于PIC單片機(jī)的智能手機(jī)充電器基于單片機(jī)的實(shí)時(shí)內(nèi)核設(shè)計(jì)及其應(yīng)用研究基于單片機(jī)的遠(yuǎn)程抄表系統(tǒng)的設(shè)計(jì)與研究基于單片機(jī)的煙氣二氧化硫濃度檢測(cè)儀的研制基于微型光譜儀的單片機(jī)系統(tǒng)單片機(jī)系統(tǒng)軟件構(gòu)件開(kāi)發(fā)的技術(shù)研究基于單片機(jī)的液體點(diǎn)滴速度自動(dòng)檢測(cè)儀的研制基于單片機(jī)系統(tǒng)的多功能溫度測(cè)量?jī)x的研制基于PIC單片機(jī)的電能采集終端的設(shè)計(jì)和應(yīng)用基于單片機(jī)的光纖光柵解調(diào)儀的研制氣壓式線性摩擦焊機(jī)單片機(jī)控制系統(tǒng)的研制基于單片機(jī)的數(shù)字磁通門(mén)傳感器基于單片機(jī)的旋轉(zhuǎn)變壓器-數(shù)字轉(zhuǎn)換器的研究基于單片機(jī)的光纖Bragg光柵解調(diào)系統(tǒng)的研究單片機(jī)控制的便攜式多功能乳腺治療儀的研制基于C8051F020單片機(jī)的多生理信號(hào)檢測(cè)儀基于單片機(jī)的電機(jī)運(yùn)動(dòng)控制系統(tǒng)設(shè)計(jì)Pico專用單片機(jī)核的可測(cè)性設(shè)計(jì)研究基于MCS-51單片機(jī)的熱量計(jì)基于雙單片機(jī)的智能遙測(cè)微型氣象站MCS-51單片機(jī)構(gòu)建機(jī)器人的實(shí)踐研究基于單片機(jī)的輪軌力檢測(cè)基于單片機(jī)的GPS定位儀的研究與實(shí)現(xiàn)基于單片機(jī)的電液伺服控制系統(tǒng)用于單片機(jī)