package login;

import java.awt.EventQueue;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextField;
import javax.swing.border.EmptyBorder;

public class Login extends JFrame {


    private static final String DRIVER = "com.mysql.jdbc.Driver";
    private static final String URL = "jdbc:mysql://localhost:3306/crud";
    private static final String PASSWORD = "niemam1";
    private static final String USERNAME = "root";

    private String receivedUser;
    private String receivedPassword;


    private JPanel contentPane;
    private JTextField txtUsername;
    private JTextField txtPassword;

    private String userName;
    private String password;


    public Login() {
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        setBounds(100, 100, 119, 177);
        contentPane = new JPanel();
        contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
        setContentPane(contentPane);
        contentPane.setLayout(null);

        txtUsername = new JTextField();
        txtUsername.setText("username");
        txtUsername.setBounds(10, 32, 86, 20);
        contentPane.add(txtUsername);
        txtUsername.setColumns(10);

        txtPassword = new JTextField();
        txtPassword.setText("password");
        txtPassword.setBounds(10, 63, 86, 20);
        contentPane.add(txtPassword);
        txtPassword.setColumns(10);

        JButton btnLogin = new JButton("login");
        btnLogin.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent arg0) {

                //getting input from username and password fields
                userName = txtUsername.getText();
                password = txtPassword.getText();
                checkAndLogin(userName, password);
            }


        });
        btnLogin.setBounds(7, 94, 89, 23);
        contentPane.add(btnLogin);
    }


    private void checkAndLogin(String user, String pass) {

        Connection conn = null;
        Statement stmt = null;

        try{
            Class.forName(DRIVER);

            conn = DriverManager.getConnection(URL, USERNAME, PASSWORD);
            stmt = conn.createStatement();

            ResultSet rs = stmt.executeQuery("select * from users");

            while(rs.next()){
                receivedUser = rs.getString("username");
                receivedPassword = rs.getString("password");
            }
            rs.close();
            stmt.close();


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

        if(user.equals(receivedUser) && password.equals(receivedPassword)){
            JOptionPane.showMessageDialog(null,
                    "username and password correct");
        }else{
            JOptionPane.showMessageDialog(null,
                    "wrong username or password, try again",
                    "WRONG",
                    JOptionPane.ERROR_MESSAGE);

        }



    }

}