Enterprise Java Development@TOPIC@

Part III. Criteria API

Table of Contents

6. JPA Criteria API

6.1. Criteria API Demo Template

6.2. Simple Entity Query

6.3. Non-Entity Query

6.4. Multi-select Query

6.4.1. Multi-select Query with Object[]
6.4.2. Multi-select Query with Tuple
6.4.3. Multi-select Query with Constructor

6.5. Path Expressions

6.5.1. Single Element Path Expressions
6.5.2. Collection Element Path Expressions

6.6. Eager Fetching through JOINs

6.6.1. Lazy Fetch Problem
6.6.2. Adding Eager Fetch during Query

6.7. Distinct Results

6.8. Summary

7. Criteria Where Clauses

7.1. Equality Test

7.2. Like Test

7.2.1. Like Test Literal
7.2.2. Like Test Literal Parameter
7.2.3. Like Test Concatenated String
7.2.4. Like Test Single Character Wildcard

7.3. Formulas

7.4. Logic Operators

7.5. Equality Tests

7.6. Between

7.7. Testing for Null

7.8. Testing Empty Collection

7.9. Membership Test

7.10. Subqueries

7.13. Summary

8. Criteria Functions

8.1. String Functions

8.1.1. Base Query
8.1.2. LOWER
8.1.3. UPPER
8.1.4. TRIM
8.1.5. CONCAT
8.1.6. LENGTH
8.1.7. LOCATE
8.1.8. SUBSTRING

8.2. Date Functions

8.3. Order By

8.4. Aggregate Functions

8.4.1. COUNT
8.4.2. MIN/MAX
8.4.3. SUM/AVE

8.5. Group By

8.6. Having

8.7. Summary