import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.*;
import java.sql.*;

import javax.swing.*;
public class delet extends JFrame implements ActionListener {
	JTextField english;
	JButton ok,cancel;
	JLabel L1;
	
//	Connection  con=null;
//	Statement st=null;
	public delet()
	{
		super("޸");
		setSize(300,200);
		setVisible(true);
		setLocationRelativeTo(null);
		 setResizable(false);
		english=new JTextField(15);
		english.setForeground(Color.RED);
		
		
		JPanel p1=new JPanel();
		JPanel p2=new JPanel();
		L1=new JLabel("Ҫɾĵʣ");
	L1.setFont(new Font("",20,20));
	L1.setForeground(Color.RED);
	//L1.setBackground(Color.red);
	
	
		ok=new JButton("ȷ");
		cancel=new JButton("ȡ");
		p1.add(L1);
		p1.add(english);
         		p1.setBackground(Color.red);
		
		
		p2.add(ok);
		p2.add(cancel);
		ok.addActionListener(this);
		cancel.addActionListener(this);
		
		
		
		getContentPane().add(p1,"Center");
		getContentPane().add(p2,"South");
		this.validate();
	}
	public void actionPerformed(ActionEvent ee) {
		if(ee.getSource()==ok)
		{
			
			if(english.getText().equals(""))
			{
				JOptionPane.showMessageDialog(this, "ɾĵ!","ע ",JOptionPane.WARNING_MESSAGE );
			}
			
			
			else 
			{
				try
				{
					delete();
				}
				catch(SQLException p)
				{
					JOptionPane.showMessageDialog(this, "ݿʧܣ"+p.getMessage());
					
				}
			}
			
			
		}
		else if(ee.getSource()==cancel)
		{
			dispose();
		}
		
		
	}
	private void delete() throws SQLException{
		String cname,ename;
		try{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		   }
			catch(ClassNotFoundException e)
			{
			System.out.println("ForName:"+e.getMessage());
			}
			String conURL ="jdbc:odbc:TSDIC";
			Connection con=DriverManager.getConnection(conURL);
			Statement st=con.createStatement();
			ResultSet re=st.executeQuery("select * from Words");
			boolean boo=false;
			while((boo=re.next())==true)
			{
				ename=re.getString("");
				cname=re.getString("");
				if(ename.equals(english.getText()))
				{
					if(JOptionPane.showConfirmDialog(null,"ȷɾ")==JOptionPane.OK_OPTION)   
				    {
						
					
					String upd="delete from Words where ='"+english.getText()+"'";
					
					st.executeUpdate(upd);
					JOptionPane.showMessageDialog(this, "ɾɹ","ʾ",JOptionPane.WARNING_MESSAGE);
					
					dispose();
						break;
				    }
					else
					{
						break;
					}
				
						
				}
			}
			con.close();
			if(boo==false)
				
			{
				JOptionPane.showMessageDialog(this, "ɾĵʲڣ","ʾ",JOptionPane.WARNING_MESSAGE);
				
			}
		
	}
	

}
