java sql多个or条件,sql多条件查询

把查询的条件作为一个Map params; 然后用一个方法进行额外查询语句的拼接;

public String getWhere(Map params) {

String str = "";

if(params.size() > 0) {

boolean and = false;

for(String param : params.keySet()) {

Object value = params.get(param);

if(value == null || value.equals(0)) {

continue;

} else {

if(and) {

str = str + " and " + param + " = " + " " + value;

} else {

and = true;

str = str + param + " = " + " " + value;

}

}

}

}

if(str != "") {

str = " where " + str;

}

return str;

}