creat.java

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

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

 public  class Creat extends JFrame implements ActionListener {
      
     JTextField username;
     TextField userword1,userword2; 
     
     JButton addbtn,cancelbtn;
     
     Connection Con=null;
     
     Statement Stmt=null;
     
     public Creat()
     {
     	super("创建用户");
     	
     	this.setBounds(320,350,400,200);
     	
     	this.setVisible(true);
     	
    	JPanel p1=new JPanel();
     	
     	p1.add(new Label("用户名:"));
     	
     	username=new JTextField(10);
     	
     	p1.add(username);
     	
     	p1.add(new Label("用户密码:"));
     	
     	userword1=new TextField(10);
     	
     	p1.add(userword1);
     	userword1.setEchoChar('*');
        p1.add(new Label("同上密码:"));
     	
     	userword2=new TextField(10);
     	
     	p1.add(userword2);
     	userword2.setEchoChar('*');
     	addbtn = new JButton("提交");
     	
     	cancelbtn = new JButton("取消");
     	
     	p1.add(addbtn); p1.add(cancelbtn);
     	
     	this.add(p1);
     	
     	addbtn.addActionListener(this);
     	
     	cancelbtn.addActionListener(this);
     	
     	this.validate();
     	     	
     }
     
     
     public void actionPerformed(ActionEvent e)
     {
     	if(e.getSource()==addbtn)
     	{
     		if(username.getText().equals(""))
     		{
     			JOptionPane.showMessageDialog(this,"您还没输入用户名呢！","SORRY！",
     		  		   	
     	                JOptionPane.WARNING_MESSAGE);
     		}
     		   
     		   	// 判断输入框不能为空
     		else if(userword1.getText().equals("")||userword2.getText().equals(""))
     		{
     			JOptionPane.showMessageDialog(this,"您密码还没输完呢！","SORRY！",
     		  		   	
     	                JOptionPane.WARNING_MESSAGE);
     		}
     		else if(!userword1.getText().trim().equals(userword2.getText().trim()))
      		   
  		   {
  		   	   JOptionPane.showMessageDialog(this,"两次输入密码不一致！","SORRY！",
  		   	
                JOptionPane.WARNING_MESSAGE);

  		   }
     		   
     		 else {
     		      		
     		        try{
     			           添加();
     			     	     			      
     		            }
     		            
     		         catch(SQLException ee){}  
     		      }   		
     		
     	}
     	
     	else if(e.getSource()==cancelbtn)
     	{
     		dispose();
     	}
     }
     
     
     public void 添加() throws SQLException   //实现添加功能
     {
     	String name,password;
     	String conURL="jdbc:odbc:user";
     	
		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)
		{
			name=rs.getString("用户名");
			
			
			if(name.equals(username.getText()))
			{
				JOptionPane.showMessageDialog(this,"用户已存在！","SORRY！",
				
				JOptionPane.WARNING_MESSAGE);
				
				break;
			}
		}
		
		if(boo==false)
		{
			String s1="'"+username.getText().trim()+"'",s2="'"+userword1.getText().trim()+"'";
     	
     	    String temp="INSERT INTO 表1 VALUES ("+s1+","+s2+")";
     	     	         	
     	    Stmt.executeUpdate(temp);
									
			JOptionPane.showMessageDialog(this,"注册成功！","恭喜",JOptionPane.WARNING_MESSAGE);
			dispose();
		}
		
		Con.close();
     	
     	     	
     }
}