ListView myList=(ListView)findViewById(android.R.id.list) ListAdapter adapter=new SimpleCursorAdapter(this,android.R.layout.simple_list_item_2, This number is used to identify if there is an upgrade or downgrade of the database.īelow, we I’ve created a class (MyDatabaseHelper) that is going to derive from SQLiteOpenHelper: public class MyDatabaseHelper extends SQLiteOpenHelper Version – The version of the database.Factory – A cursor factory (you can usually pass this as null).Name – The name of the new database file.Context – This is the context that will be used to create the database.

The SQLiteOpenHelper constructor accepts four arguments, which are This class provides the functionality to create a database and calls a function that can be overridden by the derived class. To create a database in SQLite in Android, you need to create a subclass of the class SQLiteOpenHelper.

In order to write data to a database, we need to create our database first. For more details on SQLite, you can visit and Creating a Database in Android SQLite is included with the Android system and can be easily used in your Android app. SQLite is a relational database technology that’s used most often when the developer requires an embedded database in a small system. In most cases, the most simple and straightforward way to acquire and preserve user data is via SQLite databases. Android also supports data storage in a local database, and the operating system provides a good infrastructure for storing and retrieving data. Many apps also have a remote web service that provide the data for the app in question. In Android, you can store your data using quite a few different methods, both in active memory and in written files. Developers need to store substantial amounts of data in an organized fashion in order for their apps to be truly valuable to their users. Data has always been the most important part of any mobile application.

Sqlite database in android