how convert database data to json string

Question

I have a table in database with 7 columns and want to send the column #0 and #6 of all rows to my server as json.

type of column 0 is Long and 6 is string.

my code:

Cursor c = datasource.db.rawQuery("select * from posts ",null);
    if (c.moveToFirst()) {
                        ArrayList<Object> list = new ArrayList<Object>();
                        do{
                            Object[] b = new Object[]{c.getLong(0),c.getString(6)};
                            list.add(b);
                        } while  (c.moveToNext());
                        JSONArray jsArray = new JSONArray(list);

                        Log.d("states",jsArray.toString());
                    }

my desired output is this:

[[123,"hash1"],[125,"hash2"]]

but app gives me this output:

["[Ljava.lang.String;@b212d8b8","[Ljava.lang.String;@b212d998"]

Take a look at this here , might be helpful: aspdotnet-suresh.com/2013/05/… — dtmnn
– dtmnn, Commented May 16, 2015 at 13:47

saeid ezzati · Accepted Answer · 2015-05-16 14:58:07Z

2

i think you need a array list of JSONArray with primitive type

ArrayList<JSONArray> list = new ArrayList<JSONArray>();

and add values this way

JSONArray jArray = new JSONArray(); 
jArray.put(c.getLong(0));
jArray.put(c.getLong(6));
list.add(jArray);

edited May 16, 2015 at 14:58

saeid ezzati

8911 gold badge11 silver badges30 bronze badges

answered May 16, 2015 at 14:06

rcorbellini

1,3372 gold badges21 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

how convert database data to json string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related