mardi 15 décembre 2015

How to remove the double quotes in the JSON?

From the database I get JSON in the following manner

 String DB_PATH = "/data/data/http://ift.tt/1NSaxHo";
 String myPath = DB_PATH + DBHelper.DATABASE_NAME;// Set path to your database
 String myTable = DBHelper.TABLE_CONTACT;//Set name of your table
 SQLiteDatabase myDataBase = SQLiteDatabase.openDatabase(myPath, null, SQLiteDatabase.OPEN_READONLY);

    String searchQuery = "SELECT  * FROM " + myTable;
    Cursor cursor = myDataBase.rawQuery(searchQuery, null );

    JSONArray json = 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 {
                    if(cursor.getString(i) != null) {
                        Log.d("TAG_NAME", cursor.getString(i));
                        rowObject.put(cursor.getColumnName(i), cursor.getString(i));
                    } else {
                        rowObject.put(cursor.getColumnName(i), "");
                    }
                }
                catch(Exception e) {
                    Log.d("TAG_NAME", e.getMessage());
                }
            }
        }
        json.put(rowObject);
        cursor.moveToNext();
    }
    cursor.close();
    Log.d("TAG_NAME_ALL", json.toString());
    return json.toString();

JSON coming out correct, except for one value latlng.

I get - "latlng": "[12.3456789,98.7654321]"

Need to get - "latlng": [12.3456789,98.7654321]

How to get rid from double quotes?

Aucun commentaire:

Enregistrer un commentaire