hibernate hql关联查询学习笔记（hibernate hql关联查询学习笔记）.docVIP

hibernate hql关联查询学习笔记（hibernate hql关联查询学习笔记） A Hql statement optimization principle): Need to see whether or can replace in Not no no Like can not not especially with the left% Having can only take the conditions of polymerization can be placed in the where clause is not on the having Distinct does not need to repeat on the other (two) loading strategy optimization) Immediate loading: execute the query method, the immediate implementation of SQL lazy=false Delay loading (lazy loading): query method, SQL is not executed immediately, but when you call the get method to execute the query method, SQL is not executed immediately, but when you call the get method To obtain the corresponding attributes and worthy of time. Class: lazy = true The proxy|no-proxy lazy= association The delayed loading of class node configuration lazy= true class level, only session.load Delay load, associated many-to-one, set (one-to-many) When set to lazy= false on the set node should be cautious. Delay load attribute: a corresponding field Blob, Clob property lazy= true attribute set In order to strengthen the effective compilation for.Class (delay loaded, if after session closed access objects associated error) The query method of the Query object: 1) (list) Always perform SQL, return the result set 2) (iterator) Each query ID SQL iteration, if not in the cache, Only in accordance with ID ID according to execute the query returns an object. (only the first visit inefficient implementation of the n+1 SQL) Three) query Fetch: plus fetch is urgent (, left, right) connection, The difference lies in the associated query is query two, corresponding to the two entity classes. General * * without fetch, return to the two tables in the data, the corresponding results of each concentration of elements, Is an array of object objects with two types of entities are stored in two data tables * * fetch (urgent), the return of the two data in the table, the corresponding results of each concentration of ele