Enterprise Java Development@TOPIC@

Part III. Criteria API

Table of Contents

73. JPA Criteria API

73.1. Criteria API Demo Template

73.2. Simple Entity Query

73.3. Non-Entity Query

73.4. Multi-select Query

73.4.1. Multi-select Query with Object[]
73.4.2. Multi-select Query with Tuple
73.4.3. Multi-select Query with Constructor

73.5. Path Expressions

73.5.1. Single Element Path Expressions
73.5.2. Collection Element Path Expressions

73.6. Eager Fetching through JOINs

73.6.1. Lazy Fetch Problem
73.6.2. Adding Eager Fetch during Query

73.7. Distinct Results

73.8. Summary

74. Criteria Where Clauses

74.1. Equality Test

74.2. Like Test

74.2.1. Like Test Literal
74.2.2. Like Test Literal Parameter
74.2.3. Like Test Concatenated String
74.2.4. Like Test Single Character Wildcard

74.3. Formulas

74.4. Logic Operators

74.5. Equality Tests

74.6. Between

74.7. Testing for Null

74.8. Testing Empty Collection

74.9. Membership Test

74.10. Subqueries

74.13. Summary

75. Criteria Functions

75.1. String Functions

75.1.1. Base Query
75.1.2. LOWER
75.1.3. UPPER
75.1.4. TRIM
75.1.5. CONCAT
75.1.6. LENGTH
75.1.7. LOCATE
75.1.8. SUBSTRING

75.2. Date Functions

75.3. Order By

75.4. Aggregate Functions

75.4.1. COUNT
75.4.2. MIN/MAX
75.4.3. SUM/AVE

75.5. Group By

75.6. Having

75.7. Summary