ArrayList list= ktrService.findKtr(NAME);//从service获得结果集 int totalRecord = list.size(); // 总记录数 int totalPage = totalRecord % Integer.parseInt(rows) == 0 ? totalRecord / Integer.parseInt(rows) : totalRecord / Integer.parseInt(rows) + 1; // 计算总页数 try { int index = (Integer.parseInt(page) - 1) * Integer.parseInt(rows); // 开始记录数 int pageSize = Integer.parseInt(rows); // 以下模拟构造JSON数据对象 String json = "{\"total\": \"" + totalPage + "\", \"page\": \"" + page + "\", \"records\": \"" + totalRecord + "\", \"rows\": ["; for (int i = index; i < pageSize + index && i < totalRecord; i++) { KtrInfo ktr= (KtrInfo) list.get(i); json += "{\"cell\":[\"" + ktr.getNAME() + "\",\"" + ktr.getETL_TYPE() + "\",\"" + ktr.getRUN_FLG()+ "\",\"" + ktr.getPLN_INTERVAL()+ "\",\"" + ktr.getSTART_TIME()+ "\",\"" + ktr.getEND_TIME()+ "\",\"" + ktr.getCREATE_DT()+ "\",\"" + ktr.getVALID_FLG()+ "\",\"" + new String(ktr.getOPE_MSG().getBytes("UTF-8"),"ISO8859-1")+ "\",\"" + ktr.getMAX_TIME()+ "\",\"" + ktr.getEVT_USR()+ "\",\"" + ktr.getEVT_TIME()+ "\"]}"; if (i != pageSize + index - 1 && i != totalRecord - 1) { json += ","; } } json += "]}"; // System.out.print(json); response.getWriter().write(json); // 将JSON数据返回页面 } catch (Exception ex) { System.out.println(ex); }
jq.Grid 分页后台代码
最新推荐文章于 2019-08-04 08:00:45 发布