👺
package com.javarush.task.task22.task2208;
import java.util.LinkedHashMap;
import java.util.Map;
/*
Формируем WHERE
*/
public class Solution {
public static void main(String[] args) {
Map<String, String> params = new LinkedHashMap<>();
params.put("name", null);
params.put("country", null);
params.put("city", null);
params.put("age", null);
getQuery(params);
}
public static String getQuery(Map<String, String> params) {
StringBuilder stringBuilder = new StringBuilder();
String[] str = params.toString().replaceAll("(\\{|\\}|\\,)", "").split(" ");
for (String pair : str) {
int h = pair.indexOf("=");
if ((pair.substring(0, h).equals("name")) && !(pair.substring(h + 1).equals("null"))) {
stringBuilder.append("name = '" + pair.substring(h + 1) + "'" + " and ");
}
if ((pair.substring(0, h).equals("country")) && !(pair.substring(h + 1).equals("null"))) {
stringBuilder.append("country = '" + pair.substring(h + 1) + "'" + " and ");
}
if ((pair.substring(0, h).equals("city")) && !(pair.substring(h + 1).equals("null"))) {
stringBuilder.append("city = '" + pair.substring(h + 1) + "'" + " and ");
}
if ((pair.substring(0, h).equals("age")) && !(pair.substring(h + 1).equals("null"))) {
stringBuilder.append("age = '" + pair.substring(h + 1) + "'");
}
}
if (stringBuilder.length() == 0) {
return " ";
}
String ret = stringBuilder.toString().replaceAll(" and $", "");
System.out.println(ret);
return ret;
}
}