com.easy.query.api.proxy.select

接口 ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>

所有超级接口:

Interceptable<ProxyQueryable<T1Proxy,T1>>, LogicDeletable<ProxyQueryable<T1Proxy,T1>>, Query<T1>, QueryStrategy<ProxyQueryable<T1Proxy,T1>>, TableReNameable<ProxyQueryable<T1Proxy,T1>>

所有已知子接口:

ProxyQueryable2<T1Proxy,T1,T2Proxy,T2>, ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>, ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4>

所有已知实现类:

AbstractProxyQueryable, AbstractProxyQueryable1, AbstractProxyQueryable2, AbstractProxyQueryable3, AbstractProxyQueryable4, EasyProxyQueryable, EasyProxyQueryable2, EasyProxyQueryable3, EasyProxyQueryable4

public interface ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>
extends Query<T1>, Interceptable<ProxyQueryable<T1Proxy,T1>>, LogicDeletable<ProxyQueryable<T1Proxy,T1>>, TableReNameable<ProxyQueryable<T1Proxy,T1>>, QueryStrategy<ProxyQueryable<T1Proxy,T1>>

create time 2023/6/21 17:11 文件说明

作者:

xuejiaming

方法概要

限定符和类型	方法和说明
boolean	all(SQLExpression2<ProxyFilter,T1Proxy> whereExpression) SELECT NOT EXISTS ( SELECT 1 FROM `table` AS `t` WHERE (`t`.
ProxyQueryable<T1Proxy,T1>	asNoTracking()
ProxyQueryable<T1Proxy,T1>	asTracking() 自动将查询结果集合全部添加到当前上下文追踪中,如果当前查询结果十分庞大,并且更新数据只有个别条数,建议不要使用 追踪查询，可以通过开启追踪后使用普通的查询，然后添加到当前的追踪上下文中EasyQueryClient.addTracking(Object),开始先数据追踪的差异更新 如果当前启用了追踪查询并且在当前上下文已经追加了当前trackKey的对象那么当前查询结果的对象不会被返回,返回的是被追踪的当前对象, 如果对象A:{id:1,name:2}已经被追踪了,新查询的结果是对象A:{id:1,name:3},那么查询到的数据是{id:1,name:3}但是用户获取到的数据是{id:1,name:2} 所以尽可能在追踪后调用entity update,而不是重复查询对应对象
default <TMember extends Number> BigDecimal	avgBigDecimalOrNull(SQLFuncExpression1<T1Proxy,SQLColumn<TMember>> columnSelector)
default <TMember extends Number> Float	avgFloatOrNull(SQLFuncExpression1<T1Proxy,SQLColumn<TMember>> columnSelector)
default BigDecimal	avgOrDefault(SQLFuncExpression1<T1Proxy,SQLColumn<BigDecimal>> columnSelector, BigDecimal def)
default Float	avgOrDefault(SQLFuncExpression1<T1Proxy,SQLColumn<Float>> columnSelector, Float def)
default <TMember extends Number> Double	avgOrDefault(SQLFuncExpression1<T1Proxy,SQLColumn<TMember>> columnSelector, Double def)
default <TMember extends Number,TResult extends Number> TResult	avgOrDefault(SQLFuncExpression1<T1Proxy,SQLColumn<TMember>> columnSelector, TResult def, Class<TResult> resultClass)
default <TMember extends Number> Double	avgOrNull(SQLFuncExpression1<T1Proxy,SQLColumn<TMember>> columnSelector)
ProxyQueryable<T1Proxy,T1>	cloneQueryable()
long	countDistinct(SQLExpression2<ProxySelector,T1Proxy> selectExpression)
default ProxyQueryable<T1Proxy,T1>	distinct()
ProxyQueryable<T1Proxy,T1>	distinct(boolean condition)
T1Proxy	get1Proxy()
ClientQueryable<T1>	getEntityQueryable()
ProxyQueryable<T1Proxy,T1>	groupBy(boolean condition, SQLExpression2<ProxyGroupSelector,T1Proxy> selectExpression)
default ProxyQueryable<T1Proxy,T1>	groupBy(SQLExpression2<ProxyGroupSelector,T1Proxy> selectExpression)
ProxyQueryable<T1Proxy,T1>	having(boolean condition, SQLExpression2<ProxyAggregateFilter,T1Proxy> aggregateFilterSQLExpression)
default ProxyQueryable<T1Proxy,T1>	having(SQLExpression2<ProxyAggregateFilter,T1Proxy> aggregateFilterSQLExpression)
<T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyQueryable2<T1Proxy,T1,T2Proxy,T2>	innerJoin(ProxyQueryable<T2Proxy,T2> joinQueryable, SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> on)
<T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyQueryable2<T1Proxy,T1,T2Proxy,T2>	innerJoin(T2Proxy joinProxy, SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> on)
<T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyQueryable2<T1Proxy,T1,T2Proxy,T2>	leftJoin(ProxyQueryable<T2Proxy,T2> joinQueryable, SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> on)
<T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyQueryable2<T1Proxy,T1,T2Proxy,T2>	leftJoin(T2Proxy joinProxy, SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> on)
default ProxyQueryable<T1Proxy,T1>	limit(boolean condition, long rows)
ProxyQueryable<T1Proxy,T1>	limit(boolean condition, long offset, long rows)
default ProxyQueryable<T1Proxy,T1>	limit(long rows)
default ProxyQueryable<T1Proxy,T1>	limit(long offset, long rows)
default <TMember extends Comparable<?>> TMember	maxOrDefault(SQLFuncExpression1<T1Proxy,SQLColumn<TMember>> columnSelector, TMember def)
default <TMember extends Comparable<?>> TMember	maxOrNull(SQLFuncExpression1<T1Proxy,SQLColumn<TMember>> columnSelector)
default <TMember> TMember	minOrDefault(SQLFuncExpression1<T1Proxy,SQLColumn<TMember>> columnSelector, TMember def)
default <TMember> TMember	minOrNull(SQLFuncExpression1<T1Proxy,SQLColumn<TMember>> columnSelector)
ProxyQueryable<T1Proxy,T1>	orderBy(boolean condition, SQLExpression2<ProxyOrderSelector,T1Proxy> selectExpression, boolean asc)
default ProxyQueryable<T1Proxy,T1>	orderBy(SQLExpression2<ProxyOrderSelector,T1Proxy> selectExpression, boolean asc)
default ProxyQueryable<T1Proxy,T1>	orderByAsc(boolean condition, SQLExpression2<ProxyOrderSelector,T1Proxy> selectExpression)
default ProxyQueryable<T1Proxy,T1>	orderByAsc(SQLExpression2<ProxyOrderSelector,T1Proxy> selectExpression)
default ProxyQueryable<T1Proxy,T1>	orderByDesc(boolean condition, SQLExpression2<ProxyOrderSelector,T1Proxy> selectExpression)
default ProxyQueryable<T1Proxy,T1>	orderByDesc(SQLExpression2<ProxyOrderSelector,T1Proxy> selectExpression)
ProxyQueryable<T1Proxy,T1>	orderByObject(boolean condition, ObjectSort objectSort)
default ProxyQueryable<T1Proxy,T1>	orderByObject(ObjectSort configuration)
<T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyQueryable2<T1Proxy,T1,T2Proxy,T2>	rightJoin(ProxyQueryable<T2Proxy,T2> joinQueryable, SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> on)
<T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyQueryable2<T1Proxy,T1,T2Proxy,T2>	rightJoin(T2Proxy joinProxy, SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> on)
ProxyQueryable<T1Proxy,T1>	select(Collection<ColumnSegment> columnSegments, boolean clearAll)
default ProxyQueryable<T1Proxy,T1>	select(ColumnSegment columnSegment, boolean clearAll)
<TRProxy extends ProxyEntity<TRProxy,TR>,TR> ProxyQueryable<TRProxy,TR>	select(ProxyEntity<TRProxy,TR> trProxy) 将当前T1对象转成TR对象，select会将T1属性所对应的列名映射到TR对象的列名上(忽略大小写) T1.property1列名叫做column1,T1.property2列名叫做column2，TR.property3的列名也叫column1 那么生成的sql为:select column1 from t1 如果当前存在join，那么join的子表一律不会映射到resultClass上,如果需要那么请手动调用双参数select
ProxyQueryable<T1Proxy,T1>	select(SQLExpression2<ProxySelector,T1Proxy> selectExpression) 对当前表达式返回自定义select列
ProxyQueryable<T1Proxy,T1>	select(String columns) 设置column所有join表都会生效
<TRProxy extends ProxyEntity<TRProxy,TR>,TR> ProxyQueryable<TRProxy,TR>	select(TRProxy trProxy, SQLExpression2<ProxyAsSelector<TRProxy,TR>,T1Proxy> selectExpression) 设置返回对象，返回对象会根据selectExpression映射相同列名 多次select会在前一次基础上进行对上次结果进行匿名表处理
default <TMember extends Number> BigDecimal	sumBigDecimalOrDefault(SQLFuncExpression1<T1Proxy,SQLColumn<TMember>> columnSelector, BigDecimal def)
default <TMember extends Number> BigDecimal	sumBigDecimalOrNull(SQLFuncExpression1<T1Proxy,SQLColumn<TMember>> columnSelector) 防止溢出
default <TMember extends Number> TMember	sumOrDefault(SQLFuncExpression1<T1Proxy,SQLColumn<TMember>> columnSelector, TMember def)
default <TMember extends Number> TMember	sumOrNull(SQLFuncExpression1<T1Proxy,SQLColumn<TMember>> columnSelector)
ProxyQueryable<T1Proxy,T1>	union(Collection<ProxyQueryable<T1Proxy,T1>> unionQueries)
default ProxyQueryable<T1Proxy,T1>	union(ProxyQueryable<T1Proxy,T1> unionQueryable)
default ProxyQueryable<T1Proxy,T1>	union(ProxyQueryable<T1Proxy,T1> unionQueryable1, ProxyQueryable<T1Proxy,T1> unionQueryable2)
default ProxyQueryable<T1Proxy,T1>	union(ProxyQueryable<T1Proxy,T1> unionQueryable1, ProxyQueryable<T1Proxy,T1> unionQueryable2, ProxyQueryable<T1Proxy,T1> unionQueryable3)
ProxyQueryable<T1Proxy,T1>	unionAll(Collection<ProxyQueryable<T1Proxy,T1>> unionQueries)
default ProxyQueryable<T1Proxy,T1>	unionAll(ProxyQueryable<T1Proxy,T1> unionQueryable)
default ProxyQueryable<T1Proxy,T1>	unionAll(ProxyQueryable<T1Proxy,T1> unionQueryable1, ProxyQueryable<T1Proxy,T1> unionQueryable2)
default ProxyQueryable<T1Proxy,T1>	unionAll(ProxyQueryable<T1Proxy,T1> unionQueryable1, ProxyQueryable<T1Proxy,T1> unionQueryable2, ProxyQueryable<T1Proxy,T1> unionQueryable3)
ProxyQueryable<T1Proxy,T1>	useConnectionMode(ConnectionModeEnum connectionMode)
ProxyQueryable<T1Proxy,T1>	useMaxShardingQueryLimit(int maxShardingQueryLimit)
ProxyQueryable<T1Proxy,T1>	useShardingConfigure(int maxShardingQueryLimit, ConnectionModeEnum connectionMode)
ProxyQueryable<T1Proxy,T1>	where(boolean condition, SQLExpression2<ProxyFilter,T1Proxy> whereExpression)
default ProxyQueryable<T1Proxy,T1>	where(SQLExpression2<ProxyFilter,T1Proxy> whereExpression)
ProxyQueryable<T1Proxy,T1>	whereById(boolean condition, Object id)
default ProxyQueryable<T1Proxy,T1>	whereById(Object id) 根据id主键查询
<TProperty> ProxyQueryable<T1Proxy,T1>	whereByIds(boolean condition, Collection<TProperty> ids) 根据主键id集合查询
default <TProperty> ProxyQueryable<T1Proxy,T1>	whereByIds(Collection<TProperty> ids)
ProxyQueryable<T1Proxy,T1>	whereObject(boolean condition, Object object)
default ProxyQueryable<T1Proxy,T1>	whereObject(Object object)

从接口继承的方法 com.easy.query.core.basic.api.select.Query

any, count, firstNotNull, firstNotNull, firstNotNull, firstNotNull, firstOrNull, firstOrNull, getSQLEntityExpressionBuilder, intCount, queryClass, toList, toList, toMap, toMaps, toPageResult, toPageResult, toShardingPageResult, toShardingPageResult, toSQL, toSQL, toSQL, toSQL

从接口继承的方法 com.easy.query.core.basic.api.internal.Interceptable

noInterceptor, noInterceptor, useInterceptor, useInterceptor

从接口继承的方法 com.easy.query.core.basic.api.internal.LogicDeletable

disableLogicDelete, enableLogicDelete, useLogicDelete

从接口继承的方法 com.easy.query.core.basic.api.internal.TableReNameable

asAlias, asSchema, asSchema, asTable, asTable

从接口继承的方法 com.easy.query.core.basic.api.internal.QueryStrategy

queryLargeColumn

方法详细资料

get1Proxy

T1Proxy get1Proxy()

getEntityQueryable

ClientQueryable<T1> getEntityQueryable()

cloneQueryable

ProxyQueryable<T1Proxy,T1> cloneQueryable()

指定者:

cloneQueryable 在接口中 Query<T1>

countDistinct

long countDistinct(SQLExpression2<ProxySelector,T1Proxy> selectExpression)

all

boolean all(SQLExpression2<ProxyFilter,T1Proxy> whereExpression)

SELECT NOT EXISTS ( SELECT 1 FROM `table` AS `t` WHERE (`t`.`columns` = ?))

参数:

whereExpression - 表达式最后一个是取反

返回:

sumBigDecimalOrNull

default <TMember extends Number> BigDecimal sumBigDecimalOrNull(SQLFuncExpression1<T1Proxy,SQLColumn<TMember>> columnSelector)

防止溢出

参数:

columnSelector -

返回:

sumBigDecimalOrDefault

default <TMember extends Number> BigDecimal sumBigDecimalOrDefault(SQLFuncExpression1<T1Proxy,SQLColumn<TMember>> columnSelector,
                                                                   BigDecimal def)

sumOrNull

default <TMember extends Number> TMember sumOrNull(SQLFuncExpression1<T1Proxy,SQLColumn<TMember>> columnSelector)

sumOrDefault

default <TMember extends Number> TMember sumOrDefault(SQLFuncExpression1<T1Proxy,SQLColumn<TMember>> columnSelector,
                                                      TMember def)

maxOrNull

default <TMember extends Comparable<?>> TMember maxOrNull(SQLFuncExpression1<T1Proxy,SQLColumn<TMember>> columnSelector)

maxOrDefault

default <TMember extends Comparable<?>> TMember maxOrDefault(SQLFuncExpression1<T1Proxy,SQLColumn<TMember>> columnSelector,
                                                             TMember def)

minOrNull

default <TMember> TMember minOrNull(SQLFuncExpression1<T1Proxy,SQLColumn<TMember>> columnSelector)

minOrDefault

default <TMember> TMember minOrDefault(SQLFuncExpression1<T1Proxy,SQLColumn<TMember>> columnSelector,
                                       TMember def)

avgOrNull

default <TMember extends Number> Double avgOrNull(SQLFuncExpression1<T1Proxy,SQLColumn<TMember>> columnSelector)

avgBigDecimalOrNull

default <TMember extends Number> BigDecimal avgBigDecimalOrNull(SQLFuncExpression1<T1Proxy,SQLColumn<TMember>> columnSelector)

avgFloatOrNull

default <TMember extends Number> Float avgFloatOrNull(SQLFuncExpression1<T1Proxy,SQLColumn<TMember>> columnSelector)

avgOrDefault

default <TMember extends Number> Double avgOrDefault(SQLFuncExpression1<T1Proxy,SQLColumn<TMember>> columnSelector,
                                                     Double def)

avgOrDefault

default BigDecimal avgOrDefault(SQLFuncExpression1<T1Proxy,SQLColumn<BigDecimal>> columnSelector,
                                BigDecimal def)

avgOrDefault

default Float avgOrDefault(SQLFuncExpression1<T1Proxy,SQLColumn<Float>> columnSelector,
                           Float def)

avgOrDefault

default <TMember extends Number,TResult extends Number> TResult avgOrDefault(SQLFuncExpression1<T1Proxy,SQLColumn<TMember>> columnSelector,
                                                                             TResult def,
                                                                             Class<TResult> resultClass)

select

ProxyQueryable<T1Proxy,T1> select(SQLExpression2<ProxySelector,T1Proxy> selectExpression)

对当前表达式返回自定义select列

参数:

selectExpression -

返回:

select

<TRProxy extends ProxyEntity<TRProxy,TR>,TR> ProxyQueryable<TRProxy,TR> select(ProxyEntity<TRProxy,TR> trProxy)

将当前T1对象转成TR对象，select会将T1属性所对应的列名映射到TR对象的列名上(忽略大小写) T1.property1列名叫做column1,T1.property2列名叫做column2，TR.property3的列名也叫column1 那么生成的sql为:select column1 from t1 如果当前存在join，那么join的子表一律不会映射到resultClass上,如果需要那么请手动调用双参数select

类型参数:

TRProxy -

TR -

参数:

trProxy -

返回:

select

<TRProxy extends ProxyEntity<TRProxy,TR>,TR> ProxyQueryable<TRProxy,TR> select(TRProxy trProxy,
                                                                               SQLExpression2<ProxyAsSelector<TRProxy,TR>,T1Proxy> selectExpression)

设置返回对象，返回对象会根据selectExpression映射相同列名 多次select会在前一次基础上进行对上次结果进行匿名表处理

类型参数:

TR -

参数:

trProxy -

selectExpression -

返回:

select

ProxyQueryable<T1Proxy,T1> select(String columns)

设置column所有join表都会生效

指定者:

select 在接口中 Query<T1>

参数:

columns -

返回:

select

default ProxyQueryable<T1Proxy,T1> select(ColumnSegment columnSegment,
                                          boolean clearAll)

select

ProxyQueryable<T1Proxy,T1> select(Collection<ColumnSegment> columnSegments,
                                  boolean clearAll)

where

default ProxyQueryable<T1Proxy,T1> where(SQLExpression2<ProxyFilter,T1Proxy> whereExpression)

where

ProxyQueryable<T1Proxy,T1> where(boolean condition,
                                 SQLExpression2<ProxyFilter,T1Proxy> whereExpression)

whereById

default ProxyQueryable<T1Proxy,T1> whereById(Object id)

根据id主键查询

参数:

id - 主键

返回:

链式表达式

抛出:

EasyQueryNoPrimaryKeyException,EasyQueryMultiPrimaryKeyException - @description 无主键或者多主键报错

whereById

ProxyQueryable<T1Proxy,T1> whereById(boolean condition,
                                     Object id)

参数:

condition -

id -

返回:

抛出:

EasyQueryNoPrimaryKeyException,EasyQueryMultiPrimaryKeyException - @description 无主键或者多主键报错

whereByIds

default <TProperty> ProxyQueryable<T1Proxy,T1> whereByIds(Collection<TProperty> ids)

类型参数:

TProperty -

参数:

ids -

返回:

抛出:

EasyQueryNoPrimaryKeyException,EasyQueryMultiPrimaryKeyException

whereByIds

<TProperty> ProxyQueryable<T1Proxy,T1> whereByIds(boolean condition,
                                                  Collection<TProperty> ids)

根据主键id集合查询

类型参数:

TProperty - 主键类型

参数:

condition - 是否添加该条件

ids - 主键集合

返回:

当前链式表达式

抛出:

EasyQueryNoPrimaryKeyException,EasyQueryMultiPrimaryKeyException

whereObject

default ProxyQueryable<T1Proxy,T1> whereObject(Object object)

参数:

object -

返回:

抛出:

EasyQueryWhereInvalidOperationException - 当object的where属性和查询对象不匹配或者查询对象属性不匹配

whereObject

ProxyQueryable<T1Proxy,T1> whereObject(boolean condition,
                                       Object object)

参数:

condition -

object -

返回:

抛出:

EasyQueryWhereInvalidOperationException - 当object的where属性和查询对象不匹配或者查询对象属性不匹配

groupBy

default ProxyQueryable<T1Proxy,T1> groupBy(SQLExpression2<ProxyGroupSelector,T1Proxy> selectExpression)

groupBy

ProxyQueryable<T1Proxy,T1> groupBy(boolean condition,
                                   SQLExpression2<ProxyGroupSelector,T1Proxy> selectExpression)

having

default ProxyQueryable<T1Proxy,T1> having(SQLExpression2<ProxyAggregateFilter,T1Proxy> aggregateFilterSQLExpression)

having

ProxyQueryable<T1Proxy,T1> having(boolean condition,
                                  SQLExpression2<ProxyAggregateFilter,T1Proxy> aggregateFilterSQLExpression)

orderByAsc

default ProxyQueryable<T1Proxy,T1> orderByAsc(SQLExpression2<ProxyOrderSelector,T1Proxy> selectExpression)

orderByAsc

default ProxyQueryable<T1Proxy,T1> orderByAsc(boolean condition,
                                              SQLExpression2<ProxyOrderSelector,T1Proxy> selectExpression)

orderByDesc

default ProxyQueryable<T1Proxy,T1> orderByDesc(SQLExpression2<ProxyOrderSelector,T1Proxy> selectExpression)

orderByDesc

default ProxyQueryable<T1Proxy,T1> orderByDesc(boolean condition,
                                               SQLExpression2<ProxyOrderSelector,T1Proxy> selectExpression)

orderBy

default ProxyQueryable<T1Proxy,T1> orderBy(SQLExpression2<ProxyOrderSelector,T1Proxy> selectExpression,
                                           boolean asc)

orderBy

ProxyQueryable<T1Proxy,T1> orderBy(boolean condition,
                                   SQLExpression2<ProxyOrderSelector,T1Proxy> selectExpression,
                                   boolean asc)

orderByObject

default ProxyQueryable<T1Proxy,T1> orderByObject(ObjectSort configuration)

参数:

configuration -

返回:

抛出:

EasyQueryOrderByInvalidOperationException - 当配置ObjectSort 为DynamicModeEnum.STRICT排序设置的属性不存在当前排序对象里面或者当前查询对象无法获取

orderByObject

ProxyQueryable<T1Proxy,T1> orderByObject(boolean condition,
                                         ObjectSort objectSort)

参数:

condition -

configuration -

返回:

抛出:

EasyQueryOrderByInvalidOperationException - 当配置ObjectSort 为DynamicModeEnum.STRICT排序设置的属性不存在当前排序对象里面或者当前查询对象无法获取

distinct

default ProxyQueryable<T1Proxy,T1> distinct()

distinct

ProxyQueryable<T1Proxy,T1> distinct(boolean condition)

limit

default ProxyQueryable<T1Proxy,T1> limit(long rows)

指定者:

limit 在接口中 Query<T1>

limit

default ProxyQueryable<T1Proxy,T1> limit(boolean condition,
                                         long rows)

指定者:

limit 在接口中 Query<T1>

limit

default ProxyQueryable<T1Proxy,T1> limit(long offset,
                                         long rows)

指定者:

limit 在接口中 Query<T1>

limit

ProxyQueryable<T1Proxy,T1> limit(boolean condition,
                                 long offset,
                                 long rows)

指定者:

limit 在接口中 Query<T1>

leftJoin

<T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> leftJoin(T2Proxy joinProxy,
                                                                                             SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> on)

leftJoin

<T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> leftJoin(ProxyQueryable<T2Proxy,T2> joinQueryable,
                                                                                             SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> on)

rightJoin

<T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> rightJoin(T2Proxy joinProxy,
                                                                                              SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> on)

rightJoin

<T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> rightJoin(ProxyQueryable<T2Proxy,T2> joinQueryable,
                                                                                              SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> on)

innerJoin

<T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> innerJoin(T2Proxy joinProxy,
                                                                                              SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> on)

innerJoin

<T2Proxy extends ProxyEntity<T2Proxy,T2>,T2> ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> innerJoin(ProxyQueryable<T2Proxy,T2> joinQueryable,
                                                                                              SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> on)

union

default ProxyQueryable<T1Proxy,T1> union(ProxyQueryable<T1Proxy,T1> unionQueryable)

union

default ProxyQueryable<T1Proxy,T1> union(ProxyQueryable<T1Proxy,T1> unionQueryable1,
                                         ProxyQueryable<T1Proxy,T1> unionQueryable2)

union

default ProxyQueryable<T1Proxy,T1> union(ProxyQueryable<T1Proxy,T1> unionQueryable1,
                                         ProxyQueryable<T1Proxy,T1> unionQueryable2,
                                         ProxyQueryable<T1Proxy,T1> unionQueryable3)

union

ProxyQueryable<T1Proxy,T1> union(Collection<ProxyQueryable<T1Proxy,T1>> unionQueries)

unionAll

default ProxyQueryable<T1Proxy,T1> unionAll(ProxyQueryable<T1Proxy,T1> unionQueryable)

unionAll

default ProxyQueryable<T1Proxy,T1> unionAll(ProxyQueryable<T1Proxy,T1> unionQueryable1,
                                            ProxyQueryable<T1Proxy,T1> unionQueryable2)

unionAll

default ProxyQueryable<T1Proxy,T1> unionAll(ProxyQueryable<T1Proxy,T1> unionQueryable1,
                                            ProxyQueryable<T1Proxy,T1> unionQueryable2,
                                            ProxyQueryable<T1Proxy,T1> unionQueryable3)

unionAll

ProxyQueryable<T1Proxy,T1> unionAll(Collection<ProxyQueryable<T1Proxy,T1>> unionQueries)

asTracking

ProxyQueryable<T1Proxy,T1> asTracking()

自动将查询结果集合全部添加到当前上下文追踪中,如果当前查询结果十分庞大,并且更新数据只有个别条数,建议不要使用 追踪查询，可以通过开启追踪后使用普通的查询，然后添加到当前的追踪上下文中EasyQueryClient.addTracking(Object),开始先数据追踪的差异更新 如果当前启用了追踪查询并且在当前上下文已经追加了当前trackKey的对象那么当前查询结果的对象不会被返回,返回的是被追踪的当前对象, 如果对象A:{id:1,name:2}已经被追踪了,新查询的结果是对象A:{id:1,name:3},那么查询到的数据是{id:1,name:3}但是用户获取到的数据是{id:1,name:2} 所以尽可能在追踪后调用entity update,而不是重复查询对应对象

返回:

asNoTracking

ProxyQueryable<T1Proxy,T1> asNoTracking()

useShardingConfigure

ProxyQueryable<T1Proxy,T1> useShardingConfigure(int maxShardingQueryLimit,
                                                ConnectionModeEnum connectionMode)

useMaxShardingQueryLimit

ProxyQueryable<T1Proxy,T1> useMaxShardingQueryLimit(int maxShardingQueryLimit)

useConnectionMode

ProxyQueryable<T1Proxy,T1> useConnectionMode(ConnectionModeEnum connectionMode)