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 |