changepassframe.java~42~

用java 写的学生信息管理系统

package prjsystementer;

import java.awt.BorderLayout;

import javax.swing.*;
import javax.swing.JTextField;
import java.awt.Rectangle;
import javax.swing.JPasswordField;
import javax.swing.JLabel;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import java.awt.*;
import java.awt.Font;

public class ChangePassFrame extends JFrame {
    public ChangePassFrame() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        txtOldPass.setBounds(new Rectangle(137, 41, 235, 35));
        txtOldPass.addActionListener(new
                                     ChangePassFrame_txtOldPass_actionAdapter(this));
        btnCancel.addActionListener(new ChangePassFrame_btnCancel_actionAdapter(this));
        btnOk.addActionListener(new ChangePassFrame_btnOk_actionAdapter(this));
        lblOldPass.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        lblNewPass.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        lblRPass.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        btnOk.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        btnCancel.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        this.getContentPane().add(txtOldPass);
        btnOk.setBounds(new Rectangle(71, 229, 113, 39));
        btnOk.setText("确定");
        btnCancel.setBounds(new Rectangle(213, 229, 113, 39));
        btnCancel.setText("取消");
        lblRPass.setText("重复输入");
        lblRPass.setBounds(new Rectangle(39, 178, 90, 33));
        lblNewPass.setText("新密码");
        lblNewPass.setBounds(new Rectangle(39, 106, 89, 43));
        lblOldPass.setText("原密码");
        lblOldPass.setBounds(new Rectangle(39, 43, 93, 27));
        txtRPass.setBounds(new Rectangle(137, 171, 238, 39));
        this.getContentPane().add(txtNewPass);
        this.getContentPane().add(txtRPass);
        this.getContentPane().add(btnOk);
        this.getContentPane().add(btnCancel);
        this.getContentPane().add(lblOldPass);
        this.getContentPane().add(lblRPass);
        this.getContentPane().add(lblNewPass);
        txtNewPass.setBounds(new Rectangle(137, 105, 237, 41));
    }

    JTextField txtOldPass = new JTextField();
    JPasswordField txtNewPass = new JPasswordField();
    JPasswordField txtRPass = new JPasswordField();
    JLabel lblOldPass = new JLabel();
    JLabel lblNewPass = new JLabel();
    JLabel lblRPass = new JLabel();
    JButton btnCancel = new JButton();
    JButton btnOk = new JButton();

    String userName;
    public ChangePassFrame(String name) {
        this();
        this.userName = name;

    }

    public void btnOk_actionPerformed(ActionEvent e) {
        //得到用户的原始密码
        String p1 = this.txtOldPass.getText();
        //得到用户更改的第一次密码
        String p2 = new String(txtNewPass.getPassword());
        //得到用户输入的第二次确认密码
        String p3 = new String(this.txtRPass.getPassword());
        // 实力化DBMaager
        DBManager db = new DBManager();
        //实力化登陆窗体,因为要传登陆的用户名
        SystemEnterFrame f = new SystemEnterFrame();
        //拼SQL语句，查询用户输入的密码
        String sql = "select * from T_USERINFO where userName='" +
                     this.userName +
                     "'";
        //测试是否真正传进了登陆的用户名
        // System.out.println(f.getName());
        //执行SQL的查询语句的
        ResultSet rs = db.ExecuteQuery(sql);
        try {
            while (rs.next()) {
                //得到数据库里面的密码
                String DBpass = rs.getString("pwd");
                if (p1.equals(DBpass) == false) {
                    JOptionPane.showMessageDialog(this, "旧密码错误");
                    return;
                }
                if (p2.equals("")) {
                    JOptionPane.showMessageDialog(this, "新密码不能为空");
                    return;

                }
                if (p2.equals(p3) == false) {
                    JOptionPane.showMessageDialog(this, "两次密码不一致密码错误");
                    return;
                }
                if (p1.equals(p2)) {
                    JOptionPane.showMessageDialog(this, "新密码不能和旧密码一致");
                    return;
                }
                SQL();
                JOptionPane.showMessageDialog(this, "修改成功");
                this.dispose();

            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }

    public void SQL() {
        DBManager db = new DBManager();
        String p2 = new String(txtNewPass.getPassword());
        MainFrame f = new MainFrame();
        System.out.println(this.userName);
        String Updatesql = "Update T_USERINFO set pwd ='" + p2 +
                           "' where userName ='" + this.userName + "' ";
        db.ExecuteUpdate(Updatesql);
    }

    public void btnCancel_actionPerformed(ActionEvent e) {
        this.dispose();
    }

    public void txtOldPass_actionPerformed(ActionEvent e) {

    }


    class ChangePassFrame_btnOk_actionAdapter implements ActionListener {
        private ChangePassFrame adaptee;
        ChangePassFrame_btnOk_actionAdapter(ChangePassFrame adaptee) {
            this.adaptee = adaptee;
        }

        public void actionPerformed(ActionEvent e) {
            adaptee.btnOk_actionPerformed(e);
        }
    }


    class ChangePassFrame_btnCancel_actionAdapter implements ActionListener {
        private ChangePassFrame adaptee;
        ChangePassFrame_btnCancel_actionAdapter(ChangePassFrame adaptee) {
            this.adaptee = adaptee;
        }

        public void actionPerformed(ActionEvent e) {
            adaptee.btnCancel_actionPerformed(e);
        }
    }
}


class ChangePassFrame_txtOldPass_actionAdapter implements ActionListener {
    private ChangePassFrame adaptee;
    ChangePassFrame_txtOldPass_actionAdapter(ChangePassFrame adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.txtOldPass_actionPerformed(e);
    }
}