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

public class BorrowInfo
    extends JFrame
    implements ActionListener {
  DataBaseManager db = new DataBaseManager();
  ResultSet rs;
  JPanel panel1, panel2, panel3;
  Container c;
  JLabel TipLabel = new JLabel("輸入借閱者姓名和書(shū)名點(diǎn)擊確定，將調(diào)出此書(shū)的相關(guān)信息");
  JLabel BorrowedBookStudentLabel, BorrowedBookNameLabel,
      BorrowedDateLabel, BorrowedCommentLabel;
  JTextField BorrowedBookStudentTextField, BorrowedBookNameTextField,
      BorrowedDateTextField, BorrowedCommentTextField;
  JButton ClearBtn, YesBtn, UpdateBtn, CancelBtn;
  public BorrowInfo() {
    super("修改書(shū)籍出借信息");
    c = getContentPane();
    c.setLayout(new BorderLayout());
    panel3 = new JPanel();
    panel3.add(TipLabel);
    c.add(panel3, BorderLayout.NORTH);
    BorrowedBookStudentLabel = new JLabel("借閱者姓名", JLabel.CENTER);
    BorrowedBookNameLabel = new JLabel("書(shū)名", JLabel.CENTER);
    BorrowedDateLabel = new JLabel("借書(shū)日期", JLabel.CENTER);
    BorrowedCommentLabel = new JLabel("備注", JLabel.CENTER);
    BorrowedBookStudentTextField = new JTextField(15);
    BorrowedBookNameTextField = new JTextField(15);
    BorrowedDateTextField = new JTextField(15);
    BorrowedCommentTextField = new JTextField(15);
    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);
    c.add(panel1, BorderLayout.CENTER);
    panel2 = new JPanel();
    panel2.setLayout(new GridLayout(1, 4));
    ClearBtn = new JButton("清空");
    YesBtn = new JButton("確定");
    UpdateBtn = new JButton("更新");
    CancelBtn = new JButton("取消");
    ClearBtn.addActionListener(this);
    YesBtn.addActionListener(this);
    UpdateBtn.addActionListener(this);
    UpdateBtn.setEnabled(false);
    CancelBtn.addActionListener(this);
    panel2.add(ClearBtn);
    panel2.add(YesBtn);
    panel2.add(UpdateBtn);
    panel2.add(CancelBtn);
    c.add(panel2, BorderLayout.SOUTH);
  }

  public void actionPerformed(ActionEvent e) {
    if (e.getSource() == ClearBtn) {
      BorrowedBookStudentTextField.setText("");
      BorrowedBookNameTextField.setText("");
      BorrowedDateTextField.setText("");
      BorrowedCommentTextField.setText("");
    }
    else if (e.getSource() == CancelBtn) {
      this.dispose();
    }
    else if (e.getSource() == YesBtn) {
      try {
        String strSQL =
            "select studentName,bookName,borrowDate,com from BookBrowse where studentName='" +
            BorrowedBookStudentTextField.getText().trim() + "'and bookName='" +
            BorrowedBookNameTextField.getText().trim() + "'";
        rs = db.getResult(strSQL);
        if (!rs.first()) {
          JOptionPane.showMessageDialog(null, "此學(xué)生沒(méi)有借過(guò)書(shū)！或者沒(méi)有此書(shū)！");

        }
        else {
          BorrowedBookStudentTextField.setText(rs.getString(1).trim());
          BorrowedBookNameTextField.setText(rs.getString(2).trim());
          BorrowedDateTextField.setText(rs.getString(3).trim());
          BorrowedCommentTextField.setText(rs.getString(4).trim());
          UpdateBtn.setEnabled(true);

        }
      }
      catch (Exception ex) {
        System.out.println(ex.toString());
      }

    }
    else if (e.getSource() == UpdateBtn) {
      String strSQL = "update bookBrowse set borrowDate=TO_DATE('" +
          BorrowedDateTextField.getText().trim() + "'),com='" +
          BorrowedCommentTextField.getText().trim() + "' where studentName='" +
          BorrowedBookStudentTextField.getText().trim() + "'and bookName='" +
          BorrowedBookNameTextField.getText().trim() + "'";
      if (db.updateSql(strSQL)) {
        JOptionPane.showMessageDialog(null, "更新成功！");
        db.closeConnection();
        this.dispose();
      }
      else {
        JOptionPane.showMessageDialog(null, "更新失敗！");
        db.closeConnection();
        this.dispose();
      }
    }

  }
}