I have no idea why this is being a pain.
package com.codegym.task.task22.task2208;
import java.util.LinkedHashMap;
import java.util.Map;
/*
Build a WHERE query
*/
public class Solution {
public static void main(String[] args) {
Map<String, String> map = new LinkedHashMap<>();
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 sb = new StringBuilder();
if(params == null || params.isEmpty()) return "";
int count = 1;
for (Map.Entry<String, String> pair : params.entrySet()) {
if(pair.getKey() == null || pair.getValue() == null) continue;
sb.append(pair.getKey()).append(" = ").append("'").append(pair.getValue()).append("'");
if (count != params.size()-1) {
sb.append(" and ");
count++;
}
}
return sb.toString();
}
}