将只有“行”和“列”的JSON响应解析到POJO

Question

是否可以解析对POJO的JSON响应，即使响应只发回行和列？

我从API得到这个响应：

{
"rows": [
[
  "FIRST NATIONAL BANK OF OMAHA",
  36644,
  "COM",
  44527,
  198809,
  "SH",
  -1.5631,
  "Put",
  "2019-09-30"
],
[
  "WAYNE HUMMER INVESTMENTS L.L.C.",
  49096,
  "COM",
  17975,
  90817,
  "SH",
  2.8971,
  "Put",
  "2019-06-30"
]
],
"columns": [
"Institution Name",
"Institution CIK",
"Class of Security Held",
"Value of Security Held",
"Volume of Security Held",
"Type of Security Held",
"Quarterly Change in Security Held",
"Put/Call",
"Report Date"
]
}

这是我正在使用的代码，为简洁起见，将其缩短，以连接到API并获得JSON响应，我使用Gson通过反序列化器类传递JSON响应：

public static void requestResponse(){

   URL apiURL = new URL("http://apilink.com/api/getSomething.json?T=gnbuweiogh9y89234y&symbol=GOOG");

   String readLine = null;

   HttpConnection apiConnection =  (HttpConnection) apiURL.openConnection();

   apiConnection.setRequestMethod("GET");

   int responseCode = apiConnection.getResponseCode();

   if(responseCode == HttpConnection.HTTP_OK) {

       BufferedReader in = new BufferedReader(new InputStreamReader(apiConnection.getInputStream()));

       StringBuffer response = new StringBuffer();

       while((readLine = in.readLine()) != null) {
           response.append(readLine);
       }
       in.close();

       String jsonResponse = response.toString();

       Deserializer deSerializer = new Gson().fromJson(jsonResponse, Deserializer .class);
       List<String> columns = deSerializer.getColumns;
       // Do something with the data
   }
}

这是我制作的反序列化类：

public class deSerializer {

@SerializedName("rows")
@Expose
private List<List<String>> rows = null;
@SerializedName("columns")
@Expose
private List<String> columns = null;

public List<List<String>> getRows() {
return rows;
}

public void setRows(List<List<String>> rows) {
this.rows = rows;
}

public List<String> getColumns() {
return columns;
} 

public void setColumns(List<String> columns) {
this.columns = columns;
}

}

我希望JSON响应采用这种格式，这会使序列化更简单：

{
 "data": [{
"Institution Name": "FIRST NATIONAL BANK OF OMAHA",
"Institution CIK": 36644,
"Class of Security Held": "COM",
"Value of Security Held": 44527
 } ]
}

抱歉发了这么长的帖子，但是反序列化POJO响应的最佳方法是什么？

多谢了。

Answer 1

通过向反序列化器类添加以下帮助器方法，可以将其转换为所需的格式：

public List<Map<String, Object>> asListOfMaps() {
    List<Map<String, Object>> list = new ArrayList<>(this.rows.size());
    for (List<Object> data : this.rows) {
        Map<String, Object> row = new LinkedHashMap<>(this.columns.size());
        for (int i = 0; i < this.columns.size(); i++)
            row.put(this.columns.get(i), data.get(i));
        list.add(row);
    }
    return list;
}