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;
	JTextField BorrowedBookStudentTextField,
	           BorrowedDateTextField,BorrowedCommentTextField;
	JButton ClearBtn,YesBtn,CancelBtn;
	JComboBox BookNameComboBox=new JComboBox();
	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);
		BorrowedBookStudentTextField=new JTextField(15);
		BorrowedDateTextField=new JTextField(15);
		BorrowedCommentTextField=new JTextField(15);
		try
		{
			String strSQL="select bookName from books where books_count>borrowed_count"; 
			rs=db.getResult(strSQL);
			while(rs.next())
			{
				BookNameComboBox.addItem(rs.getString(1));
			}
		}
		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(BookNameComboBox);
		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,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("");
		
		}
		else if(e.getSource()==YesBtn)
		{
			if(BorrowedBookStudentTextField.getText().trim().equals(""))
			{
				JOptionPane.showMessageDialog(null,"請輸入借閱者的姓名。。。");
			}
			else if(BookNameComboBox.getSelectedItem().equals(""))
			{
				JOptionPane.showMessageDialog(null,"對不起，現(xiàn)在書庫里沒有書，\n你現(xiàn)在不能借書!");
			}
			else
			{
				try
				{
				String strSQL="insert into bookBrowse(id,studentname,bookname,borrowdate,returndate,com) values(Id_browse_sequence.nextval,'"+
				BorrowedBookStudentTextField.getText().trim()+"','"+BookNameComboBox.getSelectedItem()+"',TO_DATE('"+
				BorrowedDateTextField.getText().trim()+"'),TO_DATE(''),'"+
				BorrowedCommentTextField.getText().trim()+"')";
				if(db.updateSql(strSQL))
				{
					JOptionPane.showMessageDialog(null,"借閱完成！");
					strSQL="update books set borrowed_count=borrowed_count+1 where bookname='"+
					BorrowedBookStudentTextField.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());
		}
			}
		}
		
	}
}