modify.java~2~

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

package 旅馆;

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

public class Modify extends JDialog {
  JLabel jLabel1 = new JLabel();
  JTextField 房间号 = new JTextField();
  JButton 开始修改 = new JButton();
  JTextField 姓名 = new JTextField();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JTextField 地址 = new JTextField();
  JButton 更新 = new JButton();
  JButton 重置 = new JButton();
  JLabel jLabel4 = new JLabel();
  JTextField 电话 = new JTextField();
  JLabel jLabel5 = new JLabel();
  JTextField 信用卡号 = new JTextField();
  public Modify(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.setFont(new java.awt.Font("Dialog", 0, 12));
    this.setModal(false);
    this.setResizable(false);
    this.setBounds(new Rectangle(50,50,530,400));
    this.setTitle("客人资料更新");
    this.getContentPane().setLayout(null);
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel1.setText(" 请输入房间号  ：");
    jLabel1.setBounds(new Rectangle(106, 53, 104, 25));
    房间号.setFont(new java.awt.Font("Dialog", 0, 13));
    房间号.setText("");
    房间号.setBounds(new Rectangle(212, 53, 88, 25));
    开始修改.setBounds(new Rectangle(304, 53, 93, 25));
    开始修改.setFont(new java.awt.Font("Dialog", 0, 13));
    开始修改.setToolTipText("");
    开始修改.setText("开始修改");
    开始修改.addActionListener(new Modify_开始修改_actionAdapter(this));

    jLabel2.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel2.setText("（新）姓       名：");
    jLabel2.setBounds(new Rectangle(103, 98, 106, 25));
    姓名.setFont(new java.awt.Font("Dialog", 0, 13));
    姓名.setText("");
    姓名.setBounds(new Rectangle(212, 98, 185, 25));

    jLabel3.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel3.setMaximumSize(new Dimension(65, 19));
    jLabel3.setText("（新）地       址：");
    jLabel3.setBounds(new Rectangle(103, 143, 106, 25));
    地址.setFont(new java.awt.Font("Dialog", 0, 13));
    地址.setText("");
    地址.setBounds(new Rectangle(212, 143, 185, 25));

    jLabel4.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel4.setText("（新）电       话：");
    jLabel4.setBounds(new Rectangle(103, 189, 106, 25));
    电话.setFont(new java.awt.Font("Dialog", 0, 13));
    电话.setText("");
    电话.setBounds(new Rectangle(214, 189, 186, 25));

    jLabel5.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel5.setText("（新）信用卡号：");
    jLabel5.setBounds(new Rectangle(106, 238, 106, 25));
    信用卡号.setFont(new java.awt.Font("Dialog", 0, 13));
    信用卡号.setText("");
    信用卡号.setBounds(new Rectangle(214, 238, 189, 25));

    更新.setBounds(new Rectangle(166, 285, 83, 30));
    更新.setEnabled(false);
    更新.setFont(new java.awt.Font("Dialog", 0, 13));
    更新.setText("更新");
    更新.addActionListener(new Modify_更新_actionAdapter(this));
    重置.setBounds(new Rectangle(278, 285, 83, 30));
    重置.setFont(new java.awt.Font("Dialog", 0, 13));
    重置.setText("重置");
    重置.addActionListener(new Modify_重置_actionAdapter(this));

    this.getContentPane().add(jLabel1, null);
    this.getContentPane().add(jLabel3, null);
    this.getContentPane().add(jLabel5, null);
    this.getContentPane().add(jLabel4, null);
    this.getContentPane().add(开始修改, null);
    this.getContentPane().add(jLabel2, null);
    this.getContentPane().add(信用卡号, null);
    this.getContentPane().add(电话, null);
    this.getContentPane().add(地址, 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()==重置)
        { 更新.setEnabled(false);
          房间号.setEnabled(true);
          房间号.setText(null);
          姓名.setText(null);
          地址.setText(null);
          电话.setText(null);
          信用卡号.setText(null);
        }
      }
void 更新_actionPerformed(ActionEvent e) {
    if(e.getSource()==更新)
      try{update();}
    catch(SQLException ee) {}
  }
public void update() 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="+name+",ADDRESS="+address+",PHONE="+phone+",CREDITCARD="+creditcard+" 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);
       }
     }
   }

class Modify_开始修改_actionAdapter implements java.awt.event.ActionListener {
  Modify adaptee;

  Modify_开始修改_actionAdapter(Modify adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.开始修改_actionPerformed(e);
  }
}

class Modify_重置_actionAdapter implements java.awt.event.ActionListener {
  Modify adaptee;

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

class Modify_更新_actionAdapter implements java.awt.event.ActionListener {
  Modify adaptee;

  Modify_更新_actionAdapter(Modify adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.更新_actionPerformed(e);
  }
}