why does it not accept this solution?

Question about the task

Under discussion

the result is correct?

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.*; /* Build a WHERE query */ public class Solution { public static void main(String[] args) { Map<String, String> map = new HashMap<>(); map.put("name", null); map.put("country", "United States"); map.put(null, "Los Angeles"); map.put("age", null); System.out.println(getQuery(map)); } public static String getQuery(Map<String, String> params) { StringBuilder str = new StringBuilder(); for(Map.Entry<String, String> pair : params.entrySet()){ String key = pair.getKey(); String val = pair.getValue(); if(val == null || key == null) continue; str.append(key + " = '" + val + "' and "); } str.delete(str.length() - 5, str.length()); return str.toString(); } }

Comments (3)

Popular
New
Old

You must be signed in to leave a comment

Guadalupe Gagnon

Level 37 , Tampa, United States

27 July 2020, 14:36

Try this for test:

public static void main(String[] args) {
   Map<String,String> map = new HashMap<>();
   System.out.println(getQuery(map));
}

hidden #10625598

Level 23

27 July 2020, 20:42

okayy i see, why doesnt it work if i put: >>>>if(str.equals(null)) return null; str.delete(str.length() - 5, str.length()); what else can i try with the stringbuilder?

Guadalupe Gagnon

Level 37 , Tampa, United States

28 July 2020, 13:16

an initialized StringBuilder with nothing in it will not be null, it will be blank/empty. Try instead to that instead