delwin.java

电子词典

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);
		}	
    
     }
 }