android Cursor to JSONArray

Question

how can I "convert" a Cursor to a JSONArray?

my cursor as 3columns (_id, name, birth)

I've searched but I can't not find any examples

Adonias Vasquez · Accepted Answer · 2014-10-27 23:53:13Z

25

Cursor to JSONArray

public JSONArray cur2Json(Cursor cursor) {

    JSONArray resultSet = new JSONArray();
    cursor.moveToFirst();
    while (cursor.isAfterLast() == false) {
        int totalColumn = cursor.getColumnCount();
        JSONObject rowObject = new JSONObject();   
        for (int i = 0; i < totalColumn; i++) {
            if (cursor.getColumnName(i) != null) {
                try {
                    rowObject.put(cursor.getColumnName(i),
                            cursor.getString(i));
                } catch (Exception e) {
                    Log.d(TAG, e.getMessage());
                }
            }
        }
        resultSet.put(rowObject);
        cursor.moveToNext();
    }

    cursor.close();
    return resultSet;

}

edited Oct 27, 2014 at 23:53

answered Sep 28, 2014 at 11:42

Adonias Vasquez

1,01414 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

zeeshan Over a year ago

What it totalColumn here?

Adonias Vasquez Over a year ago

int totalColumn = cursor.getColumnCount();

zeeshan Over a year ago

Thanks. I had figured this out. This code works perfectly fine for me.

Pratik Butani Over a year ago

Simplify cursor.isAfterLast() == false => !cursor.isAfterLast()

Krushnakant · Accepted Answer · 2017-12-25 09:46:24Z

12

private String cursorToString(Cursor crs) {
    JSONArray arr = new JSONArray();
    crs.moveToFirst();
    while (!crs.isAfterLast()) {
        int nColumns = crs.getColumnCount();
        JSONObject row = new JSONObject();
        for (int i = 0 ; i < nColumns ; i++) {
            String colName = crs.getColumnName(i);
            if (colName != null) {
                String val = "";
                try {
                    switch (crs.getType(i)) {
                    case Cursor.FIELD_TYPE_BLOB   : row.put(colName, crs.getBlob(i).toString()); break;
                    case Cursor.FIELD_TYPE_FLOAT  : row.put(colName, crs.getDouble(i))         ; break;
                    case Cursor.FIELD_TYPE_INTEGER: row.put(colName, crs.getLong(i))           ; break;
                    case Cursor.FIELD_TYPE_NULL   : row.put(colName, null)                     ; break;
                    case Cursor.FIELD_TYPE_STRING : row.put(colName, crs.getString(i))         ; break;
                    }
                } catch (JSONException e) {
                }
            }
        }
        arr.put(row);
        if (!crs.moveToNext())
            break;
    }
    crs.close(); // close the cursor
    return arr.toString();
}

edited Dec 25, 2017 at 9:46

Krushnakant

592 gold badges2 silver badges9 bronze badges

answered Jan 30, 2014 at 10:55

grebulon

8,1025 gold badges47 silver badges73 bronze badges

1 Comment

Acuna Over a year ago

It's absolutely what I need, because my Cursor have different types of data.

Just Variable · Accepted Answer · 2012-10-25 14:32:08Z

5

You can't convert the contents of a cursor directly into a JSONObject, but you can do that with some logic.

for eg: retrieve the Strings from the cursor, form a String which follows the JSON format, and use it to make a json object :

JSONObject jFromCursor=new JSONObject(string_in_JSON_format);

answered Oct 25, 2012 at 14:32

Just Variable

87710 silver badges20 bronze badges

2 Comments

Luis Neves Over a year ago

So I need to iterate the cursor and concatenate the Strings ("_id: " + cursor.getString(0) ", "name: "" + cursor.getString(1) ", "birth: "" + cursor.getString(2))???

Michael Over a year ago

Well this is just silly if the whole reason to get a JSON object is to then convert it to a string in JSON format using toString()!

Collectives™ on Stack Overflow

android Cursor to JSONArray

3 Answers 3

4 Comments

1 Comment

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related