207 | Criteria Query Selection and ResultsThe JPA Criteria API interfaces in this group are used for setting the SELECT and ORDER BY clauses and for representing query results as tuples. SELECT Clause Elements The content of the SELECT ... . Query Results as Tuples JPA 2 introduces a new way to represent multi selection results (i.e. results |
72 | SELECT clause (JPQL / Criteria API)> results = query.getResultList(); Because the results are managed entity objects they have all the support ... objects, transparent update detection, support for delete, etc. Query results are not limited to entity ... . Specifying the required query results more precisely can improve performance and in some cases |
53 | Setting and Tuning of JPA Queries execution if invoked before a query is run using getResultList or getSingleResult. Result Range (setFirstResult, setMaxResults) The setFirstResult and setMaxResults methods enable defining a result window that exposes a portion of a large query result list (hiding anything outside that window |
52 | when(condition, result)Method javax.persistence.criteria.CriteriaBuilder.Case Case<R> when( Expression<Boolean> condition, R result ) Add a when/then clause to the case expression. Parameters: condition - "when" condition result - "then" result value Returns: general case expression Since: JPA 2.0 |
52 | when(condition, result)Method javax.persistence.criteria.CriteriaBuilder.Case<R> Case<R> when( Expression<T> condition, Expression<T> result ) Add a when/then clause to the case expression. Parameters: condition - "when" condition result - "then" result expression Returns: general case expression Since: JPA 2.0 |
52 | otherwise(result)Method javax.persistence.criteria.CriteriaBuilder.Case Expression<R> otherwise( Expression<?> result ) Add an "else" clause to the case expression. Parameters: result - "else" result expression Returns: expression Since: JPA 2.0 |
52 | otherwise(result)Method javax.persistence.criteria.CriteriaBuilder.Case Expression<R> otherwise( R result ) Add an "else" clause to the case expression. Parameters: result - "else" result Returns: expression Since: JPA 2.0 |
52 | when(condition, result)Method javax.persistence.criteria.CriteriaBuilder.SimpleCase SimpleCase<C,R> when( C condition, Expression<?> result ) Add a when/then clause to the case expression. Parameters: condition - "when" condition result - "then" result expression Returns: simple case expression Since: JPA 2.0 |
52 | when(condition, result)Method javax.persistence.criteria.CriteriaBuilder.SimpleCase SimpleCase<C,R> when( C condition, R result ) Add a when/then clause to the case expression. Parameters: condition - "when" condition result - "then" result value Returns: simple case expression Since: JPA 2.0 |
52 | otherwise(result)Method javax.persistence.criteria.CriteriaBuilder.SimpleCase Expression<R> otherwise( Expression<?> result ) Add an "else" clause to the case expression. Parameters: result - "else" result expression Returns: expression Since: JPA 2.0 |
