passwordschange.java~12~

学生信息管理系统,包括成绩查询,成绩排序,用ACCESS做数据库连接

package Chapter1;
import java.io.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import java.awt.Rectangle;
import java.awt.Font;

public class  PasswordsChange extends JFrame implements ActionListener
{
   public static final int WIDTH=400;
   public static final int HEIGHT=400;

  JLabel jLabel1 = new JLabel();
  JTextField jTextField1 = new JTextField();
  JLabel jLabel2 = new JLabel();
  JTextField jTextField2 = new JTextField();
  JLabel jLabel3 = new JLabel();
  JTextField jTextField3 = new JTextField();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JButton jButton3 = new JButton();
  JLabel jLabel4 = new JLabel();
  JTextField jTextField4 = new JTextField();
  JComboBox jComboBox1 = new JComboBox();
  JLabel jLabel5 = new JLabel();
  public PasswordsChange()
   {
     setSize(WIDTH,HEIGHT);
     setTitle("修改密码");
     Container contentPane=getContentPane();
     contentPane.setBackground(Color.green);
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
   }
   public void actionPerformed(ActionEvent e)
   {
     if(e.getActionCommand().equals("修改"))
        { //用于获取用户输入的信息
           try
           {
             String url="jdbc:odbc:MySecondAccess";
             Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
             Connection con=DriverManager.getConnection(url,"","");
             Statement stmt=con.createStatement();
             String SQLOrder1="SELECT * FROM ManagersInformation WHERE 帐号='"+jTextField4.getText()+"' AND 密码='"+jTextField1.getText()+"'";
             String SQLOrder2="SELECT * FROM StudentsInformation WHERE 帐号='"+jTextField4.getText()+"' AND 密码='"+jTextField1.getText()+"'";
             ResultSet resultset=null;
             if(jComboBox1.getSelectedIndex()==0)
               resultset= stmt.executeQuery(SQLOrder1);
             else if(jComboBox1.getSelectedIndex()==1)
               resultset= stmt.executeQuery(SQLOrder2);
             if (resultset.next())
            {  //TEST
               System.out.println(1);
               if(jTextField2.getText().equals(jTextField3.getText()))
             {System.out.println(2);
              String  SQLOrder11="UPDATE ManagersInformation SET 密码='"+jTextField3.getText()+"' WHERE 帐号='"+jTextField4.getText()+"'";
              String  SQLOrder22="UPDATE StudentsInformation SET 密码='"+jTextField3.getText()+"' WHERE 帐号='"+jTextField4.getText()+"'";
              ResultSet resultSet=null;
              if(jComboBox1.getSelectedIndex()==0)
              resultSet= stmt.executeQuery(SQLOrder11);
              else if(jComboBox1.getSelectedIndex()==1)
              resultSet= stmt.executeQuery(SQLOrder22);
                  JOptionPane.showMessageDialog(null,"密码修改成功！","提示信息",JOptionPane.INFORMATION_MESSAGE);
             }
              else
              { System.out.println(3);
                JOptionPane.showMessageDialog(null,"您两次输入的密码不一致，请重新输入！","警告信息",JOptionPane.WARNING_MESSAGE);
                jTextField1.setText("");
                jTextField2.setText("");
                jTextField3.setText("");
                jTextField4.setText("");
              }
           }
            else
             { System.out.println(4);
               JOptionPane.showMessageDialog(null,"您所输入的帐号或密码不正确，请重新输入！","警告信息",JOptionPane.WARNING_MESSAGE);
               jTextField1.setText("");
               jTextField2.setText("");
               jTextField3.setText("");
               jTextField4.setText("");
             }
             stmt.close();
             con.close();
           }
           catch(Exception ex)
           {
             System.out.println(ex.getStackTrace());
             System.out.println(ex.getMessage());
           }
        }
      else if (e.getActionCommand().equals("重置"))
      {
          jTextField1.setText("");
          jTextField2.setText("");
          jTextField3.setText("");
          jTextField4.setText("");
      }
      else if  (e.getActionCommand().equals("返回"))
      {
           this.setVisible(false);
           ManagerInterface n1= new ManagerInterface();
           StudentInterface n2=new  StudentInterface();
           if(Login.jComboBox1.getSelectedIndex()==0)
                 {  n1.setVisible(true);  n2.setVisible(false);}
           else if(Login.jComboBox1.getSelectedIndex()==1)
                 {  n2.setVisible(true);  n1.setVisible(false); }
      }
   }
   public static void main(String[] args)
   {
       PasswordsChange n=new PasswordsChange();
       n.setVisible(true);
   }
  private void jbInit() throws Exception {
    jLabel1.setFont(new java.awt.Font("Dialog", 1, 13));
    jLabel1.setText("请输入旧密码:");
    jLabel1.setBounds(new Rectangle(46, 106, 106, 26));
    this.setLocale(java.util.Locale.getDefault());
    this.getContentPane().setLayout(null);
    jTextField1.setText("");
    jTextField1.setBounds(new Rectangle(174, 109, 90, 21));
    jLabel2.setFont(new java.awt.Font("Dialog", 1, 13));
    jLabel2.setText("请输入新密码:");
    jLabel2.setBounds(new Rectangle(46, 147, 90, 24));
    jTextField2.setText("");
    jTextField2.setBounds(new Rectangle(175, 148, 90, 21));
    jLabel3.setFont(new java.awt.Font("Dialog", 1, 13));
    jLabel3.setText("确认新密码:");
    jLabel3.setBounds(new Rectangle(59, 191, 88, 25));
    jTextField3.setText("");
    jTextField3.setBounds(new Rectangle(174, 191, 90, 21));
    jButton1.setBounds(new Rectangle(42, 237, 70, 30));
    jButton1.setFont(new java.awt.Font("Dialog", 1, 13));
    jButton1.setText("修改");
    jButton2.setBounds(new Rectangle(162, 236, 70, 30));
    jButton2.setFont(new java.awt.Font("Dialog", 1, 13));
    jButton2.setText("重置");
    jButton3.setBounds(new Rectangle(278, 236, 70, 30));
    jButton3.setFont(new java.awt.Font("Dialog", 1, 13));
    jButton3.setText("返回");
    jLabel4.setFont(new java.awt.Font("Dialog", 1, 13));
    jLabel4.setText("请输入帐号:");
    jLabel4.setBounds(new Rectangle(55, 70, 86, 23));
    jTextField4.setBounds(new Rectangle(174, 70, 90, 21));
    jComboBox1.setBounds(new Rectangle(174, 17, 89, 26));
    jLabel5.setFont(new java.awt.Font("Dialog", Font.BOLD, 13));
    jLabel5.setText("用户类型:");
    jLabel5.setBounds(new Rectangle(69, 17, 71, 25));
    jComboBox1.addItem("管理员");
    jComboBox1.addItem("学生");
    this.getContentPane().add(jButton1, null);
    this.getContentPane().add(jButton2, null);
    this.getContentPane().add(jButton3, null);
    this.getContentPane().add(jLabel3, null);
    this.getContentPane().add(jTextField3, null);
    this.getContentPane().add(jLabel2, null);
    this.getContentPane().add(jTextField2, null);
    this.getContentPane().add(jLabel1, null);
    this.getContentPane().add(jTextField1, null);
    this.getContentPane().add(jLabel4, null);
    this.getContentPane().add(jTextField4, null);
    this.getContentPane().add(jComboBox1);
    this.getContentPane().add(jLabel5);
    jButton1.addActionListener(this);
    jButton2.addActionListener(this);
    jButton3.addActionListener(this);
  }
}