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

接口 MutableRootQuery<T extends Table<?>>

所有超级接口:
Filterable, MutableQuery, RootSelectable<T>, Sortable
所有已知实现类:
MutableRootQueryImpl
public interface MutableRootQuery<T extends Table<?>> extends MutableQuery, RootSelectable<T>

  • 方法详细资料

    • where

      @OldChain MutableRootQuery<T> where(Predicate... predicates)
      从接口复制的说明: Filterable
      Add some predicates(logical and)
      指定者:
      where 在接口中 Filterable
      指定者:
      where 在接口中 Sortable
      参数:
      predicates - Predicates, everything one can be null
      返回:
      Return the current object to support chain programming style

    • where

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

    • where

      @OldChain MutableRootQuery<T> where(JSpecification<?,T> specification)

    • whereIf

      @OldChain @Deprecated default MutableRootQuery<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 在接口中 Sortable

    • whereIf

      @OldChain default MutableRootQuery<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 在接口中 Sortable
      参数:
      condition - The condition
      block - A lambda to create predicate when condition is true
      返回:
      Return the current object to support chain programming style

    • orderBy

      @OldChain MutableRootQuery<T> orderBy(Expression<?>... expressions)
      指定者:
      orderBy 在接口中 MutableQuery
      指定者:
      orderBy 在接口中 Sortable

    • orderByIf

      @OldChain default MutableRootQuery<T> orderByIf(boolean condition, Expression<?>... expressions)
      指定者:
      orderByIf 在接口中 MutableQuery
      指定者:
      orderByIf 在接口中 Sortable

    • orderBy

      @OldChain MutableRootQuery<T> orderBy(Order... orders)
      指定者:
      orderBy 在接口中 MutableQuery
      指定者:
      orderBy 在接口中 Sortable

    • orderByIf

      @OldChain default MutableRootQuery<T> orderByIf(boolean condition, Order... orders)
      指定者:
      orderByIf 在接口中 MutableQuery
      指定者:
      orderByIf 在接口中 Sortable

    • orderBy

      @OldChain MutableRootQuery<T> orderBy(List<Order> orders)
      指定者:
      orderBy 在接口中 MutableQuery
      指定者:
      orderBy 在接口中 Sortable

    • orderByIf

      @OldChain default MutableRootQuery<T> orderByIf(boolean condition, List<Order> orders)
      指定者:
      orderByIf 在接口中 MutableQuery
      指定者:
      orderByIf 在接口中 Sortable

    • groupBy

      MutableRootQuery<T> groupBy(Expression<?>... expressions)
      指定者:
      groupBy 在接口中 MutableQuery

    • having

      MutableRootQuery<T> having(Predicate... predicates)
      指定者:
      having 在接口中 MutableQuery

    • exists

      default boolean exists()

    • exists

      boolean exists(Connection con)