package bookmanage;

import java.awt.*;
import javax.swing.*;
import java.awt.Rectangle;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * <p>Title: 圖書管理系統(tǒng)</p>
 *
 * * <p>Description: DeleteBook類是繼承JDialog，主要是用來刪除書</p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: 浙江工業(yè)大學信息學院計算機系</p>
 *
 * @author 曾文秋
 * @version 1.0
 */
public class DeleteBook
    extends JDialog {
  public DeleteBook(Frame owner, String title, boolean modal) {
    super(owner, title, modal);
    try {
      setDefaultCloseOperation(DISPOSE_ON_CLOSE);
      jbInit();
      pack();
    }
    catch (Exception exception) {
      exception.printStackTrace();
    }
  }

  public DeleteBook() {
    this(new Frame(), "DeleteBook", false);
  }

  private void jbInit() throws Exception {
    this.getContentPane().setLayout(null);
    jLabel1.setText("ISBN：");
    jLabel1.setBounds(new Rectangle(112, 46, 41, 19));
    this.setResizable(false);
    this.setTitle("刪除書籍");
    jButtonDeleteAlert.setBounds(new Rectangle(98, 86, 71, 23));
    jButtonDeleteAlert.setText("確定");
    jButtonDeleteAlert.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButtonDeleteAlert_actionPerformed(e);
      }
    });
    jButtonDelete.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButtonDelete_actionPerformed(e);
      }
    });
    this.getContentPane().add(jLabel1);
    jButtonDelete.setBounds(new Rectangle(218, 86, 71, 23));
    jButtonDelete.setText("取消");
    this.getContentPane().add(jTextFieldDeleteISBN);
    this.getContentPane().add(jButtonDeleteAlert);
    this.getContentPane().add(jButtonDelete);
    jTextFieldDeleteISBN.setBounds(new Rectangle(171, 46, 96, 20));
  }

  JLabel jLabel1 = new JLabel();
  JTextField jTextFieldDeleteISBN = new JTextField();
  JButton jButtonDeleteAlert = new JButton();
  JButton jButtonDelete = new JButton();
  ResultSet rs;
  //定義數據庫操作對象
  private DBManager db = new DBManager();

  public void jButtonDeleteAlert_actionPerformed(ActionEvent e) {
    String ISBN="";
    String strSQL="";
    ISBN=jTextFieldDeleteISBN.getText().trim();
    if(ISBN.equals("")){
      JOptionPane.showMessageDialog(this, "ISBN號不許為空");
      return;
    }
    strSQL="select * from bookInfo where ISBN='"+ISBN+"'";
    rs = db.getResult(strSQL);
    boolean isexist = false;
    try {
      isexist = rs.first();
    }
    catch (SQLException ex1) {
    }
    //若書名存在，提示警告信息
    if (!isexist){
      JOptionPane.showMessageDialog(this, "這本書不存在");
      return;
    }
    strSQL="delete from bookInfo where ISBN='"+ISBN+"'";
    if (db.executeSql(strSQL)) {
      JOptionPane.showMessageDialog(this, "成功刪除！");
      jTextFieldDeleteISBN.setText("");
    }
    else {
      JOptionPane.showMessageDialog(this, " 刪除失敗，可能這本書還有同學借著！");
      jTextFieldDeleteISBN.setText("");
    }
    db.close();


  }

  public void jButtonDelete_actionPerformed(ActionEvent e) {
    this.dispose();
  }

}