mpassframe.java

小区物业管理系统（java版） java swing + access 2003

/*
 * mpassFrame.java
 *
 * Created on 2006年3月20日, 下午7:34
 */

package login;
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
/**
 *
 * @author  kylin
 */
public class MpassFrame extends javax.swing.JFrame {
    
    /** Creates new form mpassFrame */
    public MpassFrame() {
        super("密码设置");
        initComponents();
        setSize(375,325);
        Dimension screen=getToolkit().getScreenSize();
        setLocation((screen.width-getSize().width)/2, (screen.height-getSize().height)/2);
        try{
            String theLook=UIManager.getSystemLookAndFeelClassName();
            UIManager.setLookAndFeel(theLook);
            SwingUtilities.updateComponentTreeUI(this);
            //更新界面
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载驱动
            Connection conn=DriverManager.getConnection("jdbc:odbc:wySystem","admin", "admin");
            String sql="select id from login";
            Statement sm=conn.createStatement();
            ResultSet rs=sm.executeQuery(sql);
            if(rs.next()) idtext.setText(rs.getString("id"));
        }
        catch(Exception e){
            JOptionPane.showMessageDialog(this,"出现异常"+e.toString(),"修改密码",JOptionPane.WARNING_MESSAGE);
        }
    }

    
    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    // <editor-fold defaultstate="collapsed" desc=" 生成的代码 ">//GEN-BEGIN:initComponents
    private void initComponents() {
        labels = new javax.swing.JPanel();
        idLabel = new javax.swing.JLabel();
        passLabel = new javax.swing.JLabel();
        newpassLabel = new javax.swing.JLabel();
        cpassLabel = new javax.swing.JLabel();
        texts = new javax.swing.JPanel();
        idtext = new javax.swing.JTextField();
        spass = new javax.swing.JPasswordField();
        npass = new javax.swing.JPasswordField();
        cpass = new javax.swing.JPasswordField();
        buttons = new javax.swing.JPanel();
        ok = new javax.swing.JButton();
        cancel = new javax.swing.JButton();

        getContentPane().setLayout(null);

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        setResizable(false);
        labels.setLayout(null);

        idLabel.setText("\u7528\u6237\u540d\uff1a");
        labels.add(idLabel);
        idLabel.setBounds(0, 20, 70, 15);

        passLabel.setText("\u539f\u59cb\u5bc6\u7801\uff1a");
        labels.add(passLabel);
        passLabel.setBounds(0, 60, 70, 15);

        newpassLabel.setText("\u65b0\u5bc6\u7801\uff1a");
        labels.add(newpassLabel);
        newpassLabel.setBounds(0, 100, 70, 15);

        cpassLabel.setText("\u786e\u8ba4\u5bc6\u7801\uff1a");
        labels.add(cpassLabel);
        cpassLabel.setBounds(0, 140, 70, 15);

        getContentPane().add(labels);
        labels.setBounds(60, 50, 80, 170);

        texts.setLayout(null);

        idtext.setEnabled(false);
        texts.add(idtext);
        idtext.setBounds(10, 20, 160, 20);

        texts.add(spass);
        spass.setBounds(10, 60, 160, 20);

        texts.add(npass);
        npass.setBounds(10, 100, 160, 20);

        texts.add(cpass);
        cpass.setBounds(10, 140, 160, 20);

        getContentPane().add(texts);
        texts.setBounds(150, 50, 200, 170);

        buttons.setLayout(null);

        ok.setText("\u786e\u5b9a");
        ok.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                okActionPerformed(evt);
            }
        });

        buttons.add(ok);
        ok.setBounds(40, 10, 60, 23);

        cancel.setText("\u53d6\u6d88");
        cancel.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                cancelActionPerformed(evt);
            }
        });

        buttons.add(cancel);
        cancel.setBounds(170, 10, 60, 23);

        getContentPane().add(buttons);
        buttons.setBounds(60, 240, 290, 50);

        pack();
    }
    // </editor-fold>//GEN-END:initComponents

    private void cancelActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cancelActionPerformed
// TODO 将在此处添加您的处理代码：
         dispose();
    }//GEN-LAST:event_cancelActionPerformed

    private void okActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_okActionPerformed
// TODO 将在此处添加您的处理代码：
        String spwd=new String(spass.getPassword());//原始密码
        String npwd=new String(npass.getPassword());//新密码
        String cpwd=new String(cpass.getPassword());//确认密码
        if(spwd.length()==0||spwd.length()==0||spwd.length()==0){//检查输入框是否为空
            JOptionPane.showMessageDialog(this,"密码不能为空","修改密码",JOptionPane.INFORMATION_MESSAGE);
        }
        else{
            try{    
               Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载驱动
               Connection conn=DriverManager.getConnection("jdbc:odbc:wySystem","admin", "admin");//连接数据库
               String sql1="select password from login where id=?";//获取数据库中密码的sql语句
               PreparedStatement ps=conn.prepareCall(sql1);
               ps.setString(1, "admin");
               ResultSet rs=ps.executeQuery();
               if(rs.next()){
                  if(spwd.equals(rs.getString("password"))) {
                      if(npwd.equals(cpwd)){
                          ps.clearParameters();
                          String sql2="update login set password=? where id=?";//更新数据库中密码的sql语句
                          ps=conn.prepareCall(sql2);
                          ps.setString(1, npwd);
                          ps.setString(2, "admin");
                          ps.executeUpdate();
                          dispose();
                      }
                      else{
                           JOptionPane.showMessageDialog(this,"密码不一致","修改密码",JOptionPane.INFORMATION_MESSAGE);
                      }
                  }
                  else{
                           JOptionPane.showMessageDialog(this,"密码错误","修改密码",JOptionPane.INFORMATION_MESSAGE);
                  }
              }
              rs.close();
              conn.close();
            }
            catch(Exception e){
                 JOptionPane.showMessageDialog(this,"出现异常"+e.toString(),"修改密码",JOptionPane.WARNING_MESSAGE);
            }
        }
        
    }//GEN-LAST:event_okActionPerformed
    
    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new MpassFrame().setVisible(true);
            }
        });
    }
    
    // 变量声明 - 不进行修改//GEN-BEGIN:variables
    private javax.swing.JPanel buttons;
    private javax.swing.JButton cancel;
    private javax.swing.JPasswordField cpass;
    private javax.swing.JLabel cpassLabel;
    private javax.swing.JLabel idLabel;
    private javax.swing.JTextField idtext;
    private javax.swing.JPanel labels;
    private javax.swing.JLabel newpassLabel;
    private javax.swing.JPasswordField npass;
    private javax.swing.JButton ok;
    private javax.swing.JLabel passLabel;
    private javax.swing.JPasswordField spass;
    private javax.swing.JPanel texts;
    // 变量声明结束//GEN-END:variables
    
}