updatepassword.java

这是一个用java语言开发的运动员成绩统计系统

package com.userManager;

import com.DBManager.MyDB;
import com.MainFrame;
import java.awt.TextField;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import javax.swing.Box;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextField;
/**
 * @author  Laiger
 */
public class UpdatePassword extends JFrame implements ActionListener{
	JPanel p=new JPanel();
	JLabel userID=new JLabel("帐号");


	JLabel password=new JLabel("密码");
	JLabel newPassword=new JLabel("新密码");
	JLabel confirmAgain=new JLabel("确认密码");
	JTextField t_user=new JTextField(10);
	TextField t_pass=new TextField(10);
	TextField t_pass_new=new TextField(10);
    TextField t_pass_new2=new TextField(10);
    Box base;
    Box box1;
    Box box2;
	JButton confirm=new JButton("更新");
	JButton cancel=new JButton("取消");
	private MainFrame m;
	private MyDB db=new MyDB();
	public UpdatePassword(MainFrame m){
		super("UserInfo Update");
		this.m=m;
		this.setBounds(300,300,300,260);
		this.setVisible(true);
		 this.setResizable(false);
		t_pass.setEchoChar('*');
		t_pass_new.setEchoChar('*');
		t_pass_new2.setEchoChar('*');
		
		confirm.addActionListener(this);
		cancel.addActionListener(this);
		
		box1=Box.createVerticalBox();
		box2=Box.createVerticalBox();
		base=Box.createHorizontalBox();
		
		box1.add(userID);
		box1.add(Box.createVerticalStrut(5));
		box1.add(password);
		box1.add(Box.createVerticalStrut(5));
		box1.add(newPassword);
		box1.add(Box.createVerticalStrut(5));
		box1.add(confirmAgain);
		box1.add(Box.createVerticalStrut(50));
		box1.add(confirm);
		
		box2.add(t_user);
		box2.add(t_pass);
		box2.add(t_pass_new);
		box2.add(t_pass_new2);
		box2.add(Box.createVerticalStrut(45));
		box2.add(cancel);
		
		base.add(box1);
		base.add(Box.createHorizontalStrut(20));
		base.add(box2);
		p.add(base);
		add(p);
		this.addWindowListener(new WindowAdapter(){
			public void windowClosing(WindowEvent e){
				dispose();
			}
		});
		
		
	}
	public void actionPerformed(ActionEvent e) {

		if(e.getSource()==cancel){
			m.setVisible(true);
			this.dispose();
		}
		else
		{
			 if(t_user.getText().trim().equals(""))
			  {
			   JOptionPane.showMessageDialog(this, "用户帐号不可为空！");
			   return;
			  }
			  if(t_pass.getText().trim().equals(""))
			  {
				  JOptionPane.showMessageDialog(this, "原密码不可为空！");
				   return;
			  }
			  if(t_pass_new.getText().trim().equals(""))
			  {
				  JOptionPane.showMessageDialog(this, "新密码不可为空！");
				   return; 
			  }
			  if(t_pass_new2.getText().trim().equals(""))
			  {
				  JOptionPane.showMessageDialog(this, "再次输入的新密码不可为空！");
				   return; 
			  }
			  if(!t_pass_new.getText().trim().equals(t_pass_new2.getText().trim()))
			  {
				  JOptionPane.showMessageDialog(this, "两次输入的密码不同！");
				   return; 
			  }
			  db.connectDB();
			String  strSQL="select * from user where userID='"+t_user.getText().trim()+"' and password='"+t_pass.getText().trim()+"'";
			int count=db.rowCount(strSQL);
			 
			 if(count<1){
				 JOptionPane.showMessageDialog(this, "用户已经不存在或者密码错误！");
				  
			 }
			 else {//change password
				 strSQL="update user set Password='"+t_pass_new.getText().trim()+"' where userID='"+t_user.getText().trim()+"' and password='"+t_pass.getText().trim()+"'";
				 System.out.println(strSQL);
				 if(db.executeUpdate(strSQL))
				 {
					 JOptionPane.showMessageDialog(this, "更新成功！");
					 db.close();
					 this.dispose();
					   
				 }
				 else{
					 JOptionPane.showMessageDialog(this, "更新失败，请重新操作！"); 
				 }
			 }
			 
		}
		
	
		
	}
}