Internal Website Search

1-10 of 200 resultsRefresh

SELECT clause (JPQL / Criteria API)

/createQuery_String_Class_">createQuery("SELECT c FROM Country c", Country.class); List< ... to use almost any valid JPQL expression in SELECT clauses ... explicitly - JPQL does not support the "SELECT *" expression (which is commonly used in SQL).

Criteria Query Selection and Results

The 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 clause in a criteria query is represented by Selection:

select(selection)

="Interface in javax.persistence.criteria">CriteriaQuery<T> select(  Selection" title="Interface in javax.persistence.criteria">Selection<?> selection) Specify the item that is to be returned

javax.persistence.criteria.Selection

>Interface Selection<X> Selection interface defines an item that is to be returned in a query result. Selection in select">Chapter 4 of the ObjectDB/JPA manual.

multiselect(selections)

;Selection" title="Interface in javax.persistence.criteria">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

getCompoundSelectionItems()

">Selection" title="Interface in javax.persistence.criteria">javax.persistence.criteria.SelectionList<Selection" title="Interface in javax.persistence.criteria">Selection<?>> getCompoundSelectionItems()

tuple(selections)

/criteria/Selection" title="Interface in javax.persistence.criteria">Selection... selections) Create a tuple-valued selection item. Parameters: selections - selection items

array(selections)

; Selection" title="Interface in javax.persistence.criteria">Selection... selections) Create an array-valued selection item. Parameters: selections

construct(resultClass, selections)

; Class<T> resultClass,   Selection" title="Interface in javax.persistence.criteria">Selection[]<X> selections) Create a selection item corresponding to a constructor. This method

construct(resultClass, selections)

; Class<Y> resultClass,   Selection" title="Interface in javax.persistence.criteria">Selection... selections) Create a selection item corresponding to a constructor. This method is used