passwordframe.java

学生成绩管理系统

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

import javax.swing.*;


public class PasswordFrame extends JFrame {

	public PasswordFrame(Connection connect,String guest,String pass){
		
		setTitle("Password Manage Frame");
		con=connect;//连接到时数据库上
		user=guest;
		password=pass;
		Container c=this.getContentPane();
		c.setLayout(new GridLayout(4,1));
		
		old=new JLabel( "The old password      ");
		new1=new JLabel("The new one           ");
		new2=new JLabel("Input the one again ");
		jtf_old=new JTextField("",10);
		jtf_new1=new JTextField("",10);
		jtf_new2=new JTextField("",10);
		ok=new JButton("OK");
		
		
		JPanel p1,p2,p3,p4;
		p1=new JPanel();
		p2=new JPanel();
		p3=new JPanel();
		p4=new JPanel();
		p1.add(old);p1.add(jtf_old);
		p2.add(new1);p2.add(jtf_new1);
		p3.add(new2);p3.add(jtf_new2);
		p4.add(ok);
		
		
		c.add(p1);
		c.add(p2);
		c.add(p3);
		c.add(p4);
		////////添加OK响应事件
		ok.addActionListener(new PasswordListener());
	}
	class PasswordListener implements ActionListener{

		public void actionPerformed(ActionEvent e) {
			
			if(!(jtf_old.getText().equals(password))){
				JOptionPane.showMessageDialog(null, "The password is wrong!");
				return;
			}
			else if(!(jtf_new1.getText().equals(jtf_new2.getText()))){
				JOptionPane.showMessageDialog(null, "The two password is not same!");
				return;
			}
			else{
				try{
					String s;
					PreparedStatement preSt;
					s="select * from users where guest=?";
					preSt=con.prepareStatement(s);
					preSt.setString(1, user);
					ResultSet rs=preSt.executeQuery();
					rs.next();
					sf=rs.getInt(3);
					rs.close();
					preSt.close();
					 
					
					s="delete from users where guest=?";
					preSt=con.prepareStatement(s);
					preSt.setString(1, user);
					preSt.executeUpdate();
					
					s="insert into users values(?,?,?)";
					preSt=con.prepareStatement(s);
					preSt.setString(1, user);
					preSt.setString(2, jtf_new1.getText());
					preSt.setInt(3, sf);
					preSt.executeUpdate();
					
					
					
				}catch(SQLException e1){
					JOptionPane.showMessageDialog(null, e1.getMessage());
					return;
				}
				JOptionPane.showMessageDialog(null,"Update Password Successfully!");
			}
			
		}
		
	}
	JLabel old,new1,new2;
	JTextField jtf_old,jtf_new1,jtf_new2;
	JButton ok;
	Connection con;
	String user;
	String password;
	int sf;
}