package xiangmu;
import java.awt.*;
import javax.swing.*;
import java.awt.Rectangle;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.*;
import javax.swing.JOptionPane;
import java.awt.Font;
import java.awt.event.WindowEvent;
import java.awt.event.WindowAdapter;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class PasswordInfo extends JFrame {
    public void mima(){
       this.txtyonoghming.setText("");
    }
    public PasswordInfo() {
        try {
            jbInit();
            mima();

        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    private void jbInit() throws Exception {
        this.setResizable(false);
        this.addWindowListener(new PasswordInfo_this_windowAdapter(this));
        getContentPane().setLayout(null);
        lblmima3.setFont(new java.awt.Font("楷體_GB2312", Font.BOLD, 13));
        lblmima3.setText("確認(rèn)密碼：");
        lblmima3.setBounds(new Rectangle(19, 154, 83, 19));
        lblyonghming.setFont(new java.awt.Font("楷體_GB2312", Font.BOLD, 13));
        lblyonghming.setText("用 戶 名:");
        lblyonghming.setBounds(new Rectangle(20, 63, 84, 19));
        txtyonoghming.setFont(new java.awt.Font("宋體", Font.BOLD, 12));
        txtyonoghming.setEditable(false);
        txtyonoghming.setBounds(new Rectangle(110, 57, 112, 23));
        txtyonoghming.addActionListener(new
                PasswordInfo_txtyonoghming_actionAdapter(this));
        txtmima.setFont(new java.awt.Font("Dialog", Font.BOLD, 13));
        txtmima.setBounds(new Rectangle(110, 89, 112, 23));
        txtmima2.setFont(new java.awt.Font("Dialog", Font.BOLD, 13));
        txtmima2.setBounds(new Rectangle(110, 121, 112, 23));
        txtmima3.setFont(new java.awt.Font("Dialog", Font.BOLD, 13));
        txtmima3.setBounds(new Rectangle(110, 151, 112, 23));
        btnqueding.setBounds(new Rectangle(26, 187, 62, 23));
        btnqueding.setText("確定");
        btnqueding.addActionListener(new mima_1_btnqueding_actionAdapter(this));
        btntuichu.setBounds(new Rectangle(164, 187, 61, 23));
        btntuichu.setText("退出");
        btntuichu.addActionListener(new mima_1_btntuichu_actionAdapter(this));
        lblmima.setFont(new java.awt.Font("楷體_GB2312", Font.BOLD, 13));
        lblmima2.setFont(new java.awt.Font("楷體_GB2312", Font.BOLD, 13));
        cmbusertype.setFont(new java.awt.Font("宋體", Font.BOLD, 12));
        cmbusertype.setEditable(false);
        cmbusertype.setBounds(new Rectangle(111, 24, 111, 24));
        this.getContentPane().add(btnqueding);
        jLabel1.setFont(new java.awt.Font("楷體_GB2312", Font.BOLD, 13));
        jLabel1.setText("用戶類型：");
        jLabel1.setBounds(new Rectangle(20, 28, 77, 23));
        this.getContentPane().add(btntuichu);
        this.getContentPane().add(lblmima3);
        this.getContentPane().add(txtmima3);
        this.getContentPane().add(txtmima2);
        this.getContentPane().add(lblmima);
        this.getContentPane().add(lblmima2);
        this.getContentPane().add(txtmima);
        this.getContentPane().add(lblyonghming);
        this.getContentPane().add(txtyonoghming);
        this.getContentPane().add(jLabel1);
        this.getContentPane().add(cmbusertype);
        lblmima.setText("舊 密 碼:");
        lblmima.setBounds(new Rectangle(20, 91, 78, 19));
        lblmima2.setText("新 密 碼:");
        lblmima2.setBounds(new Rectangle(20, 124, 78, 19));
        setTitle("密碼修改");

    }

    JLabel lblmima3 = new JLabel();
    JLabel lblmima2 = new JLabel();
    JLabel lblmima = new JLabel();
    JLabel lblyonghming = new JLabel();
    JTextField txtyonoghming = new JTextField();
    JPasswordField txtmima = new JPasswordField();
    JPasswordField txtmima2 = new JPasswordField();
    JPasswordField txtmima3 = new JPasswordField();
    JButton btnqueding = new JButton();
    JButton btntuichu = new JButton();
    JLabel jLabel1 = new JLabel();
    String usertype[]={"系統(tǒng)管理員","普通用戶"};
    JTextField cmbusertype = new JTextField();
    public void btnqueding_actionPerformed(ActionEvent e) {
        try {
              Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
              Connection con=DriverManager.getConnection("jdbc:odbc:xiangmu");
              PreparedStatement pre=con.prepareStatement("select Password from SysUser where UserName=? and UserType=?");
              pre.setString(1,this.txtyonoghming.getText());
              pre.setString(2,this.cmbusertype.getText());
              ResultSet re=pre.executeQuery();
              if(re.next()){
                  if(String.valueOf(this.txtmima.getPassword()).equals(re.getString(1).toString())){
                      PreparedStatement pre1 = con.prepareStatement(
                              "update SysUser set Password=? where UserName=?");
                      pre1.setString(1,String.valueOf(this.txtmima2.getPassword()));
                      pre1.setString(2,this.txtyonoghming.getText());
                      int re1=pre1.executeUpdate();
                      if(String.valueOf(this.txtmima2.getPassword()).equals(String.valueOf(this.txtmima3.getPassword()))){
                          if (re1 > 0) {
                              JOptionPane.showMessageDialog(this, "密碼修改成功！！");
                          } else {
                              JOptionPane.showMessageDialog(this, "修改失敗！！");
                          }
                      }else{
                          JOptionPane.showMessageDialog(this,"確認(rèn)密碼不相同，請(qǐng)重新輸入！！") ;
                      }
                  }else{
                      JOptionPane.showMessageDialog(this,"原始密碼輸入不正確，無法修改！");
                  }
              }else{
                  JOptionPane.showMessageDialog(this,"沒有該用戶名！！");
              }
        } catch (Exception ex) {

        }
    }

    public void btntuichu_actionPerformed(ActionEvent e) {
      try {
          if (JOptionPane.showConfirmDialog(this, "是否確定退出密碼修改", "溫馨提示",
                                             JOptionPane.OK_CANCEL_OPTION) ==
               JOptionPane.OK_OPTION) {
                       Dimension screenSize = Toolkit.getDefaultToolkit().
                                              getScreenSize();
                        this.dispose();
                   }

          this.setVisible(false);

      } catch (Exception ex) {

      }
    }

    public void txtyonoghming_actionPerformed(ActionEvent e) {
    }

    public void this_windowOpened(WindowEvent e) {
        this.txtyonoghming.setText(denglu.userName);
        this.cmbusertype.setText(denglu.userType);
    }
}


class PasswordInfo_this_windowAdapter extends WindowAdapter {
    private PasswordInfo adaptee;
    PasswordInfo_this_windowAdapter(PasswordInfo adaptee) {
        this.adaptee = adaptee;
    }

    public void windowOpened(WindowEvent e) {
        adaptee.this_windowOpened(e);
    }
}


class PasswordInfo_txtyonoghming_actionAdapter implements ActionListener {
    private PasswordInfo adaptee;
    PasswordInfo_txtyonoghming_actionAdapter(PasswordInfo adaptee) {
        this.adaptee = adaptee;
    }

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


class mima_1_btntuichu_actionAdapter implements ActionListener {
    private PasswordInfo adaptee;
    mima_1_btntuichu_actionAdapter(PasswordInfo adaptee) {
        this.adaptee = adaptee;
    }

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


class mima_1_btnqueding_actionAdapter implements ActionListener {
    private PasswordInfo adaptee;
    mima_1_btnqueding_actionAdapter(PasswordInfo adaptee) {
        this.adaptee = adaptee;
    }

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