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

类 MutableSubQueryImpl

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.MutableSubQueryImpl

所有已实现的接口:

FilterableImplementor, MutableStatementImplementor, Filterable, MutableQuery, MutableSubQuery, SubSelectable, Sortable, SubQueryProvider

public class MutableSubQueryImpl
extends AbstractMutableQueryImpl
implements MutableSubQuery

字段概要

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

ORDER_BY_PRIORITY_GLOBAL_FILTER, ORDER_BY_PRIORITY_PROP_FILTER, ORDER_BY_PRIORITY_STATEMENT

构造器概要

构造器

构造器	说明
MutableSubQueryImpl(AbstractMutableStatementImpl parent, org.babyfish.jimmer.meta.ImmutableType immutableType)
MutableSubQueryImpl(AbstractMutableStatementImpl parent, TableProxy<?> table)
MutableSubQueryImpl(JSqlClientImplementor sqlClient, org.babyfish.jimmer.meta.ImmutableType immutableType)
MutableSubQueryImpl(JSqlClientImplementor sqlClient, TableProxy<?> table)

方法概要

修饰符和类型	方法	说明
Predicate	exists()
Filter<?>	filterOwner()
StatementContext	getContext()
AbstractMutableStatementImpl	getParent()
MutableSubQueryImpl	groupBy(Expression<?>... expressions)
MutableSubQueryImpl	having(Predicate... predicates)
Predicate	notExists()
MutableSubQueryImpl	orderBy(List<Order> orders)
MutableSubQueryImpl	orderBy(Expression<?>... expressions)
MutableSubQueryImpl	orderBy(Order... orders)
MutableSubQueryImpl	orderByIf(boolean condition, List<Order> orders)
MutableSubQueryImpl	orderByIf(boolean condition, Expression<?>... expressions)
MutableSubQueryImpl	orderByIf(boolean condition, Order... orders)
void	resolveVirtualPredicate(AstContext ctx)
<R> ConfigurableSubQuery<R>	select(Selection<R> selection)
<T1, T2> ConfigurableSubQuery<org.babyfish.jimmer.sql.ast.tuple.Tuple2<T1,T2>>	select(Selection<T1> selection1, Selection<T2> selection2)
<T1, T2, T3> ConfigurableSubQuery<org.babyfish.jimmer.sql.ast.tuple.Tuple3<T1,T2,T3>>	select(Selection<T1> selection1, Selection<T2> selection2, Selection<T3> selection3)
<T1, T2, T3, T4> ConfigurableSubQuery<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> ConfigurableSubQuery<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> ConfigurableSubQuery<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> ConfigurableSubQuery<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> ConfigurableSubQuery<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> ConfigurableSubQuery<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)
void	setParent(AbstractMutableStatementImpl parent)
MutableSubQueryImpl	where(Predicate... predicates)	Add some predicates(logical and)
MutableSubQueryImpl	whereIf(boolean condition, Supplier<Predicate> block)	Avoid using this method whenever possible, using Dynamic Predicates are a more convenient approach.
MutableSubQueryImpl	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, 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.selectable.SubSelectable

selectComparable, selectCount, selectNumber, selectString

构造器详细资料

MutableSubQueryImpl

public MutableSubQueryImpl(AbstractMutableStatementImpl parent,
 org.babyfish.jimmer.meta.ImmutableType immutableType)

MutableSubQueryImpl

public MutableSubQueryImpl(JSqlClientImplementor sqlClient,
 org.babyfish.jimmer.meta.ImmutableType immutableType)

MutableSubQueryImpl

public MutableSubQueryImpl(JSqlClientImplementor sqlClient,
 TableProxy<?> table)

MutableSubQueryImpl

public MutableSubQueryImpl(AbstractMutableStatementImpl parent,
 TableProxy<?> table)

方法详细资料

getParent

public AbstractMutableStatementImpl getParent()

指定者:

getParent 在类中 AbstractMutableStatementImpl

getContext

public StatementContext getContext()

指定者:

getContext 在类中 AbstractMutableStatementImpl

where

public MutableSubQueryImpl where(Predicate... predicates)

从接口复制的说明: Filterable

Add some predicates(logical and)

指定者:

where 在接口中 Filterable

指定者:

where 在接口中 MutableSubQuery

指定者:

where 在接口中 Sortable

覆盖:

where 在类中 AbstractMutableQueryImpl

参数:

predicates - Predicates, everything one can be null

返回:

Return the current object to support chain programming style

whereIf

@OldChain
@Deprecated
public MutableSubQueryImpl whereIf(boolean condition,
 Predicate predicate)

已过时。

从接口复制的说明: Filterable

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 在接口中 MutableSubQuery

指定者:

whereIf 在接口中 Sortable

覆盖:

whereIf 在类中 AbstractMutableQueryImpl

whereIf

@OldChain
public MutableSubQueryImpl 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 在接口中 MutableSubQuery

指定者:

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 MutableSubQueryImpl groupBy(Expression<?>... expressions)

指定者:

groupBy 在接口中 MutableQuery

指定者:

groupBy 在接口中 MutableSubQuery

覆盖:

groupBy 在类中 AbstractMutableQueryImpl

having

public MutableSubQueryImpl having(Predicate... predicates)

指定者:

having 在接口中 MutableQuery

指定者:

having 在接口中 MutableSubQuery

覆盖:

having 在类中 AbstractMutableQueryImpl

orderBy

public MutableSubQueryImpl orderBy(Expression<?>... expressions)

指定者:

orderBy 在接口中 MutableQuery

指定者:

orderBy 在接口中 MutableSubQuery

指定者:

orderBy 在接口中 Sortable

覆盖:

orderBy 在类中 AbstractMutableQueryImpl

orderByIf

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

指定者:

orderByIf 在接口中 MutableQuery

指定者:

orderByIf 在接口中 MutableSubQuery

指定者:

orderByIf 在接口中 Sortable

覆盖:

orderByIf 在类中 AbstractMutableQueryImpl

orderBy

public MutableSubQueryImpl orderBy(Order... orders)

指定者:

orderBy 在接口中 MutableQuery

指定者:

orderBy 在接口中 MutableSubQuery

指定者:

orderBy 在接口中 Sortable

覆盖:

orderBy 在类中 AbstractMutableQueryImpl

orderByIf

public MutableSubQueryImpl orderByIf(boolean condition,
 Order... orders)

指定者:

orderByIf 在接口中 MutableQuery

指定者:

orderByIf 在接口中 MutableSubQuery

指定者:

orderByIf 在接口中 Sortable

覆盖:

orderByIf 在类中 AbstractMutableQueryImpl

orderBy

public MutableSubQueryImpl orderBy(List<Order> orders)

指定者:

orderBy 在接口中 MutableQuery

指定者:

orderBy 在接口中 MutableSubQuery

指定者:

orderBy 在接口中 Sortable

覆盖:

orderBy 在类中 AbstractMutableQueryImpl

orderByIf

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

指定者:

orderByIf 在接口中 MutableQuery

指定者:

orderByIf 在接口中 MutableSubQuery

指定者:

orderByIf 在接口中 Sortable

覆盖:

orderByIf 在类中 AbstractMutableQueryImpl

select

public <R> ConfigurableSubQuery<R> select(Selection<R> selection)

指定者:

select 在接口中 SubSelectable

select

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

指定者:

select 在接口中 SubSelectable

select

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

指定者:

select 在接口中 SubSelectable

select

public <T1,
T2,
T3,
T4>
ConfigurableSubQuery<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 在接口中 SubSelectable

select

public <T1,
T2,
T3,
T4,
T5>
ConfigurableSubQuery<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 在接口中 SubSelectable

select

public <T1,
T2,
T3,
T4,
T5,
T6>
ConfigurableSubQuery<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 在接口中 SubSelectable

select

public <T1,
T2,
T3,
T4,
T5,
T6,
T7>
ConfigurableSubQuery<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 在接口中 SubSelectable

select

public <T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8>
ConfigurableSubQuery<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 在接口中 SubSelectable

select

public <T1,
T2,
T3,
T4,
T5,
T6,
T7,
T8,
T9>
ConfigurableSubQuery<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 在接口中 SubSelectable

exists

public Predicate exists()

指定者:

exists 在接口中 MutableSubQuery

notExists

public Predicate notExists()

指定者:

notExists 在接口中 MutableSubQuery

setParent

public void setParent(AbstractMutableStatementImpl parent)

resolveVirtualPredicate

public void resolveVirtualPredicate(AstContext ctx)

指定者:

resolveVirtualPredicate 在接口中 MutableStatementImplementor

覆盖:

resolveVirtualPredicate 在类中 AbstractMutableStatementImpl

filterOwner

public Filter<?> filterOwner()