程序包 org.babyfish.jimmer.sql.ast.impl.query

类 MutableRootQueryImpl<T extends Table<?>>

java.lang.Object

org.babyfish.jimmer.sql.ast.impl.AbstractMutableStatementImpl

org.babyfish.jimmer.sql.ast.impl.query.AbstractMutableQueryImpl

org.babyfish.jimmer.sql.ast.impl.query.MutableRootQueryImpl<T>

所有已实现的接口:

FilterableImplementor, MutableStatementImplementor, Filterable, MutableQuery, MutableRootQuery<T>, RootSelectable<T>, Sortable, SubQueryProvider

public class MutableRootQueryImpl<T extends Table<?>>
extends AbstractMutableQueryImpl
implements MutableRootQuery<T>

字段概要

从类继承的字段 org.babyfish.jimmer.sql.ast.impl.query.AbstractMutableQueryImpl

ORDER_BY_PRIORITY_GLOBAL_FILTER, ORDER_BY_PRIORITY_PROP_FILTER, ORDER_BY_PRIORITY_STATEMENT

构造器概要

构造器

构造器	说明
MutableRootQueryImpl(StatementContext ctx, JSqlClientImplementor sqlClient, org.babyfish.jimmer.meta.ImmutableType immutableType)
MutableRootQueryImpl(StatementContext ctx, JSqlClientImplementor sqlClient, TableProxy<?> table)
MutableRootQueryImpl(JSqlClientImplementor sqlClient, org.babyfish.jimmer.meta.ImmutableType immutableType, ExecutionPurpose purpose, FilterLevel filterLevel)
MutableRootQueryImpl(JSqlClientImplementor sqlClient, TableProxy<?> table, ExecutionPurpose purpose, FilterLevel filterLevel)

方法概要

修饰符和类型	方法	说明
boolean	exists(Connection con)
StatementContext	getContext()
AbstractMutableStatementImpl	getParent()
MutableRootQueryImpl<T>	groupBy(Expression<?>... expressions)
MutableRootQueryImpl<T>	having(Predicate... predicates)
MutableRootQueryImpl<T>	orderBy(List<Order> orders)
MutableRootQueryImpl<T>	orderBy(Expression<?>... expressions)
MutableRootQueryImpl<T>	orderBy(Order... orders)
MutableRootQueryImpl<T>	orderByIf(boolean condition, List<Order> orders)
MutableRootQueryImpl<T>	orderByIf(boolean condition, Expression<?>... expressions)
MutableRootQueryImpl<T>	orderByIf(boolean condition, Order... orders)
<R> ConfigurableRootQuery<T,R>	select(Selection<R> selection)
<T1, T2> ConfigurableRootQuery<T,org.babyfish.jimmer.sql.ast.tuple.Tuple2<T1,T2>>	select(Selection<T1> selection1, Selection<T2> selection2)
<T1, T2, T3> ConfigurableRootQuery<T,org.babyfish.jimmer.sql.ast.tuple.Tuple3<T1,T2,T3>>	select(Selection<T1> selection1, Selection<T2> selection2, Selection<T3> selection3)
<T1, T2, T3, T4> ConfigurableRootQuery<T,org.babyfish.jimmer.sql.ast.tuple.Tuple4<T1,T2,T3,T4>>	select(Selection<T1> selection1, Selection<T2> selection2, Selection<T3> selection3, Selection<T4> selection4)
<T1, T2, T3, T4, T5> ConfigurableRootQuery<T,org.babyfish.jimmer.sql.ast.tuple.Tuple5<T1,T2,T3,T4,T5>>	select(Selection<T1> selection1, Selection<T2> selection2, Selection<T3> selection3, Selection<T4> selection4, Selection<T5> selection5)
<T1, T2, T3, T4, T5, T6> ConfigurableRootQuery<T,org.babyfish.jimmer.sql.ast.tuple.Tuple6<T1,T2,T3,T4,T5,T6>>	select(Selection<T1> selection1, Selection<T2> selection2, Selection<T3> selection3, Selection<T4> selection4, Selection<T5> selection5, Selection<T6> selection6)
<T1, T2, T3, T4, T5, T6, T7> ConfigurableRootQuery<T,org.babyfish.jimmer.sql.ast.tuple.Tuple7<T1,T2,T3,T4,T5,T6,T7>>	select(Selection<T1> selection1, Selection<T2> selection2, Selection<T3> selection3, Selection<T4> selection4, Selection<T5> selection5, Selection<T6> selection6, Selection<T7> selection7)
<T1, T2, T3, T4, T5, T6, T7, T8> ConfigurableRootQuery<T,org.babyfish.jimmer.sql.ast.tuple.Tuple8<T1,T2,T3,T4,T5,T6,T7,T8>>	select(Selection<T1> selection1, Selection<T2> selection2, Selection<T3> selection3, Selection<T4> selection4, Selection<T5> selection5, Selection<T6> selection6, Selection<T7> selection7, Selection<T8> selection8)
<T1, T2, T3, T4, T5, T6, T7, T8, T9> ConfigurableRootQuery<T,org.babyfish.jimmer.sql.ast.tuple.Tuple9<T1,T2,T3,T4,T5,T6,T7,T8,T9>>	select(Selection<T1> selection1, Selection<T2> selection2, Selection<T3> selection3, Selection<T4> selection4, Selection<T5> selection5, Selection<T6> selection6, Selection<T7> selection7, Selection<T8> selection8, Selection<T9> selection9)
MutableRootQuery<T>	where(org.babyfish.jimmer.Specification<?> specification)
MutableRootQueryImpl<T>	where(Predicate... predicates)	Add some predicates(logical and)
MutableRootQuery<T>	where(JSpecification<?,T> specification)
MutableRootQueryImpl<T>	whereIf(boolean condition, Supplier<Predicate> block)	Avoid using this method whenever possible, using Dynamic Predicates are a more convenient approach.
MutableRootQueryImpl<T>	whereIf(boolean condition, Predicate predicate)	已过时。

从类继承的方法 org.babyfish.jimmer.sql.ast.impl.query.AbstractMutableQueryImpl

getAcceptedOrderByPriority, getGroupExpressions, getHavingPredicate, getHavingPredicates, getOrders, isGroupByClauseUsed, onFrozen, setHavingPredicates, setOrderByPriority

从类继承的方法 org.babyfish.jimmer.sql.ast.impl.AbstractMutableStatementImpl

applyDataLoaderGlobalFilters, applyGlobalFilters, applyVirtualPredicates, createAssociationSubQuery, createSubQuery, freeze, getFilterPredicate, getPredicate, getPredicates, getPurpose, getSqlClient, getTable, getTableImplementor, getType, hasVirtualPredicate, isFrozen, mergePredicates, modCount, modify, resolveVirtualPredicate, unfrozenPredicates, validateMutable, whereByFilter

从类继承的方法 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

从接口继承的方法 org.babyfish.jimmer.sql.ast.impl.query.FilterableImplementor

createAssociationSubQuery, createAssociationWildSubQuery, createSubQuery, createWildSubQuery

从接口继承的方法 org.babyfish.jimmer.sql.ast.query.MutableRootQuery

exists

从接口继承的方法 org.babyfish.jimmer.sql.ast.query.selectable.RootSelectable

selectCount

构造器详细资料

MutableRootQueryImpl

public MutableRootQueryImpl(JSqlClientImplementor sqlClient,
 org.babyfish.jimmer.meta.ImmutableType immutableType,
 ExecutionPurpose purpose,
 FilterLevel filterLevel)

MutableRootQueryImpl

public MutableRootQueryImpl(JSqlClientImplementor sqlClient,
 TableProxy<?> table,
 ExecutionPurpose purpose,
 FilterLevel filterLevel)

MutableRootQueryImpl

public MutableRootQueryImpl(StatementContext ctx,
 JSqlClientImplementor sqlClient,
 org.babyfish.jimmer.meta.ImmutableType immutableType)

MutableRootQueryImpl

public MutableRootQueryImpl(StatementContext ctx,
 JSqlClientImplementor sqlClient,
 TableProxy<?> table)

方法详细资料

getParent

public AbstractMutableStatementImpl getParent()

指定者:

getParent 在类中 AbstractMutableStatementImpl

getContext

public StatementContext getContext()

指定者:

getContext 在类中 AbstractMutableStatementImpl

select

public <R> ConfigurableRootQuery<T,R> select(Selection<R> selection)

指定者:

select 在接口中 RootSelectable<T extends Table<?>>

select

public <T1,
T2>
ConfigurableRootQuery<T,org.babyfish.jimmer.sql.ast.tuple.Tuple2<T1,T2>> select(Selection<T1> selection1,
 Selection<T2> selection2)

指定者:

select 在接口中 RootSelectable<T extends Table<?>>

select

public <T1,
T2,
T3>
ConfigurableRootQuery<T,org.babyfish.jimmer.sql.ast.tuple.Tuple3<T1,T2,T3>> select(Selection<T1> selection1,
 Selection<T2> selection2,
 Selection<T3> selection3)

指定者:

select 在接口中 RootSelectable<T extends Table<?>>

select

public <T1,
T2,
T3,
T4>
ConfigurableRootQuery<T,org.babyfish.jimmer.sql.ast.tuple.Tuple4<T1,T2,T3,T4>> select(Selection<T1> selection1,
 Selection<T2> selection2,
 Selection<T3> selection3,
 Selection<T4> selection4)

指定者:

select 在接口中 RootSelectable<T extends Table<?>>

select

public <T1,
T2,
T3,
T4,
T5>
ConfigurableRootQuery<T,org.babyfish.jimmer.sql.ast.tuple.Tuple5<T1,T2,T3,T4,T5>> select(Selection<T1> selection1,
 Selection<T2> selection2,
 Selection<T3> selection3,
 Selection<T4> selection4,
 Selection<T5> selection5)

指定者:

select 在接口中 RootSelectable<T extends Table<?>>

select

public <T1,
T2,
T3,
T4,
T5,
T6>
ConfigurableRootQuery<T,org.babyfish.jimmer.sql.ast.tuple.Tuple6<T1,T2,T3,T4,T5,T6>> select(Selection<T1> selection1,
 Selection<T2> selection2,
 Selection<T3> selection3,
 Selection<T4> selection4,
 Selection<T5> selection5,
 Selection<T6> selection6)

指定者:

select 在接口中 RootSelectable<T extends Table<?>>

select

public <T1,
T2,
T3,
T4,
T5,
T6,
T7>
ConfigurableRootQuery<T,org.babyfish.jimmer.sql.ast.tuple.Tuple7<T1,T2,T3,T4,T5,T6,T7>> select(Selection<T1> selection1,
 Selection<T2> selection2,
 Selection<T3> selection3,
 Selection<T4> selection4,
 Selection<T5> selection5,
 Selection<T6> selection6,
 Selection<T7> selection7)

指定者:

select 在接口中 RootSelectable<T extends Table<?>>

select

public <T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8>
ConfigurableRootQuery<T,org.babyfish.jimmer.sql.ast.tuple.Tuple8<T1,T2,T3,T4,T5,T6,T7,T8>> select(Selection<T1> selection1,
 Selection<T2> selection2,
 Selection<T3> selection3,
 Selection<T4> selection4,
 Selection<T5> selection5,
 Selection<T6> selection6,
 Selection<T7> selection7,
 Selection<T8> selection8)

指定者:

select 在接口中 RootSelectable<T extends Table<?>>

select

public <T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9>
ConfigurableRootQuery<T,org.babyfish.jimmer.sql.ast.tuple.Tuple9<T1,T2,T3,T4,T5,T6,T7,T8,T9>> select(Selection<T1> selection1,
 Selection<T2> selection2,
 Selection<T3> selection3,
 Selection<T4> selection4,
 Selection<T5> selection5,
 Selection<T6> selection6,
 Selection<T7> selection7,
 Selection<T8> selection8,
 Selection<T9> selection9)

指定者:

select 在接口中 RootSelectable<T extends Table<?>>

where

public MutableRootQueryImpl<T> where(Predicate... predicates)

从接口复制的说明: Filterable

Add some predicates(logical and)

指定者:

where 在接口中 Filterable

指定者:

where 在接口中 MutableRootQuery<T extends Table<?>>

指定者:

where 在接口中 Sortable

覆盖:

where 在类中 AbstractMutableQueryImpl

参数:

predicates - Predicates, everything one can be null

返回:

Return the current object to support chain programming style

where

public MutableRootQuery<T> where(org.babyfish.jimmer.Specification<?> specification)

指定者:

where 在接口中 MutableRootQuery<T extends Table<?>>

where

public MutableRootQuery<T> where(JSpecification<?,T> specification)

指定者:

where 在接口中 MutableRootQuery<T extends Table<?>>

whereIf

@OldChain
@Deprecated
public MutableRootQueryImpl<T> whereIf(boolean condition,
 Predicate predicate)

已过时。

This method is deprecated, using Dynamic Predicates is a more convenient approach.

Please look at this example:

 whereIf(name != null, table.name().eq(name))
 

When name is null, this code works because eq(null) is automatically translated by Jimmer to isNull(), which doesn't cause an exception.

Let's look at another example:

 whereIf(minPrice != null, table.price().ge(minPrice))
 

Except RUST marco, almost all programming languages calculate all parameters first and then call the function. Therefore, before whereIf is executed, ge(null) already causes an exception.

For this reason, whereIf provides an overloaded form with a lambda parameter:

 whereIf(minPrice != null, () -> table.price().ge(minPrice))
 

Although this overloaded form can solve this problem, it ultimately adds a mental burden during development.

Therefore, Jimmer provides Dynamic Predicates

• Java: eqIf, neIf, ltIf, leIf, gtIf, geIf, likeIf, ilikeIf, betweenIf
• Kotlin: eq?, ne?, lt?, le?, gt?, ge?, like?, ilike?, betweenIf?

Taking Java's geIf as an example, this functionality is ultimately implemented like this.

 where(table.price().geIf(minPrice))
 

指定者:

whereIf 在接口中 Filterable

指定者:

whereIf 在接口中 MutableRootQuery<T extends Table<?>>

指定者:

whereIf 在接口中 Sortable

覆盖:

whereIf 在类中 AbstractMutableQueryImpl

whereIf

@OldChain
public MutableRootQueryImpl<T> whereIf(boolean condition,
 Supplier<Predicate> block)

从接口复制的说明: Filterable

Avoid using this method whenever possible, using Dynamic Predicates are a more convenient approach.

Please look at this example:

 whereIf(name != null, table.name().eq(name))
 

When name is null, this code works because eq(null) is automatically translated by Jimmer to isNull(), which doesn't cause an exception.

Let's look at another example:

 whereIf(minPrice != null, table.price().ge(minPrice))
 

Except RUST marco, almost all programming languages calculate all parameters first and then call the function. Therefore, before whereIf is executed, ge(null) already causes an exception.

For this reason, whereIf provides an overloaded form with a lambda parameter:

 whereIf(minPrice != null, () -> table.price().ge(minPrice))
 

Although this overloaded form can solve this problem, it ultimately adds a mental burden during development.

Therefore, Jimmer provides Dynamic Predicate

• Java: eqIf, neIf, ltIf, leIf, gtIf, geIf, likeIf, ilikeIf, betweenIf
• Kotlin: eq?, ne?, lt?, le?, gt?, ge?, like?, ilike?, betweenIf?

Taking Java's geIf as an example, this functionality is ultimately implemented like this.

 where(table.price().geIf(minPrice))
 

指定者:

whereIf 在接口中 Filterable

指定者:

whereIf 在接口中 MutableRootQuery<T extends Table<?>>

指定者:

whereIf 在接口中 Sortable

覆盖:

whereIf 在类中 AbstractMutableQueryImpl

参数:

condition - The condition

block - A lambda to create predicate when condition is true

返回:

Return the current object to support chain programming style

groupBy

public MutableRootQueryImpl<T> groupBy(Expression<?>... expressions)

指定者:

groupBy 在接口中 MutableQuery

指定者:

groupBy 在接口中 MutableRootQuery<T extends Table<?>>

覆盖:

groupBy 在类中 AbstractMutableQueryImpl

having

public MutableRootQueryImpl<T> having(Predicate... predicates)

指定者:

having 在接口中 MutableQuery

指定者:

having 在接口中 MutableRootQuery<T extends Table<?>>

覆盖:

having 在类中 AbstractMutableQueryImpl

orderBy

public MutableRootQueryImpl<T> orderBy(Expression<?>... expressions)

指定者:

orderBy 在接口中 MutableQuery

指定者:

orderBy 在接口中 MutableRootQuery<T extends Table<?>>

指定者:

orderBy 在接口中 Sortable

覆盖:

orderBy 在类中 AbstractMutableQueryImpl

orderByIf

public MutableRootQueryImpl<T> orderByIf(boolean condition,
 Expression<?>... expressions)

指定者:

orderByIf 在接口中 MutableQuery

指定者:

orderByIf 在接口中 MutableRootQuery<T extends Table<?>>

指定者:

orderByIf 在接口中 Sortable

覆盖:

orderByIf 在类中 AbstractMutableQueryImpl

orderBy

public MutableRootQueryImpl<T> orderBy(Order... orders)

指定者:

orderBy 在接口中 MutableQuery

指定者:

orderBy 在接口中 MutableRootQuery<T extends Table<?>>

指定者:

orderBy 在接口中 Sortable

覆盖:

orderBy 在类中 AbstractMutableQueryImpl

orderByIf

public MutableRootQueryImpl<T> orderByIf(boolean condition,
 Order... orders)

指定者:

orderByIf 在接口中 MutableQuery

指定者:

orderByIf 在接口中 MutableRootQuery<T extends Table<?>>

指定者:

orderByIf 在接口中 Sortable

覆盖:

orderByIf 在类中 AbstractMutableQueryImpl

orderBy

public MutableRootQueryImpl<T> orderBy(List<Order> orders)

指定者:

orderBy 在接口中 MutableQuery

指定者:

orderBy 在接口中 MutableRootQuery<T extends Table<?>>

指定者:

orderBy 在接口中 Sortable

覆盖:

orderBy 在类中 AbstractMutableQueryImpl

orderByIf

public MutableRootQueryImpl<T> orderByIf(boolean condition,
 List<Order> orders)

指定者:

orderByIf 在接口中 MutableQuery

指定者:

orderByIf 在接口中 MutableRootQuery<T extends Table<?>>

指定者:

orderByIf 在接口中 Sortable

覆盖:

orderByIf 在类中 AbstractMutableQueryImpl

exists

public boolean exists(Connection con)

指定者:

exists 在接口中 MutableRootQuery<T extends Table<?>>