How to Insert Data into SQLite Database in Android with Example

Android SQLite is the most preferred method of storing data in any android applications. It is a relational database, therefore, it supports all types of relational database features. Any data stored in SQLite database can easily accessible from Android Device Monitor without establishing any kind of connections for it such as JDBC.

Inserting Data into SQLite Database in Android

To insert some data into the table inside that SQlite Databse, follow these steps:

Step 1: Go to your activity.xml file and go to the design tab there. In a blank activity, drag and drop some text views here and some added texts here. So that we can use them to insert some data.

Step 2: Now, read about how to create database and tables in Android SQLite. What I'm going to do is, I'm going to drag three large texts here and three plain texts. So that we can use them to insert some data.

Step 3: Now you may be thinking that we have four columns in our table, first is ID, second is the name, third is surname and fourth is marks, but we have taken only three variables here. If you want you can change the ID names of these text views and added texts also. So first is the name, the second is surname and third is marks.

By following these steps, you can easily insert data into SQLite database in Android with example. The process is quite simple and easy to understand.

Sqlite database in android