Using SQL statements in Hibernate

In hibernate with SQL statements, statements are createsqlquery, a column or columns of data, to convert it to an object, there are two ways,

For entity classes that have been managed by hibernate, add the following. addentity then use curly braces in the SQL statement, after select from, each {table name. *}, you can query the object.

For the DTO class for data transmission, use Setresulttransformer. Then, before the select from, the column name and the DTO's property name one by one as up.

Millions data storage, with the Foreign Key Association will reduce the efficiency can choose to use redundant fields, many to one of the associated object attributes to a number of attributes, but in this case modify one side, to batch modify the number of one side.

Using SQL statements in Hibernate