changepwd.java

这是我我完成的java的课程设计,是一个宾馆管理系统

import java.awt.*;
import javax.swing.*;

import java.awt.event.*;
import java.sql.*;
 
public class ChangePwd implements ActionListener {
  JFrame fm=new JFrame("密码修改");
  Statement ps;
  Statement slt;
  ResultSet rs;
  ResultSet rs3;
  String rs1;
  String rs2;
  Connection con;
  String url;
  JPanel panel1 = new JPanel();
  JLabel jLabel1 = new JLabel();
  String[] data = {"管理员", "收银员"};
  JComboBox userF=new JComboBox(data);
  JLabel jLabel2 = new JLabel();
  JButton cancel = new JButton();
  JButton sure = new JButton();
  JLabel jLabel3 = new JLabel();
  JPasswordField pwd = new JPasswordField();
  JPasswordField pwd1 = new JPasswordField();
  JLabel jLabel4 = new JLabel();
  JPasswordField pwd2 = new JPasswordField();
  
  private void jbInit() throws Exception {
    panel1.setLayout(null);
    fm.getContentPane().setLayout(null);
    panel1.setBounds(new Rectangle( -5, 0, 400, 300));
    jLabel4.setBounds(new Rectangle(28, 45, 78, 25));
    jLabel4.setText("原始密码：");
    jLabel4.setFont(new java.awt.Font("Dialog", 0, 15));
    pwd2.setText("");
    pwd2.setBounds(new Rectangle(120, 45, 128, 25));
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel1.setText("用户名:");
    jLabel1.setBounds(new Rectangle(28, 10, 89, 25));
    userF.setBounds(new Rectangle(123, 10, 124, 25));
    jLabel2.setFont(new java.awt.Font("Dialog", 0, 15));
    jLabel2.setText("输入新密码：");
    jLabel2.setBounds(new Rectangle(30, 75, 85, 25));
    cancel.setBounds(new Rectangle(148, 169, 89, 30));
    cancel.setFont(new java.awt.Font("Dialog", 0, 15));
    cancel.setText("重填");
    cancel.addActionListener(new ChangePwd_cancel_actionAdapter(this));
    sure.setBounds(new Rectangle(46, 167, 88, 30));
    sure.setFont(new java.awt.Font("Dialog", 0, 15));
    sure.setText("确定");
    sure.addActionListener(new ChangePwd_sure_actionAdapter(this));
    pwd.setText("");
    pwd.setBounds(new Rectangle(119, 74, 128, 30));
    jLabel3.setBounds(new Rectangle(29, 113, 78, 25));
    jLabel3.setText("再次输入：");
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 15));
    
    pwd1.setBounds(new Rectangle(119, 116, 128, 30));
    pwd1.setText("");
    fm.getContentPane().add(panel1, null);
    panel1.add(jLabel4, null);
    panel1.add(pwd2, null);
    panel1.add(jLabel1, null);
    panel1.add(userF, null);
    panel1.add(jLabel2, null);
    panel1.add(pwd, null);
    panel1.add(pwd1, null);
    panel1.add(cancel, null);
    panel1.add(sure, null);
    panel1.add(jLabel3, null);
    fm.setBounds(300, 300, 300, 250);
    fm.setVisible(true);
  }
  void cancel_actionPerformed(ActionEvent e) {
    pwd.setText("");
    pwd1.setText("");
    pwd2.setText("");
  }

  void sure_actionPerformed(ActionEvent e) {
	String password=pwd2.getText().trim().toString();
    JOptionPane.showConfirmDialog(null,"确定修改", "修改密码", JOptionPane.YES_NO_OPTION);
    try {
      if (pwd.getText().trim().equals(pwd1.getText().trim())) {
        try {
          Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
          Connection con = DriverManager.getConnection(
              "jdbc:odbc:Hotel");
          ps = con.createStatement(ResultSet.
                                   TYPE_SCROLL_INSENSITIVE,
                                   ResultSet.CONCUR_READ_ONLY);
        rs=ps.executeQuery("Select LoginPassword from Admin where LoginName='管理员'");
        while (rs.next()){
        rs1=rs.getString("LoginPassword");}
      	rs3=ps.executeQuery("Select LoginPassword from Admin where LoginName='收银员'");
      	while (rs.next()){
      	rs2=rs3.getString("LoginPassword");}
        }
        catch (Exception err) {
          err.printStackTrace(System.out);
        }
        try {
        	
        	if(userF.getSelectedIndex()==0)
			{
        		if(rs1.trim().equalsIgnoreCase(password))
        		{
        			ps.executeUpdate("Update Admin set LoginPassword='" + pwd.getText().trim() +
                      "' where LoginName='管理员'");
                    JOptionPane.showMessageDialog(null, "管理员密码修改成功");
                   fm.dispose();
        		}
        		else{
        			JOptionPane.showMessageDialog(null, "原始密码不正确");
        		}
			}
        	else if(userF.getSelectedIndex()==1)
			{
        		if(rs2.trim().equalsIgnoreCase(password))
        		{
        			ps.executeUpdate("Update Admin set LoginPassword='" + pwd.getText().trim() +
                      "' where LoginName='管理员'");
                    JOptionPane.showMessageDialog(null, "收银员密码修改成功");
                   fm.dispose();
        		}
        	else{
        			JOptionPane.showMessageDialog(null, "原始密码不正确");
        		}
			}
      }
      catch (SQLException sqle) {
              String error = sqle.getMessage();
              JOptionPane.showMessageDialog(null, error);
              sqle.printStackTrace();
            }
      }
      else {
        JOptionPane.showMessageDialog(null, "两次密码不一致！请重新输入");
            }
    }
    catch (Exception ex) {
      ex.getMessage();
      String error = ex.getMessage();
      JOptionPane.showMessageDialog(null, error);
      ex.printStackTrace();
    }
  }

 

  public void actionPerformed(ActionEvent e){
		try {
			jbInit();
		} catch (Exception e1) {
			e1.printStackTrace();
		}
	}	
}

class ChangePwd_cancel_actionAdapter
    implements java.awt.event.ActionListener {
	ChangePwd adaptee;

	ChangePwd_cancel_actionAdapter(ChangePwd adaptee) {
    this.adaptee = adaptee;
  }

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

class ChangePwd_sure_actionAdapter
    implements java.awt.event.ActionListener {
	ChangePwd adaptee;

	ChangePwd_sure_actionAdapter(ChangePwd adaptee) {
    this.adaptee = adaptee;
  }

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