import java.util.*;
import java.awt.*;
import java.io.*;
import java.net.*;
import java.sql.*;
import java.awt.event.*;
import javax.swing.*;
class Delbookfrm extends JFrame implements ActionListener
{
	JLabel l_bookname;
	JTextField t_bookname;
	JButton b_delbook,b_back;
	JPanel pan1,pan2,pan3;
	
	NetConn sql;
	Statement sqll;
	
	Delbookfrm()
	{
		
		l_bookname=new JLabel("輸入你要?jiǎng)h除的書(shū)籍的名稱(chēng)：");
		t_bookname=new JTextField("",10);
		b_delbook=new JButton("刪除");
		b_back=new JButton("返回");
		b_delbook.addActionListener(this);
		b_back.addActionListener(this);
		pan1=new JPanel();pan2=new JPanel();pan3=new JPanel();
	    pan1.add(l_bookname);pan2.add(t_bookname);pan3.add(b_delbook);pan3.add(b_back);
	    setLayout(new GridLayout(3,1));
	    add(pan1);add(pan2);add(pan3);
		setBounds(400,300,300,350);
		
		sql=new NetConn();
		
		
	}
	public void actionPerformed(ActionEvent ed)
	{
		if(ed.getSource()==b_delbook)
		{
			try
			{
			sqll=sql.connect();
			sqll.executeUpdate("delete from books where bookname="+"'"+t_bookname.getText()+"'");
			l_bookname.setText("書(shū)籍刪除成功");
			}
			catch(SQLException e6)
			{}
		}
		else if(ed.getSource()==b_back)
		{
			dispose();
		}
	}
}