How to use

executeUpdateDelete

method

in

android.database.sqlite.SQLiteStatement

@TargetApi(DatabaseConstants.MIN_API_LEVEL)
private <T> T executeUpdateDelete(
  SQLiteDatabase database,
  String query,
  ExecuteResultHandler<T> handler) {
 SQLiteStatement statement = database.compileStatement(query);
 int count = statement.executeUpdateDelete();
 return handler.handleUpdateDelete(count);
}

void remove(String key) {
  deleteStatement.bindString(1, key);
  deleteStatement.executeUpdateDelete();
  deleteStatement.clearBindings();
  workingStorage.remove(key);
}

 String sql = "UPDATE table_name SET column_2=? WHERE column_1=?";
SQLiteStatement statement = db.compileStatement(sql);

int id = 7;
String stringValue = "hi there";

statement.bindString(1, stringValue);
statement.bindLong(2, id);

int numberOfRowsAffected = statement.executeUpdateDelete();

for (long id : toRemove) {
 statement.bindLong(1, id);
 statement.executeUpdateDelete();

@Test
public void testExecuteUpdateDelete() throws Exception {
 SQLiteStatement insertStatement = database.compileStatement("INSERT INTO `routine` (`name`) VALUES (?)");
 insertStatement.bindString(1, "Hand Press");
 long pkeyOne = insertStatement.executeInsert();
 assertThat(pkeyOne).isEqualTo(1);
 SQLiteStatement updateStatement = database.compileStatement("UPDATE `routine` SET `name`=? WHERE `id`=?");
 updateStatement.bindString(1, "Head Press");
 updateStatement.bindLong(2, pkeyOne);
 assertThat(updateStatement.executeUpdateDelete()).isEqualTo(1);
 Cursor dataCursor = database.rawQuery("SELECT `name` FROM `routine`", null);
 assertThat(dataCursor.moveToNext()).isTrue();
 assertThat(dataCursor.getString(0)).isEqualTo("Head Press");
}

@Override
public int executeUpdateDelete() {
  return statement.executeUpdateDelete();
}

rowsAffected = myStatement.executeUpdateDelete();

rowsAffected = myStatement.executeUpdateDelete();

@Override
public int executeUpdateDelete(String sql, Object[] bindArgs) {
  SQLiteStatement statement = null;
  try {
    statement = db.compileStatement(sql);
    SquidCursorFactory.bindArgumentsToProgram(statement, bindArgs);
    return statement.executeUpdateDelete();
  } finally {
    if (statement != null) {
      statement.close();
    }
  }
}

/**
 * Update delete.
 *
 * @param ps the ps
 * @param contentValues the content values
 * @return the int
 */
public static int updateDelete(SQLiteStatement ps, KriptonContentValues contentValues) {
  contentValues.bind(ps);
  return ps.executeUpdateDelete();
}

/**
 * Update delete.
 *
 * @param ps the ps
 * @param contentValues the content values
 * @return the int
 */
public static int updateDelete(SQLiteStatement ps, KriptonContentValues contentValues) {
  contentValues.bind(ps);
  return ps.executeUpdateDelete();
}

 public int delete(String table, String whereClause, String[] whereArgs) {
  ...
  SQLiteStatement statement = new SQLiteStatement(this, "DELETE FROM " + table +
      (!TextUtils.isEmpty(whereClause) ? " WHERE " + whereClause : ""), whereArgs);
  try {
    return statement.executeUpdateDelete();
  } finally {
    statement.close();
  }
  ...
}

@SuppressLint("ObsoleteSdkInt")
private void executeSafeUpdateOrDelete(SQLiteStatement statement) {
  if (Build.VERSION.SDK_INT >= Build.VERSION_CODES.HONEYCOMB) {
    statement.executeUpdateDelete();
  }
  else {
    statement.execute();
  }
}

 final SQLiteStatement stmt = db.compileStatement("UPDATE " +       
  DataProviderContract.STORAGE.TABLE_NAME + " SET " +
  DataProviderContract.STORAGE.TRIES + " = " +  
  DataProviderContract.STORAGE.TRIES + " +1 WHERE " +
  DataProviderContract.STORAGE.HASHNAME + " = ?");
stmt.bindString(1, hashName);
final int rows = stmt.executeUpdateDelete();

@TargetApi(DatabaseConstants.MIN_API_LEVEL)
private <T> T executeUpdateDelete(
    SQLiteDatabase database,
    String query,
    ExecuteResultHandler<T> handler) {
  SQLiteStatement statement = database.compileStatement(query);
  int count = statement.executeUpdateDelete();
  return handler.handleUpdateDelete(count);
}

 SQLiteDatabase db = ...; // get your database
String sql = "UPDATE tableName SET columnName = columnName + 1 WHERE id = 1";
SQLiteStatement statement = db.compileStatement(sql);
int affected = statement.executeUpdateDelete();
statement.close();

 String sql = "UPDATE table_name SET column_2=? WHERE column_1=?";
SQLiteStatement statement = db.compileStatement(sql);

int id = 7;
String stringValue = "hi there";

statement.bindString(1, stringValue);
statement.bindLong(2, id); // These match to the two question marks in the sql string

int numberOfRowsAffected = statement.executeUpdateDelete();

void updateLastRunTime(long id, long lastRunTime) {
  updateLastRunTimeStatement.bindLong(1, lastRunTime);
  updateLastRunTimeStatement.bindLong(2,id);
  updateLastRunTimeStatement.executeUpdateDelete();
}

 SQLiteStatement stmt = db.compileStatement("UPDATE mytable SET val_1=?, val_2=?, val_3=?, totalVal=val_1+val_2+val_3 WHERE expr");
stmt.bindLong(1, 1);
stmt.bindLong(2, 3);
stmt.bindLong(3, 5);
stmt.executeUpdateDelete();

private void resetFirstMessageId(UUID server, String channel) {
  synchronized (mDatabaseLock) {
    waitForDatabase();
    mResetFirstMessageIdStatement.bindString(1, server.toString());
    mResetFirstMessageIdStatement.bindString(2, channel);
    mResetFirstMessageIdStatement.executeUpdateDelete();
    mResetFirstMessageIdStatement.clearBindings();
  }
}