Why this is not passing?Someone please help

Question about the task

Build a WHERE query

Java Multithreading, Level 2, Lesson 9

Resolved

Build part of a WHERE query using StringBuilder.
If a parameter is null, then it shouldn't be included in the query.

Example:

{name=Johnson, country=United States, city=Los Angeles, age=null}

Result:

name = 'Johnson' and country = 'United States' and city = 'Los Angeles'

Requirements:

The getQuery method must have one Map parameter.
The getQuery method must return a String.
The getQuery method must be static.
The getQuery method must return a string built according to the rules specified in the task conditions.

package com.codegym.task.task22.task2208; import java.util.HashMap; import java.util.Map; import java.util.Formatter; import java.util.Objects; /* Build a WHERE query */ public class Solution { public static void main(String[] args) { Map<String, String> map = new HashMap<>(); // map.put("name", "Johnson"); // map.put("country", "United States"); // map.put("city", "Los Angeles"); map.put("age", null); System.out.println(getQuery(map)); } public static String getQuery(Map<String, String> params) { // params.values().removeIf(Objects::isNull); StringBuilder str = new StringBuilder(" "); if (params == null || params.isEmpty()) return str.toString(); for (Map.Entry<String, String> map : params.entrySet()) { if (map.getValue() == null || map.getKey() == null) continue; str.append(map.getKey()).append(" = '").append(map.getValue()).append("' and "); } if(str.length()>5) str.delete(str.length() - 4, str.length()); return str.toString(); } }

Comments (6)

Popular
New
Old

You must be signed in to leave a comment

Nouser

Level 36 , Germany

1 April 2021, 07:13

public static void main(String[] args) {
   Map<String, String> map = new HashMap<>();
   /*map.put("name", "Johnson");
   map.put("country", "United States");
   map.put("city", "Los Angeles");
   map.put("age", null);*/

   System.out.println(getQuery(map));
}

run and try to select the resulting text, it's a " ", (see creation of the StringBuilder object). I'd say the result should be ""

Josephine

Level 26 , Normal, United States

1 April 2021, 13:44

still not validating... Validator saying "Generate the correct string" My code is public static void main(String[] args) { Map<String, String> map = new HashMap<>(); map.put("name", "Johnson"); map.put("country", "United States"); map.put("city", "Los Angeles"); map.put("age", null); System.out.println(getQuery(map)); } public static String getQuery(Map<String, String> params) { StringBuilder str = new StringBuilder(""); if (params == null || params.isEmpty()) return str.toString(); for (Map.Entry<String, String> map : params.entrySet()) { if (map.getValue() == null || map.getKey() == null) continue; str.append(map.getKey()).append(" = '").append(map.getValue()).append("' and "); } if(str.length()>5) str.delete(str.length() - 4, str.length()); return str.toString(); } }