How to use

close

method

in

android.database.sqlite.SQLiteStatement

@Override
public void close() {
  delegate.close();
}

  private void close() {
    insertStatement.close();
    deleteStatement.close();
  }
}

  public void destroy() {
    if (countReadyStmt != null) {
      countReadyStmt.close();
      countReadyStmt = null;
    }
    if (nextJobDelayUntilStmt != null) {
      nextJobDelayUntilStmt.close();
      nextJobDelayUntilStmt = null;
    }
  }
}

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