public enum ControlTypeEnum {
INPUT {
@Override
public String getSql(String leftParam, String rightParam) {
if (StringUtils.isBlank(rightParam)) {
return "";
}
return leftParam + " = '" + rightParam + "'";
}
},
LIKE {
@Override
public String getSql(String leftParam, String rightParam) {
if (StringUtils.isBlank(rightParam)) {
return "";
}
String sql = leftParam + " like " + "'%" + rightParam + "%'";
return sql;
}
},
COMBO_BOX {
@Override
public String getSql(String leftParam, String rightParam) {
if (StringUtils.isBlank(rightParam)) {
return "";
}
String sql = leftParam + " = '" + rightParam + "'";
return sql;
}
},
MULTI_COMBO_BOX {
@Override
public String getSql(String leftParam, String rightParam) {
if (StringUtils.isBlank(rightParam)) {
return "";
}
rightParam = StringUtils.replace(rightParam, "####", "','");
rightParam = "('" + rightParam + "')";
String sql = leftParam + " in " + rightParam;
return sql;
}
},
INPUT_COMBO_BOX {
@Override
public String getSql(String leftParam, String rightParam) {
if (StringUtils.isBlank(rightParam)) {
return "";
}
String sql = leftParam + " = '" + rightParam + "'";
return sql;
}
},
INPUT_MULTI_BOX {
@Override
public String getSql(String leftParam, String rightParam) {
if (StringUtils.isBlank(rightParam)) {
return "";
}
rightParam = StringUtils.replace(rightParam, "####", "','");
rightParam = "('" + rightParam + "')";
String sql = leftParam + " in " + rightParam;
return sql;
}
};
public abstract String getSql(String leftParam, String rightParam);
}
网友评论