pwddialog.java~24~

简单的学生管理系统。。用JBUILER和SQL2000。

package studentgl;

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

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

public class pwdDialog extends JDialog {
  JPanel panel1 = new JPanel();
  JLabel jLabel1 = new JLabel();
  JLabel jLabel2 = new JLabel();
  JPasswordField jPasswordField1 = new JPasswordField();
  JLabel jLabel3 = new JLabel();
  JLabel jLabel4 = new JLabel();
  JPasswordField jPasswordField2 = new JPasswordField();
  JLabel jLabel5 = new JLabel();
  JPasswordField jPasswordField3 = new JPasswordField();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  private  Connection con;
  private  mainFrame Frame1;
  private  Statement stmt;
  private  Statement stmt1;
  String stid;
  String teid;
  JRadioButton jRadioButton1 = new JRadioButton();
  JRadioButton jRadioButton2 = new JRadioButton();
  ButtonGroup buttonGroup1 = new ButtonGroup();
  public pwdDialog(mainFrame frame, String title, boolean modal) {
    super(frame, title, modal);
    this.setLocation(309,239);
    Frame1=frame;
    stid=Frame1.StID;
    teid=Frame1.TeID;
    try {
      jbInit();
      pack();
    }
    catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  public pwdDialog() {
    this(null, "", false);
  }
  private void jbInit() throws Exception {
    panel1.setLayout(null);
    jLabel1.setFont(new java.awt.Font("Serif", 0, 16));
    jLabel1.setForeground(SystemColor.textHighlight);
    jLabel1.setHorizontalAlignment(SwingConstants.CENTER);
    jLabel1.setText("号码：");
    jLabel1.setBounds(new Rectangle(38, 8, 113, 24));
    jLabel2.setBounds(new Rectangle(172, 8, 113, 24));
    jLabel2.setHorizontalAlignment(SwingConstants.CENTER);
    jLabel2.setForeground(SystemColor.textHighlight);
    jLabel2.setFont(new java.awt.Font("Serif", 0, 16));
    jPasswordField1.setFont(new java.awt.Font("Serif", 0, 12));
    jPasswordField1.setForeground(Color.red);
    jPasswordField1.setToolTipText("");
    jPasswordField1.setText("");
    jPasswordField1.setBounds(new Rectangle(147, 39, 174, 28));
    jLabel3.setFont(new java.awt.Font("Serif", 0, 16));
    jLabel3.setForeground(UIManager.getColor("ComboBox.selectionBackground"));
    jLabel3.setHorizontalAlignment(SwingConstants.CENTER);
    jLabel3.setText("旧密码：");
    jLabel3.setBounds(new Rectangle(42, 39, 100, 34));
    jLabel4.setBounds(new Rectangle(43, 85, 100, 34));
    jLabel4.setText("新密码：");
    jLabel4.setHorizontalAlignment(SwingConstants.CENTER);
    jLabel4.setForeground(UIManager.getColor("ComboBox.selectionBackground"));
    jLabel4.setFont(new java.awt.Font("Serif", 0, 16));
    jPasswordField2.setBounds(new Rectangle(147, 84, 174, 28));
    jPasswordField2.setText("");
    jPasswordField2.setToolTipText("");
    jPasswordField2.setForeground(Color.red);
    jPasswordField2.setFont(new java.awt.Font("Serif", 0, 12));
    jLabel5.setFont(new java.awt.Font("Serif", 0, 16));
    jLabel5.setForeground(UIManager.getColor("ComboBox.selectionBackground"));
    jLabel5.setHorizontalAlignment(SwingConstants.CENTER);
    jLabel5.setText("再输入新密码：");
    jLabel5.setBounds(new Rectangle(30, 129, 115, 34));
    jPasswordField3.setFont(new java.awt.Font("Serif", 0, 12));
    jPasswordField3.setForeground(Color.red);
    jPasswordField3.setToolTipText("");
    jPasswordField3.setText("");
    jPasswordField3.setBounds(new Rectangle(148, 127, 174, 28));
    jButton1.setBounds(new Rectangle(61, 217, 73, 25));
    jButton1.setFont(new java.awt.Font("Serif", 0, 12));
    jButton1.setForeground(Color.red);
    jButton1.setText("确定");
    jButton1.addActionListener(new pwdDialog_jButton1_actionAdapter(this));
    jButton2.setText("重设");
    jButton2.setForeground(Color.orange);
    jButton2.setFont(new java.awt.Font("Serif", 0, 12));
    jButton2.setBounds(new Rectangle(242, 217, 73, 25));
    jRadioButton1.setFont(new java.awt.Font("Serif", 0, 12));
    jRadioButton1.setSelected(true);
    jRadioButton1.setText("学生");
    jRadioButton1.setBounds(new Rectangle(61, 182, 91, 25));
    jRadioButton1.addActionListener(new pwdDialog_jRadioButton1_actionAdapter(this));
    jRadioButton2.setFont(new java.awt.Font("Serif", 0, 12));
    jRadioButton2.setText("老师");
    jRadioButton2.setBounds(new Rectangle(218, 178, 91, 25));
    jRadioButton2.addActionListener(new pwdDialog_jRadioButton2_actionAdapter(this));
    getContentPane().add(panel1);
    panel1.add(jLabel2, null);
    panel1.add(jLabel1, null);
    panel1.add(jLabel3, null);
    panel1.add(jPasswordField1, null);
    panel1.add(jLabel4, null);
    panel1.add(jPasswordField2, null);
    panel1.add(jLabel5, null);
    panel1.add(jPasswordField3, null);
    panel1.add(jRadioButton1, null);
    panel1.add(jRadioButton2, null);
    panel1.add(jButton1, null);
    panel1.add(jButton2, null);
    buttonGroup1.add(jRadioButton1);
    buttonGroup1.add(jRadioButton2);
     if(jRadioButton1.isSelected()){
        jLabel2.setText(stid);
     }
  }

  void jButton1_actionPerformed(ActionEvent e) {
     try{
       con=connect.getconn();
       stmt=con.createStatement();
       stmt1=con.createStatement();
       String oldp=jPasswordField1.getText();
       String npwd=jPasswordField2.getText();
       String npwd1=jPasswordField3.getText();
      if(jRadioButton1.isSelected()){
       String loginQuery="select * from  studentinfo where stid='"+stid+"' and stpwd ='"+oldp+"'";
       ResultSet rs = stmt.executeQuery(loginQuery);
       if(rs.next()&&npwd.equals(npwd1)){
           String update="update studentinfo set stpwd='"+npwd+"'";
           stmt.executeUpdate(update);
          JOptionPane.showMessageDialog(this,"修改密码成功","信息提示",1);
         }
        else if(!npwd.equals(npwd1))
          {JOptionPane.showMessageDialog(this,"两次密码不同","信息提示",0);}
         else
          { JOptionPane.showMessageDialog(this,"旧密码不正确","信息提示",0);}
          this.hide();
      }
      if(jRadioButton2.isSelected()){
      String loginQuery="select * from  teacherinfo where teid='"+teid+"' and tepwd ='"+oldp+"'";
       ResultSet rs = stmt.executeQuery(loginQuery);
        //rs.next();
        //String tepwd=rs.getString("tepwd");
        //System.out.print(tepwd);
       if(rs.next()&&(npwd.equals(npwd1))){
         String update1="update teacherinfo set tepwd='"+npwd+"'";
         stmt1.executeUpdate(update1);
         JOptionPane.showMessageDialog(this,"修改密码成功","信息提示",1);
        }
         else
         JOptionPane.showMessageDialog(this,"两次密码不同","信息提示",1);
         this.hide();
     }

     }catch(SQLException ex){
     System.out.print("系统或者输进数据错误！");}
  }

  void jRadioButton2_actionPerformed(ActionEvent e) {
            jLabel2.setText(teid);
  }

  void jRadioButton1_actionPerformed(ActionEvent e) {
       jLabel2.setText(stid);
  }
}

class pwdDialog_jButton1_actionAdapter implements java.awt.event.ActionListener {
  pwdDialog adaptee;

  pwdDialog_jButton1_actionAdapter(pwdDialog adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class pwdDialog_jRadioButton2_actionAdapter implements java.awt.event.ActionListener {
  pwdDialog adaptee;

  pwdDialog_jRadioButton2_actionAdapter(pwdDialog adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jRadioButton2_actionPerformed(e);
  }
}

class pwdDialog_jRadioButton1_actionAdapter implements java.awt.event.ActionListener {
  pwdDialog adaptee;

  pwdDialog_jRadioButton1_actionAdapter(pwdDialog adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jRadioButton1_actionPerformed(e);
  }
}