分页实现方法

pagination : 55,10,15,20,50 ],

每次页面操作或者查询请求CURD时响应头部都会带着页面page和rows属性。所以后台可以指定接收参数进行分页。

SEO SEOUDz59Kfjuf2CNxfO7bKe9pszqJrDXxOIlgKRlN+boH2ZXQ3+9fT3wetlPe02Y7H+q5PPGZfjkfWCGGkOEZhuVj+3bKh7SZ56OGPEGmAT6QFYISdgD/ghViXSE0l4Sn9+2U4p4283wQ7IAn/QMflOZ8kL+dT1BQUFBQUFBQUNC/SIJcw/din6uc2stB+SQRY5w16/5KjPwKsjUX9hBY9dFx+dggHHb3wf7KZF1B5nNhgc+6CBOSOOv+Sr9szOfCHqodm8/AmnV/pV829ufK5yP7V592o99f6ZeN+VxY8C/gk+ec1H5/5baCbM2F7XzgQX0HXTz2pyuFFWRv+YQVZG/4hBVkQUFBQUFBh1EWniXyns9x76htfCqJaHOex0LnZSmZSrsU4q/z/RHYx+ZTYniwWNxVLU9T3hWLLDWE6w98TrdLelQ+1D0/y77QSZRlU15pjWfO4qdwHce5OjwfNUxTSyYWI2wGTp72C/ayPy4f8K+Ft2jOZZNd3NMTejmYh//iQpwHfFw+qIL5GaOUD6LoBiE050Nxn3/I6UaOaT5BQUFBQUFBQYfQfwDpE67OB38NCwAAAABJRU5ErkJggg==" alt="">

例如在初始化的时候。我们会创建一个page的 bean用来接收前台传入的page 和 row、

</span><span style="color: #0000ff;"&gt;private</span><span style="color: #000000;"&gt; Integer page;
</span><span style="color: #0000ff;"&gt;private</span><span style="color: #000000;"&gt; Integer rows;
</span><span style="color: #0000ff;"&gt;public</span><span style="color: #000000;"&gt; Integer getPage() {
    </span><span style="color: #0000ff;"&gt;return</span><span style="color: #000000;"&gt; page;
}
</span><span style="color: #0000ff;"&gt;public</span> <span style="color: #0000ff;"&gt;void</span><span style="color: #000000;"&gt; setPage(Integer page) {
    </span><span style="color: #0000ff;"&gt;this</span>.page =<span style="color: #000000;"&gt; page;
}
</span><span style="color: #0000ff;"&gt;public</span><span style="color: #000000;"&gt; Integer getRows() {
    </span><span style="color: #0000ff;"&gt;return</span><span style="color: #000000;"&gt; rows;
}
</span><span style="color: #0000ff;"&gt;public</span> <span style="color: #0000ff;"&gt;void</span><span style="color: #000000;"&gt; setRows(Integer rows) {
    </span><span style="color: #0000ff;"&gt;this</span>.rows =<span style="color: #000000;"&gt; rows;
}

}

再定义一个 pagination来方便json数组操作。

</span><span style="color: #0000ff;"&gt;private</span> List<Object><span style="color: #000000;"&gt; rows;
</span><span style="color: #0000ff;"&gt;private</span><span style="color: #000000;"&gt; String total;

</span><span style="color: #0000ff;"&gt;public</span><span style="color: #000000;"&gt; List  getRows() {
    </span><span style="color: #0000ff;"&gt;return</span><span style="color: #000000;"&gt; rows;
}
</span><span style="color: #0000ff;"&gt;public</span> <span style="color: #0000ff;"&gt;void</span><span style="color: #000000;"&gt; setRows(List  rows) {
    </span><span style="color: #0000ff;"&gt;this</span>.rows =<span style="color: #000000;"&gt; rows;
}
</span><span style="color: #0000ff;"&gt;public</span><span style="color: #000000;"&gt; String getTotal() {
    </span><span style="color: #0000ff;"&gt;return</span><span style="color: #000000;"&gt; total;
}
</span><span style="color: #0000ff;"&gt;public</span> <span style="color: #0000ff;"&gt;void</span><span style="color: #000000;"&gt; setTotal(String total) {
    </span><span style="color: #0000ff;"&gt;this</span>.total =<span style="color: #000000;"&gt; total;
}

}

Pagination p = = String json = "{\"total\":" + p.getTotal() + ",\"rows\":" + JSON.toJSONString(p.getRows(),SerializerFeature.DisableCircularReferenceDetect) + "}" json;

直接调用find方法从数据库取出数据就可以了。结果会转化成json数据集然后显示在前台页面的。

我自己写了一个简单的分页实现，比上边方法直接，直观。

@RequestMapping("/find_test" Account account = 后台的 page row http会包含在post头中 currentPage = Integer.parseInt(request.getParameter("page" pageSize = Integer.parseInt(request.getParameter("rows"查询条件的序列成map来管理 String date_start = request.getParameter("date_start")== ?"":request.getParameter("date_start"= request.getParameter("date_end")== ?"":request.getParameter("date_end"= request.getParameter("orgid")== ?"":request.getParameter("orgid"= request.getParameter("customer.id")== ?"":request.getParameter("customer.id" searchmap = HashMap"date_start""date_end""orgid""customer.id"分页显示 List dayRecruits = total = "text/html;charset=utf-8" String json = "{\"total\":"+total+",\"rows\":"+JSON.toJSONString(dayRecruits,SerializerFeature.DisableCircularReferenceDetect)+"}"

牵扯到的hql关键语句为

Query query =-1)*pageSize); query.setMaxResults(pageSize); List dayrecruit = dayrecruit;

分页实现方法

相关文章