checkin.java

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

package 旅馆;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class CheckIn extends JDialog
{
  JLabel jLabel1 = new JLabel();
  JTextField 房间号 = new JTextField();
  JLabel jLabel2 = new JLabel();
  JTextField 姓名 = new JTextField();
  ButtonGroup sex=new ButtonGroup();
  JLabel jLabel4 = new JLabel();
  JTextField 信用卡号 = new JTextField();
  JButton 是否为空 = new JButton();
  JButton 重置 = new JButton();
  JLabel jLabel3 = new JLabel();
  JTextField 地址 = new JTextField();
  JLabel jLabel5 = new JLabel();
  JTextField 电话 = new JTextField();
  JButton 登记 = new JButton();

  public CheckIn(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,490,360));
    this.getContentPane().setLayout(null);

    jLabel1.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel1.setText("输入房间号：");
    jLabel1.setBounds(new Rectangle(102, 51, 82, 25));
    房间号.setFont(new java.awt.Font("Dialog", 0, 13));
    房间号.setText("");
    房间号.setBounds(new Rectangle(187, 50, 88, 25));
    是否为空.setBounds(new Rectangle(286, 50, 100, 25));
    是否为空.setFont(new java.awt.Font("Dialog", 0, 14));
    是否为空.setText("是否为空");
    是否为空.addActionListener(new CheckIn_是否为空_actionAdapter(this));

    jLabel2.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel2.setText("姓      名：");
    jLabel2.setBounds(new Rectangle(140, 96, 70, 25));
    姓名.setFont(new java.awt.Font("Dialog", 0, 13));
    姓名.setText("");
    姓名.setBounds(new Rectangle(213, 96, 135, 25));

    jLabel3.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel3.setText("地      址：");
    jLabel3.setBounds(new Rectangle(140, 132, 70, 25));
    地址.setFont(new java.awt.Font("Dialog", 0, 13));
    地址.setText("");
    地址.setBounds(new Rectangle(213, 132, 135, 25));

    jLabel5.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel5.setText("电      话：");
    jLabel5.setBounds(new Rectangle(140, 167, 70, 25));
    电话.setFont(new java.awt.Font("Dialog", 0, 13));
    电话.setText("");
    电话.setBounds(new Rectangle(213, 167, 135, 25));

    jLabel4.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel4.setForeground(Color.black);
    jLabel4.setText("信用卡号：");
    jLabel4.setBounds(new Rectangle(142, 202, 70, 25));
    信用卡号.setFont(new java.awt.Font("Dialog", 0, 13));
    信用卡号.setText("");
    信用卡号.setBounds(new Rectangle(215, 202, 135, 25));


    重置.setBounds(new Rectangle(257, 258, 75, 28));
    重置.setFont(new java.awt.Font("Dialog", 0, 13));
    重置.setText("重置");
    重置.addActionListener(new CheckIn_重置_actionAdapter(this));

    登记.setBounds(new Rectangle(165, 258, 75, 28));
    登记.setEnabled(false);
    登记.setFont(new java.awt.Font("Dialog", 0, 13));
    登记.setText("登记");
    登记.addActionListener(new CheckIn_登记_actionAdapter(this));
    this.getContentPane().add(房间号, null);
    this.getContentPane().add(姓名, null);
    this.getContentPane().add(jLabel1, null);
    this.getContentPane().add(是否为空, null);
    this.getContentPane().add(jLabel2, null);
    this.getContentPane().add(jLabel3, null);
    this.getContentPane().add(地址, null);
    this.getContentPane().add(电话, null);
    this.getContentPane().add(jLabel5, null);
    this.getContentPane().add(信用卡号, null);
    this.getContentPane().add(jLabel4, null);
    this.getContentPane().add(重置, null);
    this.getContentPane().add(登记, null);
  }

  void 重置_actionPerformed(ActionEvent e) {
   if(e.getSource()==重置)
   { 房间号.setEnabled(true);
     登记.setEnabled(false);
     房间号.setText(null);
     姓名.setText(null);
     地址.setText(null);
     电话.setText(null);
     信用卡号.setText(null);

   }
 }

  void 是否为空_actionPerformed(ActionEvent e) {
    if(e.getSource()==是否为空)
    {try{ isempty();}
      catch (SQLException ee) {}
    }

  }

  public void isempty() throws SQLException{

           int i=0;String a[]=new String[20];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=true");
              while(rs.next())
              {a[i]=rs.getString("ROOM");
                i++;
              }
                for(x=0;x<i;x++)
                { if(a[x].equals(房间号.getText()))
                   {
                     String tishi="   空房间，可以登记入住！";
                     JOptionPane.showMessageDialog(this,tishi,"提示",JOptionPane.INFORMATION_MESSAGE);
                     房间号.setEnabled(false);
                     登记.setEnabled(true);
                     break;
                   }
                 }
                 if(x==i)
                 { String warning="使用中或不存在的房间号,查询后重新输入！";
                   JOptionPane.showMessageDialog(this,warning,"提示",JOptionPane.INFORMATION_MESSAGE);
                   房间号.setText(null);
                 }
               }
               else
               { 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{ check();}
           catch(SQLException ee) {}
         }
       }

       public void check() throws SQLException
       {     String room="'"+房间号.getText().trim()+"'",
             name="'"+姓名.getText().trim()+"'",
             address="'"+地址.getText().trim()+"'",
             phone="'"+电话.getText().trim()+"'",
             creditcard="'"+信用卡号.getText().trim()+"'";

         String temp="UPDATE lvguan SET NAME="+name+",ADDRESS="+address+",PHONE="+phone+",CREDITCARD="+creditcard+",ISEMPTY=false 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();
         String success="     登  记  成  功！";
         JOptionPane.showMessageDialog(this,success,"成功",JOptionPane.INFORMATION_MESSAGE);
         房间号.setEnabled(true);
         房间号.setText(null);
         姓名.setText(null);
         地址.setText(null);
         电话.setText(null);
         信用卡号.setText(null);
         登记.setEnabled(false);
       }
     }

     class CheckIn_重置_actionAdapter implements java.awt.event.ActionListener {
       CheckIn adaptee;

       CheckIn_重置_actionAdapter(CheckIn adaptee) {
         this.adaptee = adaptee;
       }
       public void actionPerformed(ActionEvent e) {
         adaptee.重置_actionPerformed(e);
       }
     }

     class CheckIn_是否为空_actionAdapter implements java.awt.event.ActionListener {
       CheckIn adaptee;

       CheckIn_是否为空_actionAdapter(CheckIn adaptee) {
         this.adaptee = adaptee;
       }
       public void actionPerformed(ActionEvent e) {
         adaptee.是否为空_actionPerformed(e);
       }
     }

     class CheckIn_登记_actionAdapter implements java.awt.event.ActionListener {
       CheckIn adaptee;

       CheckIn_登记_actionAdapter(CheckIn adaptee) {
         this.adaptee = adaptee;
       }
       public void actionPerformed(ActionEvent e) {
         adaptee.登记_actionPerformed(e);
       }
     }