I have multiple records in sqlite table, and now i am trying to upload all data on button click
For that i have written below code:
Cursor cursor = databaseDataHelper.getAllData();
JSONArray arr = new JSONArray();
JSONObject jobj ;
cursor.moveToFirst();
if(cursor.moveToFirst()) {
do {
jobj = new JSONObject();
try {
jobj.put("ImageName", cursor.getString(cursor.getColumnIndex("Name")));
jobj.put("Title", cursor.getString(cursor.getColumnIndex("Title")));
} catch (JSONException e) {
e.printStackTrace();
}
} while(cursor.moveToNext());
try {
jobj.put("data", arr);
} catch (JSONException e) {
e.printStackTrace();
}
String st = jobj.toString();
Log.d("database::--", st);
String url = "http://ift.tt/1GKx6ro";
List<NameValuePair> params = new ArrayList<NameValuePair>();
params.add(new BasicNameValuePair("Data", st));
String resultServer = helper.getHttpPost(url,params);
Log.d("Entire string::", " " + resultServer);
/*** Default Value ***/
strStatusId = "0";
strMessage = "";
try {
jsonObject = new JSONObject(resultServer);
strStatusId = jsonObject.getString("StatusID");
strMessage = jsonObject.getString("Message");
} catch (JSONException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
whenever i do tap on button, log says:
database::--(22393): {"data":[],"Name":"Name1","Title":"Title1"}
Whereas it should be something like this:
{"data":[
{
"Name":"Name1",
"Title":"Title1"
},
{
"Name":"Name2",
"Title":"Title2"
}
]}
Aucun commentaire:
Enregistrer un commentaire