import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import javax.swing.table.*;
import java.util.Vector;
public class BorrowBookList extends JFrame implements ActionListener
{
	DataBaseManager db=new DataBaseManager();
	ResultSet rs;
	Container c;
	JPanel panel1,panel2;
	JLabel BookNameLabel,StudentNameLabel;
	JTextField BookNameTextField,StudentNameTextField;
	JButton SearchBtn,ExitBtn;
	JTable table=null;
	DefaultTableModel defaultModel=null;
	public BorrowBookList()
	{
		super("書籍借閱一覽！");
		c=getContentPane();
		c.setLayout(new BorderLayout());
		BookNameLabel=new JLabel("書名   ",JLabel.CENTER);
		StudentNameLabel=new JLabel("借閱者",JLabel.CENTER);
		BookNameTextField=new JTextField(15);
		StudentNameTextField=new JTextField(15);
		SearchBtn=new JButton("查詢");
		ExitBtn=new JButton("退出");
		SearchBtn.addActionListener(this);
		ExitBtn.addActionListener(this);
		Box box1=Box.createHorizontalBox();
		box1.add(StudentNameLabel);
		box1.add(StudentNameTextField);
		box1.add(SearchBtn);
		Box box2=Box.createHorizontalBox();
		box2.add(BookNameLabel);
		box2.add(BookNameTextField);
		box2.add(ExitBtn);
		Box boxH=Box.createVerticalBox();
		boxH.add(box1);
		boxH.add(box2);
		boxH.add(Box.createVerticalGlue());
		panel1=new JPanel();
		panel1.add(boxH);
		panel2=new JPanel();
		String[] name={"借閱者","書名","借閱日期","還入日期","備注"};
		String[][] data=new String[0][0];
		defaultModel=new DefaultTableModel(data,name);
		table=new JTable(defaultModel);
		table.setPreferredScrollableViewportSize(new Dimension(400,80));
		JScrollPane s=new JScrollPane(table);
		panel2.add(s);
		c.add(panel1,BorderLayout.NORTH);
		c.add(panel2,BorderLayout.SOUTH);
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==ExitBtn)
	        {
		    db.closeConnection();
		    this.dispose();
	        } 
	        else if(e.getSource()==SearchBtn)
	        {
	        	String strSQL="select studentname,bookname,borrowdate,returndate,com from bookbrowse";
	        	String strSql=null;
	        	if(StudentNameTextField.getText().trim().equals("")&&
	        	   BookNameTextField.getText().trim().equals(""))
	        	 {
	        	 	strSql=strSQL;
	        	 }
	        	 else if(StudentNameTextField.getText().trim().equals(""))
	        	 {
	        	 	strSql=strSQL+" where bookName='"+
	        	 	BookNameTextField.getText().trim()+"'";
	        	}
	        	else if(BookNameTextField.getText().trim().equals(""))
	        	{
	        		strSql=strSQL+" where studentName='"+
	        		StudentNameTextField.getText().trim()+"'";
	        	}
	        	else
	        	{
	        		strSql=strSQL+" where studentName='"+
	        		StudentNameTextField.getText().trim()+"'and bookName='"+
	        		BookNameTextField.getText().trim()+"'";
	        	}
	        	try
		{
	        //首先要刪除table中的數據先：
	        int rowCount=defaultModel.getRowCount()-1;//取得table中的數據行；
	        int j=rowCount;
	        for(int i=0;i<=rowCount;i++)
	        {
	        	defaultModel.removeRow(j);//刪除rowCount行的數據；
	        	defaultModel.setRowCount(j);//重新設置行數；
	        	j=j-1;
	        }
		rs=db.getResult(strSql);
		while(rs.next())
		{
			Vector data=new Vector();
			data.addElement(rs.getString(1));
			data.addElement(rs.getString(2));
			data.addElement(rs.getString(3));
			data.addElement(rs.getString(4));
			data.addElement(rs.getString(5));
			defaultModel.addRow(data);
		}
		table.revalidate();
	}
	catch(SQLException sqle)
		{
			System.out.println(sqle.toString());
		}
	catch(Exception ex)
		{
			System.out.println(ex.toString());
		}
	        }
	}
}