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

public class DB_LoginGUI {

//    declare the frame/window
    private JFrame frame;

//    declare user text field
    private JTextField usernameField;

//    declare password field
    private JPasswordField passwordField;

//    declare user label
    private JLabel userLabel;

//    declare password label
    private JLabel passwordLabel;

//    declare connect button
    private JButton connect;

//    constructor
    public DB_LoginGUI() {
        initialize();
    }

//    the initialize method that builds the window
    private void initialize() {

//    creates the frame/window
        frame = new JFrame("Login Window");
        frame.setBounds(100, 100, 450, 300);
        frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        frame.getContentPane().setLayout(null);


//    create user field
        usernameField = new JTextField();
        usernameField.setBounds(156, 56, 203, 26);
        frame.getContentPane().add(usernameField);
        usernameField.setColumns(10);

//    create password field
        passwordField = new JPasswordField();
        passwordField.setBounds(156, 107, 203, 26);
        frame.getContentPane().add(passwordField);
        usernameField.setColumns(10);

//    create user label
        userLabel = new JLabel("User name: ");
        userLabel.setBounds(57, 61, 87, 16);
        frame.getContentPane().add(userLabel);

//    create password label
        passwordLabel = new JLabel("Password: ");
        passwordLabel.setBounds(63, 112, 70, 16);
        frame.getContentPane().add(passwordLabel);

//    create connect button
        connect = new JButton("Connect");
        connect.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
               DB_Statements stmts = new DB_Statements();

               try {
                   String username = usernameField.getText();
                   String password = new String(passwordField.getPassword());
                   if (stmts.checkLogin(username, password)) {
                       JOptionPane.showMessageDialog(null, "User found\n Access granted");
                   } else {
                       JOptionPane.showMessageDialog(null, "User not found\nAccess denied");
                   }
               }
               catch (Exception e1) {
                   JOptionPane.showMessageDialog(null, e1);
               }
            }
        });
        connect.setBounds(148, 172, 117,29);
        frame.getContentPane().add(connect);
        frame.setVisible(true);

//    create button action
    }
}