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

public class BorrowBook
    extends JFrame
    implements ActionListener {
  DataBaseManager db = new DataBaseManager();
  ResultSet rs;
  JPanel panel1, panel2;
  Container c;
  JLabel borrowedBookStudentLabel, borrowedBookNameLabel,
      borrowedDateLabel, borrowedCommentLabel,returnDateLabel;
  JTextField borrowedBookStudentTextField,borrowedBookNameTextField,
      borrowedDateTextField, borrowedCommentTextField,returnDateTextField;
  JButton clearBtn, yesBtn, cancelBtn;

  public BorrowBook() {
    super("書籍出借");
    c = getContentPane();
    c.setLayout(new BorderLayout());
    borrowedBookStudentLabel = new JLabel("借閱者姓名", JLabel.CENTER);
    borrowedBookNameLabel = new JLabel("書名", JLabel.CENTER);
    borrowedDateLabel = new JLabel("日期", JLabel.CENTER);
    borrowedCommentLabel = new JLabel("備注", JLabel.CENTER);
    returnDateLabel = new JLabel("歸還日期",JLabel.CENTER);
    borrowedBookStudentTextField = new JTextField(15);
    borrowedDateTextField = new JTextField(15);
    borrowedCommentTextField = new JTextField(15);
    borrowedBookNameTextField = new JTextField(15);
    returnDateTextField =new JTextField(15);
    try {
      String strSQL =
          "select bookName from books where books_count>borrowed_count";
      rs = db.getResult(strSQL);


    }
    catch (SQLException sqle) {
      System.out.println(sqle.toString());
    }
    catch (Exception ex) {
      System.out.println(ex.toString());
    }
    panel1 = new JPanel();
    panel1.setLayout(new GridLayout(4, 2));
    panel1.add(borrowedBookStudentLabel);
    panel1.add(borrowedBookStudentTextField);
    panel1.add(borrowedBookNameLabel);
    panel1.add(borrowedBookNameTextField);
    panel1.add(borrowedDateLabel);
    panel1.add(borrowedDateTextField);
    panel1.add(borrowedCommentLabel);
    panel1.add(borrowedCommentTextField);
    panel1.add(returnDateLabel);
    panel1.add(returnDateTextField);
    c.add(panel1, BorderLayout.CENTER);
    panel2 = new JPanel();
    panel2.setLayout(new GridLayout(1, 3));
    clearBtn = new JButton("清空");
    yesBtn = new JButton("確定");
    cancelBtn = new JButton("取消");
    clearBtn.addActionListener(this);
    yesBtn.addActionListener(this);
    cancelBtn.addActionListener(this);
    panel2.add(clearBtn);
    panel2.add(yesBtn);
    panel2.add(cancelBtn);
    c.add(panel2, BorderLayout.SOUTH);

  }

  public void actionPerformed(ActionEvent e){


    if (e.getSource() == cancelBtn) {
      this.dispose();
    }
    else if (e.getSource() == clearBtn) {
      borrowedBookStudentTextField.setText("");
      borrowedDateTextField.setText("");
      borrowedCommentTextField.setText("");
      borrowedBookNameTextField.setText("");
      returnDateTextField.setText("");

    }
    else if (e.getSource() == yesBtn) {
      if (borrowedBookStudentTextField.getText().trim().equals("")) {
        JOptionPane.showMessageDialog(null, "請輸入借閱者的姓名。。。");
      }
      else {
        try {    String strSQL0 =
              "select studentName,bookName,borrowDate,com from BookBrowse where  bookName='" +
              borrowedBookNameTextField.getText().trim() + "'  ";
          rs = db.getResult(strSQL0);

          if (!rs.first()) {
            JOptionPane.showMessageDialog(null, "對不起，現在書庫里沒有書，\n你現在不能借書!");
          }

          else {
            try {
              String strSQL = "insert into bookBrowse(studentname,bookname,borrowdate,returndate,com) values('" +
                  borrowedBookStudentTextField.getText().trim() + "','" +
                  borrowedBookNameTextField.getText().trim() + "','" +
                  borrowedDateTextField.getText().trim() + "','','" +
                  borrowedCommentTextField.getText().trim() + "')";
              if (db.updateSql(strSQL) > 0) {
                JOptionPane.showMessageDialog(null, "借閱完成！");
                strSQL =
                    "update books set borrowed_count=borrowed_count+1 where bookname='" +
                    borrowedBookNameTextField.getText().trim() + "'";
                db.updateSql(strSQL);
                db.closeConnection();
                this.dispose();
              }
              else {
                JOptionPane.showMessageDialog(null, "借閱失敗！");
                db.closeConnection();
                this.dispose();
              }
            }
            catch (Exception ex) {
              System.out.println(ex.toString());
            }
          }
        }
        catch (HeadlessException ex1) {
        }
        catch (SQLException ex1) {
        }
      }
    }

  }
}