Java使用Queryable-pageable實現(xiàn)分頁效果
在維護(hù)老項目的時候需要對部分分頁進(jìn)行手動修改、方式是獲取前端的分頁參數(shù) page以及rows、 new PageRequest對象把分頁參數(shù)傳進(jìn)去、通過 queryable.setPageable(pageable);保存、最后進(jìn)行調(diào)用。
完整代碼如下:
@ResponseBody @RequestMapping(value = "getLbjzkList", method = RequestMethod.GET) @PageableDefaults(sort = "id=desc") private void ajaxList(Queryable queryable, PropertyPreFilterable propertyPreFilterable, HttpServletRequest request, HttpServletResponse response) throws IOException { EntityWrapper<LbjZk> entityWrapper = new EntityWrapper<LbjZk>(entityClass); propertyPreFilterable.addQueryProperty("id"); propertyPreFilterable.addQueryProperty("name"); Integer page= Integer.parseInt(request.getParameter("page").toString()); Integer rows= Integer.parseInt(request.getParameter("rows").toString()); // 預(yù)處理 queryable.setPageable(new PageRequest(page, rows)); QueryableConvertUtils.convertQueryValueToEntityValue(queryable, entityClass); SerializeFilter filter = propertyPreFilterable.constructFilter(entityClass); PageJson<LbjZk> pagejson = new PageJson<LbjZk>(lbjZkService.list(queryable,entityWrapper)); String content = JSON.toJSONString(pagejson, filter); StringUtils.printJson(response, content); }
PageJson分頁工具類:
package com.railway.core.model; import java.io.Serializable; import java.util.List; import com.railway.core.query.data.Page; /** * 頁面展示分頁 * * @author lyy * * @param <T> */ public class PageJson<T> implements Serializable { private static final long serialVersionUID = 1L; private long page = 1;// 當(dāng)前頁 private long rows = 10;// 每頁顯示記錄數(shù) private long total; // 總數(shù) private long totalPages; // 總頁數(shù) private List<T> results; // 結(jié)果 public PageJson() { } public PageJson(List<T> results) { this(0, Long.MAX_VALUE, Long.MAX_VALUE, results); } public PageJson(Page<T> page) { this(page.getNumber(), page.getSize(), page.getTotalElements(), page.getContent()); } public PageJson(long page, long rows, long total, List<T> results) { this.page = page; this.rows = rows; this.total = total; this.results = results; this.totalPages = getRows() == 0 ? 1 : (int) Math.ceil((double) total / (double) getRows()); } public long getPage() { return page; } public void setPage(long page) { this.page = page; } public long getRows() { return rows; } public void setRows(long rows) { this.rows = rows; } public long getTotal() { return total; } public void setTotal(long total) { this.total = total; } public long getTotalPages() { return totalPages; } public List<T> getResults() { return results; } public void setResults(List<T> results) { this.results = results; } }
到此這篇關(guān)于Java使用Queryable-pageable實現(xiàn)分頁效果的文章就介紹到這了,更多相關(guān)Java分頁內(nèi)容請搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家!
相關(guān)文章
Java適配器模式_動力節(jié)點Java學(xué)院整理
這篇文章主要介紹了Java適配器模式,小編覺得挺不錯的,現(xiàn)在分享給大家,也給大家做個參考。一起跟隨小編過來看看吧2017-07-07JavaSwing基礎(chǔ)之Layout布局相關(guān)知識詳解
上次我們說到View的Mearsure流程,今天接著說說layout. 關(guān)于layout,很多朋友知道它是負(fù)責(zé)布局的,那么具體是怎么布局的?viewGroup和view的layout方法又有什么不同?一起來看看吧,需要的朋友可以參考下2021-05-05