接口的使用
com.easy.query.api.proxy.sql.ProxyFilter

使用ProxyFilter的程序包

程序包	说明
com.easy.query.api.proxy.delete
com.easy.query.api.proxy.delete.abstraction
com.easy.query.api.proxy.select
com.easy.query.api.proxy.select.abstraction
com.easy.query.api.proxy.sql
com.easy.query.api.proxy.sql.impl
com.easy.query.api.proxy.update

com.easy.query.api.proxy.delete中ProxyFilter的使用

类型变量类型为ProxyFilter的com.easy.query.api.proxy.delete中的方法参数

限定符和类型	方法和说明
ProxyExpressionDeletable<TProxy,T>	ProxyExpressionDeletable.where(boolean condition, SQLExpression2<ProxyFilter,TProxy> whereExpression)
default ProxyExpressionDeletable<TProxy,T>	ProxyExpressionDeletable.where(SQLExpression2<ProxyFilter,TProxy> whereExpression)

com.easy.query.api.proxy.delete.abstraction中ProxyFilter的使用

类型变量类型为ProxyFilter的com.easy.query.api.proxy.delete.abstraction中的方法参数

限定符和类型	方法和说明
ProxyExpressionDeletable<TProxy,T>	AbstractProxyExpressionDeletable.where(boolean condition, SQLExpression2<ProxyFilter,TProxy> whereExpression)

com.easy.query.api.proxy.select中ProxyFilter的使用

类型变量类型为ProxyFilter的com.easy.query.api.proxy.select中的方法参数

限定符和类型	方法和说明
boolean	ProxyQueryable.all(SQLExpression2<ProxyFilter,T1Proxy> whereExpression) SELECT NOT EXISTS ( SELECT 1 FROM `table` AS `t` WHERE (`t`.
<T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyQueryable2<T1Proxy,T1,T2Proxy,T2>	ProxyQueryable.innerJoin(ProxyQueryable<T2Proxy,T2> joinQueryable, SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> on)
<T3Proxy extends ProxyEntity<T3Proxy,T3>,T3> ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	ProxyQueryable2.innerJoin(ProxyQueryable<T3Proxy,T3> joinQueryable, SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> on)
<T4Proxy extends ProxyEntity<T4Proxy,T4>,T4> ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4>	ProxyQueryable3.innerJoin(ProxyQueryable<T4Proxy,T4> joinQueryable, SQLExpression5<ProxyFilter,T1Proxy,T2Proxy,T3Proxy,T4Proxy> on)
<T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyQueryable2<T1Proxy,T1,T2Proxy,T2>	ProxyQueryable.innerJoin(T2Proxy joinProxy, SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> on)
<T3Proxy extends ProxyEntity<T3Proxy,T3>,T3> ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	ProxyQueryable2.innerJoin(T3Proxy joinProxy, SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> on)
<T4Proxy extends ProxyEntity<T4Proxy,T4>,T4> ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4>	ProxyQueryable3.innerJoin(T4Proxy joinProxy, SQLExpression5<ProxyFilter,T1Proxy,T2Proxy,T3Proxy,T4Proxy> on)
<T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyQueryable2<T1Proxy,T1,T2Proxy,T2>	ProxyQueryable.leftJoin(ProxyQueryable<T2Proxy,T2> joinQueryable, SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> on)
<T3Proxy extends ProxyEntity<T3Proxy,T3>,T3> ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	ProxyQueryable2.leftJoin(ProxyQueryable<T3Proxy,T3> joinQueryable, SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> on)
<T4Proxy extends ProxyEntity<T4Proxy,T4>,T4> ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4>	ProxyQueryable3.leftJoin(ProxyQueryable<T4Proxy,T4> joinQueryable, SQLExpression5<ProxyFilter,T1Proxy,T2Proxy,T3Proxy,T4Proxy> on)
<T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyQueryable2<T1Proxy,T1,T2Proxy,T2>	ProxyQueryable.leftJoin(T2Proxy joinProxy, SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> on)
<T3Proxy extends ProxyEntity<T3Proxy,T3>,T3> ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	ProxyQueryable2.leftJoin(T3Proxy joinProxy, SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> on)
<T4Proxy extends ProxyEntity<T4Proxy,T4>,T4> ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4>	ProxyQueryable3.leftJoin(T4Proxy joinProxy, SQLExpression5<ProxyFilter,T1Proxy,T2Proxy,T3Proxy,T4Proxy> on)
<T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyQueryable2<T1Proxy,T1,T2Proxy,T2>	ProxyQueryable.rightJoin(ProxyQueryable<T2Proxy,T2> joinQueryable, SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> on)
<T3Proxy extends ProxyEntity<T3Proxy,T3>,T3> ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	ProxyQueryable2.rightJoin(ProxyQueryable<T3Proxy,T3> joinQueryable, SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> on)
<T4Proxy extends ProxyEntity<T4Proxy,T4>,T4> ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4>	ProxyQueryable3.rightJoin(ProxyQueryable<T4Proxy,T4> joinQueryable, SQLExpression5<ProxyFilter,T1Proxy,T2Proxy,T3Proxy,T4Proxy> on)
<T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyQueryable2<T1Proxy,T1,T2Proxy,T2>	ProxyQueryable.rightJoin(T2Proxy joinProxy, SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> on)
<T3Proxy extends ProxyEntity<T3Proxy,T3>,T3> ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	ProxyQueryable2.rightJoin(T3Proxy joinProxy, SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> on)
<T4Proxy extends ProxyEntity<T4Proxy,T4>,T4> ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4>	ProxyQueryable3.rightJoin(T4Proxy joinProxy, SQLExpression5<ProxyFilter,T1Proxy,T2Proxy,T3Proxy,T4Proxy> on)
ProxyQueryable<T1Proxy,T1>	ProxyQueryable.where(boolean condition, SQLExpression2<ProxyFilter,T1Proxy> whereExpression)
ProxyQueryable2<T1Proxy,T1,T2Proxy,T2>	ProxyQueryable2.where(boolean condition, SQLExpression2<ProxyFilter,T1Proxy> whereExpression)
ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4>	ProxyQueryable4.where(boolean condition, SQLExpression2<ProxyFilter,T1Proxy> whereExpression)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	ProxyQueryable3.where(boolean condition, SQLExpression2<ProxyFilter,T1Proxy> whereExpression)
default ProxyQueryable2<T1Proxy,T1,T2Proxy,T2>	ProxyQueryable2.where(boolean condition, SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> whereExpression)
default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	ProxyQueryable3.where(boolean condition, SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> whereExpression)
default ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4>	ProxyQueryable4.where(boolean condition, SQLExpression5<ProxyFilter,T1Proxy,T2Proxy,T3Proxy,T4Proxy> whereExpression)
default ProxyQueryable<T1Proxy,T1>	ProxyQueryable.where(SQLExpression2<ProxyFilter,T1Proxy> whereExpression)
default ProxyQueryable2<T1Proxy,T1,T2Proxy,T2>	ProxyQueryable2.where(SQLExpression2<ProxyFilter,T1Proxy> whereExpression)
default ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4>	ProxyQueryable4.where(SQLExpression2<ProxyFilter,T1Proxy> whereExpression)
default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	ProxyQueryable3.where(SQLExpression2<ProxyFilter,T1Proxy> whereExpression)
default ProxyQueryable2<T1Proxy,T1,T2Proxy,T2>	ProxyQueryable2.where(SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> whereExpression)
default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	ProxyQueryable3.where(SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> whereExpression)
default ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4>	ProxyQueryable4.where(SQLExpression5<ProxyFilter,T1Proxy,T2Proxy,T3Proxy,T4Proxy> whereExpression)

com.easy.query.api.proxy.select.abstraction中ProxyFilter的使用

类型变量类型为ProxyFilter的com.easy.query.api.proxy.select.abstraction中的方法参数

限定符和类型	方法和说明
boolean	AbstractProxyQueryable.all(SQLExpression2<ProxyFilter,T1Proxy> whereExpression)
<T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyQueryable2<T1Proxy,T1,T2Proxy,T2>	AbstractProxyQueryable.innerJoin(ProxyQueryable<T2Proxy,T2> joinQueryable, SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> on)
<T3Proxy extends ProxyEntity<T3Proxy,T3>,T3> ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable2.innerJoin(ProxyQueryable<T3Proxy,T3> joinQueryable, SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> on)
<T4Proxy extends ProxyEntity<T4Proxy,T4>,T4> ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4>	AbstractProxyQueryable3.innerJoin(ProxyQueryable<T4Proxy,T4> joinQueryable, SQLExpression5<ProxyFilter,T1Proxy,T2Proxy,T3Proxy,T4Proxy> on)
<T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyQueryable2<T1Proxy,T1,T2Proxy,T2>	AbstractProxyQueryable.innerJoin(T2Proxy joinProxy, SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> on)
<T3Proxy extends ProxyEntity<T3Proxy,T3>,T3> ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable2.innerJoin(T3Proxy joinProxy, SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> on)
<T4Proxy extends ProxyEntity<T4Proxy,T4>,T4> ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4>	AbstractProxyQueryable3.innerJoin(T4Proxy joinProxy, SQLExpression5<ProxyFilter,T1Proxy,T2Proxy,T3Proxy,T4Proxy> on)
<T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyQueryable2<T1Proxy,T1,T2Proxy,T2>	AbstractProxyQueryable.leftJoin(ProxyQueryable<T2Proxy,T2> joinQueryable, SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> on)
<T3Proxy extends ProxyEntity<T3Proxy,T3>,T3> ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable2.leftJoin(ProxyQueryable<T3Proxy,T3> joinQueryable, SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> on)
<T4Proxy extends ProxyEntity<T4Proxy,T4>,T4> ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4>	AbstractProxyQueryable3.leftJoin(ProxyQueryable<T4Proxy,T4> joinQueryable, SQLExpression5<ProxyFilter,T1Proxy,T2Proxy,T3Proxy,T4Proxy> on)
<T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyQueryable2<T1Proxy,T1,T2Proxy,T2>	AbstractProxyQueryable.leftJoin(T2Proxy joinProxy, SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> on)
<T3Proxy extends ProxyEntity<T3Proxy,T3>,T3> ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable2.leftJoin(T3Proxy joinProxy, SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> on)
<T4Proxy extends ProxyEntity<T4Proxy,T4>,T4> ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4>	AbstractProxyQueryable3.leftJoin(T4Proxy joinProxy, SQLExpression5<ProxyFilter,T1Proxy,T2Proxy,T3Proxy,T4Proxy> on)
<T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyQueryable2<T1Proxy,T1,T2Proxy,T2>	AbstractProxyQueryable.rightJoin(ProxyQueryable<T2Proxy,T2> joinQueryable, SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> on)
<T3Proxy extends ProxyEntity<T3Proxy,T3>,T3> ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable2.rightJoin(ProxyQueryable<T3Proxy,T3> joinQueryable, SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> on)
<T4Proxy extends ProxyEntity<T4Proxy,T4>,T4> ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4>	AbstractProxyQueryable3.rightJoin(ProxyQueryable<T4Proxy,T4> joinQueryable, SQLExpression5<ProxyFilter,T1Proxy,T2Proxy,T3Proxy,T4Proxy> on)
<T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyQueryable2<T1Proxy,T1,T2Proxy,T2>	AbstractProxyQueryable.rightJoin(T2Proxy joinProxy, SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> on)
<T3Proxy extends ProxyEntity<T3Proxy,T3>,T3> ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable2.rightJoin(T3Proxy joinProxy, SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> on)
<T4Proxy extends ProxyEntity<T4Proxy,T4>,T4> ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4>	AbstractProxyQueryable3.rightJoin(T4Proxy joinProxy, SQLExpression5<ProxyFilter,T1Proxy,T2Proxy,T3Proxy,T4Proxy> on)
ProxyQueryable<T1Proxy,T1>	AbstractProxyQueryable.where(boolean condition, SQLExpression2<ProxyFilter,T1Proxy> whereExpression)
ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4>	AbstractProxyQueryable4.where(boolean condition, SQLExpression2<ProxyFilter,T1Proxy> whereExpression)
ProxyQueryable2<T1Proxy,T1,T2Proxy,T2>	AbstractProxyQueryable2.where(boolean condition, SQLExpression2<ProxyFilter,T1Proxy> whereExpression)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.where(boolean condition, SQLExpression2<ProxyFilter,T1Proxy> whereExpression)

com.easy.query.api.proxy.sql中ProxyFilter的使用

返回ProxyFilter的com.easy.query.api.proxy.sql中的方法

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

类型变量类型为ProxyFilter的com.easy.query.api.proxy.sql中的方法参数

限定符和类型	方法和说明
default ProxyFilter	ProxyFilter.and(boolean condition, SQLExpression1<ProxyFilter> proxyFilterExpression)
default ProxyFilter	ProxyFilter.and(SQLExpression1<ProxyFilter> proxyFilterExpression)
default ProxyFilter	ProxyFilter.or(boolean condition, SQLExpression1<ProxyFilter> proxyFilterExpression)
default ProxyFilter	ProxyFilter.or(SQLExpression1<ProxyFilter> sqlWherePredicateSQLExpression)

com.easy.query.api.proxy.sql.impl中ProxyFilter的使用

实现ProxyFilter的com.easy.query.api.proxy.sql.impl中的类

限定符和类型	类和说明
class	ProxyFilterImpl create time 2023/6/22 22:12 文件说明

com.easy.query.api.proxy.update中ProxyFilter的使用

类型变量类型为ProxyFilter的com.easy.query.api.proxy.update中的方法参数

限定符和类型	方法和说明
default ProxyExpressionUpdatable<TProxy,T>	ProxyExpressionUpdatable.where(boolean condition, SQLExpression2<ProxyFilter,TProxy> whereExpression)
default ProxyExpressionUpdatable<TProxy,T>	ProxyExpressionUpdatable.where(SQLExpression2<ProxyFilter,TProxy> whereExpression)