package zcgl;

import java.awt.*;

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

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("修改");
        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();
}