checkout.java~1~

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

package 旅馆;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;

public class CheckOut extends JDialog {
  JLabel jLabel1 = new JLabel();
  JTextField 房间号 = new JTextField();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JTextField 姓名 = new JTextField();
  JTextField 地址 = new JTextField();
  JTextField 电话 = new JTextField();
  JTextField 信用卡号 = new JTextField();
  JButton 当前信息 = new JButton();
  JButton 退房 = new JButton();
  JButton 取消 = new JButton();
  public CheckOut(JFrame f) throws HeadlessException {
    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.getContentPane().setLayout(null);
    this.setBounds(new Rectangle(50,50,490,360));

    jLabel1.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel1.setText("请输入房间号：");
    jLabel1.setBounds(new Rectangle(107, 46, 92, 25));
    房间号.setFont(new java.awt.Font("Dialog", 0, 13));
    房间号.setText("");
    房间号.setBounds(new Rectangle(197, 46, 80, 25));
    当前信息.setBounds(new Rectangle(285, 46, 90, 25));
    当前信息.setFont(new java.awt.Font("Dialog", 0, 13));
    当前信息.setText("当前信息");
    当前信息.addActionListener(new CheckOut_当前信息_actionAdapter(this));

    jLabel2.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel2.setText("姓      名：");
    jLabel2.setBounds(new Rectangle(126, 96, 67, 25));
    姓名.setFont(new java.awt.Font("Dialog", 0, 13));
    姓名.setText("");
    姓名.setBounds(new Rectangle(209, 94, 140, 25));

    jLabel3.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel3.setText("地      址：");
    jLabel3.setBounds(new Rectangle(126, 134, 67, 25));
    地址.setFont(new java.awt.Font("Dialog", 0, 13));
    地址.setText("");
    地址.setBounds(new Rectangle(209, 134, 140, 25));

    jLabel4.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel4.setText("电      话：");
    jLabel4.setBounds(new Rectangle(126, 170, 67, 25));
    电话.setFont(new java.awt.Font("Dialog", 0, 13));
    电话.setText("");
    电话.setBounds(new Rectangle(209, 170, 140, 25));

    jLabel5.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel5.setText("信用卡号：");
    jLabel5.setBounds(new Rectangle(125, 204, 67, 25));
    信用卡号.setFont(new java.awt.Font("Dialog", 0, 13));
    信用卡号.setText("");
    信用卡号.setBounds(new Rectangle(209, 204, 140, 25));

    退房.setBounds(new Rectangle(148, 258, 80, 28));
    退房.setEnabled(false);
    退房.setFont(new java.awt.Font("Dialog", 0, 13));
    退房.setText("退房");
    退房.addActionListener(new CheckOut_退房_actionAdapter(this));
    取消.setBounds(new Rectangle(258, 258, 80, 28));
    取消.setFont(new java.awt.Font("Dialog", 0, 13));
    取消.setText("取消");
    取消.addActionListener(new CheckOut_取消_actionAdapter(this));

    this.getContentPane().add(jLabel1, null);
    this.getContentPane().add(当前信息, null);
    this.getContentPane().add(房间号, null);
    this.getContentPane().add(退房, null);
    this.getContentPane().add(取消, null);
    this.getContentPane().add(jLabel3, null);
    this.getContentPane().add(jLabel2, null);
    this.getContentPane().add(jLabel4, null);
    this.getContentPane().add(jLabel5, null);
    this.getContentPane().add(地址, null);
    this.getContentPane().add(姓名, null);
    this.getContentPane().add(信用卡号, null);
    this.getContentPane().add(电话, null);
  }

 void 当前信息_actionPerformed(ActionEvent e)
    {
         if(e.getSource()==当前信息)
           {
             try{begin();}
             catch(SQLException ee){}
           }
     }
  public void begin() throws SQLException{
        String room[]=new String[20];
        String name[]=new String[20];
        String address[]=new String[20];
        String phone[]=new String[20];
        String creditcard[]=new String[20];
        int i=0;int x;
        if(房间号.getText().length()>0)
        { 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[i]=rs.getString("ROOM");
            name[i]=rs.getString("NAME");
            address[i]=rs.getString("ADDRESS");
            phone[i]=rs.getString("PHONE");
            creditcard[i]=rs.getString("CREDITCARD");
            i++;
           }
           for(x=0;x<i;x++)
            {if(room[x].equals( 房间号.getText())  )
              { 退房.setEnabled(true);
                姓名.setText(name[x]);
                地址.setText(address[x]);
                电话.setText(phone[x]);
                信用卡号.setText(creditcard[x]);
                房间号.setEnabled(false);
                break;
              }
            }
            if(x==i)
                { String tishi="空房间或不存在的房间号,查询后重新输入！";
                  JOptionPane.showMessageDialog(this,tishi,"提示",JOptionPane.INFORMATION_MESSAGE);
                  房间号.setText(null);
                }

          }
          else
            { 退房.setEnabled(false);
              String warning="    必须要输入房间号！";
              JOptionPane.showMessageDialog(this,warning,"警告",JOptionPane.WARNING_MESSAGE);
              房间号.setText(null);
              姓名.setText(null);
              地址.setText(null);
              电话.setText(null);
              信用卡号.setText(null);
            }
          }

  void 退房_actionPerformed(ActionEvent e)
  {
      if(e.getSource()==退房)
        try{out();}
      catch(SQLException ee) {}
    }
  public void out() throws SQLException
    {
      if(房间号.getText().length()>0)
       { String question="    确认退房结帐？";
         JOptionPane.showMessageDialog(this,question,"警告",JOptionPane.QUESTION_MESSAGE);
         String m="    客户信息将被删除！";
         int ok=JOptionPane.showConfirmDialog(this,m,"确认",JOptionPane.YES_NO_OPTION,
         JOptionPane.INFORMATION_MESSAGE);
             if(ok==JOptionPane.YES_OPTION)
             {     String room="'"+房间号.getText().trim()+"'",
                   name="'"+姓名.getText().trim()+"'",
                   address="'"+地址.getText().trim()+"'",
                   phone="'"+电话.getText().trim()+"'",
                   creditcard="'"+信用卡号.getText().trim()+"'";
               String temp="UPDATE lvguan SET NAME=null,ADDRESS=null,PHONE=null,CREDITCARD=null,ISEMPTY=true WHERE ROOM="+room+"";
               try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
               catch(ClassNotFoundException e) {}
               Connection con=DriverManager.getConnection("jdbc:odbc:lvguan");
               Statement sql=con.createStatement();
               sql.executeUpdate(temp);
               con.close();
               退房.setEnabled(false);
               房间号.setEnabled(true);
               房间号.setText(null);
               姓名.setText(null);
               地址.setText(null);
               电话.setText(null);
               信用卡号.setText(null);
             }
             else if(ok==JOptionPane.NO_OPTION)
             { 退房.setEnabled(false);
               房间号.setEnabled(true);
               房间号.setText(null);
               姓名.setText(null);
               地址.setText(null);
               电话.setText(null);
               信用卡号.setText(null);
             }
           }
         else
         {
           String warning="    必须要输入房间号！";
           JOptionPane.showMessageDialog(this,warning,"警告",JOptionPane.WARNING_MESSAGE);
         }
       }

 void 取消_actionPerformed(ActionEvent e) {
    if(e.getSource()==取消)
      { 房间号.setEnabled(true);
        房间号.setText(null);
      姓名.setText(null);
      地址.setText(null);
      电话.setText(null);
      信用卡号.setText(null);
      this.setVisible(false);}
  }

}

class CheckOut_当前信息_actionAdapter implements java.awt.event.ActionListener {
  CheckOut adaptee;

  CheckOut_当前信息_actionAdapter(CheckOut adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.当前信息_actionPerformed(e);
  }
}

class CheckOut_退房_actionAdapter implements java.awt.event.ActionListener {
  CheckOut adaptee;

  CheckOut_退房_actionAdapter(CheckOut adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.退房_actionPerformed(e);
  }
}

class CheckOut_取消_actionAdapter implements java.awt.event.ActionListener {
  CheckOut adaptee;

  CheckOut_取消_actionAdapter(CheckOut adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.取消_actionPerformed(e);
  }
}