password.java

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

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

import javax.swing.*;
public class Password extends JFrame implements ActionListener{
	TextField 用户名,旧密码,新密码1,新密码2;
	Label b1,b2,b3,b4;
	JButton ok,no;
	
	Connection Con=null;
	
	Statement Stmt=null;
	String getname,getword;
	
	public  Password()	
	{
		super("修改密码");
				
		this.setBounds(380,370,330,210);
		
		this.setVisible(true);
		
		JPanel p=new JPanel();
		p.setLayout(new GridLayout(5,2));
		b1=new Label("用户名");
		b1.setAlignment(Label.CENTER);
		
		p.add(b1);
		用户名=new TextField(8);
		p.add(用户名);
		b2=new Label("旧密码:");
		b2.setAlignment(Label.CENTER);
		p.add(b2);
		
		旧密码=new TextField(8);
		
		p.add(旧密码);
		b3=new Label("新密码:");
		b3.setAlignment(Label.CENTER);
		p.add(b3);
		
		新密码1=new TextField(8);
		
		p.add(新密码1);
		b4=new Label("新密码:");
		b4.setAlignment(Label.CENTER);
		p.add(b4);
		b1.setFont(new Font("宋体",Font.CENTER_BASELINE,14));
		b2.setFont(new Font("宋体",Font.CENTER_BASELINE,14));
		b3.setFont(new Font("宋体",Font.CENTER_BASELINE,14));
		b4.setFont(new Font("宋体",Font.CENTER_BASELINE,14));
		新密码2=new TextField(8);
		p.add(新密码2);
		旧密码.setEchoChar('*');
		新密码1.setEchoChar('*');
		新密码2.setEchoChar('*');
		ok=new JButton("确定");
		
		no = new JButton("取消");
		
		p.add(ok);p.add(no);
		
		ok.addActionListener(this);
		
		no.addActionListener(this);
		
		this.add(p);
		
		this.validate();
				
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==ok||e.getSource()==新密码2)
		{
			if(用户名.getText().trim().equals("")||旧密码.getText().trim().equals("")||
			新密码1.getText().trim().equals("")||新密码2.getText().trim().equals(""))
				JOptionPane.showMessageDialog(this, "您还没输完整呢！", "SORRY！",JOptionPane.WARNING_MESSAGE );
			else if(!新密码1.getText().trim().equals(新密码2.getText().trim()))
			{
				JOptionPane.showMessageDialog(this, "两次新密码不一致！", "SORRY！",JOptionPane.WARNING_MESSAGE );
			}
			else if(新密码1.getText().trim().equals(新密码2.getText().trim()))
			{
				getword=旧密码.getText().trim();
    			 getname=用户名.getText().trim();
    			String passname=null,password=null;
    			String conURL="jdbc:odbc:user";
    			boolean flag=false;
    				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(getname)&&password.equals(getword))
        					{
        						flag=true;
        						String s1="'"+新密码1.getText().trim()+"'";
        						String s2="'"+用户名.getText().trim()+"'";     			
        						String temp="UPDATE 表1 SET 密码="+s1+" WHERE 用户名 = "+s2;
        						Stmt.executeUpdate(temp);
        						//System.out.println("执行了修改密码！");
        						
        						JOptionPane.showMessageDialog(this,"密码修改成功！","恭喜",
        						
        						JOptionPane.WARNING_MESSAGE);
            					 dispose();
            					 break;
        					}
        					 
        				}
        				
        				Con.close();
    				}
    				catch(SQLException ex){}
    				
    				
    				if(flag==false)
    				{
    					新密码1.setText("");
    					新密码2.setText("");
    					
    					JOptionPane.showMessageDialog(this,"您没有权限修改该用户密码！","SORRY",
          	                    JOptionPane.WARNING_MESSAGE);
    				}
    				
    		 }
			
		}
		if(e.getSource()==no)
		{
			dispose();
		}
	}

}