ligerui實現數據庫端分頁功能
LigerUI的兩種分頁方式
LigerUI的分頁方式有兩種:local和server。
如果數據量不是很大,就直接采用local分頁,一次性的把數據全部發送到前臺來,之后LigerUI自身的grid會自動分頁。說一下total,在后臺傳送jsonString時傳送定義好的total(總條數),你可以定義多少都可以,但是到前臺它會自動將總條數賦值給total,這是local下的方式。
而如果數據量很大,一次性加載直接不顯示數據或反應很慢的,就需要用server分頁了,當用server分頁時,每次請求都會比local時多發送兩個參數:page和pagesize,不需要自己去發送,只需要在后臺獲取就行,
intpage=Integer.parseInt(request.getParameter("page"));
intpagesize=Integer.parseInt(request.getParameter("pagesize"));
inttotal;
這時你可以把page和pagesize寫進你的sql語句:
sql=".........";
sql+="limit"+(page*pagesize-pagesize)+","+pagesize;
這樣查出的結果放入jsonString中,這里要注意total了,total需要自己定義,需要自己重新查一下結果的總條數后賦值給total傳到頁面,其他的LigerUI會幫你搞定!
以下為實現部分內容
============
1.js頁面
userGrid=$("#userGrid").ligerGrid({ method:'GET', height:580, width:'100%', usePager:true, columns:[ {display:Resource.userName,name:"userName",align:'left',width:100,minWidth:60}, {display:Resource.email,name:"email",align:'left',width:250,minWidth:60}, {display:Resource.deparentment,name:"deparentment",align:'left',width:100,minWidth:60}, //{display:Resource.password,name:"password",align:'left',width:100,minWidth:60}, {display:Resource.userType,name:"privilege",align:'left',width:100,minWidth:60, render:function(item){ varprivilege=item.privilege; if(privilege=='1'){ returnResource.tempUser; }elseif(privilege=='2'){ returnResource.commonUser; }elseif(privilege=='4'){ returnResource.advancedUser; }elseif(privilege=='8'){ returnResource.knowledgeManager; }elseif(privilege=='16'){ returnResource.administrator; } } }, {display:Resource.accountState,name:"accountState",align:'left',width:100,minWidth:60, render:function(item){ varaccountState=item.accountState; if(accountState=='1'){ returnResource.normal; }elseif(accountState=='2'){ returnResource.unactive; }elseif(accountState=='4'){ returnResource.stopped; } } }, {display:Resource.accountExpireDate,name:"accountExpireDate",align:'left',width:100,minWidth:60} ], url:$('#initPath').val()+'/UserController.do?method=getUserPaging&privilege=-1',//必須這樣,否則不能傳page等參數 pageSize:10,rownumbers:true, |
2.action
publicModelAndViewgetUserPaging(DYRKBUseruser,HttpServletRequestrequest){ intpage=Integer.parseInt(request.getParameter("page")); intpagesize=Integer.parseInt(request.getParameter("pagesize")); if(user.getUserName()==null){ user.setUserName("");//空串時可以搜索到所有此類用戶 } Integerprivilege=user.getPrivilege(); if(privilege==-1){ user.setPrivilege(null); } List<DYRKBUser>userList=userService.getUserPaging(user,page,pagesize); inttotal=userService.getUserTotalNum(); Map<String,Object>model=newHashMap<String,Object>(1); model.put("Rows",userList);//數據要的就是Rows項 model.put("Total",total); returnnewModelAndView(Constants.JSON_VIEW,model); } |