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.
| SQLiteCursorDriver | A driver for SQLiteCursors that is used to create them and gets notified by the cursors it creates on significant events in their lifetimes. |
| SQLiteDatabase.CursorFactory | Used to allow returning sub-classes of Cursor when calling query. |
| SQLiteTransactionListener | A listener for transaction events. |
| SQLiteClosable | An object created from a SQLiteDatabase that can be closed. |
| SQLiteCursor | A Cursor implementation that exposes results from a query on a
SQLiteDatabase. |
| SQLiteDatabase | Exposes methods to manage a SQLite database. |
| SQLiteOpenHelper | A helper class to manage database creation and version management. |
| SQLiteProgram | A base class for compiled SQLite programs. |
| SQLiteQuery | Represents a query that reads the resulting rows into a SQLiteQuery. |
| SQLiteQueryBuilder | This is a convience class that helps build SQL queries to be sent to
SQLiteDatabase objects. |
| SQLiteStatement | Represents a statement that can be executed against a database. |
| 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 | |
| SQLiteCantOpenDatabaseException | |
| SQLiteConstraintException | An exception that indicates that an integrity constraint was violated. |
| 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 | |
| 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. |
| SQLiteOutOfMemoryException | |
| SQLiteReadOnlyDatabaseException | |
| SQLiteTableLockedException |