com.easy.query.api.proxy.sql

接口 ProxyFilter

所有已知实现类:

ProxyFilterImpl

public interface ProxyFilter

作者:

xuejiaming

方法概要

限定符和类型	方法和说明
default ProxyFilter	and()
default ProxyFilter	and(boolean condition)
default ProxyFilter	and(boolean condition, SQLExpression1<ProxyFilter> proxyFilterExpression)
default ProxyFilter	and(SQLExpression1<ProxyFilter> proxyFilterExpression)
default ProxyFilter	columnFunc(boolean condition, ProxyColumnPropertyFunction columnPropertyFunction, SQLPredicateCompare sqlPredicateCompare, Object val)
default ProxyFilter	columnFunc(ProxyColumnPropertyFunction columnPropertyFunction, SQLPredicateCompare sqlPredicateCompare, Object val)
default ProxyFilter	eq(boolean condition, SQLColumn<?> column, Object val) 等于 column = val
default <T2> ProxyFilter	eq(boolean condition, SQLColumn<?> column1, SQLColumn<?> column2) 小于等于 column1 = column2
default ProxyFilter	eq(SQLColumn<?> column, Object val) 等于 column = val
default <T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyFilter	eq(SQLColumn<?> column1, SQLColumn<?> column2) 小于等于 column1 = column2
default <T1Proxy extends ProxyEntity<T1Proxy,T1>,T1,T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyFilter	exists(boolean condition, T1Proxy tableProxy, ProxyQueryable<T2Proxy,T2> subQueryable)
default <T1Proxy extends ProxyEntity<T1Proxy,T1>,T1,T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyFilter	exists(T1Proxy tableProxy, ProxyQueryable<T2Proxy,T2> subQueryable)
default ProxyFilter	ge(boolean condition, SQLColumn<?> column, Object val) 等于 column >= val
default <T2> ProxyFilter	ge(boolean condition, SQLColumn<?> column1, SQLColumn<?> column2) 小于等于 column1 >= column2
default ProxyFilter	ge(SQLColumn<?> column, Object val) 等于 column >= val
default <T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyFilter	ge(SQLColumn<?> column1, SQLColumn<?> column2) 小于等于 column1 >= column2
Filter	getFilter()
default ProxyFilter	gt(boolean condition, SQLColumn<?> column, Object val) 大于 column > val
default <T2> ProxyFilter	gt(boolean condition, SQLColumn<?> column1, SQLColumn<?> column2) 小于等于 column1 > column2
default ProxyFilter	gt(SQLColumn<?> column, Object val) 大于 column > val
default <T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyFilter	gt(SQLColumn<?> column1, SQLColumn<?> column2) 小于等于 column1 > column2
default ProxyFilter	in(boolean condition, SQLColumn<?> column, Collection<?> collection) column in collection 集合为空返回False
default <TProperty> ProxyFilter	in(boolean condition, SQLColumn<?> column, TProperty[] collection) column in collection 数组为空返回False
default <TProxy extends ProxyEntity<TProxy,TProperty>,TProperty> ProxyFilter	in(boolean condition, SQLColumn<TProperty> column, ProxyQueryable<TProxy,TProperty> subQueryable) column in (select column from table)
default ProxyFilter	in(SQLColumn<?> column, Collection<?> collection) column in collection 集合为空返回False
default <TProperty> ProxyFilter	in(SQLColumn<?> column, TProperty[] collection) column in collection 数组为空返回False
default <TProxy extends ProxyEntity<TProxy,TProperty>,TProperty> ProxyFilter	in(SQLColumn<TProperty> column, ProxyQueryable<TProxy,TProperty> subQueryable) column in (select column from table)
default ProxyFilter	isNotNull(boolean condition, SQLColumn<?> column) column is not null
default ProxyFilter	isNotNull(SQLColumn<?> column) column is not null
default ProxyFilter	isNull(boolean condition, SQLColumn<?> column) column is null
default ProxyFilter	isNull(SQLColumn<?> column) column is null
default ProxyFilter	le(boolean condition, SQLColumn<?> column, Object val) 小于等于 column <= val
default <T2> ProxyFilter	le(boolean condition, SQLColumn<?> column1, SQLColumn<?> column2) 小于等于 column1 <= column2
default ProxyFilter	le(SQLColumn<?> column, Object val) 小于等于 column <= val
default <T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyFilter	le(SQLColumn<?> column1, SQLColumn<?> column2) 小于等于 column1 <= column2
default ProxyFilter	like(boolean condition, SQLColumn<?> column, Object val) column like %val% 列全匹配
default ProxyFilter	like(boolean condition, SQLColumn<?> column, Object val, SQLLikeEnum sqlLike) column like ?
default ProxyFilter	like(SQLColumn<?> column, Object val) column like %val% 列全匹配
default ProxyFilter	likeMatchLeft(boolean condition, SQLColumn<?> column, Object val) column like val% 列匹配前半部分
default ProxyFilter	likeMatchLeft(SQLColumn<?> column, Object val) column like val% 列匹配前半部分
default ProxyFilter	likeMatchRight(boolean condition, SQLColumn<?> column, Object val) column like %val 列匹配后半部分
default ProxyFilter	likeMatchRight(SQLColumn<?> column, Object val) column like %val 列匹配后半部分
default ProxyFilter	lt(boolean condition, SQLColumn<?> column, Object val) 小于 column < val
default <T2> ProxyFilter	lt(boolean condition, SQLColumn<?> column1, SQLColumn<?> column2) 小于 column < val
default ProxyFilter	lt(SQLColumn<?> column, Object val) 小于 column < val
default <T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyFilter	lt(SQLColumn<?> column1, SQLColumn<?> column2) 小于 column < val
default ProxyFilter	ne(boolean condition, SQLColumn<?> column, Object val) 不等于 column <> val
default <T2> ProxyFilter	ne(boolean condition, SQLColumn<?> column1, SQLColumn<?> column2) 小于等于 column1 <> column2
default ProxyFilter	ne(SQLColumn<?> column, Object val) 不等于 column <> val
default <T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyFilter	ne(SQLColumn<?> column1, SQLColumn<?> column2) 小于等于 column1 <> column2
default <T1Proxy extends ProxyEntity<T1Proxy,T1>,T1,T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyFilter	notExists(boolean condition, T1Proxy tableProxy, ProxyQueryable<T2Proxy,T2> subQueryable)
default <T1Proxy extends ProxyEntity<T1Proxy,T1>,T1,T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyFilter	notExists(T1Proxy tableProxy, ProxyQueryable<T2Proxy,T2> subQueryable)
default ProxyFilter	notIn(boolean condition, SQLColumn<?> column, Collection<?> collection) column not in collection 集合为空返回True
default <TPropertyProxy extends ProxyEntity<TPropertyProxy,TProperty>,TProperty> ProxyFilter	notIn(boolean condition, SQLColumn<?> column, ProxyQueryable<TPropertyProxy,TProperty> subQueryable)
default <TProperty> ProxyFilter	notIn(boolean condition, SQLColumn<?> column, TProperty[] collection)
default ProxyFilter	notIn(SQLColumn<?> column, Collection<?> collection) column not in collection 集合为空返回True
default <TPropertyProxy extends ProxyEntity<TPropertyProxy,TProperty>,TProperty> ProxyFilter	notIn(SQLColumn<?> column, ProxyQueryable<TPropertyProxy,TProperty> subQueryable)
default <TProperty> ProxyFilter	notIn(SQLColumn<?> column, TProperty[] collection)
default ProxyFilter	notLike(boolean condition, SQLColumn<?> column, Object val) column not like %val%
default ProxyFilter	notLike(boolean condition, SQLColumn<?> column, Object val, SQLLikeEnum sqlLike)
default ProxyFilter	notLike(SQLColumn<?> column, Object val) column not like %val%
default ProxyFilter	notLikeMatchLeft(boolean condition, SQLColumn<?> column, Object val) column not like val%
default ProxyFilter	notLikeMatchLeft(SQLColumn<?> column, Object val) column not like val%
default ProxyFilter	notLikeMatchRight(boolean condition, SQLColumn<?> column, Object val) column not like %val
default ProxyFilter	notLikeMatchRight(SQLColumn<?> column, Object val) column not like %val
default ProxyFilter	or()
default ProxyFilter	or(boolean condition)
default ProxyFilter	or(boolean condition, SQLExpression1<ProxyFilter> proxyFilterExpression)
default ProxyFilter	or(SQLExpression1<ProxyFilter> sqlWherePredicateSQLExpression)
default ProxyFilter	range(boolean condition, SQLColumn<?> column, boolean conditionLeft, Object valLeft, boolean conditionRight, Object valRight, SQLRangeEnum sqlRange) 自定义范围 一般用于范围比如时间,小的时间在前大的时间在后
default ProxyFilter	rangeClosed(boolean condition, SQLColumn<?> column, boolean conditionLeft, Object valLeft, boolean conditionRight, Object valRight) [left..right] = {x | left <= x <= right} 一般用于范围比如时间,小的时间在前大的时间在后
default ProxyFilter	rangeClosed(SQLColumn<?> column, boolean conditionLeft, Object valLeft, boolean conditionRight, Object valRight) [left..right] = {x | left <= x <= right} 一般用于范围比如时间,小的时间在前大的时间在后
default ProxyFilter	rangeClosed(SQLColumn<?> column, Object valLeft, Object valRight) [left..right] = {x | left <= x <= right} 一般用于范围比如时间,小的时间在前大的时间在后
default ProxyFilter	rangeClosedOpen(boolean condition, SQLColumn<?> column, boolean conditionLeft, Object valLeft, boolean conditionRight, Object valRight) [left..right) = {x | left <= x < right} 一般用于范围比如时间,小的时间在前大的时间在后
default ProxyFilter	rangeClosedOpen(SQLColumn<?> column, boolean conditionLeft, Object valLeft, boolean conditionRight, Object valRight) [left..right) = {x | left <= x < right} 一般用于范围比如时间,小的时间在前大的时间在后
default ProxyFilter	rangeOpen(boolean condition, SQLColumn<?> column, boolean conditionLeft, Object valLeft, boolean conditionRight, Object valRight) 区间 (left..right) = {x | left < x < right} 一般用于范围比如时间,小的时间在前大的时间在后
default ProxyFilter	rangeOpen(SQLColumn<?> column, boolean conditionLeft, Object valLeft, boolean conditionRight, Object valRight) 区间 (left..right) = {x | left < x < right} 一般用于范围比如时间,小的时间在前大的时间在后
default ProxyFilter	rangeOpen(SQLColumn<?> column, Object valLeft, Object valRight) 区间 (left..right) = {x | left < x < right} 一般用于范围比如时间,小的时间在前大的时间在后
default ProxyFilter	rangeOpenClosed(boolean condition, SQLColumn<?> column, boolean conditionLeft, Object valLeft, boolean conditionRight, Object valRight) 区间 (left..right] = {x | left < x <= right} 一般用于范围比如时间,小的时间在前大的时间在后
default ProxyFilter	rangeOpenClosed(SQLColumn<?> column, boolean conditionLeft, Object valLeft, boolean conditionRight, Object valRight) 区间 (left..right] = {x | left < x <= right} 一般用于范围比如时间,小的时间在前大的时间在后

方法详细资料

getFilter

Filter getFilter()

gt

default ProxyFilter gt(SQLColumn<?> column,
                       Object val)

大于 column > val

gt

default ProxyFilter gt(boolean condition,
                       SQLColumn<?> column,
                       Object val)

大于 column > val

参数:

condition - 执行条件

column - 字段

val - 值

返回:

children

ge

default ProxyFilter ge(SQLColumn<?> column,
                       Object val)

等于 column >= val

ge

default ProxyFilter ge(boolean condition,
                       SQLColumn<?> column,
                       Object val)

等于 column >= val

参数:

condition - 执行条件

column - 字段

val - 值

返回:

children

eq

default ProxyFilter eq(SQLColumn<?> column,
                       Object val)

等于 column = val

eq

default ProxyFilter eq(boolean condition,
                       SQLColumn<?> column,
                       Object val)

等于 column = val

参数:

condition - 执行条件

column - 字段

val - 值

返回:

children

ne

default ProxyFilter ne(SQLColumn<?> column,
                       Object val)

不等于 column <> val

ne

default ProxyFilter ne(boolean condition,
                       SQLColumn<?> column,
                       Object val)

不等于 column <> val

参数:

condition - 执行条件

column - 字段

val - 值

返回:

children

le

default ProxyFilter le(SQLColumn<?> column,
                       Object val)

小于等于 column <= val

le

default ProxyFilter le(boolean condition,
                       SQLColumn<?> column,
                       Object val)

小于等于 column <= val

参数:

condition - 执行条件

column - 字段

val - 值

返回:

children

lt

default ProxyFilter lt(SQLColumn<?> column,
                       Object val)

小于 column < val

lt

default ProxyFilter lt(boolean condition,
                       SQLColumn<?> column,
                       Object val)

小于 column < val

参数:

condition - 执行条件

column - 字段

val - 值

返回:

children

likeMatchLeft

default ProxyFilter likeMatchLeft(SQLColumn<?> column,
                                  Object val)

column like val% 列匹配前半部分

参数:

column -

val -

返回:

likeMatchLeft

default ProxyFilter likeMatchLeft(boolean condition,
                                  SQLColumn<?> column,
                                  Object val)

column like val% 列匹配前半部分

参数:

condition -

column -

val -

返回:

likeMatchRight

default ProxyFilter likeMatchRight(SQLColumn<?> column,
                                   Object val)

column like %val 列匹配后半部分

参数:

column -

val -

返回:

likeMatchRight

default ProxyFilter likeMatchRight(boolean condition,
                                   SQLColumn<?> column,
                                   Object val)

column like %val 列匹配后半部分

参数:

condition -

column -

val -

返回:

like

default ProxyFilter like(SQLColumn<?> column,
                         Object val)

column like %val% 列全匹配

like

default ProxyFilter like(boolean condition,
                         SQLColumn<?> column,
                         Object val)

column like %val% 列全匹配

参数:

condition - 执行条件

column - 字段

val - 值

返回:

children

like

default ProxyFilter like(boolean condition,
                         SQLColumn<?> column,
                         Object val,
                         SQLLikeEnum sqlLike)

column like ?val? 列自定义匹配

参数:

condition -

column -

val -

sqlLike -

返回:

notLikeMatchLeft

default ProxyFilter notLikeMatchLeft(SQLColumn<?> column,
                                     Object val)

column not like val%

参数:

column -

val -

返回:

notLikeMatchLeft

default ProxyFilter notLikeMatchLeft(boolean condition,
                                     SQLColumn<?> column,
                                     Object val)

column not like val%

参数:

condition -

column -

val -

返回:

notLikeMatchRight

default ProxyFilter notLikeMatchRight(SQLColumn<?> column,
                                      Object val)

column not like %val

参数:

column -

val -

返回:

notLikeMatchRight

default ProxyFilter notLikeMatchRight(boolean condition,
                                      SQLColumn<?> column,
                                      Object val)

column not like %val

参数:

condition -

column -

val -

返回:

notLike

default ProxyFilter notLike(SQLColumn<?> column,
                            Object val)

column not like %val%

notLike

default ProxyFilter notLike(boolean condition,
                            SQLColumn<?> column,
                            Object val)

column not like %val%

参数:

condition - 执行条件

column - 字段

val - 值

返回:

children

notLike

default ProxyFilter notLike(boolean condition,
                            SQLColumn<?> column,
                            Object val,
                            SQLLikeEnum sqlLike)

isNull

default ProxyFilter isNull(SQLColumn<?> column)

column is null

isNull

default ProxyFilter isNull(boolean condition,
                           SQLColumn<?> column)

column is null

参数:

condition - 执行条件

column - 字段

返回:

children

isNotNull

default ProxyFilter isNotNull(SQLColumn<?> column)

column is not null

isNotNull

default ProxyFilter isNotNull(boolean condition,
                              SQLColumn<?> column)

column is not null

参数:

condition - 执行条件

column - 字段

返回:

children

in

default ProxyFilter in(SQLColumn<?> column,
                       Collection<?> collection)

column in collection 集合为空返回False

in

default ProxyFilter in(boolean condition,
                       SQLColumn<?> column,
                       Collection<?> collection)

column in collection 集合为空返回False

in

default <TProperty> ProxyFilter in(SQLColumn<?> column,
                                   TProperty[] collection)

column in collection 数组为空返回False

类型参数:

TProperty -

参数:

column -

collection -

返回:

in

default <TProperty> ProxyFilter in(boolean condition,
                                   SQLColumn<?> column,
                                   TProperty[] collection)

column in collection 数组为空返回False

类型参数:

TProperty -

参数:

condition -

column -

collection -

返回:

in

default <TProxy extends ProxyEntity<TProxy,TProperty>,TProperty> ProxyFilter in(SQLColumn<TProperty> column,
                                                                                ProxyQueryable<TProxy,TProperty> subQueryable)

column in (select column from table)

类型参数:

TProxy -

TProperty -

参数:

column -

subQueryable -

返回:

in

default <TProxy extends ProxyEntity<TProxy,TProperty>,TProperty> ProxyFilter in(boolean condition,
                                                                                SQLColumn<TProperty> column,
                                                                                ProxyQueryable<TProxy,TProperty> subQueryable)

column in (select column from table)

类型参数:

TProxy -

TProperty -

参数:

condition -

column -

subQueryable -

返回:

notIn

default ProxyFilter notIn(SQLColumn<?> column,
                          Collection<?> collection)

column not in collection 集合为空返回True

参数:

column -

collection -

返回:

notIn

default ProxyFilter notIn(boolean condition,
                          SQLColumn<?> column,
                          Collection<?> collection)

column not in collection 集合为空返回True

参数:

condition -

column -

collection -

返回:

notIn

default <TProperty> ProxyFilter notIn(SQLColumn<?> column,
                                      TProperty[] collection)

notIn

default <TProperty> ProxyFilter notIn(boolean condition,
                                      SQLColumn<?> column,
                                      TProperty[] collection)

notIn

default <TPropertyProxy extends ProxyEntity<TPropertyProxy,TProperty>,TProperty> ProxyFilter notIn(SQLColumn<?> column,
                                                                                                   ProxyQueryable<TPropertyProxy,TProperty> subQueryable)

notIn

default <TPropertyProxy extends ProxyEntity<TPropertyProxy,TProperty>,TProperty> ProxyFilter notIn(boolean condition,
                                                                                                   SQLColumn<?> column,
                                                                                                   ProxyQueryable<TPropertyProxy,TProperty> subQueryable)

exists

default <T1Proxy extends ProxyEntity<T1Proxy,T1>,T1,T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyFilter exists(T1Proxy tableProxy,
                                                                                                                   ProxyQueryable<T2Proxy,T2> subQueryable)

exists

default <T1Proxy extends ProxyEntity<T1Proxy,T1>,T1,T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyFilter exists(boolean condition,
                                                                                                                   T1Proxy tableProxy,
                                                                                                                   ProxyQueryable<T2Proxy,T2> subQueryable)

notExists

default <T1Proxy extends ProxyEntity<T1Proxy,T1>,T1,T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyFilter notExists(T1Proxy tableProxy,
                                                                                                                      ProxyQueryable<T2Proxy,T2> subQueryable)

notExists

default <T1Proxy extends ProxyEntity<T1Proxy,T1>,T1,T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyFilter notExists(boolean condition,
                                                                                                                      T1Proxy tableProxy,
                                                                                                                      ProxyQueryable<T2Proxy,T2> subQueryable)

rangeOpenClosed

default ProxyFilter rangeOpenClosed(SQLColumn<?> column,
                                    boolean conditionLeft,
                                    Object valLeft,
                                    boolean conditionRight,
                                    Object valRight)

区间 (left..right] = {x | left < x <= right} 一般用于范围比如时间,小的时间在前大的时间在后

参数:

column -

conditionLeft -

valLeft -

conditionRight -

valRight -

返回:

rangeOpenClosed

default ProxyFilter rangeOpenClosed(boolean condition,
                                    SQLColumn<?> column,
                                    boolean conditionLeft,
                                    Object valLeft,
                                    boolean conditionRight,
                                    Object valRight)

区间 (left..right] = {x | left < x <= right} 一般用于范围比如时间,小的时间在前大的时间在后

参数:

condition -

column -

conditionLeft -

valLeft -

conditionRight -

valRight -

返回:

rangeOpen

default ProxyFilter rangeOpen(SQLColumn<?> column,
                              Object valLeft,
                              Object valRight)

区间 (left..right) = {x | left < x < right} 一般用于范围比如时间,小的时间在前大的时间在后

参数:

column - 数据库列

valLeft - 区间左侧值

valRight - 区间右侧的值

返回:

rangeOpen

default ProxyFilter rangeOpen(SQLColumn<?> column,
                              boolean conditionLeft,
                              Object valLeft,
                              boolean conditionRight,
                              Object valRight)

区间 (left..right) = {x | left < x < right} 一般用于范围比如时间,小的时间在前大的时间在后

参数:

column - 数据库列

conditionLeft - 是否添加左侧条件

valLeft - 区间左侧值

conditionRight - 是否添加右侧条件

valRight - 区间右侧的值

返回:

rangeOpen

default ProxyFilter rangeOpen(boolean condition,
                              SQLColumn<?> column,
                              boolean conditionLeft,
                              Object valLeft,
                              boolean conditionRight,
                              Object valRight)

区间 (left..right) = {x | left < x < right} 一般用于范围比如时间,小的时间在前大的时间在后

参数:

condition -

column -

conditionLeft -

valLeft -

conditionRight -

valRight -

返回:

rangeClosedOpen

default ProxyFilter rangeClosedOpen(SQLColumn<?> column,
                                    boolean conditionLeft,
                                    Object valLeft,
                                    boolean conditionRight,
                                    Object valRight)

[left..right) = {x | left <= x < right} 一般用于范围比如时间,小的时间在前大的时间在后

参数:

column -

conditionLeft -

valLeft -

conditionRight -

valRight -

返回:

rangeClosedOpen

default ProxyFilter rangeClosedOpen(boolean condition,
                                    SQLColumn<?> column,
                                    boolean conditionLeft,
                                    Object valLeft,
                                    boolean conditionRight,
                                    Object valRight)

[left..right) = {x | left <= x < right} 一般用于范围比如时间,小的时间在前大的时间在后

参数:

condition -

column -

conditionLeft -

valLeft -

conditionRight -

valRight -

返回:

rangeClosed

default ProxyFilter rangeClosed(SQLColumn<?> column,
                                Object valLeft,
                                Object valRight)

[left..right] = {x | left <= x <= right} 一般用于范围比如时间,小的时间在前大的时间在后

参数:

column -

valLeft -

valRight -

返回:

rangeClosed

default ProxyFilter rangeClosed(SQLColumn<?> column,
                                boolean conditionLeft,
                                Object valLeft,
                                boolean conditionRight,
                                Object valRight)

[left..right] = {x | left <= x <= right} 一般用于范围比如时间,小的时间在前大的时间在后

参数:

column -

conditionLeft -

valLeft -

conditionRight -

valRight -

返回:

rangeClosed

default ProxyFilter rangeClosed(boolean condition,
                                SQLColumn<?> column,
                                boolean conditionLeft,
                                Object valLeft,
                                boolean conditionRight,
                                Object valRight)

[left..right] = {x | left <= x <= right} 一般用于范围比如时间,小的时间在前大的时间在后

参数:

condition -

column -

conditionLeft -

valLeft -

conditionRight -

valRight -

返回:

range

default ProxyFilter range(boolean condition,
                          SQLColumn<?> column,
                          boolean conditionLeft,
                          Object valLeft,
                          boolean conditionRight,
                          Object valRight,
                          SQLRangeEnum sqlRange)

自定义范围 一般用于范围比如时间,小的时间在前大的时间在后

参数:

condition -

column -

conditionLeft -

valLeft -

conditionRight -

valRight -

sqlRange -

返回:

columnFunc

default ProxyFilter columnFunc(ProxyColumnPropertyFunction columnPropertyFunction,
                               SQLPredicateCompare sqlPredicateCompare,
                               Object val)

columnFunc

default ProxyFilter columnFunc(boolean condition,
                               ProxyColumnPropertyFunction columnPropertyFunction,
                               SQLPredicateCompare sqlPredicateCompare,
                               Object val)

gt

default <T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyFilter gt(SQLColumn<?> column1,
                                                                    SQLColumn<?> column2)

小于等于 column1 > column2

类型参数:

T2Proxy -

T2 -

参数:

column1 -

column2 -

返回:

gt

default <T2> ProxyFilter gt(boolean condition,
                            SQLColumn<?> column1,
                            SQLColumn<?> column2)

小于等于 column1 > column2

类型参数:

T2 -

参数:

condition -

column1 -

column2 -

返回:

ge

default <T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyFilter ge(SQLColumn<?> column1,
                                                                    SQLColumn<?> column2)

小于等于 column1 >= column2

类型参数:

T2Proxy -

T2 -

参数:

column1 -

column2 -

返回:

ge

default <T2> ProxyFilter ge(boolean condition,
                            SQLColumn<?> column1,
                            SQLColumn<?> column2)

小于等于 column1 >= column2

类型参数:

T2 -

参数:

condition -

column1 -

column2 -

返回:

eq

default <T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyFilter eq(SQLColumn<?> column1,
                                                                    SQLColumn<?> column2)

小于等于 column1 = column2

类型参数:

T2Proxy -

T2 -

参数:

column1 -

column2 -

返回:

eq

default <T2> ProxyFilter eq(boolean condition,
                            SQLColumn<?> column1,
                            SQLColumn<?> column2)

小于等于 column1 = column2

类型参数:

T2 -

参数:

condition -

column1 -

column2 -

返回:

ne

default <T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyFilter ne(SQLColumn<?> column1,
                                                                    SQLColumn<?> column2)

小于等于 column1 <> column2

类型参数:

T2Proxy -

T2 -

参数:

column1 -

column2 -

返回:

ne

default <T2> ProxyFilter ne(boolean condition,
                            SQLColumn<?> column1,
                            SQLColumn<?> column2)

小于等于 column1 <> column2

类型参数:

T2 -

参数:

condition -

column1 -

column2 -

返回:

le

default <T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyFilter le(SQLColumn<?> column1,
                                                                    SQLColumn<?> column2)

小于等于 column1 <= column2

类型参数:

T2Proxy -

T2 -

参数:

column1 -

column2 -

返回:

le

default <T2> ProxyFilter le(boolean condition,
                            SQLColumn<?> column1,
                            SQLColumn<?> column2)

小于等于 column1 <= column2

类型参数:

T2 -

参数:

condition -

column1 -

column2 -

返回:

lt

default <T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyFilter lt(SQLColumn<?> column1,
                                                                    SQLColumn<?> column2)

小于 column < val

类型参数:

T2Proxy -

T2 -

参数:

column1 -

column2 -

返回:

lt

default <T2> ProxyFilter lt(boolean condition,
                            SQLColumn<?> column1,
                            SQLColumn<?> column2)

小于 column < val

类型参数:

T2 -

参数:

condition -

column1 -

column2 -

返回:

and

default ProxyFilter and()

and

default ProxyFilter and(boolean condition)

and

default ProxyFilter and(SQLExpression1<ProxyFilter> proxyFilterExpression)

and

default ProxyFilter and(boolean condition,
                        SQLExpression1<ProxyFilter> proxyFilterExpression)

or

default ProxyFilter or()

or

default ProxyFilter or(boolean condition)

or

default ProxyFilter or(SQLExpression1<ProxyFilter> sqlWherePredicateSQLExpression)

or

default ProxyFilter or(boolean condition,
                       SQLExpression1<ProxyFilter> proxyFilterExpression)