import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;

public class BookAdd
    extends JFrame
    implements ActionListener {
  DataBaseManager db = new DataBaseManager();
  ResultSet rs;
  JPanel panel1, panel2;
  JLabel BookNameLabel, PressNameLabel,
      AuthorLabel, AddressLabel,
      PressDateLabel, PriceLabel, BookCountLabel, CommentLabel;
  JTextField BookNameTextField, PressNameTextField,
      AuthorTextField, AddressTextField,
      PressDateTextField, PriceTextField, BookCountTextField, CommentTextField;
  Container c;
  JButton ClearBtn, AddBtn, ExitBtn;
  public BookAdd() {
    super("添加書籍信息");
    c = getContentPane();
    c.setLayout(new BorderLayout());
    BookNameLabel = new JLabel("名稱", JLabel.CENTER);
    PressNameLabel = new JLabel("出版社", JLabel.CENTER);
    AuthorLabel = new JLabel("作者", JLabel.CENTER);
    AddressLabel = new JLabel("地址", JLabel.CENTER);
    PressDateLabel = new JLabel("出版日期", JLabel.CENTER);
    PriceLabel = new JLabel("價格", JLabel.CENTER);
    BookCountLabel = new JLabel("新書數目", JLabel.CENTER);
    CommentLabel = new JLabel("備注", JLabel.CENTER);
    BookNameTextField = new JTextField(15);
    PressNameTextField = new JTextField(15);
    AuthorTextField = new JTextField(15);
    AddressTextField = new JTextField(15);
    PressDateTextField = new JTextField(15);
    PriceTextField = new JTextField(15);
    BookCountTextField = new JTextField(15);
    CommentTextField = new JTextField(15);
    panel1 = new JPanel();
    panel1.setLayout(new GridLayout(8, 2));
    panel1.add(BookNameLabel);
    panel1.add(BookNameTextField);
    panel1.add(PressNameLabel);
    panel1.add(PressNameTextField);
    panel1.add(AuthorLabel);
    panel1.add(AuthorTextField);
    panel1.add(AddressLabel);
    panel1.add(AddressTextField);
    panel1.add(PressDateLabel);
    panel1.add(PressDateTextField);
    panel1.add(PriceLabel);
    panel1.add(PriceTextField);
    panel1.add(BookCountLabel);
    panel1.add(BookCountTextField);
    panel1.add(CommentLabel);
    panel1.add(CommentTextField);
    panel2 = new JPanel();
    panel2.setLayout(new GridLayout(1, 3));
    ClearBtn = new JButton("清空");
    ClearBtn.addActionListener(this);
    AddBtn = new JButton("添加");
    AddBtn.addActionListener(this);
    ExitBtn = new JButton("退出");
    ExitBtn.addActionListener(this);
    panel2.add(ClearBtn);
    panel2.add(AddBtn);
    panel2.add(ExitBtn);
    c.add(panel1, BorderLayout.CENTER);
    c.add(panel2, BorderLayout.SOUTH);

  }

  public void actionPerformed(ActionEvent e) {
    if (e.getSource() == ExitBtn) {
      db.closeConnection();
      this.dispose();
    }
    else if (e.getSource() == ClearBtn) {
      BookNameTextField.setText("");
      PressNameTextField.setText("");
      AuthorTextField.setText("");
      AddressTextField.setText("");
      PressDateTextField.setText("");
      PriceTextField.setText("");
      BookCountTextField.setText("");
      CommentTextField.setText("");
    }
    else if (e.getSource() == AddBtn) {
      if (BookNameTextField.getText().trim().equals("")) {
        JOptionPane.showMessageDialog(null, "書名不能為空！");
      }
      else if (PressNameTextField.getText().trim().equals("")) {
        JOptionPane.showMessageDialog(null, "出版社不能為空！");
      }
      else if (AuthorTextField.getText().trim().equals("")) {
        JOptionPane.showMessageDialog(null, "作者不能為空！");
      }
      else if (BookCountTextField.getText().trim().equals("")) {
        JOptionPane.showMessageDialog(null, "新書數目不能為空！");
      }
      else {
        try {
          String strSQL = "insert into books(id,bookname,press,author,address,pressDate,price,books_count,com) values(ID_sequence.nextval,'" +
              BookNameTextField.getText().trim() + "','" +
              PressNameTextField.getText().trim() + "','" +
              AuthorTextField.getText().trim() + "','" +
              AddressTextField.getText().trim() + "',TO_DATE('" +
              PressDateTextField.getText().trim() + "'),'" +
              PriceTextField.getText().trim() + "','" +
              BookCountTextField.getText().trim() + "','" +
              CommentTextField.getText().trim() + "')";
          if (db.updateSql(strSQL)) {
            JOptionPane.showMessageDialog(null, "添加書籍成功！");
            this.dispose();
          }
          else {
            JOptionPane.showMessageDialog(null, "添加書籍失敗！");
            this.dispose();
          }
          db.closeConnection();
        }
        catch (Exception ex) {
          System.out.println(ex.toString());
        }
      }

    }
  }
}