August 1,2016
Today i come to know the sqlite and database in android.
Android SQLite
SQLite is an open-source relational database i.e. used to perform database operations on android devices such as storing, manipulating or retrieving persistent data from the database.
It is embedded in android bydefault. So, there is no need to perform any database setup or administration task.
SQLiteOpenHelper class
The android.database.sqlite.SQLiteOpenHelper class is used for database creation and version management. For performing any database operation, you have to provide the implementation of onCreate() and onUpgrade() methods of SQLiteOpenHelper class.
Constructors of SQLiteOpenHelper class
There are two constructors of SQLiteOpenHelper class.
| Constructor | Description |
|---|---|
| SQLiteOpenHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) | creates an object for creating, opening and managing the database. |
| SQLiteOpenHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version, DatabaseErrorHandler errorHandler) | creates an object for creating, opening and managing the database. It specifies the error handler. |
Methods of SQLiteOpenHelper class
There are many methods in SQLiteOpenHelper class. Some of them are as follows:
| Method | Description |
|---|---|
| public abstract void onCreate(SQLiteDatabase db) | called only once when database is created for the first time. |
| public abstract void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) | called when database needs to be upgraded. |
| public synchronized void close () | closes the database object. |
| public void onDowngrade(SQLiteDatabase db, int oldVersion, int newVersion) | called when database needs to be downgraded. |
Site Title 