editpassword.java

用JAVA+SQL编写的一个教学管理软件

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

public class Editpassword extends JFrame{
	
	private String tempStatus,tempName;
	private int tempId;
	private JLabel lbl_oldpwd,lbl_newpwd,lbl_conpwd;
	private JPasswordField pwd_old,pwd_new,pwd_con;
	private JButton btn_ok,btn_back;
	private JPanel panel;
	private String ErrorMessage;
	private String sql;
	
	public Editpassword(String status,String name,int id){
		super("密码修改");
		tempStatus=status;
		tempName=name;
		tempId=id;
		lbl_oldpwd=new JLabel("原密码");
		lbl_newpwd=new JLabel("新密码");
		lbl_conpwd=new JLabel("确认密码");
		pwd_old=new JPasswordField();
		pwd_new=new JPasswordField();
		pwd_con=new JPasswordField();
		btn_back=new JButton("返回");
		btn_ok=new JButton("提交");
		
		panel=new JPanel();
		panel.setLayout(new GridLayout(4,2,10,10));
		panel.add(lbl_oldpwd);
		panel.add(pwd_old);
		panel.add(lbl_newpwd);
		panel.add(pwd_new);
		panel.add(lbl_conpwd);
		panel.add(pwd_con);
		panel.add(btn_ok);
		panel.add(btn_back);
		panel.setBorder(BorderFactory.createEmptyBorder(20,20,15,20));
		getContentPane().add(panel);
		
		addWindowListener(new WindowAdapter(){
			public void windowClosing(WindowEvent e)
			{
				dispose();
				System.exit(0);
			}
		});	
		setLocation(400,250);
		pack();
		setVisible(true);
		
		btn_back.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
				dispose();
				returnMenu();
			}	
		});
		
		btn_ok.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent e){
				try{
					
					if(!checkView()){
						JOptionPane.showMessageDialog(pwd_new,ErrorMessage,"错误",1);
					}
					else{
						
					    Connection conn=null;
				    	DateSource date=new DateSource();
				    	conn=date.getconnection();
				    	if(tempStatus.equals("同学")){
							sql="SELECT * FROM students WHERE id=?";
						}
						else if(tempStatus.equals("老师")){
							sql="SELECT * FROM teacher WHERE id=?";
						}
						else if(tempStatus.equals("管理员")){
							sql="SELECT * FROM admi WHERE id=?";
						}
						PreparedStatement stmt=conn.prepareStatement(sql,ResultSet.TYPE_SCROLL_INSENSITIVE,
                                      ResultSet.CONCUR_UPDATABLE);
						stmt.setInt(1,tempId);
						ResultSet rs=stmt.executeQuery();
						if(rs.next()){
							String tempPwd;
							tempPwd=rs.getString(2);
							if(tempPwd.equals(pwd_old.getText())){
								rs.updateString(2,pwd_new.getText());
								rs.updateRow();
								JOptionPane.showMessageDialog(pwd_new,"密码修改成功","提示",1);
								dispose();
								returnMenu();
								rs.close();
								conn.close();
							}
						else {
							JOptionPane.showMessageDialog(pwd_new,"原密码错误","错误",1);
							rs.close();
							conn.close();
						}
					}
					
				}
			}catch(Exception ex){
					JOptionPane.showMessageDialog(pwd_new,ex.getMessage(),"错误",1);
				}
							
		}
	});
		
		
	}
	
	private boolean checkView(){
		boolean flag=true;
		ErrorMessage="";
		if(pwd_old.getText().equals("")){
			flag=false;
			ErrorMessage=ErrorMessage+"\n"+"原密码不能为空";
        }
		if(pwd_new.getText().equals("")){
			flag=false;
			ErrorMessage=ErrorMessage+"\n"+"新密码不能为空";
		}
		else{
			if(pwd_con.getText().equals("")){
			     flag=false;
			     ErrorMessage=ErrorMessage+"\n"+"确认密码不能为空";
		    }
		    else{
		    	if(!pwd_new.getText().equals(pwd_con.getText())){
		    		flag=false;
			        ErrorMessage=ErrorMessage+"\n"+"新密码和确认密码不一样";
		    	}
		    }
		}
		if(flag==false){
			return false;
		}
		else
		return true;
	}
	
	private void returnMenu(){
		Cmenu user=new Cmenu(tempStatus,tempName,tempId);
	}
	
	
}