login.java

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

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

import javax.swing.*;

public class Login extends JFrame implements ActionListener{
     JTextField getname;
     TextField getword;
     JButton ok,no;
	Connection Con=null;
     Statement Stmt=null;
     String passname=null,password=null,getu=null,passw=null;
     boolean flag;
     Color c=new Color(127,255,212);
     public Login()
     {
     	super("英汉小词典用户登陆");
     	
     	this.setBounds(380,300,350,150);
     	
     	this.setVisible(true);
     	
    	JPanel p1=new JPanel();
     	p1.setBackground(c);
     	p1.add(new Label("用户名:"));
     	
     	getname=new JTextField(7);
       	p1.add(getname);
      	p1.add(new Label("密码:"));
     	
     	getword=new TextField(8);
     	getword.setEchoChar('*');
     	getword.setBackground(new Color(240,255,240));
     	getname.setBackground(new Color(240,255,240));
     	
     	p1.add(getword);
     	getword.addActionListener(this);
     	
     	ok = new JButton("登陆");
     	
     	no = new JButton("取消");
     	ok.setBackground(new Color(173,255,47));
     	no.setBackground(new Color(173,255,47));
     	p1.add(ok); p1.add(no);
     	
     	this.add(p1);
     	
     	ok.addActionListener(this);
     	
     	no.addActionListener(this);
     	
     	this.validate();
     	     	
     }
     public void actionPerformed(ActionEvent e)
     {
    	 if(e.getSource()==ok||e.getSource()==getword)
    	 {
    		 if(getword.getText().equals("")||getname.getText().equals(""))
    		 {
    			 JOptionPane.showMessageDialog(this,"您还没有输入完整呢！","SORRY",
    						
    	                    JOptionPane.WARNING_MESSAGE);
    		 }
    		 else 
    		 {
    			
    			passw=getword.getText().trim();
    			getu=getname.getText().trim();
    			String conURL="jdbc:odbc:user";
    				try
    				{
    					Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    				}
    				
    				catch(ClassNotFoundException ex){}
    				try{
    					Con = DriverManager.getConnection(conURL);
						
        				Stmt=Con.createStatement();
        				
        				ResultSet rs=Stmt.executeQuery("SELECT * FROM 表1");
        				while(rs.next())
        				{
        					passname=rs.getString("用户名");	
        					password=rs.getString("密码");
        					if(passname.equals(getu)&&password.equals(passw))
        					{
        						flag=true;
        						DataWindow window=new DataWindow();
            					window.validate();
            					 dispose();
            					 break;
        					}
        					
        				}
        				
        				Con.close();
    				}
    				catch(SQLException ex){}
    				
    				
    				if(!flag)
    				{
    					getname.setText("");
    					getword.setText("");
    					JOptionPane.showMessageDialog(this,"密码和帐号不匹配！","SORRY",
        						
        	                    JOptionPane.WARNING_MESSAGE);
    				}
    				
    		 }
    		
    		 //System.out.println(" get is:"+get);
    		// System.out.println(" pass is:"+pass);
    	 }
    	 else if(e.getSource()==no)
    	 {
    		 dispose();
    	 }
     }
     

}