Close

JPA Tutorials - Criteria API

  1. Getting started with Criteria API, using Select query
  2. Using Metamodel to create type safe queries
  3. ORDER BY in Criteria Queries
  4. Query Selection Other Than Entities
  5. Selecting User defined Objects using CriteriaBuilder#construct()
  6. Multiple Query selection and use of Tuple
  7. Distinct clause in Criteria API
  8. Using Literals
  9. Using ParameterExpression to supply query parameters at query execution time
  10. Assigning Aliases to Selection Items
  11. Inner Join
  12. Left Outer Join
  13. Left Outer Join On Condition
  14. Fetch Joins in Criteria API
  15. Selecting java.util.Map key/values/entries via MapJoin
  16. Path Navigation
  17. Restricting Query Results by applying 'where' conditions
  18. Applying Between Predicate
  19. Applying 'Is Empty' and 'Is Not Empty' Predicate
  20. Applying isMember() and isNotMember() Predicate
  21. Applying like() and notLike() Predicate
  22. Applying isNull() and isNotNull() Predicate
  23. Applying in() Predicate
  24. Downcasting with CriteriaBuilder.treat() methods
  25. Aggregate Methods
  26. GroupBy And Having methods of CriteriaQuery
  27. Mapping groupBy() result to user defined object
  28. Subqueries
  29. Using Subquery.correlate() method
  30. Using CriteriaBuilder.exists() Method
  31. Using all(), any(), some() methods of CriteriaBuilder
  32. CriteriaBuilder String Manipulation Methods
  33. CriteriaBuilder Arithmetic Operations
  34. Collection Operations size() and index()
  35. CriteriaBuilder Date Time Operations
  36. Calling Database Function with CriteriaBuilder.function()
  37. Case Expressions with CriteriaBuilder.selectCase()
  38. Update Operations
  39. Delete Operations
  40. Modifying and Reusing Query Objects