NutzWk Datatables 插件如何实现分页查询数据的分装？

本文共计160个文字，预计阅读时间需要1分钟。

Datatables插件分页查询实现，参数包括：- 公共NutMap数据（int length, int start, int draw, List orders, List columns, Cnd cnd, String linkName, Cnd subCnd）- 创建NutMap对象re- 检查orders是否非空且大小大于0- 遍历orders

datatables 插件分页查询

public NutMap data(int length, int start, int draw, List orders, List columns, Cnd cnd, String linkName, Cnd subCnd) { NutMap re = new NutMap(); if (orders != null && orders.size() > 0) { for (DataTableOrder order : orders) { DataTableColumn col = columns.get(order.getColumn()); cnd.orderBy(Sqls.escapeSqlFieldValue(col.getData()).toString(), order.getDir()); } } Pager pager = new OffsetPager(start, length); re.put("recordsFiltered", this.dao().count(this.getEntityClass(), cnd)); List list = this.dao().query(this.getEntityClass(), cnd, pager); if (!Strings.isBlank(linkName)) { if (subCnd != null) this.dao().fetchLinks(list, linkName, subCnd); else this.dao().fetchLinks(list, linkName); } re.put("data", list); re.put("draw", draw); re.put("recordsTotal", length); return re; }