Hibernate page summary

Hibernate is usually used in three types: hql query, QBC query, and QBE query:
1. QBE (Qurey By Example) Retrieval Method

QBE is the simplest, but its function is also the weakest. It is not very powerful and only useful in some scenarios. A typical application scenario is to allow users to enter a series of query conditions in the query window and then return matched objects. QBE only supports the = and like comparison operators, and cannot match a small interval value or its or. In this case, the HQL or QBC retrieval method is used.

1. /** 
2. * @ Function displays the matched records in the database by Page Based on the passed objects. 
3. * @ Param pageNo 
4. * Current page number 
5. * @ Param pageSize 
6. * Number of records displayed on each page 
7. * @ Param object 
8. * Encapsulate query conditions as objects 
9. * @ Return encapsulate the query result as Pager returned 
10. */
11. PublicPager findPageByExample (IntPageNo,IntPageSize, Object object)
12. {
13. Pager pager =Null;
14. Try
15. {
16. Criteria criteria =This. GetSession (). createCriteria (
17. Class. forName (This. GetEntity ()));
19. If(Object! =Null)
20. {
21. Criteria. add (Example. create (object). enableLike ());
22. }
24. // Obtain the total number of rows queried by criteria by PAGE
25. IntRowCount = (Integer) criteria. setProjection (
26. Projections. rowCount (). uniqueResult ();
27. Criteria. setProjection (Null);
29. Criteria. setFirstResult (pageNo-1) * PageSize );
30. Criteria. setMaxResults (pageSize );
32. List result = criteria. list ();
34. Pager =NewPager (pageSize, pageNo, rowCount, result );
36. }Catch(RuntimeException re)
37. {
38. ThrowRe;
39. }Finally
40. {
41. ReturnPager;
42. }
44. }