DHTMLX Grid中实现分页查询

1、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.

2、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">

3、</script>2、jsp页中的相关设置/两个input域 和一个button按钮用于模糊查询<div>Name<br><input type="text" id="search_name"></div><div>Chname<br><input type="text" id="search_chname"><button onclick="reloadGrid()" id="sub

4、mitButton" style="margin-left:30px;">Search</button></div><div id="gridbox" style="width:100%;height:200px;margin-top:20px;margin-bottom:10px;"></div><div><span id="pagingArea"></span></div>3、初始化：<scri

5、pt>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(&

6、quot;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>/enabl

7、ePaging中对应的参数的意义分别是：是否开启分页；每页显示的行数（这里设置为10行）；每次显示多少页（下图为显示5页）；分页div的id；是否显示统计结果（对应下图的 Records from 1 to 10 of 999）/模糊插叙方法function reloadGrid()var name_mask = document.getElementById("search_name").valuevar chname_mask = document.getElementById("search_chname").value/把查询条件传到action

8、中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");Strin

9、g name = req.getParameter("name_mask");String chname = req.getParameter("chname_mask");/第一次请求posStart和count值均为空，需要一个默认值int icount=50;/默认第一次取出50条记录try icount =Integer.parseInt(count); catch (Exception e) if(null=count)icount = 50;int iposStart=0;try iposStart = Integer.parseInt(po

10、sStart); catch (Exception e) if(null=posStart)iposStart = 0;/统计数据的总条数（在这里直接得到一个list，然后conntlist.size取得的）对应xml文、/件中的total_count的值List conntlist = baseService.queryByHqlName("queryPage",map);/定义一个Map，将查询条件put到map中Map map = new HashMap();if (name=null) name=""if (chname=null) chname

11、=""map.put("nameP","%"+name+"%");map.put("chnameP","%"+chname+"%");/ 通过调用BaseDaoImpl中类的loadPageData方法进行分页查询，得到一个list/参数"queryPage"为user-query.hbm.xml中的name（就是下面的代码）list = baseService.loadPageData(iposStart,icount,UserFor

12、m.class,"queryPage",map);5、user-query.hbm.xml配置文件<query name="queryPage">from UserForm where 1=1and name like :namePand chname like :chnameP</query>6、xml文件格式 （这个例子用到了数据库中users表）/ total_count为数据总行数；pos为起始行<?xml version="1.0" encoding="UTF-8"?><rows total_count='conntlist.size()' pos='iposStart'