在android中创建Json multiple Array String

Question

我尝试创建包含多个JsonArray和JsonObject的Json字符串。我想创建Json字符串的格式如下所示:

[
{
    "CustomerId": -1,
    "PoolGuyId": 117,
    "FilterChanges": [
        {
            "FilterChangeId": -1,
            "CustomerId": -1,
            "Reminders": [
                {
                    "ReminderId": -1,
                    "FilterChangeId": -1,
                    "CustomerId": -1
                },
                {
                    "ReminderId": -2,
                    "FilterChangeId": -1,
                    "CustomerId": -1
                }
            ]
        },
        {
            "FilterChangeId": -2,
            "CustomerId": -1,
            "Reminders": [
                {
                    "ReminderId": -3,
                    "FilterChangeId": -1,
                    "CustomerId": -1
                }
            ]
        }
    ],
    "IsDeleted": false
}
]

我尝试了很多参考，但我的字符串仍然没有创建。帮我

我从数据库中获得价值。在sqlite数据库中有3个表，分别命名为customerDetails, JobHistory, reminders。在这些表中存储多个值。

try {
        customerDetailsTable = new CustomerDetailsTable(con);
        customerDetailsTable.open();
        arrayListCustomer = customerDetailsTable.getAllContacts();
        customerDetailsTable.close();
        JSONObject objCust = null;
        JSONArray jsonArrayCust = new JSONArray();
        for (int i = 0; i < arrayListCustomer.size(); i++) {
            customerDetailsSetGet = arrayListCustomer.get(i);
            objCust = new JSONObject();
            try {
                objCust.put("CustomerId", customerDetailsSetGet.getCustomerID());
                objCust.put("PoolGuyId", customerDetailsSetGet.getPoolGuyId());
               } catch (JSONException e) {
            }
            ArrayList<JobHistorySetGet> arrayListjobHistory = new ArrayList<>();
            jobHistoryTable = new JobHistoryTable(con);
            jobHistoryTable.open();
            arrayListjobHistory = jobHistoryTable.getJobsAsPerCustId(customerDetailsSetGet.getCustomerID());
            jobHistoryTable.close();
            JSONObject objJobHis = null;
            JSONArray jsonArrayJob = new JSONArray();
            for (int j = 0; j < arrayListjobHistory.size(); j++) {
                jobHistorySetGet = arrayListjobHistory.get(j);
                objJobHis = new JSONObject();
                try {
                    objJobHis.put("FilterChangeId", jobHistorySetGet.getFilterChangeId());
                    objJobHis.put("CustomerId", jobHistorySetGet.getCustomerId());
                } catch (JSONException e) {
                }
                ArrayList<ReminderSetGet> arrayListReminder = new ArrayList<>();
                reminderTable = new ReminderTable(con);
                reminderTable.open();
                arrayListReminder = reminderTable.getReminderAsPerJobID(jobHistorySetGet.getId());
                reminderTable.close();
                JSONArray jsonArrayReminder = new JSONArray();
                JSONObject objReminder = null;
                for (int k = 0; k < arrayListReminder.size(); k++) {
                    reminderSetGet = arrayListReminder.get(k);
                    objReminder = new JSONObject();
                    try {
                        Log.d("Anuj", "9");
                        objReminder.put("ReminderId", reminderSetGet.getReminderId());
                        objReminder.put("FilterChangeId", reminderSetGet.getFilterChangeId());
                        objReminder.put("CustomerId", reminderSetGet.getCustomerId());
                        jsonArrayReminder.put(objReminder);
                    } catch (JSONException e) {
                    }
                }
                objJobHis.put("Reminders", jsonArrayJob.toString());
                jsonArrayJob.put(objJobHis);
            }
            objCust.putOpt("FilterChanges", jsonArrayJob.toString());
            jsonArrayCust.put(objCust);
         }
        JSONObject finalobject = new JSONObject();
        finalobject.put("Final", jsonArrayCust.toString());
    } catch (SQLException e) {
        e.printStackTrace();
    } catch (JSONException e) {
        e.printStackTrace();
    }catch (Exception e) {
        e.printStackTrace();
    }

我的要求是在层次顺序意味着可能有多个客户表，在每个客户表中将有多个job和在每个job中，将有多个提醒

Answer 1

试试这个，这个是基于你的json制作json字符串。

try {
        customerDetailsTable = new CustomerDetailsTable(con);
        customerDetailsTable.open();
        arrayListCustomer = customerDetailsTable.getAllContacts();
        customerDetailsTable.close();
        JSONObject objCust = null;
        JSONArray jsonArrayCust = new JSONArray();
        for (int i = 0; i < arrayListCustomer.size(); i++) {
            customerDetailsSetGet = arrayListCustomer.get(i);
            objCust = new JSONObject();
            try {
                objCust.put("CustomerId", customerDetailsSetGet.getCustomerID());
                objCust.put("PoolGuyId", customerDetailsSetGet.getPoolGuyId());
            } catch (JSONException e) {
            }
            ArrayList<JobHistorySetGet> arrayListjobHistory = new ArrayList<>();
            jobHistoryTable = new JobHistoryTable(con);
            jobHistoryTable.open();
            arrayListjobHistory = jobHistoryTable.getJobsAsPerCustId(customerDetailsSetGet.getCustomerID());
            jobHistoryTable.close();
            JSONObject objJobHis = null;
            JSONArray jsonArrayJob = new JSONArray();
            for (int j = 0; j < arrayListjobHistory.size(); j++) {
                jobHistorySetGet = arrayListjobHistory.get(j);
                objJobHis = new JSONObject();
                try {
                    objJobHis.put("FilterChangeId", jobHistorySetGet.getFilterChangeId());
                    objJobHis.put("CustomerId", jobHistorySetGet.getCustomerId());
                } catch (JSONException e) {
                }
                ArrayList<ReminderSetGet> arrayListReminder = new ArrayList<>();
                reminderTable = new ReminderTable(con);
                reminderTable.open();
                arrayListReminder = reminderTable.getReminderAsPerJobID(jobHistorySetGet.getId());
                reminderTable.close();
                JSONArray jsonArrayReminder = new JSONArray();
                JSONObject objReminder = null;
                for (int k = 0; k < arrayListReminder.size(); k++) {
                    reminderSetGet = arrayListReminder.get(k);
                    objReminder = new JSONObject();
                    try {
                        Log.d("Anuj", "9");
                        objReminder.put("ReminderId", reminderSetGet.getReminderId());
                        objReminder.put("FilterChangeId", reminderSetGet.getFilterChangeId());
                        objReminder.put("CustomerId", reminderSetGet.getCustomerId());
                        jsonArrayReminder.put(objReminder);
                    } catch (JSONException e) {
                    }
                }
                objJobHis.put("Reminders",jsonArrayReminder);
                jsonArrayJob.put(objJobHis);
            }
            objCust.putOpt("FilterChanges", jsonArrayJob);
            jsonArrayCust.put(objCust);
        }
        JSONObject finalobject = new JSONObject();
        finalobject.put("Final", jsonArrayCust);
    } catch (SQLException e) {
        e.printStackTrace();
    } catch (JSONException e) {
        e.printStackTrace();
    }catch (Exception e) {
        e.printStackTrace();
    }