11.4.2. HQL Statements
HQL allows
SELECT
, UPDATE
, DELETE
, and INSERT
statements. The HQL INSERT
statement has no equivalent in JPQL.
Important
Care should be taken as to when an
UPDATE
or DELETE
statement is executed.
Table 11.8. HQL Statements
Statement | Description |
---|---|
SELECT |
The BNF for
SELECT statements in HQL is:
select_statement :: = [select_clause] from_clause [where_clause] [groupby_clause] [having_clause] [orderby_clause]
The simplest possible HQL
SELECT statement is of the form:
from com.acme.Cat |
UDPATE | The BNF for UPDATE statement in HQL is the same as it is in JPQL |
DELETE | The BNF for DELETE statements in HQL is the same as it is in JPQL |