Applications use these classes to manage private databases. If creating a content provider, you will probably have to use these classes to create and manage your own database to store content. See Content Providers to learn the conventions for implementing a content provider. See the NotePadProvider class in the NotePad sample application in the SDK for an example of a content provider. Android ships with SQLite version 3.4.0
If you are working with data sent to you by a provider, you will not use these SQLite classes, but instead use the generic Android.Database classes.
Android ships with the sqlite3 database tool in the tools/ folder. You can use this tool to browse or run SQL commands on the device. Run by typing sqlite3 in a shell window.
| Type | Reason |
|---|---|
| Conflict | Enumerates values returned by several types and taken as a parameter of the Android.Database.Sqlite.SQLiteDatabase.InsertWithOnConflict, and Android.Database.Sqlite.SQLiteDatabase.UpdateWithOnConflict members. |
| DatabaseOpenFlags | Enumerates values returned by several methods of Android.Database.Sqlite.DatabaseOpenFlags and taken as a parameter of the Android.Database.Sqlite.SQLiteDatabase.OpenDatabase, and Android.Database.Sqlite.SQLiteDatabase.OpenDatabase members. |
| ISQLiteCursorDriver | A driver for SQLiteCursors that is used to create them and gets notified by the cursors it creates on significant events in their lifetimes. |
| ISQLiteTransactionListener | A listener for transaction events. |
| SQLiteAbortException | An exception that indicates that the SQLite program was aborted. |
| SQLiteAccessPermException | This exception class is used when sqlite can't access the database file due to lack of permissions on the file. |
| SQLiteBindOrColumnIndexOutOfRangeException | Thrown if the the bind or column parameter index is out of range |
| SQLiteBlobTooBigException | [Android Documentation] |
| SQLiteCantOpenDatabaseException | [Android Documentation] |
| SQLiteClosable | An object created from a SQLiteDatabase that can be closed. |
| SQLiteConstraintException | An exception that indicates that an integrity constraint was violated. |
| SQLiteCursor | A Cursor implementation that exposes results from a query on a Android.Database.Sqlite.SQLiteDatabase. |
| SQLiteDatabase | Exposes methods to manage a SQLite database. |
| SQLiteDatabase+ICursorFactory | Used to allow returning sub-classes of Android.Database.ICursor when calling query. |
| SQLiteDatabaseCorruptException | An exception that indicates that the SQLite database file is corrupt. |
| SQLiteDatabaseLockedException | Thrown if the database engine was unable to acquire the database locks it needs to do its job. |
| SQLiteDatatypeMismatchException | [Android Documentation] |
| SQLiteDiskIOException | An exception that indicates that an IO error occured while accessing the SQLite database file. |
| SQLiteDoneException | An exception that indicates that the SQLite program is done. |
| SQLiteException | A SQLite exception that indicates there was an error with SQL parsing or execution. |
| SQLiteFullException | An exception that indicates that the SQLite database is full. |
| SQLiteMisuseException | This error can occur if the application creates a SQLiteStatement object and allows multiple threads in the application use it at the same time. |
| SQLiteOpenHelper | A helper class to manage database creation and version management. |
| SQLiteOutOfMemoryException | [Android Documentation] |
| SQLiteProgram | A base class for compiled SQLite programs. |
| SQLiteQuery | Represents a query that reads the resulting rows into a Android.Database.Sqlite.SQLiteQuery. |
| SQLiteQueryBuilder | This is a convience class that helps build SQL queries to be sent to Android.Database.Sqlite.SQLiteDatabase objects. |
| SQLiteReadOnlyDatabaseException | [Android Documentation] |
| SQLiteStatement | Represents a statement that can be executed against a database. |
| SQLiteTableLockedException | [Android Documentation] |