@Override public void close() { delegate.close(); }
private void tryCloseStatement(SQLiteStatement statement) { if (statement != null) { statement.close(); } } }
return stmt.simpleQueryForLong(); } finally { stmt.close();
@Test public void testExecuteInsertShouldCloseGeneratedKeysResultSet() throws Exception { // NOTE: // As a side-effect we will get "database locked" exception // on rollback if generatedKeys wasn't closed // // Don't know how suitable to use Mockito here, but // it will be a little bit simpler to test ShadowSQLiteStatement // if actualDBStatement will be mocked database.beginTransaction(); try { SQLiteStatement insertStatement = database.compileStatement("INSERT INTO `routine` " + "(`name` ,`lastUsed`) VALUES ('test',0)"); try { insertStatement.executeInsert(); } finally { insertStatement.close(); } } finally { database.endTransaction(); } }
@Test public void testCloseShouldCloseUnderlyingPreparedStatement() throws Exception { SQLiteStatement insertStatement = database.compileStatement("INSERT INTO `routine` (`name`) VALUES (?)"); insertStatement.bindString(1, "Hand Press"); insertStatement.close(); try { insertStatement.executeInsert(); fail(); } catch (Exception e) { assertThat(e).isInstanceOf(IllegalStateException.class); } } }
@Override public void close() { statement.close(); }
@Override public void ensureSqlCompiles(String sql) { if (Build.VERSION.SDK_INT >= Build.VERSION_CODES.JELLY_BEAN) { SQLiteStatement statement = null; try { statement = db.compileStatement(sql); } finally { if (statement != null) { statement.close(); } } } else { Cursor c = db.rawQuery(sql, null); if (c != null) { c.close(); } } }
@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(); } } }
@Override public long executeInsert(String sql, Object[] bindArgs) { SQLiteStatement statement = null; try { statement = db.compileStatement(sql); SquidCursorFactory.bindArgumentsToProgram(statement, bindArgs); return statement.executeInsert(); } finally { if (statement != null) { statement.close(); } } }
@Override public long simpleQueryForLong(String sql, Object[] bindArgs) { SQLiteStatement statement = null; try { statement = db.compileStatement(sql); SquidCursorFactory.bindArgumentsToProgram(statement, bindArgs); return statement.simpleQueryForLong(); } finally { if (statement != null) { statement.close(); } } }
@Override public String simpleQueryForString(String sql, Object[] bindArgs) { SQLiteStatement statement = null; try { statement = db.compileStatement(sql); SquidCursorFactory.bindArgumentsToProgram(statement, bindArgs); return statement.simpleQueryForString(); } finally { if (statement != null) { statement.close(); } } }
private long performGetLength() { SQLiteDatabase database = mDatabaseSupplier.getDatabase(); if (database == null) { return 0; } String sql = "SELECT count(" + WXSQLiteOpenHelper.COLUMN_KEY + ") FROM " + WXSQLiteOpenHelper.TABLE_STORAGE; SQLiteStatement statement = null; try { statement = database.compileStatement(sql); return statement.simpleQueryForLong(); } catch (Exception e) { WXLogUtils.e(WXSQLiteOpenHelper.TAG_STORAGE, "DefaultWXStorage occurred an exception when execute getLength:" + e.getMessage()); return 0; } finally { if(statement != null) { statement.close(); } } }
/** * We can't use IOUtils here because older versions didn't implement Closeable. */ private void closeQuietly(SQLiteStatement statement) { if (statement != null) { statement.close(); } }
} finally { if(statement != null) { statement.close();
long sumValue = -1L; Database db = ((Application)SugarApp.getSugarContext()).obtainDatabase(); SQLiteDatabase sqLiteDatabase = db.getDB(); SQLiteStatement sqLiteStatement = sqLiteDatabase.compileStatement( "SELECT SUM(column_name) FROM table_name"); try { sumValue = sqLiteStatement.simpleQueryForLong(); } catch (Exception var16) { var16.printStackTrace(); } finally { sqLiteStatement.close(); }
public static boolean isTableEmpty(SQLiteDatabase database, String table) { String sql = "SELECT COUNT(*) FROM " + table; SQLiteStatement statement = database.compileStatement(sql); long records = statement.simpleQueryForLong(); statement.close(); return records == 0; } }
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();
SQLiteDatabase db = dbHelper.getWritableDatabase(); SQLiteStatement stmt = db.compileStatement("INSERT INTO SomeTable (name, age) values (?,?)"); // Careful! The index begins at 1, not 0 !! stmt.bindString(1, "Jon"); stmt.bindLong(2, 48L); stmt.execute(); // Also important! Clean up after yourself. stmt.close();