xgmima.java

实现学生信息管理,使学生信息管理工作更加容易,从而提高工作效率,降低管理成本.

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

public class xgmima extends JInternalFrame
{
  JLabel lbe1=new JLabel("修改密码");
  JPanel p=new JPanel();
  public xgmima()
  {
  	setTitle("修改密码");
    p.add(lbe1);
    AmendPanel panel=new AmendPanel();
    Container contentPane=getContentPane();
    contentPane.add(p,"North");
    contentPane.add(panel,"Center");

    setBounds(100, 100, 280, 260);
    this.setClosable(true);
    setVisible(true);
    
  }


}

class AmendPanel extends JPanel
{
  JButton b1,b2;
  JLabel lbe2,lbe3,lbe4,lbe5;
  JPasswordField pas1,pas2,pas3;
  JComboBox tf;
  public AmendPanel()
  {
          lbe2=new JLabel("用户名:");
          lbe3=new JLabel("输入旧密码:");
          lbe4=new JLabel("输入新密码:");
          lbe5=new JLabel("确定新密码:");
          tf=new JComboBox();
          pas1=new JPasswordField();
          pas2=new JPasswordField();
          pas3=new JPasswordField();
          b1=new JButton("确定");
          b2=new JButton("清空");

         //把组件加在内容窗格中
          add(lbe2);
          lbe2.setBounds(16,10,90,25);
          this.add(tf);
          tf.setBounds(100,10,120,25);
          add(lbe3);
          lbe3.setBounds(16,45,90,25);
          add(pas1);
          pas1.setBounds(100,45,120,25);
          add(lbe4);
          lbe4.setBounds(16,80,80,25);
          add(pas2);
          pas2.setBounds(100,80,120,25);
          add(lbe5);
          lbe5.setBounds(16,115,80,25);
          add(pas3);
          pas3.setBounds(100,115,120,25);
          add(b1);
          b1.setBounds(100,160,60,30);
          add(b2);
          b2.setBounds(160,160,60,30);
          setLayout(null);

//将所有用用户名读出来
         database.joinDB();
         String sql="select * from user";
         try{
         	if(database.query(sql)){
         		while(database.rs.next()){
         			String name=database.rs.getString("user_id");
         			tf.addItem(name);
         			}
         		}
         	}
         catch(Exception e){}
	b1.addActionListener(new ActionListener(){
         	public void actionPerformed(ActionEvent e){

         		String name="" + tf.getSelectedItem();
         		System.out.println(name);
         		String sql="select * from user where user_id='"+ name +"'";
         		System.out.println(sql);
         		try{
         		   if(database.query(sql)){
         		   	    database.rs.next();
	         			String ps1=pas1.getText();
	         			String password=database.rs.getString("Password");
	         			if(ps1.equals(password)){
	         				if(pas2.getText().equals(pas3.getText())){
	         					String supdate="update user set password='"+ pas3.getText()+"' where user_id='"+ name +"'";
	         					database.executeSQL(supdate);
	         					new JOptionPane().showMessageDialog(null,"密码更改成功！");
	         					}
	         				else{
	         					new JOptionPane().showMessageDialog(null,"两次密码不同！");
	         					}
	         				}
	         			else{
	         				new JOptionPane().showMessageDialog(null,"旧密码不正确！");
	         				}
	         			}
	         	    }
	         	 catch(Exception el){
	         	 	System.out.println(el);
	         	 	}
	         	}
         	});
         b2.addActionListener(new ActionListener(){
         	public void actionPerformed(ActionEvent e){
         		pas1.setText("");
         		pas2.setText("");
         		pas3.setText("");
         		}
         	});
  }
}