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;
     Label l;
     
     DelWin()
     {
     	super("                              删除单词                               ");
     	
     	this.setBounds(380,370,300,140);
     	
     	this.setVisible(true);
     	
     	JPanel p1 = new JPanel();
     	
     	l=new Label("输入要删除的单词:");
     	l.setBackground(new Color(240,248,255));
     	p1.add(l);
     	
     	删除单词_文本条 = new JTextField(10);
     	删除单词_文本条.setBackground(new Color( 248,248,255));
     	p1.add(删除单词_文本条);
     	     	     	
     	delbtn = new JButton("删除");
     	
     	cancelbtn = new JButton("取消");
     	
     	p1.add(delbtn);p1.add(cancelbtn);
     	
     	this.add(p1);
     	p1.setBackground(new Color(240,248,255));
     	
     	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;
     	String conURL="jdbc:odbc:test2";
     	
		try
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		}
		
		catch(ClassNotFoundException e){}
		
		Con = DriverManager.getConnection(conURL);
		
		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);
		}	
    
     }
 }