delword.java

是一个电子词典

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

import javax.swing.*;

import SqlConnection.JdbcOdbcConn;
public class Delword extends JFrame implements ActionListener {
    JTextField 删除单词_文本条;     
    JButton delbtn,cancelbtn;    
    Connection Con = null;    
    Statement Stmt = null;    
    JdbcOdbcConn jdbcconn=new JdbcOdbcConn();
    ResultSet rs;
    
    public Delword()
    {  	super("删除单词");    	
    	this.setBounds(300,300,300,350);    	
    	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 English=删除单词_文本条.getText();
    	char a=English.charAt(0);//取得首字母
    	String sql="delete from view"+a+" where 单词原型='"+English+"'";
    	jdbcconn.DeleteSql(sql);
     	JOptionPane.showMessageDialog(this,"删除成功！","恭喜",JOptionPane.WARNING_MESSAGE);
     	dispose();
    }
     
}