com.easy.query.api.proxy.select

接口 ProxyQueryable3<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1,T2Proxy extends ProxyEntity<T2Proxy,T2>,T2,T3Proxy extends ProxyEntity<T3Proxy,T3>,T3>

所有超级接口:

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

所有已知实现类:

AbstractProxyQueryable3, EasyProxyQueryable3

public interface ProxyQueryable3<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1,T2Proxy extends ProxyEntity<T2Proxy,T2>,T2,T3Proxy extends ProxyEntity<T3Proxy,T3>,T3>
extends ProxyQueryable<T1Proxy,T1>

create time 2023/6/23 15:26 文件说明

作者:

xuejiaming

方法概要

限定符和类型	方法和说明
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	asAlias(String alias)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	asNoTracking()
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	asSchema(java.util.function.Function<String,String> schemaAs)
default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	asSchema(String tableName)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	asTable(java.util.function.Function<String,String> tableNameAs) 将当前表达式最近的一张表的表名修改成 返回的表名 如果当前最近的表是正常的数据库表名,那么直接将表名改写 如果当前最近的表是匿名表比如嵌套queryable的表那么将alias改成对应的表名
default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	asTable(String tableName) 将当前表达式最近的一张表的表名修改成 如果当前最近的表是正常的数据库表名,那么直接将表名改写 如果当前最近的表是匿名表比如嵌套queryable的表那么将alias改成对应的表名
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	asTracking() 自动将查询结果集合全部添加到当前上下文追踪中,如果当前查询结果十分庞大,并且更新数据只有个别条数,建议不要使用 追踪查询，可以通过开启追踪后使用普通的查询，然后添加到当前的追踪上下文中EasyQueryClient.addTracking(Object),开始先数据追踪的差异更新
default <TMember extends Number> BigDecimal	avgBigDecimalOrDefault(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression, BigDecimal def)
default <TMember extends Number> BigDecimal	avgBigDecimalOrNull(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression)
default <TMember extends Number> Float	avgFloatOrDefault(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression, Float def)
default <TMember extends Number> Float	avgFloatOrNull(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression)
default <TMember extends Number> Double	avgOrDefault(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression, Double def)
<TMember extends Number,TResult extends Number> TResult	avgOrDefault(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression, TResult def, Class<TResult> resultClass)
default <TMember extends Number> Double	avgOrNull(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	disableLogicDelete()
default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	distinct()
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	distinct(boolean condition)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	enableLogicDelete()
T2Proxy	get2Proxy()
T3Proxy	get3Proxy()
ClientQueryable3<T1,T2,T3>	getClientQueryable3()
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	groupBy(boolean condition, SQLExpression2<ProxyGroupSelector,T1Proxy> selectExpression)
default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	groupBy(boolean condition, SQLExpression4<ProxyGroupSelector,T1Proxy,T2Proxy,T3Proxy> selectExpression)
default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	groupBy(SQLExpression2<ProxyGroupSelector,T1Proxy> selectExpression)
default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	groupBy(SQLExpression4<ProxyGroupSelector,T1Proxy,T2Proxy,T3Proxy> selectExpression)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	having(boolean condition, SQLExpression2<ProxyAggregateFilter,T1Proxy> predicateExpression)
default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	having(boolean condition, SQLExpression4<ProxyAggregateFilter,T1Proxy,T2Proxy,T3Proxy> aggregateFilterExpression)
default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	having(SQLExpression2<ProxyAggregateFilter,T1Proxy> predicateExpression)
default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	having(SQLExpression4<ProxyAggregateFilter,T1Proxy,T2Proxy,T3Proxy> aggregateFilterExpression)
<T4Proxy extends ProxyEntity<T4Proxy,T4>,T4> ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4>	innerJoin(ProxyQueryable<T4Proxy,T4> joinQueryable, SQLExpression5<ProxyFilter,T1Proxy,T2Proxy,T3Proxy,T4Proxy> on)
<T4Proxy extends ProxyEntity<T4Proxy,T4>,T4> ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4>	innerJoin(T4Proxy joinProxy, SQLExpression5<ProxyFilter,T1Proxy,T2Proxy,T3Proxy,T4Proxy> on)
<T4Proxy extends ProxyEntity<T4Proxy,T4>,T4> ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4>	leftJoin(ProxyQueryable<T4Proxy,T4> joinQueryable, SQLExpression5<ProxyFilter,T1Proxy,T2Proxy,T3Proxy,T4Proxy> on)
<T4Proxy extends ProxyEntity<T4Proxy,T4>,T4> ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4>	leftJoin(T4Proxy joinProxy, SQLExpression5<ProxyFilter,T1Proxy,T2Proxy,T3Proxy,T4Proxy> on)
default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	limit(boolean condition, long rows)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	limit(boolean condition, long offset, long rows)
default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	limit(long rows)
default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	limit(long offset, long rows)
<TMember> TMember	maxOrDefault(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression, TMember def)
default <TMember> TMember	maxOrNull(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression)
<TMember> TMember	minOrDefault(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression, TMember def)
default <TMember> TMember	minOrNull(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	noInterceptor()
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	noInterceptor(String name)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	orderByAsc(boolean condition, SQLExpression2<ProxyOrderSelector,T1Proxy> selectExpression)
default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	orderByAsc(boolean condition, SQLExpression4<ProxyOrderSelector,T1Proxy,T2Proxy,T3Proxy> selectExpression)
default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	orderByAsc(SQLExpression2<ProxyOrderSelector,T1Proxy> selectExpression)
default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	orderByAsc(SQLExpression4<ProxyOrderSelector,T1Proxy,T2Proxy,T3Proxy> selectExpression)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	orderByDesc(boolean condition, SQLExpression2<ProxyOrderSelector,T1Proxy> selectExpression)
default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	orderByDesc(boolean condition, SQLExpression4<ProxyOrderSelector,T1Proxy,T2Proxy,T3Proxy> selectExpression)
default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	orderByDesc(SQLExpression2<ProxyOrderSelector,T1Proxy> selectExpression)
default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	orderByDesc(SQLExpression4<ProxyOrderSelector,T1Proxy,T2Proxy,T3Proxy> selectExpression)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	queryLargeColumn(boolean queryLarge)
<T4Proxy extends ProxyEntity<T4Proxy,T4>,T4> ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4>	rightJoin(ProxyQueryable<T4Proxy,T4> joinQueryable, SQLExpression5<ProxyFilter,T1Proxy,T2Proxy,T3Proxy,T4Proxy> on)
<T4Proxy extends ProxyEntity<T4Proxy,T4>,T4> ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4>	rightJoin(T4Proxy joinProxy, SQLExpression5<ProxyFilter,T1Proxy,T2Proxy,T3Proxy,T4Proxy> on)
<TRProxy extends ProxyEntity<TRProxy,TR>,TR> ProxyQueryable<TRProxy,TR>	select(TRProxy trProxy, SQLExpression4<ProxyAsSelector<TRProxy,TR>,T1Proxy,T2Proxy,T3Proxy> selectExpression)
<TMember extends Number> BigDecimal	sumBigDecimalOrDefault(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression, BigDecimal def)
default <TMember extends Number> BigDecimal	sumBigDecimalOrNull(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression) 防止溢出
<TMember extends Number> TMember	sumOrDefault(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression, TMember def)
default <TMember extends Number> TMember	sumOrNull(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	useConnectionMode(ConnectionModeEnum connectionMode)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	useInterceptor()
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	useInterceptor(String name)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	useLogicDelete(boolean enable)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	useMaxShardingQueryLimit(int maxShardingQueryLimit)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	useShardingConfigure(int maxShardingQueryLimit, ConnectionModeEnum connectionMode)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	where(boolean condition, SQLExpression2<ProxyFilter,T1Proxy> whereExpression)
default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	where(boolean condition, SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> whereExpression)
default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	where(SQLExpression2<ProxyFilter,T1Proxy> whereExpression)
default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	where(SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> whereExpression)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	whereById(boolean condition, Object id)
default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	whereById(Object id) 根据id主键查询
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	whereObject(boolean condition, Object object)
default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	whereObject(Object object)

从接口继承的方法 com.easy.query.api.proxy.select.ProxyQueryable

all, avgBigDecimalOrNull, avgFloatOrNull, avgOrDefault, avgOrDefault, avgOrDefault, avgOrDefault, avgOrNull, cloneQueryable, countDistinct, get1Proxy, getEntityQueryable, innerJoin, innerJoin, leftJoin, leftJoin, maxOrDefault, maxOrNull, minOrDefault, minOrNull, orderBy, orderBy, orderByObject, orderByObject, rightJoin, rightJoin, select, select, select, select, select, select, sumBigDecimalOrDefault, sumBigDecimalOrNull, sumOrDefault, sumOrNull, union, union, union, union, unionAll, unionAll, unionAll, unionAll, whereByIds, whereByIds

从接口继承的方法 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

方法详细资料

get2Proxy

T2Proxy get2Proxy()

get3Proxy

T3Proxy get3Proxy()

getClientQueryable3

ClientQueryable3<T1,T2,T3> getClientQueryable3()

leftJoin

<T4Proxy extends ProxyEntity<T4Proxy,T4>,T4> ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4> leftJoin(T4Proxy joinProxy,
                                                                                                                   SQLExpression5<ProxyFilter,T1Proxy,T2Proxy,T3Proxy,T4Proxy> on)

leftJoin

<T4Proxy extends ProxyEntity<T4Proxy,T4>,T4> ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4> leftJoin(ProxyQueryable<T4Proxy,T4> joinQueryable,
                                                                                                                   SQLExpression5<ProxyFilter,T1Proxy,T2Proxy,T3Proxy,T4Proxy> on)

rightJoin

<T4Proxy extends ProxyEntity<T4Proxy,T4>,T4> ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4> rightJoin(T4Proxy joinProxy,
                                                                                                                    SQLExpression5<ProxyFilter,T1Proxy,T2Proxy,T3Proxy,T4Proxy> on)

rightJoin

<T4Proxy extends ProxyEntity<T4Proxy,T4>,T4> ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4> rightJoin(ProxyQueryable<T4Proxy,T4> joinQueryable,
                                                                                                                    SQLExpression5<ProxyFilter,T1Proxy,T2Proxy,T3Proxy,T4Proxy> on)

innerJoin

<T4Proxy extends ProxyEntity<T4Proxy,T4>,T4> ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4> innerJoin(T4Proxy joinProxy,
                                                                                                                    SQLExpression5<ProxyFilter,T1Proxy,T2Proxy,T3Proxy,T4Proxy> on)

innerJoin

<T4Proxy extends ProxyEntity<T4Proxy,T4>,T4> ProxyQueryable4<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3,T4Proxy,T4> innerJoin(ProxyQueryable<T4Proxy,T4> joinQueryable,
                                                                                                                    SQLExpression5<ProxyFilter,T1Proxy,T2Proxy,T3Proxy,T4Proxy> on)

whereById

default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> whereById(Object id)

从接口复制的说明: ProxyQueryable

根据id主键查询

指定者:

whereById 在接口中 ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>

参数:

id - 主键

返回:

链式表达式

whereById

ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> whereById(boolean condition,
                                                            Object id)

指定者:

whereById 在接口中 ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>

返回:

whereObject

default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> whereObject(Object object)

指定者:

whereObject 在接口中 ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>

返回:

whereObject

ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> whereObject(boolean condition,
                                                              Object object)

指定者:

whereObject 在接口中 ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>

返回:

where

default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> where(SQLExpression2<ProxyFilter,T1Proxy> whereExpression)

指定者:

where 在接口中 ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>

where

ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> where(boolean condition,
                                                        SQLExpression2<ProxyFilter,T1Proxy> whereExpression)

指定者:

where 在接口中 ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>

where

default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> where(SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> whereExpression)

where

default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> where(boolean condition,
                                                                SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> whereExpression)

select

<TRProxy extends ProxyEntity<TRProxy,TR>,TR> ProxyQueryable<TRProxy,TR> select(TRProxy trProxy,
                                                                               SQLExpression4<ProxyAsSelector<TRProxy,TR>,T1Proxy,T2Proxy,T3Proxy> selectExpression)

sumBigDecimalOrNull

default <TMember extends Number> BigDecimal sumBigDecimalOrNull(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression)

防止溢出

类型参数:

TMember -

参数:

columnSelectorExpression -

返回:

sumBigDecimalOrDefault

<TMember extends Number> BigDecimal sumBigDecimalOrDefault(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression,
                                                           BigDecimal def)

sumOrNull

default <TMember extends Number> TMember sumOrNull(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression)

sumOrDefault

<TMember extends Number> TMember sumOrDefault(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression,
                                              TMember def)

maxOrNull

default <TMember> TMember maxOrNull(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression)

maxOrDefault

<TMember> TMember maxOrDefault(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression,
                               TMember def)

minOrNull

default <TMember> TMember minOrNull(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression)

minOrDefault

<TMember> TMember minOrDefault(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression,
                               TMember def)

avgOrNull

default <TMember extends Number> Double avgOrNull(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression)

avgBigDecimalOrNull

default <TMember extends Number> BigDecimal avgBigDecimalOrNull(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression)

avgFloatOrNull

default <TMember extends Number> Float avgFloatOrNull(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression)

avgOrDefault

default <TMember extends Number> Double avgOrDefault(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression,
                                                     Double def)

avgBigDecimalOrDefault

default <TMember extends Number> BigDecimal avgBigDecimalOrDefault(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression,
                                                                   BigDecimal def)

avgFloatOrDefault

default <TMember extends Number> Float avgFloatOrDefault(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression,
                                                         Float def)

avgOrDefault

<TMember extends Number,TResult extends Number> TResult avgOrDefault(SQLFuncExpression3<T1Proxy,T2Proxy,T3Proxy,SQLColumn<TMember>> columnSelectorExpression,
                                                                     TResult def,
                                                                     Class<TResult> resultClass)

groupBy

default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> groupBy(SQLExpression2<ProxyGroupSelector,T1Proxy> selectExpression)

指定者:

groupBy 在接口中 ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>

groupBy

ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> groupBy(boolean condition,
                                                          SQLExpression2<ProxyGroupSelector,T1Proxy> selectExpression)

指定者:

groupBy 在接口中 ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>

groupBy

default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> groupBy(SQLExpression4<ProxyGroupSelector,T1Proxy,T2Proxy,T3Proxy> selectExpression)

groupBy

default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> groupBy(boolean condition,
                                                                  SQLExpression4<ProxyGroupSelector,T1Proxy,T2Proxy,T3Proxy> selectExpression)

having

default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> having(SQLExpression2<ProxyAggregateFilter,T1Proxy> predicateExpression)

指定者:

having 在接口中 ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>

having

ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> having(boolean condition,
                                                         SQLExpression2<ProxyAggregateFilter,T1Proxy> predicateExpression)

指定者:

having 在接口中 ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>

having

default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> having(SQLExpression4<ProxyAggregateFilter,T1Proxy,T2Proxy,T3Proxy> aggregateFilterExpression)

having

default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> having(boolean condition,
                                                                 SQLExpression4<ProxyAggregateFilter,T1Proxy,T2Proxy,T3Proxy> aggregateFilterExpression)

orderByAsc

default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> orderByAsc(SQLExpression2<ProxyOrderSelector,T1Proxy> selectExpression)

指定者:

orderByAsc 在接口中 ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>

orderByAsc

ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> orderByAsc(boolean condition,
                                                             SQLExpression2<ProxyOrderSelector,T1Proxy> selectExpression)

指定者:

orderByAsc 在接口中 ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>

orderByAsc

default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> orderByAsc(SQLExpression4<ProxyOrderSelector,T1Proxy,T2Proxy,T3Proxy> selectExpression)

orderByAsc

default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> orderByAsc(boolean condition,
                                                                     SQLExpression4<ProxyOrderSelector,T1Proxy,T2Proxy,T3Proxy> selectExpression)

orderByDesc

default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> orderByDesc(SQLExpression2<ProxyOrderSelector,T1Proxy> selectExpression)

指定者:

orderByDesc 在接口中 ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>

orderByDesc

ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> orderByDesc(boolean condition,
                                                              SQLExpression2<ProxyOrderSelector,T1Proxy> selectExpression)

指定者:

orderByDesc 在接口中 ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>

orderByDesc

default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> orderByDesc(SQLExpression4<ProxyOrderSelector,T1Proxy,T2Proxy,T3Proxy> selectExpression)

orderByDesc

default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> orderByDesc(boolean condition,
                                                                      SQLExpression4<ProxyOrderSelector,T1Proxy,T2Proxy,T3Proxy> selectExpression)

limit

default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> limit(long rows)

指定者:

limit 在接口中 ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>

指定者:

limit 在接口中 Query<T1>

limit

default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> limit(boolean condition,
                                                                long rows)

指定者:

limit 在接口中 ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>

指定者:

limit 在接口中 Query<T1>

limit

default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> limit(long offset,
                                                                long rows)

指定者:

limit 在接口中 ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>

指定者:

limit 在接口中 Query<T1>

limit

ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> limit(boolean condition,
                                                        long offset,
                                                        long rows)

指定者:

limit 在接口中 ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>

指定者:

limit 在接口中 Query<T1>

distinct

default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> distinct()

指定者:

distinct 在接口中 ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>

distinct

ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> distinct(boolean condition)

指定者:

distinct 在接口中 ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>

disableLogicDelete

ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> disableLogicDelete()

指定者:

disableLogicDelete 在接口中 LogicDeletable<ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>>

enableLogicDelete

ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> enableLogicDelete()

指定者:

enableLogicDelete 在接口中 LogicDeletable<ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>>

useLogicDelete

ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> useLogicDelete(boolean enable)

指定者:

useLogicDelete 在接口中 LogicDeletable<ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>>

noInterceptor

ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> noInterceptor()

指定者:

noInterceptor 在接口中 Interceptable<ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>>

useInterceptor

ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> useInterceptor(String name)

指定者:

useInterceptor 在接口中 Interceptable<ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>>

noInterceptor

ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> noInterceptor(String name)

指定者:

noInterceptor 在接口中 Interceptable<ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>>

useInterceptor

ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> useInterceptor()

指定者:

useInterceptor 在接口中 Interceptable<ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>>

asTracking

ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> asTracking()

自动将查询结果集合全部添加到当前上下文追踪中,如果当前查询结果十分庞大,并且更新数据只有个别条数,建议不要使用 追踪查询，可以通过开启追踪后使用普通的查询，然后添加到当前的追踪上下文中EasyQueryClient.addTracking(Object),开始先数据追踪的差异更新

指定者:

asTracking 在接口中 ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>

返回:

asNoTracking

ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> asNoTracking()

指定者:

asNoTracking 在接口中 ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>

queryLargeColumn

ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> queryLargeColumn(boolean queryLarge)

指定者:

queryLargeColumn 在接口中 QueryStrategy<ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>>

useShardingConfigure

ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> useShardingConfigure(int maxShardingQueryLimit,
                                                                       ConnectionModeEnum connectionMode)

指定者:

useShardingConfigure 在接口中 ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>

useMaxShardingQueryLimit

ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> useMaxShardingQueryLimit(int maxShardingQueryLimit)

指定者:

useMaxShardingQueryLimit 在接口中 ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>

useConnectionMode

ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> useConnectionMode(ConnectionModeEnum connectionMode)

指定者:

useConnectionMode 在接口中 ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>

asTable

default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> asTable(String tableName)

将当前表达式最近的一张表的表名修改成 如果当前最近的表是正常的数据库表名,那么直接将表名改写 如果当前最近的表是匿名表比如嵌套queryable的表那么将alias改成对应的表名

指定者:

asTable 在接口中 TableReNameable<ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>>

参数:

tableName -

返回:

asTable

ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> asTable(java.util.function.Function<String,String> tableNameAs)

将当前表达式最近的一张表的表名修改成 返回的表名 如果当前最近的表是正常的数据库表名,那么直接将表名改写 如果当前最近的表是匿名表比如嵌套queryable的表那么将alias改成对应的表名

指定者:

asTable 在接口中 TableReNameable<ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>>

参数:

tableNameAs -

返回:

asSchema

default ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> asSchema(String tableName)

指定者:

asSchema 在接口中 TableReNameable<ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>>

asSchema

ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> asSchema(java.util.function.Function<String,String> schemaAs)

指定者:

asSchema 在接口中 TableReNameable<ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>>

asAlias

ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> asAlias(String alias)

指定者:

asAlias 在接口中 TableReNameable<ProxyQueryable<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1>>