酒店管理系統(tǒng)4

1、自選題目設(shè)計(jì)一:酒店管理系統(tǒng)程序代碼.數(shù)據(jù)庫(kù)的實(shí)現(xiàn)創(chuàng)建系統(tǒng)用戶表格RoomtypecreatedatabasehotelgousehotelgoCREATETABLERoomtype(TypeidVarchar(10)primarykey,TypenameVarchar(16),BednumSMALLINT,PriceINT,)insertintoRoomtypevalues(LX0001,標(biāo)準(zhǔn)單人問(wèn),1,100)insertintoRoomtypevalues(LX0002,標(biāo)準(zhǔn)雙人問(wèn),2,160)insertintoRoomtypevalues(LX0003,豪華單人問(wèn),1,200)ins

2、ertintoRoomtypevalues(LX0004,豪華雙人問(wèn),2,360)insertintoRoomtypevalues(LX0005,商務(wù)套房,1,1000)insertintoRoomtypevalues(LX0006,總統(tǒng)套房,2,2000)創(chuàng)建客房信息表格RoomsCREATETABLERooms(RoomNOVarchar(10)primarykey,TypeidVarchar(10)NOTNULL,RoompositionVarchar(5)NULL,PutupVarchar(5)NOTNULL，F(xiàn)OREIGNKEY(Typeid)REFERENCESRoomtype(T

3、ypeid).登錄功能實(shí)現(xiàn)該模塊只要是為了方便酒店管理員的操作，界面友好，簡(jiǎn)單易操作。需要有一定的美觀性和可操作性。同時(shí)為了保證安全性，我們?cè)O(shè)定了權(quán)限功能，管理員可以使用全部功能，而普通用戶不能使用系統(tǒng)管理功能，所以普通用戶不能增減客房信息，同時(shí)，也不能增減系統(tǒng)的用戶。圖4主界面主代碼如下packageUI;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;importjava.util.*;importUI.*;publicclassmainFrameextendsJFrameprivateJButtonbt1,bt2,bt3,

4、bt4,bt5;privateJTextFieldtf1,tf2;privateintwholepart;publicmainFrame()super（金翎酒店歡迎您?。?JPanelpanelMain,panelCent,panelNort,panelBottom;panelMain=newJPanel(newBorderLayout();panelNort=buildNorth();panelCent=buildDTM();panelMain.add(panelNort,BorderLayout.NORTH);panelMain.add(panelCent);setContentPane(

5、panelMain);setSize(780,620);setVisible(true);privateJPanelbuildNorth()JPanelpanelNort1=newJPanel();Iconbug1=newImageIcon(pic/m01.gif);Iconbug2=newImageIcon(pic/m04.gif);Iconbug3=newImageIcon(pic/m05.gif);Iconbug4=newImageIcon(pic/m06.gif);Iconbug5=newImageIcon(pic/m07.gif);bt1=newJButton(客戶預(yù)定,bug3);

6、bt2=newJButton(入住登記,bug2);bt3=newJButton(客戶結(jié)賬,bug1);bt4=newJButton(營(yíng)業(yè)查詢,bug4);bt5=newJButton(系統(tǒng)管理,bug5);panelNort1.add(bt1);panelNort1.add(bt2);panelNort1.add(bt3);panelNort1.add(bt4);panelNort1.add(bt5);Buttonhandlerhandler=newButtonhandler();bt1.addActionListener(handler);bt2.addActionListener(han

7、dler);bt3.addActionListener(handler);bt4.addActionListener(handler);bt5.addActionListener(handler);returnpanelNort1;privateJPanelbuildDTM()JPanelpanelCent1=newJPanel(newBorderLayout();tf1=newJTextField(20);tf1.setForeground(Color.yellow);tf1.setBackground(Color.red);tfl.setText(金翎酒店歡迎您！)；tf1.setFont

8、(newFont(t皆體,Font.BOLD,20);tf1.setHorizontalAlignment(JTextField.CENTER);tf1.setBorder(newLineBorder(newColor(87,87,47);tf1.setEditable(false);panelCent1.add(North,tf1);JPanelpanelBottom1=newJPanel(newBorderLayout();finalImageIconimageIcon=newImageIcon(pic/jiudian.jpg);JPanelp=newJPanel()/獲取圖片Imagei

9、mage=imageIcon.getImage();publicvoidpaint(Graphicsg)/繪制圖片g.drawImage(image,0,0,this.getWidth(),this.getHeight(),this);JScrollPanescrollPane=newJScrollPane(p);panelBottom1.add(panelCent1,BorderLayout.NORTH);panelBottom1.add(scrollPane,BorderLayout.CENTER);returnpanelBottom1;publicvoidsetwholepart(int

10、a)wholepart=a;privateclassButtonhandlerimplementsActionListenerpublicvoidactionPerformed(ActionEventevent)Objecto=event.getSource();if(o=bt1)newEngage();/客戶預(yù)定elseif(o=bt2)newCustomer();/入住登記elseif(o=bt3)newaccount();/客戶結(jié)賬elseif(o=bt4)newquarryBussiness();營(yíng)業(yè)查詢elseif(o=bt5)if(wholepart=0)JOptionPane.s

11、howMessageDialog(null,金翎酒店提示您n非管理員無(wú)此權(quán)限！);elsenewsystemManager();/系統(tǒng)管理publicstaticvoidmain(Stringargs)mainFrameapplication=newmainFrame();application.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);一一.預(yù)定功能實(shí)現(xiàn)此模塊主要實(shí)現(xiàn)客戶的預(yù)定功能，包括查詢、增加、刪除預(yù)訂信息，并能查詢剩余的客房，以便于實(shí)現(xiàn)預(yù)定功能。因金翎酒店需尸預(yù)訂口雷空噌加.刪除查詢預(yù)定信息查遍客房信息圖8客戶預(yù)定主界面主代碼：pac

12、kageUI;importjavax.swing.*;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;importjava.util.*;importUI.*;publicclassEngageextendsJFrameprivateJButtonbt1,bt2,bt3,bt4;privateJTextFieldtf1;publicEngage()super(金翎酒店客戶預(yù)訂);JPanelpanelMain,panelCent,panelNort;panelMain=newJPanel(newBorderLayout();pa

13、nelNort=buildNorth();panelCent=buildDTM();panelMain.add(North,panelNort);panelMain.add(panelCent);setContentPane(panelMain);setSize(500,130);setResizable(false);/不允許改變窗口大小setVisible(true);privateJPanelbuildNorth()JPanelpanelCent1=newJPanel(newBorderLayout();tf1=newJTextField(賓客預(yù)定信息)tf1.setFont(newFo

14、nt(t皆體,Font.BOLD,15);tf1.setHorizontalAlignment(JTextField.CENTER);tf1.setForeground(Color.yellow);tf1.setBackground(Color.red);tf1.setBorder(newLineBorder(newColor(87,87,47);tf1.setEditable(false);panelCent1.add(North,tf1);panelCent1.setBorder(BorderFactory.createTitledBorder();returnpanelCent1;pri

15、vateJPanelbuildDTM()JPanelpanelNort1=newJPanel();Iconbug1=newImageIcon(pic/new.gif);Iconbug2=newImageIcon(pic/del.gif);Iconbug3=newImageIcon(pic/find.gif);bt1=newJButton(增加,bug1);bt3=newJButton(刪除,bug2);bt2=newJButton(查詢預(yù)定信息,bug3);bt4=newJButton(查詢客房信息,bug3);panelNort1.add(bt1);panelNort1.add(bt3);p

16、anelNort1.add(bt2);panelNort1.add(bt4);Buttonhandlerhandler=newButtonhandler();bt1.addActionListener(handler);bt2.addActionListener(handler);bt3.addActionListener(handler);bt4.addActionListener(handler);returnpanelNort1;privateclassButtonhandlerimplementsActionListenerpublicvoidactionPerformed(Actio

17、nEventevent)Objecto=event.getSource();if(o=bt1)addEngageadd=newaddEngage();elseif(o=bt3)deleteEngagedelete=newdeleteEngage();elseif(o=bt2)quaryEngagequary=newquaryEngage();elseif(o=bt4)quaryLeftquary=newquaryLeft();publicstaticvoidmain(Stringargs)Engageapplication=newEngage();application.setDefaultC

18、loseOperation(JFrame.EXIT_ON_CLOSE);一一增加預(yù)定信息圖9增加客戶預(yù)訂信息主代碼如下：/addEngage.javapackageUI;importjava.awt.event.*;importjava.sql.*;importjava.util.*;importjavax.swing.*;importUI.HotelUI;importUI.ConnectionSql;classaddEngageextendsJFrameprivateHotelUIuserInterface;privateJButtonclearButton,writeButton;Stri

19、ngsqlString;Stringnames=訂房編號(hào),姓名,身份證號(hào),客房編號(hào),聯(lián)系電話,入住時(shí)間;publicaddEngage()super(客房預(yù)訂);userInterface=newHotelUI(names);getContentPane().add(userInterface,BorderLayout.CENTER);writeButton=userInterface.getDoTask1Button();writeButton.setText(保存);writeButton.addActionListener(newActionListener()publicvoidact

20、ionPerformed(ActionEventevent)addRecord(););clearButton=userInterface.getDoTask2Button();clearButton.setText(清除);clearButton.addActionListener(newActionListener()publicvoidactionPerformed(ActionEventevent)userInterface.clearFields(););setSize(300,200);setBackground(newColor(199,183,143);setVisible(t

21、rue);publicvoidaddRecord()ConnectionSqltempdb=newConnectionSql();StringfieldValues=userInterface.getFieldValues();if(!fieldValuesHotelUI.Bookno.equals()tryStringsqlInsert1=INSERTINTOBookin+VALUES(+fieldValues0+,+fieldValues1+,+fieldValues2+,+fieldValues3+,+fieldValues4+”,+WHEREfieldValues5+);Strings

22、qlInsert2=UpdateRoomsSET+Putup=1+RoomNo=+fieldValues3+”;intresult1=tempdb.statement.executeUpdate(sqlInsert1);intresult2=tempdb.statement.executeUpdate(sqlInsert2);if(result1!=0&result2!=0)userInterface.clearFields();JOptionPane.showMessageDialog(this,插入成功,InsertResult,JOptionPane.INFORMATION_MESSAG

23、E);catch(SQLExceptionee)System.out.println(ee);elseJOptionPane.showMessageDialog(this,”錯(cuò)誤的編號(hào),InvalidNumberFormat,JOptionPane.ERROR_MESSAGE);tempdb.terminate();/endmethodaddRecordpublicstaticvoidmain(Stringargs口)newaddEngage();刪除預(yù)訂信息:圖5刪除客戶預(yù)訂信息主代碼如下：/deleteEngage.javapackageUI;importjava.awt.*;import

24、java.sql.*;importjava.util.*;importjavax.swing.*;importUI.*;classdeleteEngageextendsJFrameprivateHotelUIuserInterface1,userInterface2;privateJButtonfirstButton1,secondButton1,firstButton2,secondButton2;StringBooknoUpdate;StringsqlString;publicdeleteEngage()super(刪除預(yù)定信息);Stringnames1=請(qǐng)輸入要?jiǎng)h除的預(yù)定編號(hào):;use

25、rInterface1=newHotelUI(names1);/fourtextfieldsStringnames2=訂房編號(hào),姓名,身份證號(hào),客房編號(hào),聯(lián)系電話,入住日期;userInterface2=newHotelUI(names2);Containerc=getContentPane();Boxbox=Box.createVerticalBox();box.add(userInterface1);box.add(userInterface2);c.add(box);firstButton1=userInterface1.getDoTask1Button();firstButton1.s

26、etText(確認(rèn));firstButton1.addActionListener(newActionListener()publicvoidactionPerformed(ActionEventevent)/initialize();DisplayRecord(););secondButton1=userInterface1.getDoTask2Button();secondButton1.setText(清除);secondButton1.addActionListener(newActionListener()publicvoidactionPerformed(ActionEventev

27、ent)userInterface1.clearFields(););firstButton2=userInterface2.getDoTask1Button();firstButton2.setText(確認(rèn)刪除);firstButton2.addActionListener(newActionListener()publicvoidactionPerformed(ActionEventevent)UpdateRecord(););secondButton2=userInterface2.getDoTask2Button();secondButton2.setText(放棄);secondB

28、utton2.addActionListener(newActionListener()publicvoidactionPerformed(ActionEventevent)userInterface2.clearFields(););setSize(400,300);setVisible(true);publicvoidDisplayRecord()StringfieldValues1=userInterface1.getFieldValues();ConnectionSqltempdb=newConnectionSql();StringfieldValues2=newString6;if(

29、!fieldValues1HotelUI.Bookno.equals()BooknoUpdate=fieldValues10;wheretryStringsqlString=select*fromBookin+Bookno=+fieldValues10+;ResultSetresultSet=tempdb.statement.executeQuery(sqlString);ResultSetMetaDatametaData=resultSet.getMetaData();intnumberOfColumns=metaData.getColumnCount();if(resultSet.next

30、()fieldValues20=resultSet.getString(1);fieldValues21=resultSet.getString(2);fieldValues22=resultSet.getString(3);fieldValues23=resultSet.getString(4);fieldValues24=resultSet.getString(5);fieldValues25=resultSet.getString(6);userInterface2.setFieldValues(fieldValues2);elseuserInterface2.clearFields()

31、;JOptionPane.showMessageDialog(this,Notfundthisrecord!,FindResult,JOptionPane.INFORMATION_MESSAGE);catch(NumberFormatExceptionformatException)JOptionPane.showMessageDialog(this,Badagenumber,InvalidNumberFormat,JOptionPane.ERROR_MESSAGE);catch(SQLExceptionee)System.out.println(ee);elseJOptionPane.sho

32、wMessageDialog(this,錯(cuò)誤的預(yù)定編號(hào),InvalidNumberFormat,JOptionPane.ERROR_MESSAGE);tempdb.terminate();publicvoidUpdateRecord()ConnectionSqltempdb=newConnectionSql();StringfieldValues=userInterface2.getFieldValues();if(!fieldValuesHotelUI.Bookno.equals()try/thestringsqlstatementStringsqlString1=deletefromBoo

33、kin+WHEREwhereBookno=+BooknoUpdate+StringsqlString2=UpdateRoomsSET+Putup=0+RoomNo=+fieldValues3+;intresult1=tempdb.statement.executeUpdate(sqlString1);intresult2=tempdb.statement.executeUpdate(sqlString2);if(result1!=0&result2!=0)JOptionPane.showMessageDialog(this,Deletedsucess!,DeleteResult,JOption

34、Pane.INFORMATION_MESSAGE);catch(NumberFormatExceptionformatException)JOptionPane.showMessageDialog(this,Badagenumber,InvalidNumberFormat,JOptionPane.ERROR_MESSAGE);catch(SQLExceptionee)System.out.println(ee);/endofifsnofieldvalueisnotemptyelseJOptionPane.showMessageDialog(this,”錯(cuò)誤的預(yù)定編號(hào),InvalidNumber

35、Format,JOptionPane.ERROR_MESSAGE);tempdb.terminate();publicstaticvoidmain(Stringargs口)newdeleteEngage();/endclass查詢客房預(yù)訂信息，客房預(yù)討信息-1X訂房編號(hào)顧客姓名顧客身份證號(hào)頊定客房編號(hào)聯(lián)系方式技定日期房分0001吳海佳124354110031333333333320091111預(yù)定0002吳佳佳134534510041313243333420091112秋定0003于金銘1244354200323423432420091112預(yù)定0004張愷6463sB310041333333

36、333420091112制定0005張卻翻635787630041332433233420091113我定OOOB明明12346678100212323213220100101鑿定.TI圖6客房預(yù)訂狀態(tài)查詢主代碼如下:packageUI;importjava.awt.*;importjava.sql.*;importjava.util.*;importjavax.swing.*;publicclassquaryEngageextendsJFramepublicquaryEngage()super(客房預(yù)iT信息);ConnectionSqltempdb=newConnectionSql();t

37、ryStringsqlString=newString(selectBooknoas訂房編號(hào)，Customnameas顧客姓名，CustomIDas顧客身份證號(hào)，RoomNOas預(yù)定客房編號(hào),Phonenoas聯(lián)系方式，Bookdateas預(yù)定日期，預(yù)定as房態(tài)fromBookin);ResultSetresultSet=tempdb.statement.executeQuery(sqlString);StringBufferresults=newStringBuffer();ResultSetMetaDatametaData=resultSet.getMetaData();intnumber

38、OfColumns=metaData.getColumnCount();for(inti=1;i=numberOfColumns;i+)results.append(metaData.getColumnName(i)+t);results.append(n);while(resultSet.next()for(inti=1;i=numberOfColumns;i+)results.append(resultSet.getObject(i)+t);results.append(n);JTextAreatextArea=newJTextArea(results.toString();Contain

39、ercontainer=getContentPane();container.add(newJScrollPane(textArea);setSize(600,400);/setwindowsizesetVisible(true);/displaywindowcatch(SQLExceptionsqlException)JOptionPane.showMessageDialog(null,sqlException.getMessage(),DatabaseError,JOptionPane.ERROR_MESSAGE);System.exit(1);tempdb.terminate();/cl

40、osedb/endDisplayStudentsconstructorpublicstaticvoidmain(Stringargs)quaryEngagewindow=newquaryEngage();window.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);一一剩余客房查詢r(jià)B剩余客房查詢一嚼_o1客房編號(hào)標(biāo)準(zhǔn)客房位置床位數(shù)量單價(jià)房意A1001標(biāo)難單人間一褶1100空閑1002標(biāo)推單人間一樓1100空閑2001標(biāo)推雙人間二樓2160空閑2002標(biāo)準(zhǔn)雙人間二樓2160空鬧3001奈華雙人間三樓2360空閑3302商務(wù)套房三楂11000空鬧30

41、03豪華雙A間三樓2360楚.*111圖7剩余客房查詢主代碼如下：packageUI;importjava.awt.*;importjava.sql.*;importjava.util.*;importjavax.swing.*;publicclassquaryLeftextendsJFramepublicquaryLeft()super(剩余客房查詢);ConnectionSqltempdb=newConnectionSql();tryStringsqlString=newString(selectRoomNOas客房編號(hào),Typenameas標(biāo)準(zhǔn),Roompositionas客房位置,Be

42、dnumas床位數(shù)量,Priceas單價(jià),空閑as房態(tài)fromRoomsview+wherePutup=0);ResultSetresultSet=tempdb.statement.executeQuery(sqlString);StringBufferresults=newStringBuffer();ResultSetMetaDatametaData=resultSet.getMetaData();intnumberOfColumns=metaData.getColumnCount();for(inti=1;i=numberOfColumns;i+)results.append(metaD

43、ata.getColumnName(i)+t);results.append(n);while(resultSet.next()for(inti=1;i=numberOfColumns;i+)results.append(resultSet.getObject(i)+t);results.append(n);JTextAreatextArea=newJTextArea(results.toString();Containercontainer=getContentPane();container.add(newJScrollPane(textArea);setSize(510,280);/se

44、twindowsizesetVisible(true);/displaywindow/endtrycatch(SQLExceptionsqlException)JOptionPane.showMessageDialog(null,sqlException.getMessage(),DatabaseError,JOptionPane.ERROR_MESSAGE);System.exit(1);tempdb.terminate();/closedb/endDisplayStudentsconstructorpublicstaticvoidmain(Stringargs)quaryLeftwindo

45、w=newquaryLeft();window.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);.入住登記功能實(shí)現(xiàn)此模塊主要實(shí)現(xiàn)客戶入住登記、查詢、刪除以及剩余客房的查詢，因此功能與客戶預(yù)定功能很相近，故代碼不再列出。圖8客戶入住信息5.結(jié)算功能實(shí)現(xiàn)此模塊主要實(shí)現(xiàn)客戶的退宿結(jié)算功能圖9客戶結(jié)算信息主代碼如下：deleteEngage.javapackageUI;importjava.awt.*;importjava.awt.event.*;importjava.sql.*;importjava.util.*;importjavax.swing.*;

46、importUI.*;classaccountextendsJFrameprivateHotelUIuserInterface1,userInterface2,userInterface3,userInterface4;privateJButtonfirstButton1,secondButton1,firstButton2,secondButton2;StringBooknoUpdate;StringsqlString;publicaccount。super（結(jié)賬信息）;Stringnames1口=請(qǐng)輸入客戶編號(hào)：;Stringnames2=請(qǐng)輸入結(jié)賬日期:;Stringnames3=您的總

47、消費(fèi)額為:;userInterface1=newHotelUI(names1);/fourtextfieldsuserInterface2=newHotelUI(names2);userInterface3=newHotelUI(names3);Stringnames4=客戶編號(hào),姓名,客房編號(hào),客房類型,客房位置,入住日期,客房單價(jià);userInterface4=newHotelUI(names4);Containerc=getContentPane();Boxbox=Box.createVerticalBox();box.add(userInterface1);box.add(userIn

48、terface2);box.add(userInterface3);box.add(userInterface4);c.add(box);firstButton1=userInterface1.getDoTask1Button();firstButton1.setText(確認(rèn));firstButton1.addActionListener(newActionListener()publicvoidactionPerformed(ActionEventevent)DisplayRecord(););secondButton1=userInterface1.getDoTask2Button();

49、secondButton1.setText(清除);secondButton1.addActionListener(newActionListener()publicvoidactionPerformed(ActionEventevent)userInterface1.clearFields(););firstButton2=userInterface4.getDoTask1Button();firstButton2.setText(結(jié)算);firstButton2.addActionListener(newActionListener()publicvoidactionPerformed(ActionEventevent)accountRecord(););