DHTMLX Grid中实现分页查询.doc

Grid中实现分页查询 注：将Tomcat 5.0下的conf/server.xml中的URIEncoding 设置成UTF-8可以解决中文问题 1、导入文件： link rel=STYLESHEET type=text/css href=../../codebase/dhtmlxgrid.css link rel=STYLESHEET type=text/css href=../../codebase/ext/dhtmlxgrid_pgn_bricks.css script src=../../codebase/dhtmlxcommon.js/script script src=../../codebase/dhtmlxgrid.js/script script src=../../codebase/ext/dhtmlxgrid_pgn.js/script script src=../../codebase/dhtmlxgridcell.js/script 2、jsp页中的相关设置 //两个input域 和一个button按钮用于模糊查询 divNamebr input type=text id=search_name /div divChnamebr input type=text id=search_chname button onclick=reloadGrid() id=submitButton style=margin-left:30px;Search/button /div div id=gridbox style=width:100%;height:200px;margin-top:20px;margin-bottom:10px; /div divspan id=pagingArea/span/div 3、初始化： script function doOnLoad(){ var mygrid = new dhtmlXGridObject(gridbox); mygrid.setImagePath(../../codebase/imgs/); mygrid.setHeader(id,name,chname,pwd); mygrid.setInitWidths(150,150,*,150) mygrid.setColAlign(left,left,left,right) mygrid.setColSorting(server,na,na,server); mygrid.setColTypes(ro,ro,ro,ro); mygrid.setSkin(light); mygrid.init(); //////////////////////// mygrid.enablePaging(true,10,5,pagingArea,true); mygrid.setPagingSkin(bricks); /////////////////////// mygrid.loadXML(../../../user!mylist.action); } /script //enablePaging中对应的参数的意义分别是： 是否开启分页； 每页显示的行数（这里设置为10行）； 每次显示多少页（下图为显示5页）； 分页div的id； 是否显示统计结果（对应下图的 Records from 1 to 10 of 999） //模糊插叙方法 function reloadGrid(){ var name_mask = document.getElementById(search_name).value var chname_mask = document.getElementById(search_chname).value //把查询条件传到action中 mygrid.clearAndLoad(%=basePath%user!mylist.action?name_mask=+name_mask+chname_mask=+chname_mask); } 4、后台action //得到posStart（从那条数据开始读）count（读取多少条数据）和两个查询条件 String count = req.getParameter(count); String posStart = req.getParameter(posStart); String name = req.getParameter(name_mask); String chname = req.getParameter(chname_mask); //第一次请求posStart和count值均为空，需要一个默认值 int