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 |