onUpgrade(): if current version of the database is higher than the old, this method will be called to perform upgrading operations.And it won't be called any more if the database exists.
onCreate(): this will be called automatically if the database doesn't exist.This class will take care of opening the database if it exists, creating it if it doesn't, and upgrading it as necessary. Create a subclass of SQLiteOpenHelper and implement two methods: onCreate() and onUpgrade().The second design is to create an adapter or utility class to encapsulate database operations.Ĭommon steps of using SQLite database in Android. The first way is to call the SQLite database APIs directly wherever you need. There are two ways of using database in Android application. SQLiteDatabase is the class which has APIs to handle database operations such as insert, query, update and delete. You must create your own subclass of this abstract class. SQLiteOpenHelper is an abstract class which is responsible for creating or upgrading your SQLite databases and returning SQLiteDatabase object instance. Programmatically created SQLite database in an application is stored under path: /data/data//databases/.Ģ How to use SQLite in Android 2.1 SQLiteOpenHelper and SQLiteDatabase So it is a good way to store complex private data of application using SQLite database. The SQLite database of an Android application can only be accessed by classes in the application itself, but not others. This database is separated from other applications and saved in internal storage. It is self-contained, serverless, zero-configuration, transactional and uses standard SQL language for executing queries.Įach Android application has its own SQLite database. SQLite is an embedded SQL database engine. Tutorial about how to use SQLite database in Android application.
0 kommentar(er)
