package supermarket;
import DB.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.*;
import java.awt.event.KeyEvent;
import java.awt.event.KeyAdapter;

public class Password
    extends JDialog {
  public Password() {
    try {
      jbInit();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  private void jbInit() throws Exception {
    lbltitle.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
    lbltitle.setText("密   碼   修   改");
    lbltitle.setBounds(new Rectangle(125, 10, 180, 35));
    this.getContentPane().setLayout(null);
    txtname.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblname.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lbljiu.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblxin.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblxin.setBounds(new Rectangle(44, 138, 111, 23));
    lblque.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    lblque.setBounds(new Rectangle(44, 177, 111, 23));
    jButton2.setBackground(Color.gray);
    jButton2.setBounds(new Rectangle(225, 230, 87, 33));
    jButton2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    jButton2.setText("");
    jButton2.addActionListener(new Password_jButton2_actionAdapter(this));
    btntijiao.setBackground(Color.gray);
    btntijiao.setBounds(new Rectangle(66, 230, 92, 33));
    btntijiao.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
    btntijiao.setText("");
    btntijiao.addActionListener(new Password_btntijiao_actionAdapter(this));
    lblque.setText("確認新密碼:");
    lblxin.setText("新    密   碼:");
    txtname.setText("");
    txtname.setBounds(new Rectangle(174, 60, 138, 23));
    txtname.addKeyListener(new Password_txtname_keyAdapter(this));
    lbljiu.setText("舊    密   碼:");
    lbljiu.setBounds(new Rectangle(44, 99, 111, 23));
    txtpsw.setText("");
    txtpsw.setBounds(new Rectangle(174, 99, 138, 23));
    txtpsw.addKeyListener(new Password_txtpsw_keyAdapter(this));
    txtpswnew.setText("");
    txtpswnew.setBounds(new Rectangle(174, 138, 138, 23));
    txtpswnew.addKeyListener(new Password_txtpswnew_keyAdapter(this));
    txtpswnew2.setText("");
    txtpswnew2.setBounds(new Rectangle(174, 177, 138, 23));
    txtpswnew2.addKeyListener(new Password_txtpswnew2_keyAdapter(this));
    this.setTitle("密碼修改");
    this.getContentPane().add(txtname);
    this.getContentPane().add(lblname);
    this.getContentPane().add(lbljiu);
    this.getContentPane().add(lblxin);
    this.getContentPane().add(lblque);
    this.getContentPane().add(lbltitle, null);
    this.getContentPane().add(txtpsw);
    this.getContentPane().add(txtpswnew);
    this.getContentPane().add(txtpswnew2);
    this.getContentPane().add(jButton2);
    this.getContentPane().add(btntijiao);
    this.setModal(true);
    lblname.setText("用    戶   名:");
    lblname.setBounds(new Rectangle(44, 60, 111, 23));
    btntijiao.setIcon(new ImageIcon("img/ok.jpg"));
    jButton2.setIcon(new ImageIcon("img/cal.jpg"));
  }

  JLabel lbltitle = new JLabel();
  JLabel lblname = new JLabel();
  JLabel lbljiu = new JLabel();
  JTextField txtname = new JTextField();
  JLabel lblxin = new JLabel();
  JLabel lblque = new JLabel();
  JButton btntijiao = new JButton();
  JButton jButton2 = new JButton();
  JPasswordField txtpsw = new JPasswordField();
  JPasswordField txtpswnew = new JPasswordField();
  JPasswordField txtpswnew2 = new JPasswordField();
  public void jButton2_actionPerformed(ActionEvent e) {
    this.dispose();
  }

  public void btntijiao_actionPerformed(ActionEvent e) {
    String name = txtname.getText().trim();//存用戶名
    String psw = String.valueOf(txtpsw.getPassword());//存原始密碼
    String pswnew = String.valueOf(txtpswnew.getPassword());//存新密碼
    String pswnew2 = String.valueOf(txtpswnew2.getPassword());//存新密碼
    if (name.equals("") || psw.equals("") || pswnew.equals("") ||//驗證信息完整
        pswnew2.equals("")) {
      JOptionPane.showMessageDialog(null, "請?zhí)顚懲暾畔?quot;, "錯誤",
                                    JOptionPane.ERROR_MESSAGE);
      return;
    }
   if (!pswnew.equals(pswnew2)) {//驗證兩次新密碼
      JOptionPane.showMessageDialog(null, "兩次新密碼必須相同", "提示",
                                    JOptionPane.INFORMATION_MESSAGE);
      return;
    }
     String sql = "";
    sql = "select * from usertitle where username='" + name + "' and password='"+psw+"'";
    Link lk = new Link();
    lk.connection();
    ResultSet rs = lk.Select(sql);
    try {
        if (rs.next()) {
          if (rs.getString(1).equals(name) && rs.getString(2).equals(psw)) {//確定要修改的用戶
            sql = "Update usertitle set password='" + pswnew +
                "' where username='" +
                name + "'";
            int it = lk.Update(sql);
            System.out.println(sql);
            if (it > 0) {
              JOptionPane.showMessageDialog(null, "密碼修改成功");//密碼修改成功后清空文本框
              txtname.setText("");
              txtpsw.setText("");
              txtpswnew.setText("");
              txtpswnew2.setText("");
            }
          }
          else {
            JOptionPane.showMessageDialog(null, "用戶名或密碼錯誤", "提示",
                                          JOptionPane.INFORMATION_MESSAGE);
          }
        }else{
          JOptionPane.showMessageDialog(null, "用戶名或密碼錯誤", "提示",
                                          JOptionPane.INFORMATION_MESSAGE);
        }

    }
    catch (SQLException ex) {
    }
    lk.close();
  }

  public void txtname_keyPressed(KeyEvent e) {
if((int)e.getKeyChar()==10){
  btntijiao_actionPerformed(null);
}
  }

  public void txtpsw_keyPressed(KeyEvent e) {
    if((int)e.getKeyChar()==10){
      btntijiao_actionPerformed(null);
}
  }

  public void txtpswnew_keyPressed(KeyEvent e) {
    if((int)e.getKeyChar()==10){
      btntijiao_actionPerformed(null);
}
  }

  public void txtpswnew2_keyPressed(KeyEvent e) {
    if((int)e.getKeyChar()==10){
      btntijiao_actionPerformed(null);
}
  }
}

class Password_txtpswnew2_keyAdapter
    extends KeyAdapter {
  private Password adaptee;
  Password_txtpswnew2_keyAdapter(Password adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.txtpswnew2_keyPressed(e);
  }
}

class Password_txtpsw_keyAdapter
    extends KeyAdapter {
  private Password adaptee;
  Password_txtpsw_keyAdapter(Password adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.txtpsw_keyPressed(e);
  }
}

class Password_txtpswnew_keyAdapter
    extends KeyAdapter {
  private Password adaptee;
  Password_txtpswnew_keyAdapter(Password adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.txtpswnew_keyPressed(e);
  }
}

class Password_btntijiao_actionAdapter
    implements ActionListener {
  private Password adaptee;
  Password_btntijiao_actionAdapter(Password adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.btntijiao_actionPerformed(e);
  }
}

class Password_txtname_keyAdapter
    extends KeyAdapter {
  private Password adaptee;
  Password_txtname_keyAdapter(Password adaptee) {
    this.adaptee = adaptee;
  }

  public void keyPressed(KeyEvent e) {
    adaptee.txtname_keyPressed(e);
  }
}

class Password_jButton2_actionAdapter
    implements ActionListener {
  private Password adaptee;
  Password_jButton2_actionAdapter(Password adaptee) {
    this.adaptee = adaptee;
  }

  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}