Some of them are as follows: Example of android SQLite database Lets see the simple example of android sqlite database.

public void onCreate(SQLiteDatabase db) ) ĭelete:-The SQLite DELETE statement allows you to delete one row, multiple rows, and all rows in a table. There are many methods in SQLiteDatabase class. Since, SQLiteOpenHelper is an abstract class so we have to implement abstract method of this class given below:ġ. SQLiteOpenHelper takes care of all the database management activities. This class helps us to manage database creation and version management. It contains well written, well thought and well explained computer science and programming articles, quizzes and practice/competitive programming/company interview Questions. An SQLiteDatabase object is the Java representation of the database. To create and upgrade a database in your Android application you subclass the SQLiteOpenHelper class. How does our Android + SQLite Example App works User can enter a String Value and click Insert, this record will get inserted into the SQLite database. SQLiteOpenHelper class provides the functionality to use the SQLite database, for creating database we have to extend SQLiteOpenHelper class. The package contains the SQLite specific classes. Android SQLite is a very lightweight database which comes with Android OS.It is an open source which is used to perform database operation in android application.

Android sqlite example