Mapper icon indicating copy to clipboard operation
Mapper copied to clipboard

组装weekendsql查询条件时,查询条件为空时不添加

Open Dron1sh opened this issue 7 years ago • 3 comments

public WeekendSqls<T> andEqualToIfNotNull(Fn<T, Object> fn, Object value) {
    if(value != null) {
        return this.andEqualTo(Reflections.fnToFieldName(fn), value);
    }
    ...
}

Dron1sh avatar Aug 16 '18 06:08 Dron1sh

我也要这个需求所以自己重新写了个weekendsql

liu-xinhui avatar Aug 28 '18 08:08 liu-xinhui

@liunewshine 我也是这么干的 -。-、

Dron1sh avatar Aug 28 '18 08:08 Dron1sh

感觉WeekendSqls里面的方法,都可以加一个带条件的重载,从而实现查询的时候动态判断拼接哪些查询条件 我看到MybatisPlus是这么处理的,有些时候不光是判断value是不是null

public WeekendSqls<T> andEqualTo(boolean condition, Fn<T, Object> fn, Object value) {
        if (condition) {
            return this.andEqualTo(Reflections.fnToFieldName(fn), value);
        }
        ...
}

MRLEILOVE avatar Nov 08 '22 16:11 MRLEILOVE