Java搜索类

if (LIKE_RIGHT.equals(type)) {

condition = condition + “concat(?,‘%’)”;

}

if (LIKE_BOTH.equals(type)) {

condition = condition + “concat(‘%’,?,‘%’)”;

}

columns.add(columnName);

likeConditionMap.put(columnName, condition);

return this;

}

/**

• 指定日期等于某个时间

• @author fengzx

• @date 2020/3/28 12:13

*/

public Search eqDate(IGetter fn, Date param, String pattern) {

compareDate(fn, param, pattern, " = '");

return this;

}

/**

• 指定日期等于某个时间

• @author fengzx

• @date 2020/3/28 12:13

*/

public Search eqDate(IGetter fn, String param) {

if (StringUtils.isBlank(param)) {

return this;

}

//属性名

String propertyName = BeanUtils.convertToFieldName(fn);

String columnName = BeanUtils.HumpToUnderline(propertyName);

String condition = columnName + " = ‘" + param + "’";

conditions.add(condition);

return this;

}

/**

• 指定日期小于某个时间

• @author fengzx

• @date 2020/3/28 12:14

*/

public Search ltDate(IGetter fn, String param) {

if (StringUtils.isBlank(param)) {

return this;

}

//属性名

String propertyName = BeanUtils.convertToFieldName(fn);

String columnName = BeanUtils.HumpToUnderline(propertyName);

String condition = columnName + " < ‘" + param + "’";

conditions.add(condition);

return this;

}

/**

• 指定日期小于某个时间

• @author fengzx

• @date 2020/3/28 12:14

*/

public Search ltDate(IGetter fn, Date param, String pattern) {

compareDate(fn, param, pattern, " < '");

return this;

}

/**

• 指定日期大于某个时间

• @author fengzx

• @date 2020/3/28 12:14

*/

public void gtDate(IGetter fn, Date param, String pattern) {

compareDate(fn, param, pattern, " > '");

}

/**

• 日期比较

• @author fengzx

• @date 2020/4/11 12:26

*/

private Search compareDate(IGetter fn, Date param, String pattern, String compare) {

if (param == null || StringUtils.isBlank(pattern)) {

return this;

}

SimpleDateFormat format = new SimpleDateFormat(pattern);

String dateParam = format.format(param);

//属性名

String propertyName = BeanUtils.convertToFieldName(fn);

String columnName = BeanUtils.HumpToUnderline(propertyName);

St 《一线大厂Java面试题解析+后端开发学习笔记+最新架构讲解视频+实战项目源码讲义》无偿开源 威信搜索公众号【编程进阶路】 ring condition = columnName + compare + dateParam + “'”;

conditions.add(condition);

return this;

}

/**

• 指定日期大于某个时间

• @author fengzx

• @date 2020/3/28 12:14

*/

public Search gtDate(IGetter fn, String param) {

if (StringUtils.isBlank(param)) {

return this;

}

//属性名

String propertyName = BeanUtils.convertToFieldName(fn);

String columnName = BeanUtils.HumpToUnderline(propertyName);