package zcgl;

import java.awt.*;

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

public class UserPsw extends JFrame {
    Connection con = null;
    Statement smt = null;
    ResultSet rs = null;
    public UserPsw() {
        try {
            jbInit();
            con = new DbCon().getConnection();
            smt = con.createStatement();
            rs = smt.executeQuery("select * from OPERATOR");
            if (rs.next()) {
                txtUser.setText(rs.getString(1));
                txtPass.setText(rs.getString(2).trim());
            }

        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jPanel1.setBorder(BorderFactory.createEtchedBorder());
        jPanel1.setBounds(new Rectangle(52, 48, 289, 168));
        jPanel1.setLayout(null);
        jLabel2.setText("密碼");
        jLabel2.setBounds(new Rectangle(34, 103, 37, 26));
        txtPass.setBounds(new Rectangle(78, 107, 131, 21));
        jButton1.setBounds(new Rectangle(133, 240, 116, 37));
        jButton1.setToolTipText("");
        jButton1.setText("修改");
        jButton1.addActionListener(new UserPsw_jButton1_actionAdapter(this));
        this.getContentPane().add(jPanel1);
        this.getContentPane().add(jButton1);
        txtUser.setBounds(new Rectangle(75, 53, 131, 20));
        jPanel1.add(jLabel1);
        jPanel1.add(txtUser);
        jPanel1.add(jLabel2);
        jPanel1.add(txtPass);
        jLabel1.setText("用戶");
        jLabel1.setBounds(new Rectangle(36, 50, 107, 29));

    }

    JPanel jPanel1 = new JPanel();
    JLabel jLabel1 = new JLabel();
    JTextField txtUser = new JTextField();
    JLabel jLabel2 = new JLabel();
    JPasswordField txtPass = new JPasswordField();
    JButton jButton1 = new JButton();
    public void jButton1_actionPerformed(ActionEvent e) {
        con = new DbCon().getConnection();

        try {

             smt = con.createStatement();
            smt.executeUpdate("update OPERATOR set name='" + txtUser.getText()+"',pwd='"+txtPass.getText()+"'");
            JOptionPane.showMessageDialog(this, "成功修改！");
        } catch (SQLException ex) {
        }
    }
}


class UserPsw_jButton1_actionAdapter implements ActionListener {
    private UserPsw adaptee;
    UserPsw_jButton1_actionAdapter(UserPsw adaptee) {
        this.adaptee = adaptee;
    }

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