import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class YongHuGengGai extends JFrame implements ActionListener
{
	ShuJuKu db=new ShuJuKu();
	ResultSet rs;
	JPanel panel1,panel2;
	Container c;
	JLabel UserLabel,PasswordLabel,NewPasswordLabel,PasswordConfirmLabel;
	JTextField UserTextField;
	JPasswordField PasswordTextField,NewPasswordTextField,PasswordConfirmTextField;
	JButton UpdateBtn,CancelBtn;
	public YongHuGengGai()
	{
		super("更改密碼");
		c=getContentPane();
		c.setLayout(new BorderLayout());
		UserLabel=new JLabel("用戶名",JLabel.CENTER);
		PasswordLabel=new JLabel("原密碼",JLabel.CENTER);
		NewPasswordLabel=new JLabel("新密碼",JLabel.CENTER);
		PasswordConfirmLabel=new JLabel("確認新密碼",JLabel.CENTER);
		UserTextField=new JTextField(10);
		PasswordTextField=new JPasswordField(10);
		NewPasswordTextField=new JPasswordField(10);
		PasswordConfirmTextField=new JPasswordField(10);
		UpdateBtn=new JButton("更新");
		CancelBtn=new JButton("取消");
		UpdateBtn.addActionListener(this);
		CancelBtn.addActionListener(this);
		panel1=new JPanel();
		panel1.setLayout(new GridLayout(4,2));
		panel1.add(UserLabel);
		panel1.add(UserTextField);
		panel1.add(PasswordLabel);
		panel1.add(PasswordTextField);
		panel1.add(NewPasswordLabel);
		panel1.add(NewPasswordTextField);
		panel1.add(PasswordConfirmLabel);
		panel1.add(PasswordConfirmTextField);
		panel2=new JPanel();
		panel2.add(UpdateBtn);
		panel2.add(CancelBtn);
		c.add(panel1,BorderLayout.CENTER);
		c.add(panel2,BorderLayout.SOUTH);
		setSize(300,300);
		
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==CancelBtn)
		{
			db.closeConnection();
			this.dispose();
		}
		else if(e.getSource()==UpdateBtn)
		{
			try
			{
				char[] password=PasswordTextField.getPassword();
			        String passwordSTR=new String(password);
			        char[] newPassword=NewPasswordTextField.getPassword();
			        String newPasswordSTR=new String(newPassword);
			        char[] confirmPassword=PasswordConfirmTextField.getPassword();
			        String confirmPasswordSTR=new String(confirmPassword);
				String strSQL="select * from userTable where userName='"+
				UserTextField.getText().trim()+"'and password='"+
				passwordSTR+"'";
				if(UserTextField.getText().trim().equals(""))
				{
					JOptionPane.showMessageDialog(null,"用戶名不能為空！");
				}
				else if(passwordSTR.equals(""))
				{
					JOptionPane.showMessageDialog(null,"原密碼不能為空！");
				}
				else if(!newPasswordSTR.equals(confirmPasswordSTR))
				{
					JOptionPane.showMessageDialog(null,"兩次輸入的新密碼不一致！");
				}
				else 
				{
					if(!db.getResult(strSQL).first())
				        {
					          JOptionPane.showMessageDialog(null,"此用戶不存在或者原密碼不正確！");
					 
				        }
				        else
				        {
				        	strSQL="update userTable set password='"+
				        	newPasswordSTR+"'where userName='"+UserTextField.getText()
				        	.trim()+"'";
				        	if(db.updateSql(strSQL))
				        	{
				        		JOptionPane.showMessageDialog(null,"更新密碼成功！");
				        		this.dispose();
				        	}
				        	else
				        	{
				        		JOptionPane.showMessageDialog(null,"更新密碼失敗！");
				        		this.dispose();
				        	}
				        	db.closeConnection();
				        }
				}
			}
			catch(SQLException sqle)
			{
				System.out.println(sqle.toString());
			}
			catch(Exception ex)
			{
				System.out.println(ex.toString());
			}
		}
	}
}