package bookmanager;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 bookDelete extends JFrame {   //定義結果集  ResultSet rs;  //定義數據庫操作對象  private DBManager db =new DBManager();  XYLayout xYLayout1 = new XYLayout();  JLabel jLabel1 = new JLabel();  JTextField jTextFieldname = new JTextField();  JButton jButtonOk = new JButton();  JButton jButtonCancel = new JButton();  public bookDelete() {    try {      jbInit();    }    catch(Exception e) {      e.printStackTrace();    }  }  public static void main(String[] args) {    bookDelete bookDelete = new bookDelete();  }  private void jbInit() throws Exception {    jLabel1.setFont(new java.awt.Font("Dialog", 0, 16));    jLabel1.setText("請輸入您要刪除的書的名稱：");    this.getContentPane().setLayout(xYLayout1);    jButtonOk.setFont(new java.awt.Font("Dialog", 0, 16));    jButtonOk.setText("確定");    jButtonOk.addMouseListener(new bookDelete_jButtonOk_mouseAdapter(this));    jButtonCancel.setFont(new java.awt.Font("Dialog", 0, 16));    jButtonCancel.setText("退出");    jButtonCancel.addMouseListener(new bookDelete_jButtonCancel_mouseAdapter(this));    xYLayout1.setWidth(363);    xYLayout1.setHeight(219);    jTextFieldname.setFont(new java.awt.Font("Dialog", 0, 16));    jTextFieldname.setText("");    this.getContentPane().add(jLabel1,    new XYConstraints(28, 19, 226, 32));    this.getContentPane().add(jTextFieldname, new XYConstraints(99, 85, 161, 27));    this.getContentPane().add(jButtonOk, new XYConstraints(73, 159, 76, 28));    this.getContentPane().add(jButtonCancel, new XYConstraints(195, 156, 81, 28));  }  void jButtonCancel_mouseClicked(MouseEvent e) {            this.dispose();  }  void jButtonOk_mouseClicked(MouseEvent e) {        String strSQL ;		//校驗書名是否為空		 if(jTextFieldname.getText().trim().equals(""))	       {JOptionPane.showMessageDialog(null,"書名不許為空！");	        return;}      //生成sql操作語句，查詢要刪除的書是否存在，若存在執行刪除，若不存在提示并返回         strSQL="select * from Books where bookname='"+jTextFieldname.getText().trim() +"'";                rs=db.getResult(strSQL) ;         if(rs != null)           {JOptionPane.showMessageDialog(null,"此書不存在！");		                     }         else           {			 //生成刪除此書的sql語句               strSQL="delete from Books where bookname='"+jTextFieldname.getText().trim() +"'";			    //由數據庫操作對象執行數據庫操作，并返回操作成功失敗的提示信息               if(db.executeSql(strSQL))                  {JOptionPane.showMessageDialog(null,"成功刪除！"); }               else                  { JOptionPane.showMessageDialog(null," 刪除失敗，請重新操作！");      }             }  }}class bookDelete_jButtonCancel_mouseAdapter extends java.awt.event.MouseAdapter {  bookDelete adaptee;  bookDelete_jButtonCancel_mouseAdapter(bookDelete adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtonCancel_mouseClicked(e);  }}class bookDelete_jButtonOk_mouseAdapter extends java.awt.event.MouseAdapter {  bookDelete adaptee;  bookDelete_jButtonOk_mouseAdapter(bookDelete adaptee) {    this.adaptee = adaptee;  }  public void mouseClicked(MouseEvent e) {    adaptee.jButtonOk_mouseClicked(e);  }}