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.*;
import javax.swing.table.*;

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

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

  private void jbInit() throws Exception {
    this.getContentPane().setLayout(null);
    jLabel1.setText("學號：");
    jLabel1.setBounds(new Rectangle(42, 19, 48, 20));
    jButtonBorrowAlert.setBounds(new Rectangle(221, 16, 66, 23));
    jButtonBorrowAlert.setText("確定");
    jButtonBorrowAlert.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButtonBorrowAlert_actionPerformed(e);
      }
    });
    this.setTitle("借書");
    name.setEditable(false);
    name.setBounds(new Rectangle(108, 54, 93, 20));
    jLabel2.setText("姓名：");
    jLabel2.setBounds(new Rectangle(42, 54, 48, 20));
    jLabel3.setText("類型：");
    jLabel3.setBounds(new Rectangle(219, 56, 42, 15));
    type.setEditable(false);
    type.setBounds(new Rectangle(269, 54, 93, 20));
    jLabel4.setText("性別：");
    jLabel4.setBounds(new Rectangle(42, 90, 42, 15));
    jRadioButtonMale.setText("男");
    jRadioButtonMale.setBounds(new Rectangle(108, 90, 46, 23));
    jRadioButtonFemale.setText("女");
    jRadioButtonFemale.setBounds(new Rectangle(153, 90, 46, 23));
    jLabel5.setText("年級：");
    jLabel5.setBounds(new Rectangle(219, 88, 42, 15));
    jTextFieldGrade.setEditable(false);
    jTextFieldGrade.setBounds(new Rectangle(269, 90, 93, 20));
    jLabel6.setText("學院：");
    jLabel6.setBounds(new Rectangle(42, 120, 42, 15));
    jTextFieldXueYuan.setEditable(false);
    jTextFieldXueYuan.setBounds(new Rectangle(108, 120, 93, 20));
    jLabel7.setText("專業：");
    jLabel7.setBounds(new Rectangle(219, 120, 42, 15));
    jTextFieldZhuanYe.setEditable(false);
    jTextFieldZhuanYe.setBounds(new Rectangle(269, 120, 93, 20));
    jLabel8.setText("欠款：");
    jLabel8.setBounds(new Rectangle(42, 150, 42, 15));
    jTextFieldMoney.setEditable(false);
    jTextFieldMoney.setBounds(new Rectangle(108, 150, 93, 20));
    jLabel9.setText("卡狀態：");
    jLabel9.setBounds(new Rectangle(219, 150, 56, 20));
    jCheckBoxGuaQi.setText("有無掛起");
    jCheckBoxGuaQi.setBounds(new Rectangle(269, 150, 93, 23));
    jScrollPane1.setBounds(new Rectangle(2, 231, 403, 210));
    jTextFieldXueHao.setBounds(new Rectangle(108, 19, 93, 20));
    jTextFieldXueHao.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButtonBorrowAlert_actionPerformed(e);
      }
    });
    jLabel10.setText("ISBN:");
    jLabel10.setBounds(new Rectangle(18, 194, 39, 16));
    jTextFieldBorrowISBN.setText("");
    jTextFieldBorrowISBN.setBounds(new Rectangle(49, 192, 115, 22));
    jLabel11.setText("tag:");
    jLabel11.setBounds(new Rectangle(165, 195, 39, 16));
    jTextFieldtag.setText("");
    jTextFieldtag.setBounds(new Rectangle(187, 192, 44, 22));
    jTextFieldtag.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButtonBack_actionPerformed(e);
      }
    });
    jButtonBorrow.setBounds(new Rectangle(241, 190, 58, 25));
    jButtonBorrow.setEnabled(false);
    jButtonBorrow.setText("借書");
    jButtonBorrow.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButtonBorrow_actionPerformed(e);
      }
    });
    jButtonBack.setBounds(new Rectangle(311, 191, 62, 25));
    jButtonBack.setEnabled(false);
    jButtonBack.setDoubleBuffered(true);
    jButtonBack.setText("還書");
    jButtonBack.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButtonBack_actionPerformed(e);
      }
    });
    jButton1.setBounds(new Rectangle(307, 15, 66, 23));
    jButton1.setText("取消");
    jButton1.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButton1_actionPerformed(e);
      }
    });
    this.getContentPane().add(jLabel4);
    this.getContentPane().add(jTextFieldGrade);
    this.getContentPane().add(jRadioButtonMale);
    this.getContentPane().add(jLabel7);
    this.getContentPane().add(jTextFieldZhuanYe);
    this.getContentPane().add(jLabel6);
    this.getContentPane().add(jTextFieldXueYuan);
    this.getContentPane().add(jCheckBoxGuaQi);
    this.getContentPane().add(jLabel8);
    this.getContentPane().add(jTextFieldMoney);
    this.getContentPane().add(jLabel9);
    this.getContentPane().add(jRadioButtonFemale);
    this.getContentPane().add(jLabel5);
    this.getContentPane().add(jLabel3);
    this.getContentPane().add(type);
    this.getContentPane().add(jTextFieldXueHao);
    this.getContentPane().add(name);
    this.getContentPane().add(jLabel1);
    this.getContentPane().add(jLabel2);
    this.getContentPane().add(jScrollPane1);
    this.getContentPane().add(jTextFieldBorrowISBN, null);
    this.getContentPane().add(jTextFieldtag, null);
    this.getContentPane().add(jButtonBorrow, null);
    jScrollPane1.getViewport().add(jTable1);
    buttonGroup1.add(jRadioButtonMale);
    buttonGroup1.add(jRadioButtonFemale);
    this.getContentPane().add(jButtonBack, null);
    this.getContentPane().add(jLabel10, null);
    this.getContentPane().add(jLabel11, null);
    this.getContentPane().add(jButtonBorrowAlert);
    this.getContentPane().add(jButton1);
  }

  JLabel jLabel1 = new JLabel();
  JTextField jTextFieldXueHao = new JTextField();
  JButton jButtonBorrowAlert = new JButton();
  JLabel jLabel2 = new JLabel();
  JTextField name = new JTextField();
  JLabel jLabel3 = new JLabel();
  JTextField type = new JTextField();
  JLabel jLabel4 = new JLabel();
  ButtonGroup buttonGroup1 = new ButtonGroup();
  JRadioButton jRadioButtonMale = new JRadioButton();
  JRadioButton jRadioButtonFemale = new JRadioButton();
  JLabel jLabel5 = new JLabel();
  JTextField jTextFieldGrade = new JTextField();
  JLabel jLabel6 = new JLabel();
  JTextField jTextFieldXueYuan = new JTextField();
  JLabel jLabel7 = new JLabel();
  JTextField jTextFieldZhuanYe = new JTextField();
  JLabel jLabel8 = new JLabel();
  JTextField jTextFieldMoney = new JTextField();
  JLabel jLabel9 = new JLabel();
  JCheckBox jCheckBoxGuaQi = new JCheckBox();
  JScrollPane jScrollPane1 = new JScrollPane();
  JTable jTable1 = new JTable();
  JLabel jLabel10 = new JLabel();
  JTextField jTextFieldBorrowISBN = new JTextField();
  JLabel jLabel11 = new JLabel();
  JTextField jTextFieldtag = new JTextField();
  JButton jButtonBorrow = new JButton();
  JButton jButtonBack = new JButton();

  ResultSet rs;
  ResultSet rs1;
  //定義數據庫操作對象
  private DBManager db = new DBManager();
  private DBManager db1 = new DBManager();
  String strSQL="";
  String xh="";
  DefaultTableModel model=null;
  JButton jButton1 = new JButton();
  boolean bcq=false;
  int bookNumOfChaoqi=0;

  /**
   * 按下確定后，顯示該學生的基本信息
   * @param e ActionEvent
   */
  public void jButtonBorrowAlert_actionPerformed(ActionEvent e) {

    xh=jTextFieldXueHao.getText().trim();

    if(xh.equals("")){
      JOptionPane.showMessageDialog(this, " 學號不能為空！");
      return;
    }
    jButtonBorrow.setEnabled(true);
    strSQL="select * from buser where xuehao='"+xh+"'";
    rs = db.getResult(strSQL);
    boolean isexist = false;
    try {
      isexist = rs.first();
    }
    catch (SQLException ex1) {
    }
    if(!isexist){
      JOptionPane.showMessageDialog(this, " 沒有這個學生！");
      return;
    }
    try{
      name.setText(rs.getString("name"));
      type.setText(rs.getString("type"));
      if(rs.getString("sex").equals("男")){
        jRadioButtonMale.setSelected(true);
        jRadioButtonFemale.setSelected(false);
      }
      else{
        jRadioButtonMale.setSelected(false);
        jRadioButtonFemale.setSelected(true);
      }
      jTextFieldGrade.setText(rs.getString("grade").trim());
      jTextFieldXueYuan.setText(rs.getString("institute").trim());
      jTextFieldZhuanYe.setText(rs.getString("specialty").trim());
      jTextFieldMoney.setText(String.valueOf(rs.getFloat("penalty")));
      if(rs.getInt("hangUp")==1){
        jCheckBoxGuaQi.setSelected(true);
      }
      else{
        jCheckBoxGuaQi.setSelected(false);
      }
    }catch(Exception ee){
      ee.printStackTrace();
    }
    String titles[]={"書名","ISBN","索引號","借書日期","還書日期","超期天數"};
    model=new DefaultTableModel(titles,0);
    jTable1.setModel(model);
    strSQL="select ISBN,name,bookAdress,lendDate,returnDate, DATEDIFF(day,returnDate,getDate()) as 'chaoqi' from bookInfo_VIEW where xuehao='"+xh+"'";
    String [] record=new String[6];
     rs = db.getResult(strSQL);

     try{
       while(rs.next()){
         record[0]=rs.getString("name").trim();
         record[1]=rs.getString("ISBN").trim();
         record[2]=rs.getString("bookAdress").trim();
         record[3]=rs.getDate("lendDate").toString().trim();
         record[4]=rs.getDate("returnDate").toString().trim();
         record[5]=String.valueOf(rs.getInt("chaoqi"));
         if(rs.getInt("chaoqi")>0){
           bcq=true;
           bookNumOfChaoqi++;
         }
         model.addRow(record);
       }

     }catch(Exception el){
       el.printStackTrace();
     }