使用JSON -simple库从Java为Flexigrid生成JSON

Question

给定以下预期的JSON格式，我试图使用Java生成JSON:

{
  "stat": "ok",
  "page": 1,
  "total": 100,
  "rows": [
     {
       "id":"1",
       "cell":[
         "content of column 1",
         "content of column 2",
         "content of column 3",
         "content of column 4", 
         "content of column 5",
         "content of column 6",
         "content of column 7",
         "content of column 8",
         "content of column 9"
       ]
    },  
     {
       "id":"2",
       "cell":[
         "content of column 1",
         "content of column 2",
         "content of column 3",
         "content of column 4", 
         "content of column 5",
         "content of column 6",
         "content of column 7",
         "content of column 8",
         "content of column 9"
       ]
    },

到目前为止，我已经编写了以下代码，在某些方面很接近，但它不包含支持嵌套对象的逻辑。我发现这很困难，因为表示JSON对象所需的代码使用HashMap类型的对象，该对象需要唯一的键。因此，当我需要有多个"id"条目时，我只能使用id输入一个哈希映射键。我也尝试过google/Guava multimap，但是在尝试同时转换或混合JSON库和google实现时有一个限制。

下面的代码生成这个作为输出:

{
  "total": "100",
  "page": "1",
  "stat": "ok",
  "rows": [
    {
      "id": "1",
      "cell": [
        "test which represents one column's content",
        "test, which contains 2nd column's data"
      ]
    }
  ]
}

，你可以从上面看到，将接近但不正确的，因为它将只包含1 x行和单元格。

public class GenerateJSON {
    public static void main(String[] args) {
        JSONArray cell = new JSONArray();
        cell.add("test which represents one column's content");
        cell.add("test, which contains 2nd column's data");
        JSONObject ids = new JSONObject();
        ids.put("id", "1");
        ids.put("cell",cell);
        HashMap<String,String> map = new HashMap(ids);
        JSONArray rows = new JSONArray();
        rows.add(ids);
        JSONObject obj = new JSONObject();
        obj.put("stat","ok");
        obj.put("total","100");
        obj.put("page","1");
        obj.put("rows",rows);
        System.out.println(obj);    
    }
}

Answer 1

尝试下面的代码，这可能会起作用。

public static void main(String[] args) throws JSONException {
    JSONObject obj = null;
    JSONArray cellArray = new JSONArray();
    JSONArray cellArray1 = new JSONArray();
    for (int i = 0; i < 2; i++) {
        obj = new JSONObject();
        obj.put("id", i);
        obj.put("cell", "contecnt 1, content 2, content 3");
        cellArray.put(obj);
    }
    JSONObject responseData = new org.json.JSONObject();
    responseData.put("rows", cellArray);
//      System.out.println(responseData);
    JSONObject obj1 = new JSONObject();
    obj1.put("stat", "ok");
    obj1.put("total", "100");
    obj1.put("page", 1);
    obj1.put("rows", responseData);
    cellArray1.put(obj1);
    JSONObject response = new org.json.JSONObject();
    response.put("data", cellArray1);
    System.out.println(response);
}

输出:

{"data":[{"total":"100","page":1,"stat":"ok",
"rows":
{"rows":[
  {"id":0,
  "cell":"contecnt 1, content 2, content 3"},
  {"id":1,
  "cell":"contecnt 1, content 2, content 3"}
 ]}
}]}

Answer 2

如果没有问题，你可以分两步来做。

1)使用文档构建器在java中生成json的xml等价物。

2)转换XML到它的json等效是相当容易的，然后…希望这对你有帮助!