package bookmanager;import javax.swing.*;import com.borland.jbcl.layout.*;import java.awt.*;import java.awt.event.*;import java.sql.*;/** * <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.setFont(new java.awt.Font("Dialog", 0, 16));    jButtonOK.setText("確定");    jButtonOK.addMouseListener(new userDelete_jButtonOK_mouseAdapter(this));    jTextFieldusername.setFont(new java.awt.Font("Dialog", 0, 16));    jTextFieldusername.setText("");    jLabel1.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel1.setText("用戶名");    jButtonCancel.setFont(new java.awt.Font("Dialog", 0, 16));    jButtonCancel.setText("取消");    jButtonCancel.addMouseListener(new userDelete_jButtonCancel_mouseAdapter(this));     jLabel2.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel2.setText("密碼");    this.getContentPane().setLayout(xYLayout1);    xYLayout1.setWidth(400);    xYLayout1.setHeight(239);    this.getContentPane().add(jButtonOK, new XYConstraints(90, 174, 91, 31));    this.getContentPane().add(jButtonCancel, new XYConstraints(208, 175, 94, 30));    this.getContentPane().add(jLabel1, new XYConstraints(65, 37, 99, 34));    this.getContentPane().add(jLabel2, new XYConstraints(72, 90, 80, 34));    this.getContentPane().add(jTextFieldusername, new XYConstraints(201, 40, 111, 28));    this.getContentPane().add(jPasswordold, new XYConstraints(203, 92, 111, 26));  }  void jButtonCancel_mouseClicked(MouseEvent e) {          this.dispose();  }  void jButtonOK_mouseClicked(MouseEvent e) {    String strSQL ;	//校驗用戶名是否為空   if(jTextFieldusername.getText().trim().equals(""))	       {JOptionPane.showMessageDialog(null,"書名不許為空！");	        return;}    //生成sql操作語句，查詢要刪除的用戶名是否存在，若存在執行刪除，若不存在提示并返回       strSQL="select * from user where username='"+jTextFieldusername.getText().trim() +"' and password='"+jPasswordold.getText().trim()+"'";              rs=db.getResult(strSQL) ;        boolean  isexist=false;                         try {                                  isexist = rs.first();                                  }                         catch (SQLException ex1) {                                  }           //若用戶名不存在，提示警告信息             if(!isexist)         {JOptionPane.showMessageDialog(null,"用戶名不存在，或原密碼不正確！");                  }       else         {             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);  }}