?? modify.java~4~
字號:
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); }}?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -