public List<User> getUsersList () {
        try {
            List<User> usersList = new ArrayList<>();
            Statement getUsersList = waggrConnection.createStatement();
            String query = "SELECT * FROM users;";
            ResultSet res = getUsersList.executeQuery(query);
            while (res.next()) {
                String userLogin = res.getString(1);
                String userPassword = res.getString(2);
                String userName = res.getString(3);
                String userSurname = res.getString(4);
                String userCity = res.getString(5);
                String userCountry = res.getString(6);
                User newUser = new User(userLogin,userPassword,userName,userSurname,userCity,userCountry);
                usersList.add(newUser);
            }
            return usersList;

        } catch (SQLException e) {
            System.out.println("getUserList exception");
        }
        return null;
    }