package scince;

import java.awt.*;

import javax.swing.*;
import java.awt.Rectangle;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class PassWord_Change_Dialog extends JDialog {
    JPanel panel1 = new JPanel();
    JButton jButton1 = new JButton();
    JButton jButton2 = new JButton();
    JButton jButton3 = new JButton();
    JLabel jLabel1 = new JLabel();
    JLabel jLabel2 = new JLabel();
    JLabel jLabel3 = new JLabel();
    JLabel jLabel4 = new JLabel();
    JTextField jTextField1 = new JTextField();
    JPasswordField jPasswordField1 = new JPasswordField();
    JPasswordField jPasswordField2 = new JPasswordField();
    JPasswordField jPasswordField3 = new JPasswordField();
    public PassWord_Change_Dialog(Frame owner, String title, boolean modal) {
        super(owner, title, modal);
        try {
            setDefaultCloseOperation(DISPOSE_ON_CLOSE);
            jbInit();
            pack();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    public PassWord_Change_Dialog() {
        this(new Frame(), "PassWord_Change_Dialog", false);
    }

    private void jbInit() throws Exception {
        panel1.setLayout(null);
        jButton1.setBounds(new Rectangle(40, 238, 72, 37));
        jButton1.setText("確定");
        jButton1.addActionListener(new
                                   PassWord_Change_Dialog_jButton1_actionAdapter(this));
        jButton2.setBounds(new Rectangle(142, 239, 75, 37));
        jButton2.setText("重置");
        jButton2.addActionListener(new
                                   PassWord_Change_Dialog_jButton2_actionAdapter(this));
        jButton3.setBounds(new Rectangle(255, 237, 108, 38));
        jButton3.setText("取消退出");
        jButton3.addActionListener(new
                                   PassWord_Change_Dialog_jButton3_actionAdapter(this));
        jLabel1.setText("用戶名");
        jLabel1.setBounds(new Rectangle(45, 35, 89, 31));
        jLabel2.setText("舊密碼");
        jLabel2.setBounds(new Rectangle(45, 93, 79, 27));
        jLabel3.setText("新密碼");
        jLabel3.setBounds(new Rectangle(42, 130, 85, 40));
        jLabel4.setText("確認(rèn)新密碼");
        jLabel4.setBounds(new Rectangle(19, 193, 80, 27));
        jTextField1.setBounds(new Rectangle(135, 36, 83, 29));
        jPasswordField1.setBounds(new Rectangle(134, 82, 104, 33));
        jPasswordField2.setBounds(new Rectangle(134, 137, 104, 33));
        jPasswordField3.setBounds(new Rectangle(133, 189, 109, 31));
        panel1.setBackground(new Color(66, 255, 106));
        getContentPane().add(panel1);
        panel1.add(jButton1);
        panel1.add(jButton2);
        panel1.add(jButton3);
        panel1.add(jLabel2);
        panel1.add(jLabel1);
        panel1.add(jLabel3);
        panel1.add(jLabel4);
        panel1.add(jTextField1);
        panel1.add(jPasswordField1);
        panel1.add(jPasswordField2);
        panel1.add(jPasswordField3);
    }

    public void jButton3_actionPerformed(ActionEvent e) {
        this.dispose();
    }

    public void jButton2_actionPerformed(ActionEvent e) {
        jTextField1.setText("");
        jPasswordField1.setText("");
        jPasswordField2.setText("");
        jPasswordField3.setText("");
    }

    public void jButton1_actionPerformed(ActionEvent e) {
        Connection con;
        Statement sql;
        ResultSet rs;
        String queryString;
        String user;
        String password;
        String password1;
        String password2;
        user = jTextField1.getText().trim();
        password = jPasswordField1.getText();
        password1 = jPasswordField2.getText();
        password2 = jPasswordField3.getText();

        queryString = "select * from 用戶 where 用戶名='" + user + "' and 密碼='"+password+"'";
        //判斷用戶輸入十分是空
        if (user.equals("") || password.equals("")) {
            JOptionPane.showMessageDialog(null, "輸入的用戶名及密碼不完整！", "密碼修改對(duì)話框",
                                          JOptionPane.WARNING_MESSAGE);
        }
        //用戶沒(méi)有輸入新的密碼
        else if (password1.equals("") || password2.equals("")) {
            JOptionPane.showMessageDialog(null, "請(qǐng)輸入新密碼并確認(rèn)！", "密碼修改對(duì)話框",
                                          JOptionPane.WARNING_MESSAGE);
        }
        //輸入的兩個(gè)新密碼不一致；

        else if(!password1.equals(password2)){JOptionPane.showMessageDialog(null,"兩個(gè)新密碼不一致！","密碼修改對(duì)話框",JOptionPane.WARNING_MESSAGE);}
        //輸入都合法，判斷用戶名是否已經(jīng)存在
        else {
            try {
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            } catch (java.lang.ClassNotFoundException ee) {
                System.err.print("class not find!");
                System.err.println(ee.getMessage());
            }
            try {
                con = DriverManager.getConnection("jdbc:odbc:scince",
                                                  "", "");
                sql = con.createStatement();
                rs = sql.executeQuery(queryString);
                if (rs.next()) {

               queryString = "UPdate 用戶 set  密碼='" +
                             password2 +"' where 用戶名= '" + user + "'";
               sql.executeUpdate(queryString);
               JOptionPane.showMessageDialog(null, "密碼修改成功！", "密碼修改對(duì)話框",
                                             JOptionPane.WARNING_MESSAGE);
               jTextField1.setText("");
               jPasswordField1.setText("");
               jPasswordField2.setText("");
               jPasswordField3.setText("");


           } else {

               JOptionPane.showMessageDialog(null, "您輸入的用戶不存在！",
                                           "密碼修改對(duì)話框",
                                           JOptionPane.WARNING_MESSAGE);
             jTextField1.setText("");
             jPasswordField1.setText("");
             jPasswordField2.setText("");
             jPasswordField3.setText("");
              queryString="";

           }

            } catch (SQLException ex) {};



        }

    }


    class PassWord_Change_Dialog_jButton2_actionAdapter implements
            ActionListener {
        private PassWord_Change_Dialog adaptee;
        PassWord_Change_Dialog_jButton2_actionAdapter(PassWord_Change_Dialog
                adaptee) {
            this.adaptee = adaptee;
        }

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


    class PassWord_Change_Dialog_jButton1_actionAdapter implements
            ActionListener {
        private PassWord_Change_Dialog adaptee;
        PassWord_Change_Dialog_jButton1_actionAdapter(PassWord_Change_Dialog
                adaptee) {
            this.adaptee = adaptee;
        }

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


    class PassWord_Change_Dialog_jButton3_actionAdapter implements
            ActionListener {
        private PassWord_Change_Dialog adaptee;
        PassWord_Change_Dialog_jButton3_actionAdapter(PassWord_Change_Dialog
                adaptee) {
            this.adaptee = adaptee;
        }

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