hql 查询语句（HQL query statement）.docVIP

hql 查询语句（HQL query statement） HQL query: Criteria queries on the query conditions of object-oriented package, in accordance with the programmers way of thinking, but the HQL (Hibernate Query Lanaguage) query provides a more extensive and flexible query characteristics, so the Hibernate will HQL query for official recommended standard query, HQL query based on Criteria query function covers all the next, provides a similar standard SQL queries, but also provides a more object-oriented package. The full HQL statement follows: Select/update/delete...... From...... Where...... Group by...... Having...... Order by...... Asc/desc Where update/delete is the newly added function in Hibernate3, and you can see that HQL queries are very similar to standard SQL queries. Because of the core position of the HQL query throughout the Hibernate entity operating system, this section will focus on specific technical details of HQL operations. 1, entity query: As for entity query technology, we have already covered many of them in the past, such as the following example: String hql=, from User user; List list=session.CreateQuery (HQL).List (); The result of the above code execution is to query all the data corresponding to the User entity object, and encapsulate the data into a User entity object and return it in List. It should be noted that the Hibernate entity exists to determine the inheritance relationship query, such as we have discussed in the previous mapping entity the inheritance relation of Employee entity object, it has two sub categories are HourlyEmployee, SalariedEmployee, if there is such a HQL statement: from Employee, when the retrieval Hibernate will retrieve the all the corresponding Employee type object data (including its subclasses HourlyEmployee, SalariedEmployee corresponding data). Because the HQL statement and the SQL statement is similar to standard, so we can use the where clause in the HQL statement, and can use a variety of expressions in the where claus