About expression
javax.persistence.criteria.CriteriaBuilder
Used to construct criteria queries, compound selections, expressions, predicates, orderings.(Interface of JPA)
JPA Query Expressions (JPQL / Criteria)
Describes JPA query (JPQL / Criteria API) expressions (literals, operators and functions).... JPQL / Criteria Literals Every query expression consists of at least one atomic component. More complex query ... CriteriaBuilder's method Create an expression for a literal. See JavaDoc Reference Page... , ... CriteriaBuilder's method Create an expression for a null literal with the given type. See JavaDoc Reference ...
Strings in JPQL and Criteria Queries
Explains string expressions in JPQL queries, including LIKE, LOCATE, LOWER, UPPER, TRIM, CONCAT and SUBSTRING.... is always the string to check for a match (usually a path expression) and the right operand is always the pattern (usually a parameter or ... // Create path and parameter expressions: Expression javax.persistence.criteria.Expression JPA interface ...
Numbers in JPQL and Criteria Queries
Shows how numbers, arithmetic expressions and numeric functions and operators (MOD, ABS) can be used in JPQL queries.... to combine simple numeric values into a more complex expression. This page covers the following topics: ... operands. At least one operand must be a criteria numeric expression. The other operand may be either another numeric expression or a ...
Paths and Types in JPQL and Criteria API
Explains how to use object expressions (path navigation, type) in JPA/JPQL.... Navigation through Path Expressions A path expression always starts with an instance of a user defined class (represented by a variable, parameter or prefix path expression) and uses the dot ( . ) operator to navigate through persistent ...
Literals in JPQL and Criteria Queries
Describes literals in JPQL, including null, false, true, numbers, strings, dates enums and types.... CriteriaBuilder's method Create an expression for a literal. See JavaDoc Reference Page... , takes a Java object and returns a literal expression. For example: // Boolean literals: Expression ...
Collections in JPQL and Criteria Queries
Shows how collections and maps can be used in JPQL queries.... // Create path and parameter expressions: Expression javax.persistence.criteria.Expression JPA interface Type for query expressions. See JavaDoc ...
Logical Operators in JPQL and Criteria API
Explains how to use AND, OR and NOT in JPQL queries.... expressions are represented in criteria queries by Expression javax.persistence.criteria.Expression JPA interface Type for query expressions. See JavaDoc ...
Comparison in JPQL and Criteria API
Explains how comparison operators can be used in JPQL queries, including in comparing null values.... // Create String path and parameter expressions: Expression javax.persistence.criteria.Expression JPA interface Type for query expressions. See JavaDoc ...
