public class DBUtilities {
    // Getting connection to the database.
    public static Connection getConnection() throws SQLException {
        String url = "jdbc:mysql://localhost:3306/studentmanagementdb";
        String user = "admin";
        String pass = "administrator";
        Connection connection = DriverManager.getConnection(url, user, pass);
        return connection;
    }
    // Close prepared statement.
    public static void closePreparedStatement(PreparedStatement pStmt) {
        try {
            if(pStmt != null) {
                pStmt.close();
            }
        }catch(SQLException sExepction) {
            showErrorMsg("SQL Database Error:", "Prepared Statement could not be closed.");
        }
    }
    // Close result set.
    public static void closeResultSet(ResultSet resSet) {
        try {
            if (resSet != null){
                resSet.close();
            }
        }catch (SQLException sException) {
            showErrorMsg("SQL Database Error:", "Result Set could not be closed.");
        }
    }
    public static void closeConnection(Connection connect) {
        try {
            if(connect != null) {
                connect.close();
            }
        }catch (SQLException sException) {
            showErrorMsg("SQL Database Error:", "Database Connection could not be close.");
        }
    }
    // Shows error message.
    public static void showErrorMsg(String title, String msg) {
        Platform.runLater(() -> {
            Alert alert = new Alert(Alert.AlertType.ERROR);
            alert.setTitle(title);
            alert.setHeaderText(msg);
            alert.setWidth(200);
            alert.setHeight(200);
            alert.showAndWait();
        });
    }
}

@FXML
private TextField txtUserName;
@FXML
private PasswordField txtPassword;
@FXML
private Button btnLogin;

Connection connection = null;
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
DBUtilities dbUtil =  new DBUtilities();



// Setting the login button.
@FXML
private void setBtnLogin(ActionEvent event) {

    try {
        connection = dbUtil.getConnection();
        String sqlQuery = "SELECT * FROM 'User_Login_Details' WHERE 'User_Name' = ? AND 'User_Password' = ?";
        connection.prepareStatement(sqlQuery);
        preparedStatement.setString(1, txtUserName.getText());
        preparedStatement.setString(2, txtPassword.getText());
        resultSet = preparedStatement.executeQuery();

    }catch (Exception exception) {
        //dbUtilities.showErrorMsg("Database Connection Error:", "Could not connect to the database.");
        exception.printStackTrace();
    }finally {
        dbUtil.closePreparedStatement(preparedStatement);
        dbUtil.closeResultSet(resultSet);
        dbUtil.closeConnection(connection);
    }
}
@Override
public void initialize(URL location, ResourceBundle resources) {
    btnLogin.setOnAction(this::setBtnLogin);
}
}