Oracle and MySql paging examples

Triplicate

Select mbid00, mbmc00, llurl0, cfwz00, mbsltp, sycs00, lrsj00 from (
Select mbid00, mbmc00, llurl0, cfwz00, mbsltp, sycs00, lrsj00, rownum as con from (
Select * from JZ_MBXXB0 where 1 = 1 and lbid00 =
'123'
Order by lrsj00)
Where rownum <=
10
) Where con> =
1

In hibernate + Mysql

1. /** 
2. * Paging Query 
3. */
4. @ SuppressWarnings("Unchecked")
5. PublicList doSearch (PageDao pageDAO,Final IntPageSize,
6. FinalString name00)ThrowsException {
8. List list =NewArrayList ();
9. StringBuffer SQL =NewStringBuffer (
10. "From Book B where B. name00 LIKE '%");
11. SQL. append (name00 );
12. SQL. append ("% '");
14. FinalString typeSql =NewString (SQL );
15. // Set the number of entries displayed on each page
16. PageDAO. setPagesize (pageSize );
17. IntPagesize = pageDAO. getPagesize ();
18. // Obtain the total number of records
19. List count = (listmediahibernatetemplate.exe cute (
21. NewHibernateCallback (){
22. PublicObject doInHibernate (Session session)
23. ThrowsHibernateException, SQLException {
24. Query q = session. createQuery (typeSql );
25. // Q. setFirstResult (0 );
26. // Q. setMaxResults (2 );
27. List ss = q. list ();
28. ReturnQ. list ();// No null is returned even if no data is found. Only isEmpty can be used.
29. }
30. }
31. );
32. PageDAO. getRsCountForSQL (count. size ());
33. // Obtain the total number of pages
34. PageDAO. GetPageCount ();
35. // Obtain the current page
36. Final IntCurrpage = pageDAO. GetCurrentPageForRequest ();
37. // Set the toolbar type
38. String pool = pageDAO. pagetool (PageDao. Text );
40. // System. out. println (pageDAO. getParamUrl ());
42. List <BookDTO> dt =NewArrayList <BookDTO> ();
43. List rs = (listpolichibernatetemplate.exe cute (
45. NewHibernateCallback (){
46. PublicObject doInHibernate (Session session)
47. ThrowsHibernateException, SQLException {
48. Query q = session. createQuery (typeSql );
49. Q. setFirstResult (currpage-1) * PageSize );
50. Q. setMaxResults (pageSize );// Currpage *
51. List ss = q. list ();
52. ReturnQ. list ();// No null is returned even if no data is found. Only isEmpty can be used.
53. }
54. }
55. );
56. For(Iterator it = rs. iterator (); it. hasNext ();){
57. Object obj = it. next ();
58. BookDTO dto =NewBookDTO ();
59. BeanUtils. copyProperties (obj, dto );
60. Dt. add (dto );
61. }
62. // Session. setAttribute ("pagedto", pageDAO );
63. List. add (0, Dt );
64. List. add (1, Pool );
65. ReturnList;
67. }

1 2 Next Page