package Manager;import javax.swing.*;import java.sql.*;import com.borland.jbcl.layout.*;import java.awt.*;import java.awt.event.*;/** * <p>Title: </p> * <p>Description: </p> * <p>Copyright: Copyright (c) 2003</p> * <p>Company: </p> * @author not attributable * @version 1.0 */public class userDelete extends JFrame {  ResultSet rs;    //定義結果集  private DBManager db =new DBManager();  XYLayout xYLayout1 = new XYLayout();  JLabel jLabel2 = new JLabel();  JButton jButtonCancel = new JButton();  JLabel jLabel1 = new JLabel();  JTextField jTextFieldusername = new JTextField();  JButton jButtonOK = new JButton();  JPasswordField jPasswordold = new JPasswordField();  public userDelete() {    try {      jbInit();    }    catch(Exception e) {      e.printStackTrace();    }  }  public static void main(String[] args) {    userDelete userDelete = new userDelete();  }  private void jbInit() throws Exception {    jPasswordold.setText("");    jButtonOK.setText("確定");    jButtonOK.addMouseListener(new userDelete_jButtonOK_mouseAdapter(this));    jButtonOK.setFont(new java.awt.Font("Dialog", 0, 16));    jTextFieldusername.setText("");    jTextFieldusername.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel1.setText("用戶名");    jLabel1.setFont(new java.awt.Font("Dialog", 0, 16));    jButtonCancel.setText("取消");    jButtonCancel.addMouseListener(new userDelete_jButtonCancel_mouseAdapter(this));    jButtonCancel.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel2.setText("密碼");    jLabel2.setFont(new java.awt.Font("Dialog", 0, 16));    this.getContentPane().setLayout(xYLayout1);    xYLayout1.setWidth(364);    xYLayout1.setHeight(225);    this.setTitle("刪除用戶");    this.getContentPane().add(jTextFieldusername, new XYConstraints(198, 28, 111, 28));    this.getContentPane().add(jLabel2, new XYConstraints(69, 78, 80, 34));    this.getContentPane().add(jLabel1, new XYConstraints(62, 25, 99, 34));    this.getContentPane().add(jPasswordold,  new XYConstraints(195, 79, 111, 26));    this.getContentPane().add(jButtonOK, new XYConstraints(67, 141, 91, 31));    this.getContentPane().add(jButtonCancel, new XYConstraints(194, 139, 94, 30));  }//退出此窗口  void jButtonCancel_mouseClicked(MouseEvent e) {     this.dispose();  }//刪除紀錄  void jButtonOK_mouseClicked(MouseEvent e) {    //檢驗用戶名是否為空   if(jTextFieldusername.getText().trim() =="")              { JOptionPane.showMessageDialog(null,"用戶名不可為空！");                   return;}   //檢驗密碼是否為空      if(jPasswordold.getText().trim() =="")              {JOptionPane.showMessageDialog(null,"密碼不可為空！");                  return;}   //定義字符串對象,代表sql語句    String strSQL ;      //生成sql語句，用戶名和密碼從相應文本框取得           strSQL="select * from user where Username='"+jTextFieldusername.getText().trim() +"' and Password='"+jPasswordold.getText().trim()+"'";          //由DBManager對象執行查詢過程           rs=db.getResult(strSQL) ;   //判斷結果集是否為空                     boolean  isexist=false;                 try {                          isexist = rs.first();                          }                 catch (SQLException ex1) {                          }   //若為空，則說明用戶名不存在或密碼不正確，彈出警告信息           if(!isexist)             {JOptionPane.showMessageDialog(null,"用戶名不存在，或原密碼不正確！");                      }   //若不為空，則說明用戶名存在且密碼正確           else             {   //由DBManager對象執行過程，若成功返回成功信息，若失敗返回失敗提示                 strSQL="delete from user where Username='"+jTextFieldusername.getText().trim() +"'";                 if(db.executeSql(strSQL))                    {JOptionPane.showMessageDialog(null,"成功刪除！"); }                 else                    { JOptionPane.showMessageDialog(null," 刪除失敗，請重新操作！");      }               }  }}class userDelete_jButtonCancel_mouseAdapter extends java.awt.event.MouseAdapter {  userDelete adaptee;  userDelete_jButtonCancel_mouseAdapter(userDelete adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtonCancel_mouseClicked(e);  }}class userDelete_jButtonOK_mouseAdapter extends java.awt.event.MouseAdapter {  userDelete adaptee;  userDelete_jButtonOK_mouseAdapter(userDelete adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtonOK_mouseClicked(e);  }}