package src;

import db.Service;

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

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

public class AddPanel extends JPanel 
{
	JLabel bookNumber=new JLabel("書號");
	JLabel bookName=new JLabel("書名");
	JLabel writer=new JLabel("作者");
	JLabel publisher=new JLabel("出版社");
	JLabel publishDate=new JLabel("出版時間");
	
	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 AddPanel()
	{
		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 insertSql="insert into book (sh,sm,zz,cbs,cbsj) values('"+tbookNumber.getText()+"'," +
						"'"+tbookName.getText()+"'," +
						"'"+twriter.getText()+"'," +
						"'"+tpublisher.getText()+"'," +
						"'"+tpublishDate.getText()+"')";
				try 
				{
					Service.execute(insertSql, 1, -1);
					JOptionPane.showMessageDialog(null,"保存成功","提示信息",JOptionPane.INFORMATION_MESSAGE);
				} 
				catch (ClassNotFoundException e) 
				{
					System.out.println("未找到驅動");
				} 
				catch (SQLException e)
				{
					System.out.println("數據庫訪問異常");
				}
			}
		});
	}
}