JSONArray嵌套

      SqlCommand cmd = new SqlCommand("select v.name ,count(v.name) count from eqt_status es left join eqt_main_info m on es.uuid = m.uuid\n" +
                    "left join eqt_type tt on m.eqt_type_code = tt.id\n" +
                    "left join enum_value v on tt.eqt_type_value = v.value\n" +
                    "left join enum_type mt on v.enum_type_id = mt.id\n" +
                    "where mt.code = 'eqt_type' and es.eqt_mark =1\n" +
                    "group by v.name;");
            JSONArray eCategory = adapter.query(cmd).toDataJSON();
            JSONArray eqtStatusCount;
            JSONArray result = new JSONArray();

            for(int i = 0 ; i<eCategory.size();i++){
                JSONObject jsonEqtName=new JSONObject((new LinkedHashMap()));
                String eqtTypeName = eCategory.getJSONObject(i).getString("name");
                String count = eCategory.getJSONObject(i).getString("count");
                SqlCommand cmd1 = new SqlCommand("select es.transition_after ,count(es.transition_after) statusCount from eqt_status es left join eqt_main_info m on es.uuid = m.uuid\n" +
                        "left join eqt_type tt on m.eqt_type_code = tt.id\n" +
                        "left join enum_value v on tt.eqt_type_value = v.value\n" +
                        "left join enum_type mt on v.enum_type_id = mt.id\n" +
                        "where  es.eqt_mark =1 and v.name = :eqtTypeName\n" +
                        "group by es.transition_after ")
                        .setParameter("eqtTypeName",eqtTypeName);
                eqtStatusCount = adapter.query(cmd1).toDataJSON();

                jsonEqtName.put("eqtTypeName",eqtTypeName);
                jsonEqtName.put("count",count);
                jsonEqtName.put("TCount",eqtStatusCount);

                result.add(jsonEqtName);

结果：

参考：Java中使用JSONArray时实现嵌套_YEN_CSDN的博客-CSDN博客_jsonarray嵌套jsonarray前言处理步骤结果前言最近开发的Java Web系统中涉及到为移动端写接口，需要返回JSON数据，而移动端用的是API Cloud开发的，调用它上面的电话插件时要按照他执行的格式。首先看一下他要求的格式：[ { "employee_id" : 191, "remark" : "王科研",https://blog.csdn.net/YEN_CSDN/article/details/71273458