import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class BookAdd extends JFrame implements ActionListener
{
	DataBaseManager db=new DataBaseManager();
	ResultSet rs;
	JPanel panel1,panel2;
	JLabel BookNameLabel,PressNameLabel,
	       AuthorLabel,AddressLabel,
	       PressDateLabel,PriceLabel,BookCountLabel,CommentLabel;
	JTextField BookNameTextField,PressNameTextField,
	           AuthorTextField,AddressTextField,
	           PressDateTextField,PriceTextField,BookCountTextField,CommentTextField;
	Container c;
	JButton ClearBtn,AddBtn,ExitBtn;
	public BookAdd()
	{
		super("添加書籍信息");
		c=getContentPane();
		c.setLayout(new BorderLayout());
		BookNameLabel=new JLabel("名稱",JLabel.CENTER);
		PressNameLabel=new JLabel("出版社",JLabel.CENTER);
		AuthorLabel=new JLabel("作者",JLabel.CENTER);
		AddressLabel=new JLabel("地址",JLabel.CENTER);
		PressDateLabel=new JLabel("出版日期",JLabel.CENTER);
		PriceLabel=new JLabel("價格",JLabel.CENTER);
		BookCountLabel=new JLabel("新書數目",JLabel.CENTER);
		CommentLabel=new JLabel("備注",JLabel.CENTER);
		BookNameTextField=new JTextField(15);
		PressNameTextField=new JTextField(15);
		AuthorTextField=new JTextField(15);
		AddressTextField=new JTextField(15);
		PressDateTextField=new JTextField(15);
		PriceTextField=new JTextField(15);
		BookCountTextField=new JTextField(15);
		CommentTextField=new JTextField(15);
		panel1=new JPanel();
		panel1.setLayout(new GridLayout(8,2));
		panel1.add(BookNameLabel);
		panel1.add(BookNameTextField);
		panel1.add(PressNameLabel);
		panel1.add(PressNameTextField);
		panel1.add(AuthorLabel);
		panel1.add(AuthorTextField);
		panel1.add(AddressLabel);
		panel1.add(AddressTextField);
		panel1.add(PressDateLabel);
		panel1.add(PressDateTextField);
		panel1.add(PriceLabel);
		panel1.add(PriceTextField);
		panel1.add(BookCountLabel);
		panel1.add(BookCountTextField);
		panel1.add(CommentLabel);
		panel1.add(CommentTextField);
		panel2=new JPanel();
		panel2.setLayout(new GridLayout(1,3));
		ClearBtn=new JButton("清空");
		ClearBtn.addActionListener(this);
		AddBtn=new JButton("添加");
		AddBtn.addActionListener(this);
		ExitBtn=new JButton("退出");
		ExitBtn.addActionListener(this);
		panel2.add(ClearBtn);
		panel2.add(AddBtn);
		panel2.add(ExitBtn);
		c.add(panel1,BorderLayout.CENTER);
		c.add(panel2,BorderLayout.SOUTH);
		
		
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==ExitBtn)
		{
			db.closeConnection();
			this.dispose();
		}
		else if(e.getSource()==ClearBtn)
		{
		BookNameTextField.setText("");
		PressNameTextField.setText("");
		AuthorTextField.setText("");
		AddressTextField.setText("");
		PressDateTextField.setText("");
		PriceTextField.setText("");
		BookCountTextField.setText("");
		CommentTextField.setText("");
		}
		else if(e.getSource()==AddBtn)
		{
			if(BookNameTextField.getText().trim().equals(""))
			{
				JOptionPane.showMessageDialog(null,"書名不能為空！");
			}
			else if(PressNameTextField.getText().trim().equals(""))
			{
				JOptionPane.showMessageDialog(null,"出版社不能為空！");
			}
			else if(AuthorTextField.getText().trim().equals(""))
			{
				JOptionPane.showMessageDialog(null,"作者不能為空！");
			}
			else if(BookCountTextField.getText().trim().equals(""))
			{
				JOptionPane.showMessageDialog(null,"新書數目不能為空！");
			}
			else
			{
				try
				{
					String strSQL="insert into books(id,bookname,press,author,address,pressDate,price,books_count,com) values(ID_sequence.nextval,'"+
					BookNameTextField.getText().trim()+"','"+
					PressNameTextField.getText().trim()+"','"+
					AuthorTextField.getText().trim()+"','"+
					AddressTextField.getText().trim()+"',TO_DATE('"+
					PressDateTextField.getText().trim()+"'),'"+
					PriceTextField.getText().trim()+"','"+
					BookCountTextField.getText().trim()+"','"+
					CommentTextField.getText().trim()+"')";
					if(db.updateSql(strSQL))
					{
						JOptionPane.showMessageDialog(null,"添加書籍成功！");
						this.dispose();
					}
					else
					{
						JOptionPane.showMessageDialog(null,"添加書籍失敗！");
						this.dispose();
					}
					db.closeConnection();
				}
			        catch(Exception ex)
			        {
				      System.out.println(ex.toString());
			        }
			}
				
		}
	}
}