javax.persistence.criteria.CriteriaQuery Maven / Gradle / Ivy
Show all versions of jakarta.persistence-api Show documentation
/*
* Copyright (c) 2008, 2019 Oracle and/or its affiliates. All rights reserved.
*
* This program and the accompanying materials are made available under the
* terms of the Eclipse Public License v. 2.0 which is available at
* http://www.eclipse.org/legal/epl-2.0,
* or the Eclipse Distribution License v. 1.0 which is available at
* http://www.eclipse.org/org/documents/edl-v10.php.
*
* SPDX-License-Identifier: EPL-2.0 OR BSD-3-Clause
*/
// Contributors:
// Linda DeMichiel - 2.1
// Linda DeMichiel - 2.0
package javax.persistence.criteria;
import java.util.List;
import java.util.Set;
/**
* The CriteriaQuery
interface defines functionality that is specific
* to top-level queries.
*
* @param the type of the defined result
*
* @since 2.0
*/
public interface CriteriaQuery extends AbstractQuery {
/**
* Specify the item that is to be returned in the query result.
* Replaces the previously specified selection(s), if any.
*
* Note: Applications using the string-based API may need to
* specify the type of the select item when it results from
* a get or join operation and the query result type is
* specified.
*
*
* For example:
*
* CriteriaQuery<String> q = cb.createQuery(String.class);
* Root<Order> order = q.from(Order.class);
* q.select(order.get("shippingAddress").<String>get("state"));
*
* CriteriaQuery<Product> q2 = cb.createQuery(Product.class);
* q2.select(q2.from(Order.class)
* .join("items")
* .<Item,Product>join("product"));
*
*
* @param selection selection specifying the item that
* is to be returned in the query result
* @return the modified query
* @throws IllegalArgumentException if the selection is
* a compound selection and more than one selection
* item has the same assigned alias
*/
CriteriaQuery select(Selection extends T> selection);
/**
* Specify the selection items that are to be returned in the
* query result.
* Replaces the previously specified selection(s), if any.
*
* The type of the result of the query execution depends on
* the specification of the type of the criteria query object
* created as well as the arguments to the multiselect method.
* An argument to the multiselect method must not be a tuple-
* or array-valued compound selection item.
*
*
The semantics of this method are as follows:
*
* -
* If the type of the criteria query is
*
CriteriaQuery<Tuple>
(i.e., a criteria
* query object created by either the
* createTupleQuery
method or by passing a
* Tuple
class argument to the
* createQuery
method), a Tuple
object
* corresponding to the arguments of the multiselect
* method, in the specified order, will be instantiated and
* returned for each row that results from the query execution.
*
* - If the type of the criteria query is
CriteriaQuery<X>
for
* some user-defined class X (i.e., a criteria query object
* created by passing a X class argument to the createQuery
* method), the arguments to the multiselect
method will be
* passed to the X constructor and an instance of type X will be
* returned for each row.
*
* - If the type of the criteria query is
CriteriaQuery<X[]>
for
* some class X, an instance of type X[] will be returned for
* each row. The elements of the array will correspond to the
* arguments of the multiselect
method, in the
* specified order.
*
* - If the type of the criteria query is
CriteriaQuery<Object>
* or if the criteria query was created without specifying a
* type, and only a single argument is passed to the multiselect
* method, an instance of type Object
will be returned for
* each row.
*
* - If the type of the criteria query is
CriteriaQuery<Object>
* or if the criteria query was created without specifying a
* type, and more than one argument is passed to the multiselect
* method, an instance of type Object[]
will be instantiated
* and returned for each row. The elements of the array will
* correspond to the arguments to the multiselect
method,
* in the specified order.
*
*
* @param selections selection items corresponding to the
* results to be returned by the query
* @return the modified query
* @throws IllegalArgumentException if a selection item is
* not valid or if more than one selection item has
* the same assigned alias
*/
CriteriaQuery multiselect(Selection>... selections);
/**
* Specify the selection items that are to be returned in the
* query result.
* Replaces the previously specified selection(s), if any.
*
* The type of the result of the query execution depends on
* the specification of the type of the criteria query object
* created as well as the argument to the multiselect
method.
* An element of the list passed to the multiselect
method
* must not be a tuple- or array-valued compound selection item.
*
*
The semantics of this method are as follows:
*
* - If the type of the criteria query is
CriteriaQuery<Tuple>
* (i.e., a criteria query object created by either the
* createTupleQuery
method or by passing a Tuple
class argument
* to the createQuery
method), a Tuple
object corresponding to
* the elements of the list passed to the multiselect
method,
* in the specified order, will be instantiated and returned for each
* row that results from the query execution.
*
* - If the type of the criteria query is
CriteriaQuery<X>
for
* some user-defined class X (i.e., a criteria query object
* created by passing a X class argument to the createQuery
* method), the elements of the list passed to the multiselect
* method will be passed to the X constructor and an instance
* of type X will be returned for each row.
*
* - If the type of the criteria query is
CriteriaQuery<X[]>
for
* some class X, an instance of type X[] will be returned for
* each row. The elements of the array will correspond to the
* elements of the list passed to the multiselect
method,
* in the specified order.
*
* - If the type of the criteria query is
CriteriaQuery<Object>
* or if the criteria query was created without specifying a
* type, and the list passed to the multiselect
method contains
* only a single element, an instance of type Object
will be
* returned for each row.
*
* - If the type of the criteria query is
CriteriaQuery<Object>
* or if the criteria query was created without specifying a
* type, and the list passed to the multiselect
method contains
* more than one element, an instance of type Object[]
will be
* instantiated and returned for each row. The elements of the
* array will correspond to the elements of the list passed to
* the multiselect
method, in the specified order.
*
*
* @param selectionList list of selection items corresponding
* to the results to be returned by the query
* @return the modified query
* @throws IllegalArgumentException if a selection item is
* not valid or if more than one selection item has
* the same assigned alias
*/
CriteriaQuery multiselect(List> selectionList);
/**
* Modify the query to restrict the query result according
* to the specified boolean expression.
* Replaces the previously added restriction(s), if any.
* This method only overrides the return type of the
* corresponding AbstractQuery
method.
* @param restriction a simple or compound boolean expression
* @return the modified query
*/
CriteriaQuery where(Expression restriction);
/**
* Modify the query to restrict the query result according
* to the conjunction of the specified restriction predicates.
* Replaces the previously added restriction(s), if any.
* If no restrictions are specified, any previously added
* restrictions are simply removed.
* This method only overrides the return type of the
* corresponding AbstractQuery
method.
* @param restrictions zero or more restriction predicates
* @return the modified query
*/
CriteriaQuery where(Predicate... restrictions);
/**
* Specify the expressions that are used to form groups over
* the query results.
* Replaces the previous specified grouping expressions, if any.
* If no grouping expressions are specified, any previously
* added grouping expressions are simply removed.
* This method only overrides the return type of the
* corresponding AbstractQuery
method.
* @param grouping zero or more grouping expressions
* @return the modified query
*/
CriteriaQuery groupBy(Expression>... grouping);
/**
* Specify the expressions that are used to form groups over
* the query results.
* Replaces the previous specified grouping expressions, if any.
* If no grouping expressions are specified, any previously
* added grouping expressions are simply removed.
* This method only overrides the return type of the
* corresponding AbstractQuery
method.
* @param grouping list of zero or more grouping expressions
* @return the modified query
*/
CriteriaQuery groupBy(List> grouping);
/**
* Specify a restriction over the groups of the query.
* Replaces the previous having restriction(s), if any.
* This method only overrides the return type of the
* corresponding AbstractQuery
method.
* @param restriction a simple or compound boolean expression
* @return the modified query
*/
CriteriaQuery having(Expression restriction);
/**
* Specify restrictions over the groups of the query
* according the conjunction of the specified restriction
* predicates.
* Replaces the previously added having restriction(s), if any.
* If no restrictions are specified, any previously added
* restrictions are simply removed.
* This method only overrides the return type of the
* corresponding AbstractQuery
method.
* @param restrictions zero or more restriction predicates
* @return the modified query
*/
CriteriaQuery having(Predicate... restrictions);
/**
* Specify the ordering expressions that are used to
* order the query results.
* Replaces the previous ordering expressions, if any.
* If no ordering expressions are specified, the previous
* ordering, if any, is simply removed, and results will
* be returned in no particular order.
* The left-to-right sequence of the ordering expressions
* determines the precedence, whereby the leftmost has highest
* precedence.
* @param o zero or more ordering expressions
* @return the modified query
*/
CriteriaQuery orderBy(Order... o);
/**
* Specify the ordering expressions that are used to
* order the query results.
* Replaces the previous ordering expressions, if any.
* If no ordering expressions are specified, the previous
* ordering, if any, is simply removed, and results will
* be returned in no particular order.
* The order of the ordering expressions in the list
* determines the precedence, whereby the first element in the
* list has highest precedence.
* @param o list of zero or more ordering expressions
* @return the modified query
*/
CriteriaQuery orderBy(List o);
/**
* Specify whether duplicate query results will be eliminated.
* A true value will cause duplicates to be eliminated.
* A false value will cause duplicates to be retained.
* If distinct has not been specified, duplicate results must
* be retained.
* This method only overrides the return type of the
* corresponding AbstractQuery
method.
* @param distinct boolean value specifying whether duplicate
* results must be eliminated from the query result or
* whether they must be retained
* @return the modified query.
*/
CriteriaQuery distinct(boolean distinct);
/**
* Return the ordering expressions in order of precedence.
* Returns empty list if no ordering expressions have been
* specified.
* Modifications to the list do not affect the query.
* @return the list of ordering expressions
*/
List getOrderList();
/**
* Return the parameters of the query. Returns empty set if
* there are no parameters.
* Modifications to the set do not affect the query.
* @return the query parameters
*/
Set> getParameters();
}