changepasswordframe.java

用java写的固定资产管理系统原代码 这可是自己小组做的哦

package com.cn.szhaccp.landing;

/*
 * ChangePasswordFrame.java
 *
 * Created on 2007年4月29日, 上午8:32
 *
 * To change this template, choose Tools | Template Manager
 * and open the template in the editor.
 */
import javax.swing.JDialog;
import javax.swing.JOptionPane;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;
 /**
 * @author Admin
 */
public class ChangePasswordFrame {
    
    /** Creates a new instance of ChangePasswordFrame */
    public ChangePasswordFrame(JDialog parent,String userID,String oldpassword,String newpassword,String newpassword1) {
        if(userID.equals("") || oldpassword.equals("") || newpassword.equals("") || newpassword1.equals("")) {
            JOptionPane.showMessageDialog(parent,"请正确填写所有项!","错误",JOptionPane.ERROR_MESSAGE);
        } else if(!newpassword.equals(newpassword1)) {
            JOptionPane.showMessageDialog(parent,"两次密码输入不一致!请正确输入!","错误",JOptionPane.ERROR_MESSAGE);
        } else {
            try {
                dbc = new DatabaseConnection();
                stmt1 = dbc.getConn().createStatement();
                rs1 = stmt1.executeQuery("SELECT *FROM Users WHERE ID = '" + userID + "' AND PassWord = '" +  oldpassword + "'");
                if(rs1.next()) {
                    stmt2 = dbc.getConn().createStatement();
                    stmt2.executeUpdate("UPDATE Users SET PassWord = '" + newpassword + "' WHERE ID = '" + userID + "'");
                    rs2 = stmt2.getResultSet();
                    JOptionPane.showMessageDialog(parent,"密码修改成功!","恭喜",JOptionPane.INFORMATION_MESSAGE);
                    parent.dispose();
                } else {
                    JOptionPane.showMessageDialog(parent,"没有该用户ID或密码错误!","错误",JOptionPane.ERROR_MESSAGE);
                }
                
            } catch(ClassNotFoundException e) {
                e.printStackTrace();
            } catch(SQLException e) {
                e.printStackTrace();
            }
        }
    }
    
    private DatabaseConnection dbc;
    private Statement stmt1;
    private Statement stmt2;
    private ResultSet rs1;
    private ResultSet rs2;
}