package library.info;

import java.awt.BorderLayout;
import java.awt.Container;
import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.util.GregorianCalendar;
import java.util.List;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextField;

import library.hibernate.BookBrowse;
import library.main.HibernateUtil;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;

/**
 * 修改還書信息類
 * 
 * @author lianhw
 * 
 */
public class ReturnInfo extends JFrame implements ActionListener {

	JPanel panel1, panel2;

	Container container;

	JLabel tipLabel = new JLabel("輸入還書者姓名和書名點(diǎn)擊確定，將調(diào)出此書的相關(guān)信息");

	JLabel returnedBookStudentLabel, returnedBookNameLabel, returnedDateLabel,
			returnedCommentLabel;

	JTextField returnedBookStudentText, returnedBookNameText, returnedDateText,
			returnedCommentText;

	JButton clearButton, yesButton, updateButton, cancelButton;

	public ReturnInfo() {
		super("修改書籍還入信息");
		container = getContentPane();
		container.setLayout(new BorderLayout());
		container.add(tipLabel, BorderLayout.NORTH);
		// “還書者姓名”標(biāo)簽
		returnedBookStudentLabel = new JLabel("還書者姓名", JLabel.CENTER);
		// “書名”標(biāo)簽
		returnedBookNameLabel = new JLabel("書名", JLabel.CENTER);
		// “還書日期”標(biāo)簽
		returnedDateLabel = new JLabel("還書日期", JLabel.CENTER);
		// “備注”標(biāo)簽
		returnedCommentLabel = new JLabel("備注", JLabel.CENTER);
		// 輸入還書學(xué)生姓名文本框
		returnedBookStudentText = new JTextField(15);
		// 輸入還書名稱文本框
		returnedBookNameText = new JTextField(15);
		// 輸入還書日期文本框
		returnedDateText = new JTextField(15);
		// 輸入還書備注文本框
		returnedCommentText = new JTextField(15);
		panel1 = new JPanel();
		panel1.setLayout(new GridLayout(4, 2));
		panel1.add(returnedBookStudentLabel);
		panel1.add(returnedBookStudentText);
		panel1.add(returnedBookNameLabel);
		panel1.add(returnedBookNameText);
		panel1.add(returnedDateLabel);
		panel1.add(returnedDateText);
		panel1.add(returnedCommentLabel);
		panel1.add(returnedCommentText);
		container.add(panel1, BorderLayout.CENTER);
		panel2 = new JPanel();
		panel2.setLayout(new GridLayout(1, 4));
		// “清空”按鈕
		clearButton = new JButton("清空");
		// “確定”按鈕
		yesButton = new JButton("確定");
		// “更新”按鈕
		updateButton = new JButton("更新");
		// “取消”按鈕
		cancelButton = new JButton("取消");
		// 為“清空”按鈕添加監(jiān)聽者
		clearButton.addActionListener(this);
		// 為“確定”按鈕添加監(jiān)聽者
		yesButton.addActionListener(this);
		// 為“更新”按鈕添加監(jiān)聽者
		updateButton.addActionListener(this);
		updateButton.setEnabled(false);
		// 為“取消”按鈕添加監(jiān)聽者
		cancelButton.addActionListener(this);
		panel2.add(clearButton);
		panel2.add(yesButton);
		panel2.add(updateButton);
		panel2.add(cancelButton);
		container.add(panel2, BorderLayout.SOUTH);
	}

	/**
	 * 動(dòng)作響應(yīng)方法，將修改后的出借圖書信息提交到數(shù)據(jù)庫中
	 * 
	 * @see java.awt.event.ActionListener#actionPerformed(java.awt.event.ActionEvent)
	 */
	public void actionPerformed(ActionEvent action) {
		if (action.getSource() == clearButton) {
			// 單擊“清空”按鈕，清空所有的文本框
			returnedBookStudentText.setText("");
			returnedBookNameText.setText("");
			returnedDateText.setText("");
			returnedCommentText.setText("");
		} else if (action.getSource() == cancelButton) {
			// 單擊“退出”按鈕不作任何事情
			this.dispose();
		} else if (action.getSource() == yesButton) {
			// 取得SessionFactory
			SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
			// 打開session
			Session session = sessionFactory.openSession();
			// 創(chuàng)建一個(gè)事務(wù)
			Transaction tx = session.beginTransaction();
			// hsql執(zhí)行語句
			String hql = "from BookBrowse where studentName='"
					+ returnedBookStudentText.getText().trim()
					+ "'and bookName='" + returnedBookNameText.getText().trim()
					+ "'";
			// 執(zhí)行查詢
			Query userList = session.createQuery(hql);
			// 將查詢結(jié)果放置到一個(gè)list鏈表中
			List list = userList.list();
			BookBrowse browse = (BookBrowse) list.get(0);
			returnedBookStudentText.setText(browse.getStudentName());
			returnedBookNameText.setText(browse.getBookName());
			returnedDateText.setText(browse.getBorrowDate().toString());
			returnedCommentText.setText(browse.getCom());
			updateButton.setEnabled(true);
			// 事務(wù)提交
			tx.commit();
			// 關(guān)閉session
			session.close();

		} else if (action.getSource() == updateButton) {
			// 取得SessionFactory
			SessionFactory sessionFactory = HibernateUtil.getSessionFactory();
			// 打開session
			Session session = sessionFactory.openSession();
			// 創(chuàng)建一個(gè)事務(wù)
			Transaction tx = session.beginTransaction();
			BookBrowse browse2 = new BookBrowse();
			browse2.setBookName(returnedBookNameText.getText().trim());
			browse2.setStudentName(returnedBookStudentText.getText().trim());
			browse2.setBorrowDate(new GregorianCalendar().getTime());
			browse2.setCom(returnedCommentText.getText().trim());
			browse2.setReturnDate(new GregorianCalendar().getTime());
			session.saveOrUpdate(browse2);
			JOptionPane.showMessageDialog(null, "修改書籍成功！");
			// 事務(wù)提交
			tx.commit();
			// 關(guān)閉session
			session.close();

			this.dispose();

		}
	}
}