Paging Query
---CONTROLLER---
/*** All members are queried by paging.* @param page* @param request* @return*/
@RequestMapping ("/allstaff.do")public string Getallstaff (string page,httpservletrequest request){if (page ==null){page = 1+ "";}Request.setattribute ("page", page);Request.setattribute ("Pagenum", Staffservice.getpagenum ());Request.setattribute ("Stafflist", Staffservice.allstaff (page));return "/allstaff.do";}
/*** Paging Query Next page* @param page* @param request* @return*/@RequestMapping ("/nextpage.do")public string NextPage (string Page,httpservletrequest request) {int curpage = integer.parseint (page);Request.setattribute ("page", curpage+1);Request.setattribute ("Pagenum", Staffservice.getpagenum ());Request.setattribute ("Stafflist", Staffservice.allstaff (curpage+1+ ""));return "/allstaff.do";}/*** Paged Query Previous page* @param page* @param request* @return*/
@RequestMapping ("/prevpage.do")public string PrevPage (string Page,httpservletrequest request) {int curpage = integer.parseint (page);Request.setattribute ("page", curPage-1);Request.setattribute ("Pagenum", Staffservice.getpagenum ());Request.setattribute ("Stafflist", Staffservice.allstaff (curpage-1+ ""));return "/allstaff.do";}
---Action---
/*** Paged Query Member information* @param page* @return*/Public list<staff> Allstaff (String page);
/*** Get page numbers.* @return*/public int getpagenum ();
/*** Paged Query Member information* @param page* @return*/Public list<staff> Allstaff (String page) {return Staffdao.allstaff (page);}
/*** Get page numbers.* @return*/public int Getpagenum () {return Staffdao.getpagenum ();}
----DAO---
public int getpagenum ();Public list<staff> Allstaff (String page);
/*** Get total page number information for employee pages.*/public int Getpagenum (){String hql= "from staff";Query query = sessionfactory.getcurrentsession (). CreateQuery (HQL);int temp = Query.list (). Size ()/pagesize;//size=10if (Query.list (). Size ()%pagesize!=0){temp++;}return temp;}
/*** Paging gets all employees, on the first page.*/Public list<staff> Allstaff (String page){String hql= "from staff";Query query = sessionfactory.getcurrentsession (). CreateQuery (HQL);Query.setfirstresult ((Integer.parseint (page)-1) *pagesize);Query.setmaxresults (pageSize);return Query.list ();}
From for notes (Wiz)
Paged Query case
