import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;

class DelWin extends JFrame implements ActionListener {
      
     JTextField 刪除單詞_文本條; 
     
     JButton delbtn,cancelbtn;
     
     Connection Con = null;
     
     Statement Stmt = null;
     
     DelWin()
     {
     	super("刪除單詞");
     	
     	this.setBounds(250,250,250,200);
     	
     	this.setVisible(true);
     	
     	JPanel p1 = new JPanel();
     	
     	p1.add(new Label("輸入要刪除的單詞:"));
     	
     	刪除單詞_文本條 = new JTextField(20);
     	
     	p1.add(刪除單詞_文本條);
     	     	     	
     	delbtn = new JButton("刪除");
     	
     	cancelbtn = new JButton("取消");
     	
     	p1.add(delbtn);p1.add(cancelbtn);
     	
     	this.add(p1);
     	
     	delbtn.addActionListener(this);
     	
     	cancelbtn.addActionListener(this);
     	
     	this.validate();
     	     	
     }
     
     
     public void actionPerformed(ActionEvent e)
     {
     	if(e.getSource()==delbtn)
     	{
     		if(刪除單詞_文本條.getText().equals(""))
     		{
     			 JOptionPane.showMessageDialog(this,"刪除的單詞不能為空！","警告",
                    
                     JOptionPane.WARNING_MESSAGE);
     		}
     		
     			// 判斷輸入框不能為空
     		     		     		
     		else
     		{     		     		
     			try{
     				刪除();
     			     			     			
     				}
     				
     			catch(SQLException ee){}
     		}     		
     	}
     	
     	else if(e.getSource()==cancelbtn)
     	{
     		dispose();
     	}
     }
     
     
     public void 刪除() throws SQLException   //實現刪除功能
     {
     	
     	String cname,ename;
     	
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		
		catch(ClassNotFoundException e){}
		
		Con = DriverManager.getConnection("jdbc:odbc:Driver={MicroSoft Access Driver (*.mdb)};DBQ=english\\english.mdb","","");
		
		Stmt=Con.createStatement();
		
		ResultSet rs=Stmt.executeQuery("SELECT * FROM 表1");
		
		boolean boo=false;
		
		while((boo=rs.next())==true)
		{
			ename=rs.getString("單詞");
			
			cname=rs.getString("解釋");
			
			if(ename.equals(刪除單詞_文本條.getText()))
			{
				String s1="'"+刪除單詞_文本條.getText().trim()+"'";
		
		        String temp="DELETE FROM 表1 WHERE 單詞="+s1;
								
				Stmt.executeUpdate(temp);
				
				JOptionPane.showMessageDialog(this,"成功刪除記錄！","恭喜",
				
				JOptionPane.WARNING_MESSAGE);
				
				dispose();
				
				break;
			}
		}
		
		Con.close();
			
		if(boo==false)
		{
			JOptionPane.showMessageDialog(this,"不存在此單詞！","警告",
			
			JOptionPane.WARNING_MESSAGE);
		}	
    
     }
 }