package testsystem;

import java.awt.*;
import java.sql.*;
import javax.swing.*;
import java.awt.Rectangle;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

public class PassWordFrom extends JFrame {
    private ImageIcon im1 = new ImageIcon("img\\forumlink.gif");
    public PassWordFrom() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.setResizable(false);
        setTitle("密碼修改");
        getContentPane().setLayout(null);
        jLabel1.setText("請輸入用戶名：");
        jLabel1.setBounds(new Rectangle(53, 64, 96, 28));
        jButton1.setBounds(new Rectangle(152, 206, 111, 35));
        jButton1.setToolTipText("");
        jButton1.setIcon(im1);
        jButton1.setText("修改");
        jButton1.addActionListener(new PassWordFrom_jButton1_actionAdapter(this));
        this.getContentPane().add(jLabel1);
        jp2.setBounds(new Rectangle(152, 149, 147, 32));
        jp1.setBounds(new Rectangle(151, 105, 149, 30));
        jt1.setBounds(new Rectangle(151, 65, 150, 30));
        jLabel4.setHorizontalAlignment(SwingConstants.CENTER);
        jLabel4.setText("密 碼 修 改");
        jLabel4.setBounds(new Rectangle(122, 11, 151, 32));
        jLabel3.setText("請輸入新密碼：");
        jLabel3.setBounds(new Rectangle(53, 148, 87, 28));
        this.getContentPane().add(jLabel2);
        this.getContentPane().add(jLabel3);
        this.getContentPane().add(jLabel4);
        this.getContentPane().add(jt1);
        this.getContentPane().add(jp1);
        this.getContentPane().add(jp2);
        this.getContentPane().add(jButton1);
        jLabel2.setText("請輸入舊密碼：");
        jLabel2.setBounds(new Rectangle(53, 105, 85, 29));
    }

    public static void main(String[] args) {
        PassWordFrom passwordfrom = new PassWordFrom();
    }

    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JTextField jt1 = new JTextField();
    JPasswordField jp1 = new JPasswordField();
    JPasswordField jp2 = new JPasswordField();
    JButton jButton1 = new JButton();
    public void jButton1_actionPerformed(ActionEvent e) {
          String Name=jt1.getText().trim();
          String psw=new String(jp1.getPassword()).trim();
          String pwd=new String(jp2.getPassword()).trim();
          Connection con=null;
          Statement s1=null;
          ResultSet rs=null;
          if(Name.length()!=0&&psw.length()!=0&&pwd.length()!=0)
          {
              try
              {
                  con = DBcon.link();
                  s1 = con.createStatement();
                  rs = s1.executeQuery("select * from Login where Name='" + Name + "'");
                  if (rs.next())
                  {
                      String oldpsw = rs.getString("Password");
                      if (oldpsw.equals(psw))
                      {
                          JOptionPane.showMessageDialog(null, "舊密碼輸入正確！");
                          s1.executeUpdate("update Login set PassWord='"+pwd+"' where Name='"+Name+"'");
                          JOptionPane.showMessageDialog(null, "新密碼修改成功！");
                      }
                      else
                      {
                          JOptionPane.showMessageDialog(null, "舊密碼輸入錯誤！","提示",JOptionPane.ERROR_MESSAGE);
                      }
                  }
                  else
                  {
                      JOptionPane.showMessageDialog(null, "無此用戶，請重新輸入！","提示",JOptionPane.ERROR_MESSAGE);
                      jt1.setText("");
                      jp1.setText("");
                      jp2.setText("");
                      jt1.requestFocus();
                  }
              }
              catch(SQLException co)
              {
                  co.getMessage();
              }
          }
          else
          {
              JOptionPane.showMessageDialog(null, "對不起，信息不能為空！","提示",JOptionPane.ERROR_MESSAGE);
          }
    }
}


class PassWordFrom_jButton1_actionAdapter implements ActionListener {
    private PassWordFrom adaptee;
    PassWordFrom_jButton1_actionAdapter(PassWordFrom adaptee) {
        this.adaptee = adaptee;
    }

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