I am initializing my variables as follows:
String separator = "" ;
String insertQuery1 = "INSERT INTO " + PhoneContactsTable.TABLE_PHONE_CONTACTS + " (" +
PhoneContactsTable.KEY_NAME +"," + PhoneContactsTable.KEY_PH_NO +","
+ PhoneContactsTable.KEY_SNID +","+ PhoneContactsTable.KEY_EMAIL +") VALUES " ;
StringBuilder insertQuery2 = new StringBuilder();
I am generating insertQuery2(stringbuilder) as follows:
try
{
JSONArray jsonArray = new JSONArray(returndResultForSNID);
for(int i = 0; i < jsonArray.length(); i++)
{
snid = jsonArray.getJSONObject(i).getString("snid");
insertQuery2.append(separator).append("('").append(contactNameArr.get(i).toString()).append("','").append(contactPhoneNumberArr.get(i).toString()).append("','")
.append(snid).append("',").append("''").append(")");
separator = "," ;
}
}
catch (Exception e)
{
System.out.println( "Could not parse malformed JSONArray: " + e.toString() );
}
I am creating the last String as insertQuery3 which is being inserted into database:
try
{
String insertQuery3 = insertQuery1 + (insertQuery2.toString()).toString();
phoneContactsDAO.open(false);
phoneContactsDAO.addFullStringToDb(insertQuery3);
phoneContactsDAO.close();
}
catch (Exception e)
{
System.out.println( "Could not added into database: " + e.toString() );
}
My database query is as follows which seem fine:
public void addFullStringToDb(String insertQuery3)
{
database.execSQL(insertQuery3);
}
This code worked in 4phones. But is not working on a 5th device
Aucun commentaire:
Enregistrer un commentaire