changepass.java

管理学生信息

import java.awt.*;
import javax.swing.*;
import java.sql.*;
import java.awt.event.*;
class ChangePass extends JFrame implements ActionListener
{
	String s;
	JButton ok,cancel;
	JPasswordField t[]=new JPasswordField[3];
	public ChangePass(String s){
		super("密码更改");
		this.s=s;
		setSize(500,300);
		setLayout(new GridLayout(4,1));
		setVisible(true);
		JPanel p[]=new JPanel[4];
		JLabel l[]=new JLabel[3];
		String k[]=new String[]{"旧密码","新密码","确认一次新密码"};
		for (int i=0;i<3 ;i++ )
		{
			l[i]=new JLabel(k[i]);
			t[i]=new JPasswordField(10);
			p[i]=new JPanel();
			p[i].add(l[i]);
			p[i].add(t[i]);
			add(p[i]);
		}
		p[3]=new JPanel();

		ok=new JButton("确定");
		cancel=new JButton("取消");
		p[3].add(cancel);
		p[3].add(ok);
		add(p[3]);
		cancel.addActionListener(this);
		ok.addActionListener(this);
		t[2].addActionListener(this);
		validate();
		pack();
		setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
	}
	public void actionPerformed(ActionEvent e){
		if (e.getSource()==ok||e.getSource()==t[2])
		{
			if(String.valueOf(t[1].getPassword()).equals(String.valueOf(t[2].getPassword())))
			{
				Connection con=null;
				Statement sm=null;
				ResultSet rs=null;
				try{
					Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
					con=DriverManager.getConnection("jdbc:odbc:student");
				}catch(Exception ex){System.out.println(ex.getMessage());}
				try{
					sm=con.createStatement();
					String command="select pws from yonghu where username='"+s+"'";
					System.out.println(s);
					rs=sm.executeQuery(command);
					if(rs.next())
					{
						if(rs.getString(1).trim().equals(String.valueOf(t[0].getPassword()).trim())){	
							command="update yonghu set pws='"+String.valueOf(t[1].getPassword())+"'  where username='"+s+"'";
							sm.executeUpdate(command);
							JOptionPane.showMessageDialog(this,"修改成功","修改成功",JOptionPane.WARNING_MESSAGE);
						}
						else
							JOptionPane.showMessageDialog(this,"原密码错误!","warring",JOptionPane.WARNING_MESSAGE);
					}
					sm.close();
					con.close();
				}catch(SQLException kk){System.out.println(kk.getMessage());}
			 }
			 else
				 JOptionPane.showMessageDialog(this,"确认密码错误!","warring",JOptionPane.WARNING_MESSAGE);
		}
		else
			dispose();
		}
}