Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Difference between revisions of "EclipseLink/Examples/JPA/DatabaseQuery"
< EclipseLink | Examples | JPA
(New page: In addition to JPQL, EclipseLink defines a rich DatabaseQuery and Expression criteria API. See: * [http://www.eclipse.org/eclipselink/api/1.1/org/eclipse/persistence/queries/package-frame...) |
|||
(3 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
+ | [[Category:EclipseLink/Example/JPA|DatabaseQuery]] | ||
+ | |||
In addition to JPQL, EclipseLink defines a rich DatabaseQuery and Expression criteria API. | In addition to JPQL, EclipseLink defines a rich DatabaseQuery and Expression criteria API. | ||
Line 4: | Line 6: | ||
* [http://www.eclipse.org/eclipselink/api/1.1/org/eclipse/persistence/queries/package-frame.html org.eclipse.persistence.queries] | * [http://www.eclipse.org/eclipselink/api/1.1/org/eclipse/persistence/queries/package-frame.html org.eclipse.persistence.queries] | ||
* [http://www.eclipse.org/eclipselink/api/1.1/org/eclipse/persistence/expressions/package-frame.html org.eclipse.persistence.expressions] | * [http://www.eclipse.org/eclipselink/api/1.1/org/eclipse/persistence/expressions/package-frame.html org.eclipse.persistence.expressions] | ||
− | * [[ | + | * [[EclipseLink/UserGuide/Queries_(ELUG)|Queries]] in the ''EclipseLink User's Guide'' |
− | == Using JpaEntityManager createQuery() API == | + | === Using JpaEntityManager createQuery() API === |
<source lang="java"> | <source lang="java"> | ||
+ | import javax.persistence.Query; | ||
+ | import org.eclipse.persistence.expressions.*; | ||
+ | import org.eclipse.persistence.queries.ReadAllQuery; | ||
+ | |||
ExpressionBuilder builder = new ExpressionBuilder(); | ExpressionBuilder builder = new ExpressionBuilder(); | ||
ReadAllQuery databaseQuery = new ReadAllQuery(Employee.class, builder); | ReadAllQuery databaseQuery = new ReadAllQuery(Employee.class, builder); |
Latest revision as of 17:13, 25 November 2009
In addition to JPQL, EclipseLink defines a rich DatabaseQuery and Expression criteria API.
See:
- org.eclipse.persistence.queries
- org.eclipse.persistence.expressions
- Queries in the EclipseLink User's Guide
Using JpaEntityManager createQuery() API
import javax.persistence.Query; import org.eclipse.persistence.expressions.*; import org.eclipse.persistence.queries.ReadAllQuery; ExpressionBuilder builder = new ExpressionBuilder(); ReadAllQuery databaseQuery = new ReadAllQuery(Employee.class, builder); databaseQuery.setSelectionCriteria(builder.get("firstName").like("B%")); databaseQuery.addOrdering(builder.get("firstName").toUpperCase()); Query query = ((JpaEntityManager)entityManager.getDelegate()).createQuery(databaseQuery); List result = query.getResultList();
This JpaEntityManager API was added in EclipseLink 1.1, in EclipseLink 1.0, the JpaQuery method setDatabaseQuery() could be used.