import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class BookModify extends JFrame implements ActionListener
{
	DataBaseManager db=new DataBaseManager();
	ResultSet rs;
	JPanel panel1,panel2,panel3;
	JLabel TipLabel=new JLabel("輸入書名點確定，將調出此書相關信息");
	JLabel BookNameLabel,PressNameLabel,
	       AuthorLabel,AddressLabel,
	       PressDateLabel,PriceLabel,CommentLabel;
	JTextField BookNameTextField,PressNameTextField,
	           AuthorTextField,AddressTextField,
	           PressDateTextField,PriceTextField,CommentTextField;
	Container c;
	JButton ClearBtn,YesBtn,UpdateBtn,ExitBtn;
	public BookModify()
	{
		super("修改書籍信息");
		c=getContentPane();
		c.setLayout(new BorderLayout());
		panel3=new JPanel();
		panel3.add(TipLabel);
		c.add(panel3,BorderLayout.NORTH);
		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);
		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);
		CommentTextField=new JTextField(15);
		panel1=new JPanel();
		panel1.setLayout(new GridLayout(7,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(CommentLabel);
		panel1.add(CommentTextField);
		panel2=new JPanel();
		panel2.setLayout(new GridLayout(1,4));
		ClearBtn=new JButton("清空");
		YesBtn=new JButton("確定");
		UpdateBtn=new JButton("更新");
		ExitBtn=new JButton("退出");
		panel2.add(ClearBtn);
		panel2.add(YesBtn);
		panel2.add(UpdateBtn);
		panel2.add(ExitBtn);
		ClearBtn.addActionListener(this);
		YesBtn.addActionListener(this);
		UpdateBtn.addActionListener(this);
		ExitBtn.addActionListener(this);
		UpdateBtn.setEnabled(false);
		c.add(panel1,BorderLayout.CENTER);
		c.add(panel2,BorderLayout.SOUTH);
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==ExitBtn)
		{
			this.dispose();
		}
		else if(e.getSource()==ClearBtn)
		{
			BookNameTextField.setText("");
		        PressNameTextField.setText("");
		        AuthorTextField.setText("");
		        AddressTextField.setText("");
		        PressDateTextField.setText("");
		        PriceTextField.setText("");
		        CommentTextField.setText("");
		}
		else if(e.getSource()==YesBtn)
		{
			try
			{
			String strSQL="select * from books where bookName='"+
			BookNameTextField.getText().trim()+"'";
			if(BookNameTextField.getText().trim().equals(""))
			{
				JOptionPane.showMessageDialog(null,"清輸入書名：<*v*>");
			}
			else if(!db.getResult(strSQL).first())
			{
				JOptionPane.showMessageDialog(null,"此書沒有在書庫中...");
			}
			else 
			{
				rs=db.getResult(strSQL);
				rs.first();
				BookNameTextField.setText(rs.getString(2));
		                PressNameTextField.setText(rs.getString(3));
		                AuthorTextField.setText(rs.getString(4));
		                AddressTextField.setText(rs.getString(5));
		                PressDateTextField.setText(rs.getString(6));
		                PriceTextField.setText(rs.getString(7));
		                CommentTextField.setText(rs.getString(8));
		                UpdateBtn.setEnabled(true);
			}
		        }
		        catch(NullPointerException upe)
		        {
		        	System.out.println(upe.toString());
		        }
		        catch(SQLException sqle)
			{
				System.out.println(sqle.toString());
			}
			catch(Exception ex)
			{
				System.out.println(ex.toString());
			}
		}
		else if(e.getSource()==UpdateBtn)
		{
			try
			{
			String strSQL="update books set bookName='"+
			BookNameTextField.getText().trim()+"',press='"+
			PressNameTextField.getText().trim()+"',author='"+
			AuthorTextField.getText().trim()+"',address='"+
			AddressTextField.getText().trim()+"',pressDate=TO_DATE('"+
			PressDateTextField.getText().trim()+"',),price='"+
			PriceTextField.getText().trim()+"',com='"+
			CommentTextField.getText().trim()+"'";
			if(db.updateSql(strSQL))
			{
				JOptionPane.showMessageDialog(null,"更新書籍信息成功！");
				db.closeConnection();
				this.dispose();
			}
			else
			{
				JOptionPane.showMessageDialog(null,"更新書籍信息失??！");
				db.closeConnection();
				this.dispose();
			}
		        }
			catch(Exception ex)
			{
				System.out.println(ex.toString());
			}
		}
	}
}