HQL Statement Summary "constantly updated"

1: Basic Query statement

From is the simplest statement and the most basic HQL statement. The class name of the persisted class immediately after the FROM keyword.
For example:
From person indicates that all instances are selected from the person persistence class. Note that the entity class here is case sensitive!

2: Query part of fields to make new objects

Select New article (a.id,a.title,a.category) from article a WHERE a.id =?

Sometimes, you do not need to return some large pieces of the table, such as the Content field of the blog table, then you can use the above statement. Only return the required blog ID, blog title and blog category, to form a new article object to return.

Note: the article entity class must have a article constructor with the Id,title and category three properties.

HQL Statement Summary "constantly updated"