Be sure that the values following equals signs are wrapped in single quotes

Question about the task

Build a WHERE query

Java Multithreading, Level 2, Lesson 9

Resolved

Please Help !!!!!

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.Formatter; import java.util.Map; /* Build a WHERE query */ public class Solution { public static void main(String[] args) { } public static String getQuery(Map<String, String> params) { String[] param1 = new String[]{"name", "country", "city", "age"}; StringBuilder sb = new StringBuilder(); Formatter fm = new Formatter(sb); String h = null; int i = 1; for (Map.Entry<String, String> map : params.entrySet()) { if (map.getValue() != null) { for (String str : param1) { if (str.equals(map.getKey())) { fm.format("%s = '%s'", map.getKey(), map.getValue()); sb.append(" and "); } } String s = sb.toString().trim(); int n = s.length(); h = s.substring(0,n-3); } } return h; } }

Comments (1)

Popular
New
Old

You must be signed in to leave a comment

Nouser

Level 36 , Germany

2 March 2021, 12:02

solution

Just build a query from the map. If the map contains {size=m}, then build the query: size = 'm' if the map contains {x=2.15, y=3.0} then the query should be x = '2.15' and y = '3.0' That's just an example Codegym gave you. name, country, city and age are not fix positions to look for in the map. Make the query out of the entire map.