public User getUser (String login){
        try {
            Statement CheckLogin = waggrConnection.createStatement();
            ResultSet Res = CheckLogin.executeQuery("SELECT * FROM users WHERE login ='" + login + "';");
            if (Res.next()) {
                Res.close();
                Statement GetCity = waggrConnection.createStatement();
                ResultSet UserData = GetCity.executeQuery("SELECT password, name, surname, city_name, country_name  FROM users WHERE login ='" + login +  "';");
                UserData.next();
                return new User(login, UserData.getString(1), UserData.getString(2), UserData.getString(3), UserData.getString(4),UserData.getString(5));
            }
            Res.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return null;
    }