search.java~1~

一个简单的JAVA小旅馆的程序

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();
   JToggleButton 查询 = new JToggleButton();
   JToggleButton 空房查询 = new JToggleButton();

   JScrollPane jScrollPane2 = new JScrollPane();
   JTextArea text = new JTextArea();
   JTable table;

   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));
     查询.setFont(new java.awt.Font("Dialog", 0, 13));
     查询.setText("查询");
     查询.setBounds(new Rectangle(40, 37, 112, 29));
     查询.addActionListener(new Search_查询_actionAdapter(this));

     空房查询.setFont(new java.awt.Font("Dialog", 0, 13));
     空房查询.setText("空房查询");
     空房查询.setBounds(new Rectangle(40, 265, 97, 56));
     空房查询.addActionListener(new Search_空房查询_actionAdapter(this));

     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);
     this.getContentPane().add(jScrollPane1, null);
     jScrollPane1.getViewport().add(table, null);
     this.getContentPane().add(查询, null);
     this.getContentPane().add(jScrollPane2, 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;
       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++;
       }

     }

     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);
     }
   }