接口的使用
com.easy.query.api.proxy.select.ProxyQueryable3

使用ProxyQueryable3的程序包

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

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

返回ProxyQueryable3的com.easy.query.api.proxy.select中的方法

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

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

实现ProxyQueryable3的com.easy.query.api.proxy.select.abstraction中的类

限定符和类型	类和说明
class	AbstractProxyQueryable3<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1,T2Proxy extends ProxyEntity<T2Proxy,T2>,T2,T3Proxy extends ProxyEntity<T3Proxy,T3>,T3> create time 2023/6/23 22:08 文件说明

返回ProxyQueryable3的com.easy.query.api.proxy.select.abstraction中的方法

限定符和类型	方法和说明
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.asAlias(String alias)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.asNoTracking()
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.asSchema(java.util.function.Function<String,String> schemaAs)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.asTable(java.util.function.Function<String,String> tableNameAs)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.asTracking()
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.disableLogicDelete()
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.distinct(boolean condition)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.enableLogicDelete()
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.groupBy(boolean condition, SQLExpression2<ProxyGroupSelector,T1Proxy> selectExpression)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.having(boolean condition, SQLExpression2<ProxyAggregateFilter,T1Proxy> aggregateFilterSQLExpression)
<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)
<T3Proxy extends ProxyEntity<T3Proxy,T3>,T3> ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable2.innerJoin(T3Proxy joinProxy, SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> 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)
<T3Proxy extends ProxyEntity<T3Proxy,T3>,T3> ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable2.leftJoin(T3Proxy joinProxy, SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> on)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.limit(boolean condition, long offset, long rows)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.noInterceptor()
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.noInterceptor(String name)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.orderByAsc(boolean condition, SQLExpression2<ProxyOrderSelector,T1Proxy> selectExpression)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.orderByDesc(boolean condition, SQLExpression2<ProxyOrderSelector,T1Proxy> selectExpression)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.queryLargeColumn(boolean queryLarge)
<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)
<T3Proxy extends ProxyEntity<T3Proxy,T3>,T3> ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable2.rightJoin(T3Proxy joinProxy, SQLExpression4<ProxyFilter,T1Proxy,T2Proxy,T3Proxy> on)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.useConnectionMode(ConnectionModeEnum connectionMode)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.useInterceptor()
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.useInterceptor(String name)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.useLogicDelete(boolean enable)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.useMaxShardingQueryLimit(int maxShardingQueryLimit)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.useShardingConfigure(int maxShardingQueryLimit, ConnectionModeEnum connectionMode)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.where(boolean condition, SQLExpression2<ProxyFilter,T1Proxy> whereExpression)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.whereById(boolean condition, Object id)
<TProperty> ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.whereByIds(boolean condition, Collection<TProperty> ids)
ProxyQueryable3<T1Proxy,T1,T2Proxy,T2,T3Proxy,T3>	AbstractProxyQueryable3.whereObject(boolean condition, Object object)

com.easy.query.api.proxy.select.impl中ProxyQueryable3的使用

实现ProxyQueryable3的com.easy.query.api.proxy.select.impl中的类

限定符和类型	类和说明
class	EasyProxyQueryable3<T1Proxy extends ProxyEntity<T1Proxy,T1>,T1,T2Proxy extends ProxyEntity<T2Proxy,T2>,T2,T3Proxy extends ProxyEntity<T3Proxy,T3>,T3> create time 2023/6/23 23:22 文件说明