通过Java执行http客户端时的JSONObject文本格式错误

Question

在下面的代码中，我正在执行HTTP客户端以获得响应。

public String exmp(StringBuilder sql, String table){
    authCache = new BasicAuthCache();
    basicAuth = new BasicScheme();
    authCache.put(target, basicAuth);

    localContext = HttpClientContext.create();
    localContext.setAuthCache(authCache);
    String postJsonstr=null;
    try {
        HttpPost httpPost = new HttpPost(API_URL);

        StringBuilder str = new StringBuilder();
        str.append("{");
        str.append("\"format\":\"csv\",");
        str.append("\"version\":\"1.0\",");
        str.append("\"name\":\""+table+"\",");
        str.append("\"encrypted\":\"none\",");
        str.append("\"queries\":[{");
        str.append("\"name\":\""+table+"\",");
        str.append("\"query\":\"" + sql + "\",");
        str.append("\"type\":\"export\"");
        str.append("}]");
        str.append("}");

        httpPost.addHeader("accept", jsonContentType);
        StringEntity posEnt = new StringEntity(str.toString().trim());
        posEnt.setContentType(jsonContentType);
        httpPost.setEntity(posEnt);

        CloseableHttpResponse response = httpclient.execute(target, httpPost, localContext);}

当我执行这段代码时，我得到的错误是:org.json.jsonException:JSONObject文本必须以“{”开头，位于1[字符2行1]。

我尝试执行system.out.println((int)sb.tostring().trim().charat(0))；查看第一个字符是什么，根据一些文章，它是123，这是“{”的正确代码。

更新的代码：这是我使用JSONObject更新的代码。我仍然得到同样的错误

public String exmp(StringBuilder sql, String table){
        authCache = new BasicAuthCache();
        basicAuth = new BasicScheme();
        authCache.put(target, basicAuth);

        localContext = HttpClientContext.create();
        localContext.setAuthCache(authCache);
        String postJsonstr=null;
        try {
            HttpPost httpPost = new HttpPost(API_URL);

            JSONObject sbjson = new JSONObject();
            sbjson.put("format", "csv");
            sbjson.put("version", "1.0");
            sbjson.put("name", table);
            sbjson.put("encrypted", "none");

            JSONArray array = new JSONArray();
            JSONObject item = new JSONObject();
            item.put("name", table);
            item.put("query", sql);
            item.put("type", "export");
            array.put(item);

            sbjson.put("queries", array);

            httpPost.addHeader("accept", jsonContentType);
            StringEntity postEntity = new StringEntity(sbjson.toString());
            posEnt.setContentType(jsonContentType);
            httpPost.setEntity(posEnt);

            CloseableHttpResponse response = httpclient.execute(target, httpPost, localContext);}

Answer 1

String.format("{\"format \":\"csv \""
            + ",\"version \":\"1.0 \""
            + ",\"name \":\"%s\""
            + ",\"encrypted \":\"none \""
            + ",\"queries \":[{\"name \":\"%s\"\""
                           + ",\"query\":\"%s\""
                           + ",\"type\":\"export\"}]}",
              table, table, sql);