/** * 查询所有栏位的实现方法(带分页)。模糊查询也是调用此方法 * * @return */ @RequestMapping(value = "/queryAllColumnAction") public void queryAllColumnAction( Column column, Resource resource, HttpServletRequest request, HttpServletResponse response) { // 分页查询 List<Column> list = new ArrayList<Column>(); if (column != null && column.getSort() != null && column.getSort().trim() != "") { column.setSort(column.getSort().toLowerCase()); // 排序字段全部转化为小写。避免Linux系统 排序字段报错 } column.setResource(resource); try { list = columnService.queryAllColumn(column); } catch (Exception e) { log.error("queryAllColumn error分页查询栏位出错"); } // 查询总数 int count = 0; try { count = columnService.queryColumnCount(column); } catch (Exception e) { log.error("queryColumnCount error 查询菜单栏位总数出错"); } Map<String, Object> userEasyUIMap = new HashMap<String, Object>(); userEasyUIMap.put("rows", list); // easyUI需要用的rows userEasyUIMap.put("total", count); // easyUI需要用的总数 response.setContentType("text/html;charset=utf-8"); PrintWriter pw = null; try { pw = response.getWriter(); // pw.print(jsonData); // pw.write(JSONArray.fromObject(userMap).toString()); //输出的全部是字符串 pw.write(JSONObject.fromObject(userEasyUIMap).toString()); // 输入的是json key Object的字符串 pw.flush(); } catch (IOException e) { // e.printStackTrace(); log.error("输出json出错"); } finally { if (pw != null) { pw.close(); } } }