package src;

import java.awt.GridLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.SQLException;
import java.util.List;

import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JTextField;
import javax.swing.JTabbedPane;

import db.Service;

public class SearchConditionPanel extends JPanel 
{
	JLabel bookNumber=new JLabel("書(shū)號(hào)");
	JLabel bookName=new JLabel("書(shū)名");
	JLabel writer=new JLabel("作者");
	JLabel publisher=new JLabel("出版社");
	JLabel publishDate=new JLabel("出版時(shí)間");
	
	JTextField  tbookNumber=new JTextField(20);
	JTextField  tbookName=new JTextField(20);
	JTextField  twriter=new JTextField(20);
	JTextField  tpublisher=new JTextField(20);
	JTextField  tpublishDate=new JTextField(20);
	JButton submit=new JButton("檢索");
	
	JPanel pbookNumber=new JPanel();
	JPanel pbookName=new JPanel();
	JPanel pwriter=new JPanel();
	JPanel ppublisher=new JPanel();
	JPanel ppublishDate=new JPanel();
	JPanel psubmit=new JPanel();
	public SearchConditionPanel()
	{
		pbookNumber.add(bookNumber);
		pbookNumber.add(tbookNumber);
		pbookName.add(bookName);
		pbookName.add(tbookName);
		pwriter.add(writer);
		pwriter.add(twriter);
		ppublisher.add(publisher);
		ppublisher.add(tpublisher);
		ppublishDate.add(publishDate);
		ppublishDate.add(tpublishDate);
		psubmit.add(submit);
		
		this.setLayout(new GridLayout(6,1));
		this.add(pbookNumber);
		this.add(pbookName);
		this.add(pwriter);
		this.add(ppublisher);
		this.add(ppublishDate);
		this.add(psubmit);
		
		submit.addActionListener(new ActionListener()
		{
			public void actionPerformed(ActionEvent event)
			{
				String selectSql="select * from book where sh like '%"+tbookNumber.getText()+"%' and " +
						"sm like '%"+tbookName.getText()+"%' and " +
						"zz like '%"+twriter.getText()+"%' and " +
						"cbs like '%"+tpublisher.getText()+"%' and " +
						"cbsj like '%"+tpublishDate.getText()+"%'";
				try 
				{
						List result=Service.execute(selectSql, 1, -1);
						JTabbedPane tab=(JTabbedPane)pbookNumber.getParent().getParent();
						if(tab.getComponentCount()==3)
						{
							tab.remove(2);
						}
						tab.add("檢索結(jié)果", new SearchResultPanel(new SearchResultModel(null,result)));
				} 
				catch (ClassNotFoundException e) 
				{
					System.out.println("未找到驅(qū)動(dòng)");
					e.printStackTrace();
				} 
				catch (SQLException e)
				{
					System.out.println("數(shù)據(jù)庫(kù)訪問(wèn)異常");
					e.printStackTrace();
				}
			}
		});
	}
}