addwin.java

实现英汉,汉英单词查询,添加,修改,删除功能,界面友好!

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

 public  class AddWin extends JFrame implements ActionListener {
      
     JTextField 添加汉语解释_文本条,添加英语单词_文本条; 
     
     JButton addbtn,cancelbtn;
     Label l1,l2;
     
     Connection Con=null;
     
     Statement Stmt=null;
     
     
     public AddWin()
     {
     	super("                            添加单词                               ");
     	
     	this.setBounds(380,370,300,130);
     	
     	this.setVisible(true);
     	
    	JPanel p1=new JPanel();
     	l1=new Label("单词:");
     	l1.setBackground(new Color(240,248,255));
     	p1.add(l1);
     	
     	添加英语单词_文本条=new JTextField(18);
     	添加英语单词_文本条.setBackground(new Color( 248,248,255));
     	p1.add(添加英语单词_文本条);
     	l2=new Label("解释:");
     	l2.setBackground(new Color(240,248,255));
     	p1.add(l2);
     	
     	添加汉语解释_文本条=new JTextField(18);
     	添加汉语解释_文本条.setBackground(new Color( 248,248,255));
     	p1.add(添加汉语解释_文本条);
     	
     	addbtn = new JButton("提交");
     	
     	cancelbtn = new JButton("取消");
     	
     	p1.add(addbtn); p1.add(cancelbtn);
     	
     	this.add(p1);
     	
     	addbtn.addActionListener(this);
     	
     	cancelbtn.addActionListener(this);
     	p1.setBackground(new Color(240,248,255));
     	this.validate();
     	     	
     }
     
     
     public void actionPerformed(ActionEvent e)
     {
     	if(e.getSource()==addbtn)
     	{
     		if(添加英语单词_文本条.getText().equals("")||添加汉语解释_文本条.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()))
			{
				JOptionPane.showMessageDialog(this,"此词汇已存在！","警告",
				
				JOptionPane.WARNING_MESSAGE);
				
				break;
			}
		}
		
		if(boo==false)
		{
			String s1="'"+添加英语单词_文本条.getText().trim()+"'",s2="'"+添加汉语解释_文本条.getText().trim()+"'";
     	
     	    String temp="INSERT INTO 表1 VALUES ("+s1+","+s2+")";
     	     	         	
     	    Stmt.executeUpdate(temp);
									
			JOptionPane.showMessageDialog(this,"添加成功！","恭喜",JOptionPane.WARNING_MESSAGE);
			dispose();
		}
		
		Con.close();
     	
     	     	
     }
}