package com.taover.util; import java.util.ArrayList; import java.util.HashMap; import java.util.Iterator; import java.util.List; import java.util.Map; import com.alibaba.fastjson.JSONArray; import com.alibaba.fastjson.JSONObject; public class ToolsFastJson { public static JSONObject getPreviewObjArr(JSONObject originExcelData, int arrMaxSize) { JSONObject previewObj = new JSONObject(); if(originExcelData != null && !originExcelData.isEmpty()) { for(String keyItem: originExcelData.keySet()) { JSONArray dataItem = originExcelData.getJSONArray(keyItem); int maxSize = dataItem.size() > arrMaxSize ? arrMaxSize : dataItem.size(); JSONArray dataItemShunk = new JSONArray(); for(int i=0; i>> translateObjArrArr(JSONObject previewOriginExcelDatasJson) { Map>> originDataMap = new HashMap>>(); if(previewOriginExcelDatasJson != null && !previewOriginExcelDatasJson.isEmpty()) { for(String keyItem: previewOriginExcelDatasJson.keySet()) { originDataMap.put(keyItem, translateArrArr(previewOriginExcelDatasJson.getJSONArray(keyItem))); } } return originDataMap; } public static List> translateArrArr(JSONArray jsonArray){ if(jsonArray == null) { return null; } List> resultList = new ArrayList>(); for (int i = 0; i < jsonArray.size(); i++) { ArrayList columList = new ArrayList(); JSONArray columArray = jsonArray.getJSONArray(i); for (int j = 0; j < columArray.size(); j++) { columList.add(columArray.getString(j)); } resultList.add(columList); } return resultList; } public static boolean isJsonNull(Object data){ if(data == null){ return true; } if(!(data instanceof String) && data.toString().equals("null")){ return true; } return false; } public static void removeJsonNull(JSONObject data){ if(data == null){ return; } Iterator keyIter = data.keySet().iterator(); List removeKeys = new ArrayList(data.size()); while(keyIter.hasNext()){ String keyItem = keyIter.next(); Object value = data.get(keyItem); if(isJsonNull(value)) { removeKeys.add(keyItem); continue; } if(value instanceof JSONObject){ removeJsonNull((JSONObject)value); }else if(value instanceof JSONArray){ removeJsonNull((JSONArray)value); } } for(String rKey: removeKeys) { data.remove(rKey); } } public static void removeJsonNull(JSONArray dataArr){ if(dataArr == null){ return; } for(int i=0; i keyIter = data.keySet().iterator(); while(keyIter.hasNext()){ String keyItem = keyIter.next(); Object value = data.get(keyItem); if(isJsonNull(value)) { data.put(keyItem, target); continue; } if(value instanceof JSONObject){ replaceJsonNull((JSONObject)value, target); }else if(value instanceof JSONArray){ replaceJsonNull((JSONArray)value, target); } } } public static void replaceJsonNull(JSONArray dataArr, Object target){ if(dataArr == null){ return; } for(int i=0; i