/**
* 查询所有栏位的实现方法(带分页)。模糊查询也是调用此方法
*
* @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();
}
}
}
