Hibernate HQL查询 插入 更新(update)实例(国外英文资料).doc

Hibernate HQL查询 插入 更新(update)实例(国外英文资料) 1, query entity: The relevant entity query technology, we have previously been repeatedly involved, such as the following example: String hql= from User user; List list=session.CreateQuery (HQL) (.List); The above code execution, query all data corresponding to the User object, and the data will be packaged into a User object, and add List in return. 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 clause, the comparison operators and the use of and, or with different query combination. Some simple examples see below: From User user where user.age=20; From User user where user.age between 20 and 30; From User user where user.age in (20,30); From User user where is null; From User user where like %zx%; From User user where (user.age%2) =1; From User user where user.age=20 and like %zx%; 2, update and delete entities: To explain HQL other more powerful query features, we first explain the use of HQL technology to update and delete entities. This technology is the new function of Hibernate3 function in Hibernate2 is not available. As for Hibernate2, if we want all 18 year old users in the database of all ages to 20 years old, so we must first search at the age of 18 year old users, and then modify their age is 20 years old, last call Session.update () to update statement. The Hibernate3 provides a more flexible and