package 旅館;import java.awt.*;import java.awt.event.*;import javax.swing.*;import java.sql.*; public class Search extends JDialog {   Object a[][];   Object columnName[]={"房間號","姓名","地址","電話","信用卡號","房間價格"};   JScrollPane jScrollPane1 = new JScrollPane();   JScrollPane jScrollPane2 = new JScrollPane();   JTextArea text = new JTextArea();   JTable table;  JButton 查詢 = new JButton();  JButton 空房查詢 = new JButton();   public Search(JFrame f) {     try {       jbInit();     }     catch(Exception e) {       e.printStackTrace();     }   }   private void jbInit() throws Exception {     this.getContentPane().setBackground(new Color(240, 255, 240));    this.setResizable(false);     this.setTitle("查詢窗口");     this.setBounds(new Rectangle(50,50,650,430));     this.getContentPane().setLayout(null);     a=new Object[20][6];     table = new JTable(a,columnName);     jScrollPane1.setBounds(new Rectangle(40, 67, 555, 186));     jScrollPane2.setBounds(new Rectangle(150, 265, 190, 98));     table.setEnabled(true);     table.setFont(new java.awt.Font("Dialog", 0, 12));     table.setDoubleBuffered(true);     table.setCellSelectionEnabled(false);     table.setRowHeight(18);     查詢.setBounds(new Rectangle(40, 37, 112, 29));    查詢.setFont(new java.awt.Font("Dialog", 0, 13));    查詢.setText("查詢");    查詢.addActionListener(new Search_查詢_actionAdapter(this));    空房查詢.setBounds(new Rectangle(40, 265, 97, 56));    空房查詢.setFont(new java.awt.Font("Dialog", 0, 13));    空房查詢.setText("空房查詢");    空房查詢.addActionListener(new Search_空房查詢_actionAdapter(this));    this.getContentPane().add(jScrollPane1, null);     jScrollPane1.getViewport().add(table, null);     this.getContentPane().add(jScrollPane2, null);    this.getContentPane().add(查詢, null);    this.getContentPane().add(空房查詢, null);     jScrollPane2.getViewport().add(text, null);   }   void 查詢_actionPerformed(ActionEvent e) {     if(e.getSource()==查詢)     {       try{searchIn();}       catch(SQLException ee){}}   }   public void searchIn() throws SQLException     { int i=0;       for(int x=0;x<20;x++)         for(int y=0;y<6;y++)         {a[x][y]=null;}       String room,name,address,phone,creditcard;int price;       try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}       catch(ClassNotFoundException e) {}       Connection con=DriverManager.getConnection("jdbc:odbc:lvguan");       Statement sql=con.createStatement();       ResultSet rs=sql.executeQuery("SELECT * FROM lvguan WHERE ISEMPTY=false");       while(rs.next())       {         room=rs.getString("ROOM");name=rs.getString("NAME");         address=rs.getString("ADDRESS");phone=rs.getString("PHONE");         creditcard=rs.getString("CREDITCARD");price=rs.getInt("PRICE");         a[i][0]=room;         a[i][1]=name;         a[i][2]=address;         a[i][3]=phone;         a[i][4]=creditcard;         a[i][5]=String.valueOf(price);         i++;       }con.close();     }     void 空房查詢_actionPerformed(ActionEvent e) {       if(e.getSource()==空房查詢)       {text.setText("查詢結果:"+'\n');         try{searchKong();}         catch(SQLException ee){} }     }     public void searchKong() throws SQLException      {String room;        try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}        catch(ClassNotFoundException e) {}        Connection con=DriverManager.getConnection("jdbc:odbc:lvguan");        Statement sql=con.createStatement();        ResultSet rs=sql.executeQuery("SELECT * FROM lvguan WHERE ISEMPTY=true");        while(rs.next())        {room=rs.getString("ROOM");          text.append("**"+room+" 號房  空 **"+'\n');        }      }    }class Search_查詢_actionAdapter implements java.awt.event.ActionListener {  Search adaptee;  Search_查詢_actionAdapter(Search adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.查詢_actionPerformed(e);  }}class Search_空房查詢_actionAdapter implements java.awt.event.ActionListener {  Search adaptee;  Search_空房查詢_actionAdapter(Search adaptee) {    this.adaptee = adaptee;  }  public void actionPerformed(ActionEvent e) {    adaptee.空房查詢_actionPerformed(e);  }}