Convert SQLite to JSON

Question

when i add data using SQLite is it possible to convert the data to JSON so that when I retrieve data it should be parsed and fetch data.If possible explain with example.

Answer 1

When you fetch data from your SQLiteDatabase, it is returned in a Cursor. Unfortunately there's no such direct format to convert data from a cursor to JSON, but you can do it with some code like:

private JSONArray convertCursorToJSON(Cursor cursor) {
  JSONArray result = new JSONArray();

  int columnCount = cursor.getColumnCount();
  while (cursor.moveToNext()) {
    JSONObject row = new JSONObject();
    for (int index = 0; index < columnCount; index++) {
      row.put(cursor.getColumnName(index), cursor.getString(index));
    }
    result.put(row);
  }
  cursor.close();

  return result;
}

Answer 2

you can modify and use the following according to your need.

    Gson gson = new GsonBuilder().create();

    //wordList should be your arraylistdata or values etc which you want to insert 
    //Use GSON to serialize Array List to JSON
   gson.toJson(wordList);

use this while storing your data