How to Insert, Delete and Update in SQLite Database Using Android?

0 4,789

In this tutorial we are going to discuss about how we can insert, delete and update in SQLite Database using android programming in detail.

Basic Terms:

SQLiteOpenHelper Class: A helper class to manage database creation and version management.

SQLiteDatabase Class: SQLiteDatabase has methods to create, delete, execute SQL commands, and perform other common database management tasks.

ContentValues Class: ContentValue class lets you put information inside an object in the form of Key-Value pairs for columns and their value. The object can then be passed to the insert() method of an instance of the SQLiteDatabase class to insert or update your WritableDatabase.

STEPS:

 

 

if you have any confusion, watch the following videos: