com.easy.query.api.proxy.select

接口 ProxyQueryable2<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1,T2Proxy extends ProxyEntity<T2Proxy,T2>,T2>

所有超级接口:

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

所有已知实现类:

AbstractProxyQueryable2, EasyProxyQueryable2

public interface ProxyQueryable2<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1,T2Proxy extends ProxyEntity<T2Proxy,T2>,T2>
extends ProxyQueryable<T1Proxy,T1>

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

作者:

xuejiaming

方法概要

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

getClientQueryable2

ClientQueryable2<T1,T2> getClientQueryable2()

leftJoin

<T3Proxy extends ProxyEntity<T3Proxy,T3>,T3> ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> leftJoin(T3Proxy joinProxy,
                                                                                                        SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> on)

leftJoin

<T3Proxy extends ProxyEntity<T3Proxy,T3>,T3> ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> leftJoin(ProxyQueryable<T3Proxy,T3> joinQueryable,
                                                                                                        SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> on)

rightJoin

<T3Proxy extends ProxyEntity<T3Proxy,T3>,T3> ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> rightJoin(T3Proxy joinProxy,
                                                                                                         SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> on)

rightJoin

<T3Proxy extends ProxyEntity<T3Proxy,T3>,T3> ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> rightJoin(ProxyQueryable<T3Proxy,T3> joinQueryable,
                                                                                                         SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> on)

innerJoin

<T3Proxy extends ProxyEntity<T3Proxy,T3>,T3> ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> innerJoin(T3Proxy joinProxy,
                                                                                                         SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> on)

innerJoin

<T3Proxy extends ProxyEntity<T3Proxy,T3>,T3> ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3> innerJoin(ProxyQueryable<T3Proxy,T3> joinQueryable,
                                                                                                         SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> on)

whereById

default ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> whereById(Object id)

从接口复制的说明: ProxyQueryable

根据id主键查询

指定者:

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

参数:

id - 主键

返回:

链式表达式

whereById

ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> whereById(boolean condition,
                                                 Object id)

指定者:

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

返回:

whereObject

default ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> whereObject(Object object)

指定者:

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

返回:

whereObject

ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> whereObject(boolean condition,
                                                   Object object)

指定者:

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

返回:

where

default ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> where(SQLExpression2<ProxyFilter,T1Proxy> whereExpression)

指定者:

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

where

ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> where(boolean condition,
                                             SQLExpression2<ProxyFilter,T1Proxy> whereExpression)

指定者:

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

where

default ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> where(SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> whereExpression)

where

default ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> where(boolean condition,
                                                     SQLExpression3<ProxyFilter,T1Proxy,T2Proxy> whereExpression)

select

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

sumBigDecimalOrNull

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

防止溢出

类型参数:

TMember -

参数:

columnSelectorExpression -

返回:

sumBigDecimalOrDefault

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

sumOrNull

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

sumOrDefault

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

maxOrNull

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

maxOrDefault

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

minOrNull

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

minOrDefault

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

avgOrNull

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

avgBigDecimalOrNull

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

avgFloatOrNull

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

avgOrDefault

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

avgBigDecimalOrDefault

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

avgFloatOrDefault

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

avgOrDefault

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

groupBy

default ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> groupBy(SQLExpression2<ProxyGroupSelector,T1Proxy> selectExpression)

指定者:

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

groupBy

ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> groupBy(boolean condition,
                                               SQLExpression2<ProxyGroupSelector,T1Proxy> selectExpression)

指定者:

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

groupBy

default ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> groupBy(SQLExpression3<ProxyGroupSelector,T1Proxy,T2Proxy> selectExpression)

groupBy

default ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> groupBy(boolean condition,
                                                       SQLExpression3<ProxyGroupSelector,T1Proxy,T2Proxy> selectExpression)

having

default ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> having(SQLExpression2<ProxyAggregateFilter,T1Proxy> aggregateFilterExpression)

指定者:

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

having

ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> having(boolean condition,
                                              SQLExpression2<ProxyAggregateFilter,T1Proxy> aggregateFilterExpression)

指定者:

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

having

default ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> having(SQLExpression3<ProxyAggregateFilter,T1Proxy,T2Proxy> aggregateFilterExpression)

having

default ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> having(boolean condition,
                                                      SQLExpression3<ProxyAggregateFilter,T1Proxy,T2Proxy> aggregateFilterExpression)

orderByAsc

default ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> orderByAsc(SQLExpression2<ProxyOrderSelector,T1Proxy> selectExpression)

指定者:

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

orderByAsc

ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> orderByAsc(boolean condition,
                                                  SQLExpression2<ProxyOrderSelector,T1Proxy> selectExpression)

指定者:

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

orderByAsc

default ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> orderByAsc(SQLExpression3<ProxyOrderSelector,T1Proxy,T2Proxy> selectExpression)

orderByAsc

default ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> orderByAsc(boolean condition,
                                                          SQLExpression3<ProxyOrderSelector,T1Proxy,T2Proxy> selectExpression)

orderByDesc

default ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> orderByDesc(SQLExpression2<ProxyOrderSelector,T1Proxy> selectExpression)

指定者:

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

orderByDesc

ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> orderByDesc(boolean condition,
                                                   SQLExpression2<ProxyOrderSelector,T1Proxy> selectExpression)

指定者:

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

orderByDesc

default ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> orderByDesc(SQLExpression3<ProxyOrderSelector,T1Proxy,T2Proxy> selectExpression)

orderByDesc

default ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> orderByDesc(boolean condition,
                                                           SQLExpression3<ProxyOrderSelector,T1Proxy,T2Proxy> selectExpression)

limit

default ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> limit(long rows)

指定者:

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

指定者:

limit 在接口中 Query<T1>

limit

default ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> limit(boolean condition,
                                                     long rows)

指定者:

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

指定者:

limit 在接口中 Query<T1>

limit

default ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> limit(long offset,
                                                     long rows)

指定者:

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

指定者:

limit 在接口中 Query<T1>

limit

ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> limit(boolean condition,
                                             long offset,
                                             long rows)

指定者:

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

指定者:

limit 在接口中 Query<T1>

distinct

default ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> distinct()

指定者:

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

distinct

ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> distinct(boolean condition)

指定者:

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

disableLogicDelete

ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> disableLogicDelete()

指定者:

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

enableLogicDelete

ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> enableLogicDelete()

指定者:

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

useLogicDelete

ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> useLogicDelete(boolean enable)

指定者:

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

noInterceptor

ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> noInterceptor()

指定者:

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

useInterceptor

ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> useInterceptor(String name)

指定者:

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

noInterceptor

ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> noInterceptor(String name)

指定者:

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

useInterceptor

ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> useInterceptor()

指定者:

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

asTracking

ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> asTracking()

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

指定者:

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

返回:

asNoTracking

ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> asNoTracking()

指定者:

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

queryLargeColumn

ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> queryLargeColumn(boolean queryLarge)

指定者:

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

useShardingConfigure

ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> useShardingConfigure(int maxShardingQueryLimit,
                                                            ConnectionModeEnum connectionMode)

指定者:

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

useMaxShardingQueryLimit

ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> useMaxShardingQueryLimit(int maxShardingQueryLimit)

指定者:

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

useConnectionMode

ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> useConnectionMode(ConnectionModeEnum connectionMode)

指定者:

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

asTable

default ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> asTable(String tableName)

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

指定者:

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

参数:

tableName -

返回:

asTable

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

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

指定者:

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

参数:

tableNameAs -

返回:

asSchema

default ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> asSchema(String tableName)

指定者:

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

asSchema

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

指定者:

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

asAlias

ProxyQueryable2<T1Proxy,T1,T2Proxy,T2> asAlias(String alias)

指定者:

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