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