# SupportSQLiteProgram

added in[version 1.1.0](https://developer.android.com/topic/libraries/support-library/revisions)  
belongs to Maven artifact android.arch.persistence:db:1.1.0-beta2  
Summary:[Methods](https://developer.android.com/reference/android/arch/persistence/db/SupportSQLiteProgram#pubmethods)\|[Inherited Methods](https://developer.android.com/reference/android/arch/persistence/db/SupportSQLiteProgram#inhmethods)  

# SupportSQLiteProgram

| The`android.arch`Architecture Components packages are no longer maintained. They have been superseded by the corresponding[androidx.\*](https://developer.android.com/jetpack/androidx/migrate)packages. See[androidx.sqlite.db.SupportSQLiteProgram](https://developer.android.com/reference/androidx/sqlite/db/SupportSQLiteProgram)instead.

`
public


interface
SupportSQLiteProgram
`  
`


implements

Closeable


`

|--------------------------------------------------|
| android.arch.persistence.db.SupportSQLiteProgram |

|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| Known indirect subclasses [SupportSQLiteStatement](https://developer.android.com/reference/android/arch/persistence/db/SupportSQLiteStatement) |----------------------------------------------------------------------------------------------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------| | [SupportSQLiteStatement](https://developer.android.com/reference/android/arch/persistence/db/SupportSQLiteStatement) | An interface to map the behavior of[SQLiteStatement](https://developer.android.com/reference/android/database/sqlite/SQLiteStatement.html). | |

<br />

*** ** * ** ***

An interface to map the behavior of[SQLiteProgram](https://developer.android.com/reference/android/database/sqlite/SQLiteProgram.html).

## Summary

|                                                                                                        ### Public methods                                                                                                        ||
|------------------|----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| ` abstract void` | ` `[bindBlob](https://developer.android.com/reference/android/arch/persistence/db/SupportSQLiteProgram#bindBlob(int, byte[]))`(int index, byte[] value) ` Bind a byte array value to this statement.           |
| ` abstract void` | ` `[bindDouble](https://developer.android.com/reference/android/arch/persistence/db/SupportSQLiteProgram#bindDouble(int, double))`(int index, double value) ` Bind a double value to this statement.           |
| ` abstract void` | ` `[bindLong](https://developer.android.com/reference/android/arch/persistence/db/SupportSQLiteProgram#bindLong(int, long))`(int index, long value) ` Bind a long value to this statement.                     |
| ` abstract void` | ` `[bindNull](https://developer.android.com/reference/android/arch/persistence/db/SupportSQLiteProgram#bindNull(int))`(int index) ` Bind a NULL value to this statement.                                       |
| ` abstract void` | ` `[bindString](https://developer.android.com/reference/android/arch/persistence/db/SupportSQLiteProgram#bindString(int, java.lang.String))`(int index, String value) ` Bind a String value to this statement. |
| ` abstract void` | ` `[clearBindings](https://developer.android.com/reference/android/arch/persistence/db/SupportSQLiteProgram#clearBindings())`() ` Clears all existing bindings.                                                |

| ### Inherited methods |
|-----------------------|---|
| From interface` java.io.Closeable ` |------------------|-------------| | ` abstract void` | ` close() ` | ||
| From interface` java.lang.AutoCloseable ` |------------------|-------------| | ` abstract void` | ` close() ` | ||

## Public methods

### bindBlob

added in[version 1.1.0](https://developer.android.com/topic/libraries/support-library/revisions)  

```
void bindBlob (int index, 
                byte[] value)
```

Bind a byte array value to this statement. The value remains bound until[clearBindings()](https://developer.android.com/reference/android/arch/persistence/db/SupportSQLiteProgram#clearBindings())is called.

<br />

|                            Parameters                             ||
|---------|----------------------------------------------------------|
| `index` | `int`: The 1-based index to the parameter to bind <br /> |
| `value` | `byte`: The value to bind, must not be null <br />       |

### bindDouble

added in[version 1.1.0](https://developer.android.com/topic/libraries/support-library/revisions)  

```
void bindDouble (int index, 
                double value)
```

Bind a double value to this statement. The value remains bound until[clearBindings()](https://developer.android.com/reference/android/arch/persistence/db/SupportSQLiteProgram#clearBindings())is called.

<br />

|                            Parameters                             ||
|---------|----------------------------------------------------------|
| `index` | `int`: The 1-based index to the parameter to bind <br /> |
| `value` | `double`: The value to bind <br />                       |

### bindLong

added in[version 1.1.0](https://developer.android.com/topic/libraries/support-library/revisions)  

```
void bindLong (int index, 
                long value)
```

Bind a long value to this statement. The value remains bound until[clearBindings()](https://developer.android.com/reference/android/arch/persistence/db/SupportSQLiteProgram#clearBindings())is called. addToBindArgs

<br />

|                            Parameters                             ||
|---------|----------------------------------------------------------|
| `index` | `int`: The 1-based index to the parameter to bind <br /> |
| `value` | `long`: The value to bind <br />                         |

### bindNull

added in[version 1.1.0](https://developer.android.com/topic/libraries/support-library/revisions)  

```
void bindNull (int index)
```

Bind a NULL value to this statement. The value remains bound until[clearBindings()](https://developer.android.com/reference/android/arch/persistence/db/SupportSQLiteProgram#clearBindings())is called.

<br />

|                                Parameters                                 ||
|---------|------------------------------------------------------------------|
| `index` | `int`: The 1-based index to the parameter to bind null to <br /> |

### bindString

added in[version 1.1.0](https://developer.android.com/topic/libraries/support-library/revisions)  

```
void bindString (int index, 
                String value)
```

Bind a String value to this statement. The value remains bound until[clearBindings()](https://developer.android.com/reference/android/arch/persistence/db/SupportSQLiteProgram#clearBindings())is called.

<br />

|                            Parameters                             ||
|---------|----------------------------------------------------------|
| `index` | `int`: The 1-based index to the parameter to bind <br /> |
| `value` | `String`: The value to bind, must not be null <br />     |

### clearBindings

added in[version 1.1.0](https://developer.android.com/topic/libraries/support-library/revisions)  

```
void clearBindings ()
```

Clears all existing bindings. Unset bindings are treated as NULL.

<br />

-

  ## Interfaces

  - [SupportSQLiteDatabase](https://developer.android.com/reference/android/arch/persistence/db/SupportSQLiteDatabase)
  - [SupportSQLiteOpenHelper](https://developer.android.com/reference/android/arch/persistence/db/SupportSQLiteOpenHelper)
  - [SupportSQLiteOpenHelper.Factory](https://developer.android.com/reference/android/arch/persistence/db/SupportSQLiteOpenHelper.Factory)
  - [SupportSQLiteProgram](https://developer.android.com/reference/android/arch/persistence/db/SupportSQLiteProgram)
  - [SupportSQLiteQuery](https://developer.android.com/reference/android/arch/persistence/db/SupportSQLiteQuery)
  - [SupportSQLiteStatement](https://developer.android.com/reference/android/arch/persistence/db/SupportSQLiteStatement)
-

  ## Classes

  - [SimpleSQLiteQuery](https://developer.android.com/reference/android/arch/persistence/db/SimpleSQLiteQuery)
  - [SupportSQLiteOpenHelper.Callback](https://developer.android.com/reference/android/arch/persistence/db/SupportSQLiteOpenHelper.Callback)
  - [SupportSQLiteOpenHelper.Configuration](https://developer.android.com/reference/android/arch/persistence/db/SupportSQLiteOpenHelper.Configuration)
  - [SupportSQLiteOpenHelper.Configuration.Builder](https://developer.android.com/reference/android/arch/persistence/db/SupportSQLiteOpenHelper.Configuration.Builder)
  - [SupportSQLiteQueryBuilder](https://developer.android.com/reference/android/arch/persistence/db/SupportSQLiteQueryBuilder)