@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(); } }