abstract void

onCreate(SQLiteDatabasedb)

Called when the database is created for the first time.

abstract void

onUpgrade(SQLiteDatabasedb, int oldVersion, int newVersion)

Called when the database needs to be upgraded.

synchronizedSQLiteDatabase

getReadableDatabase()

Create and/or open a database.

synchronizedSQLiteDatabase

getWritableDatabase()

Create and/or open a database that will be used for reading and writing.

void

close()

Close the database.

int

delete(Stringtable,StringwhereClause,String[]whereArgs)

Convenience method for deleting rows in the database.

void

execSQL(Stringsql)

Execute a single SQL statement that is NOT a SELECT or any other SQL statement that returns data.

void

execSQL(Stringsql,Object[]bindArgs)

Execute a single SQL statement that is NOT a SELECT/INSERT/UPDATE/DELETE.

long

insert(Stringtable,StringnullColumnHack,ContentValuesvalues)

Convenience method for inserting a row into the database.

long

insertOrThrow(Stringtable,StringnullColumnHack,ContentValuesvalues)

Convenience method for inserting a row into the database.

boolean

isOpen()

boolean

isReadOnly()

return whether the DB is opened as read only.

staticSQLiteDatabase

openDatabase(Stringpath,SQLiteDatabase.CursorFactoryfactory, int flags,DatabaseErrorHandlererrorHandler)

Open the database according to the flagsOPEN_READWRITEOPEN_READONLYCREATE_IF_NECESSARYand/orNO_LOCALIZED_COLLATORS.

staticSQLiteDatabase

openDatabase(Stringpath,SQLiteDatabase.CursorFactoryfactory, int flags)

Open the database according to the flagsOPEN_READWRITEOPEN_READONLYCREATE_IF_NECESSARYand/orNO_LOCALIZED_COLLATORS.

staticSQLiteDatabase

openOrCreateDatabase(Stringpath,SQLiteDatabase.CursorFactoryfactory,DatabaseErrorHandlererrorHandler)

Equivalent to openDatabase(path, factory, CREATE_IF_NECESSARY, errorHandler).

staticSQLiteDatabase

openOrCreateDatabase(Stringpath,SQLiteDatabase.CursorFactoryfactory)

Equivalent to openDatabase(path, factory, CREATE_IF_NECESSARY).

staticSQLiteDatabase

openOrCreateDatabase(Filefile,SQLiteDatabase.CursorFactoryfactory)

Equivalent to openDatabase(file.getPath(), factory, CREATE_IF_NECESSARY).

Cursor

query(Stringtable,String[]columns,Stringselection,String[]selectionArgs,StringgroupBy,Stringhaving,StringorderBy,Stringlimit)

Query the given table, returning aCursorover the result set.

Cursor

query(Stringtable,String[]columns,Stringselection,String[]selectionArgs,StringgroupBy,Stringhaving,StringorderBy)

Query the given table, returning aCursorover the result set.

Cursor

query(boolean distinct,Stringtable,String[]columns,Stringselection,String[]selectionArgs,StringgroupBy,Stringhaving,StringorderBy,Stringlimit)

Query the given URL, returning aCursorover the result set.

Cursor

queryWithFactory(SQLiteDatabase.CursorFactorycursorFactory, boolean distinct,Stringtable,String[]columns,Stringselection,String[]selectionArgs,StringgroupBy,Stringhaving,StringorderBy,Stringlimit)

Query the given URL, returning aCursorover the result set.

Cursor

rawQuery(Stringsql,String[]selectionArgs)

Runs the provided SQL and returns aCursorover the result set.

Cursor

rawQueryWithFactory(SQLiteDatabase.CursorFactorycursorFactory,Stringsql,String[]selectionArgs,StringeditTable)

Runs the provided SQL and returns a cursor over the result set.

static int

releaseMemory()

Attempts to release memory that SQLite holds but does not require to operate properly.

long

replace(Stringtable,StringnullColumnHack,ContentValuesinitialValues)

Convenience method for replacing a row in the database.

long

replaceOrThrow(Stringtable,StringnullColumnHack,ContentValuesinitialValues)

Convenience method for replacing a row in the database.