Android 2.3 Gingerbread

Package android.database.sqlite

Contains the SQLite database management classes that an application would use to manage its own private database.

See:
          Description

Interface Summary
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.
 

Class Summary
SQLiteClosable An object created from a SQLiteDatabase that can be closed.
SQLiteCompiledSql This class encapsulates compilation of sql statement and release of the compiled statement obj.
SQLiteContentHelper Some helper functions for using SQLite database to implement content providers.
SQLiteCursor A Cursor implementation that exposes results from a query on a SQLiteDatabase.
SQLiteDatabase Exposes methods to manage a SQLite database.
SQLiteDatabase.ActiveDatabases  
SQLiteDebug Provides debugging info about all SQLite databases running in the current process.
SQLiteDebug.DbStats contains statistics about a database
SQLiteDebug.PagerStats Contains statistics about the active pagers in the current process.
SQLiteDirectCursorDriver A cursor driver that uses the given query directly.
SQLiteOpenHelper A helper class to manage database creation and version management.
SQLiteProgram A base class for compiled SQLite programs.
SQLiteQuery A SQLite program that represents a query that reads the resulting rows into a CursorWindow.
SQLiteQueryBuilder This is a convience class that helps build SQL queries to be sent to SQLiteDatabase objects.
SQLiteStatement A pre-compiled statement against a SQLiteDatabase that can be reused.
SqliteWrapper  
 

Exception Summary
DatabaseObjectNotClosedException An exception that indicates that garbage-collector is finalizing a database object that is not explicitly closed
SQLiteAbortException An exception that indicates that the SQLite program was aborted.
SQLiteConstraintException An exception that indicates that an integrity constraint was violated.
SQLiteDatabaseCorruptException An exception that indicates that the SQLite database file is corrupt.
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  
 

Package android.database.sqlite Description

Contains the SQLite database management classes that an application would use to manage its own private database.

Applications use these classes to maange 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.


Android 2.3 Gingerbread