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 bookAdd
    extends JFrame {
//定義數據庫操作對象
  private DBManager db = new DBManager();

  XYLayout xYLayout1 = new XYLayout();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JLabel jLabel6 = new JLabel();
  JLabel jLabel7 = new JLabel();
  JTextField jTextFieldname = new JTextField();
  JTextField jTextFieldpress = new JTextField();
  JTextField jTextFieldauthor = new JTextField();
  JTextField jTextFieldaddress = new JTextField();
  JTextField jTextFieldpressdate = new JTextField();
  JTextField jTextFieldprice = new JTextField();
  JTextField jTextFieldcomment = new JTextField();
  JButton jButtonClear = new JButton();
  JButton jButtonAdd = new JButton();
  JButton jButtonExit = new JButton();

  public bookAdd() {
    try {
      jbInit();
    }
    catch (Exception e) {
      e.printStackTrace();
    }
  }

  public static void main(String[] args) {
    bookAdd bookAdd = new bookAdd();
  }

  private void jbInit() throws Exception {
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel1.setText("名稱");
    this.getContentPane().setLayout(xYLayout1);
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel2.setText("出版社");
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel3.setText("作者");
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel4.setText("地址");
    jLabel5.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel5.setText("出版日期");
    jLabel6.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel6.setText("價格");
    jLabel7.setFont(new java.awt.Font("Dialog", 0, 16));
    jLabel7.setText("備注");
    xYLayout1.setWidth(433);
    xYLayout1.setHeight(344);
    jTextFieldname.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFieldname.setText("");
    jTextFieldpress.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFieldpress.setText("");
    jTextFieldauthor.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFieldauthor.setText("");
    jTextFieldaddress.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFieldaddress.setText("");
    jTextFieldpressdate.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFieldpressdate.setText("");
    jTextFieldprice.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFieldprice.setText("");
    jTextFieldcomment.setFont(new java.awt.Font("Dialog", 0, 16));
    jTextFieldcomment.setText("");
    jButtonClear.setFont(new java.awt.Font("Dialog", 0, 16));
    jButtonClear.setText("清空");
    jButtonClear.addMouseListener(new bookAdd_jButtonClear_mouseAdapter(this));
    jButtonAdd.setFont(new java.awt.Font("Dialog", 0, 16));
    jButtonAdd.setText("添加");
    jButtonAdd.addMouseListener(new bookAdd_jButtonAdd_mouseAdapter(this));
    jButtonExit.setFont(new java.awt.Font("Dialog", 0, 16));
    jButtonExit.setText("退出");
    jButtonExit.addMouseListener(new bookAdd_jButtonExit_mouseAdapter(this));
    //將對象添加到相應容器
    this.setTitle("添加書籍信息");
    this.getContentPane().add(jLabel1, new XYConstraints(59, 16, 72, 23));
    this.getContentPane().add(jLabel2, new XYConstraints(57, 51, 89, 21));
    this.getContentPane().add(jLabel3, new XYConstraints(56, 87, 57, 21));
    this.getContentPane().add(jLabel4, new XYConstraints(56, 124, 51, 21));
    this.getContentPane().add(jLabel5, new XYConstraints(54, 163, 98, -1));
    this.getContentPane().add(jLabel6, new XYConstraints(56, 201, 62, 26));
    this.getContentPane().add(jLabel7, new XYConstraints(55, 242, 54, 20));
    this.getContentPane().add(jTextFieldname,
                              new XYConstraints(181, 19, 131, 27));
    this.getContentPane().add(jTextFieldpress,
                              new XYConstraints(181, 58, 132, 23));
    this.getContentPane().add(jTextFieldauthor,
                              new XYConstraints(182, 89, 133, 24));
    this.getContentPane().add(jTextFieldaddress,
                              new XYConstraints(181, 119, 134, 27));
    this.getContentPane().add(jTextFieldpressdate,
                              new XYConstraints(179, 163, 137, 21));
    this.getContentPane().add(jTextFieldprice,
                              new XYConstraints(177, 202, 139, 27));
    this.getContentPane().add(jTextFieldcomment,
                              new XYConstraints(178, 239, 137, 23));
    this.getContentPane().add(jButtonClear, new XYConstraints(67, 294, 66, 28));
    this.getContentPane().add(jButtonAdd, new XYConstraints(173, 294, -1, 28));
    this.getContentPane().add(jButtonExit, new XYConstraints(293, 294, 66, 27));
  }

//退出本窗口
  void jButtonExit_mouseClicked(MouseEvent e) {
    this.dispose();
  }

  //清空文本框
  void jButtonClear_mouseClicked(MouseEvent e) {
    jTextFieldname.setText("");
    jTextFieldpress.setText("");
    jTextFieldauthor.setText("");
    jTextFieldaddress.setText("");
    jTextFieldpressdate.setText("");
    jTextFieldprice.setText("");
    jTextFieldcomment.setText("");
  }

//添加一條新記錄
  void jButtonAdd_mouseClicked(MouseEvent e) {
    //校驗書名是否為空
    if (jTextFieldname.getText().trim().equals("")) {
      JOptionPane.showMessageDialog(null, "書名不許為空！");
      return;
    }
    //校驗作者是否為空
    if (jTextFieldauthor.getText().trim().equals("")) {
      JOptionPane.showMessageDialog(null, "作者不許為空！");
      return;
    }
    //校驗出版社是否為空
    if (jTextFieldpress.getText().trim().equals("")) {
      JOptionPane.showMessageDialog(null, "出版社不許為空！");
      return;
    }
    //校驗價格是否為空
    if (jTextFieldprice.getText().trim().equals("")) {
      JOptionPane.showMessageDialog(null, "價格不許為空！");
      return;
    }

    String strSQL;
    //生成sql操作語句
    strSQL =
        "insert into  Books(Bookname,Press,Author,Address,Pressdate,Price,Comment) ";
    strSQL = strSQL + "values('" + jTextFieldname.getText().trim() + "','" +
        jTextFieldpress.getText().trim() + "',";
    strSQL = strSQL + " '" + jTextFieldauthor.getText().trim() + "','" +
        jTextFieldaddress.getText().trim() + "',";
    strSQL = strSQL + " '" + jTextFieldpressdate.getText().trim() + "','" +
        jTextFieldprice.getText().trim() + "',";
    strSQL = strSQL + " '" + jTextFieldcomment.getText().trim() + "')";
    //由數據庫操作對象執行數據庫操作，并返回操作成功失敗的提示信息
    if (db.executeSql(strSQL)) {
      JOptionPane.showMessageDialog(null, "成功添加！");
    }
    else {
      JOptionPane.showMessageDialog(null, " 添加失敗，請重新操作！");
    }
  }

  class bookAdd_jButtonExit_mouseAdapter
      extends java.awt.event.MouseAdapter {
    bookAdd adaptee;

    bookAdd_jButtonExit_mouseAdapter(bookAdd adaptee) {
      this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
      adaptee.jButtonExit_mouseClicked(e);
    }
  }

  class bookAdd_jButtonClear_mouseAdapter
      extends java.awt.event.MouseAdapter {
    bookAdd adaptee;

    bookAdd_jButtonClear_mouseAdapter(bookAdd adaptee) {
      this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
      adaptee.jButtonClear_mouseClicked(e);
    }
  }

  class bookAdd_jButtonAdd_mouseAdapter
      extends java.awt.event.MouseAdapter {
    bookAdd adaptee;

    bookAdd_jButtonAdd_mouseAdapter(bookAdd adaptee) {
      this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
      adaptee.jButtonAdd_mouseClicked(e);
    }
  }
}

class bookAdd_jButtonClear_mouseAdapter
    extends java.awt.event.MouseAdapter {
  bookAdd adaptee;

  bookAdd_jButtonClear_mouseAdapter(bookAdd adaptee) {
    this.adaptee = adaptee;
  }

  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonClear_mouseClicked(e);
  }
}

class bookAdd_jButtonExit_mouseAdapter
    extends java.awt.event.MouseAdapter {
  bookAdd adaptee;

  bookAdd_jButtonExit_mouseAdapter(bookAdd adaptee) {
    this.adaptee = adaptee;
  }

  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonExit_mouseClicked(e);
  }
}

class bookAdd_jButtonAdd_mouseAdapter
    extends java.awt.event.MouseAdapter {
  bookAdd adaptee;

  bookAdd_jButtonAdd_mouseAdapter(bookAdd adaptee) {
    this.adaptee = adaptee;
  }

  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonAdd_mouseClicked(e);
  }
}