When you press on update record you, you would be taken back to the screen where you inserted your record.

When you press on delete record the particular record will be deleted from SQLite database.

When user press the Add button, we’ll show him the form where user can add two fieldsīy clicking the Insert button, record will be saved into SQLite database and user can see added record on the first screen.īy long pressing on record you can Delete or Update record. The final output should look something like following:Īs you can see from the screenshots above initially user will see a list (which would be empty right now, since there are no records) and button called ‘Add‘. We are going to create a project where you will be able to insert/ update/ delete the user records from database. To get more details about SQLite in general, please refer the following link: If you would like to learn more about the above 4 points, please refer the following link: SQLite is used as a database for android application development.

To manipulate data (insert, update, delete) in SQLite database – we’ll use SQL (Structured Query Language).

SQLite is embedded within the Android operating System, so you don’t need anything external on Android to use SQLite.SQLite is written in C programming language.SQLite is RDBMS (Relational Database Management System).SQLite is used as a Local Database in android.įour Major things to understand about SQLite: So before we start coding our app, let’s understand few things about SQLite. Learn how to Insert Update Delete Retrieve Records in SQLite Database in Android

Android studio tutorial database