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

public class UserModify
    extends JFrame
    implements ActionListener {
  DataBaseManager db = new DataBaseManager();
  ResultSet rs;
  JPanel panel1, panel2;
  Container c;
  JLabel UserLabel, PasswordLabel, NewPasswordLabel, PasswordConfirmLabel;
  JTextField UserTextField;
  JPasswordField PasswordTextField, NewPasswordTextField,
      PasswordConfirmTextField;
  JButton UpdateBtn, CancelBtn;
  public UserModify() {
    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)>0) {
              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());
      }
    }
  }
}