---
title: "Insert, Update, Delete in Android"  
description: "Android provides easy way to manage structured data in SQLite database. It has full support for SQLite database. Any databases you create will be acce"  
author: "Chris Anderson"  
published: 2011-10-28  
updated: 2020-04-02  
canonical: https://www.mindstick.com/articles/796/insert-update-delete-in-android  
category: "android"  
tags: ["android"]  
reading_time: 3 minutes  

---

# Insert, Update, Delete in Android

Android provides easy way to manage structured data in SQLite database. It has full support for SQLite database. Any databases you create will be accessible by name to any class in the application, but not outside the application.\

In this article I am going to explain how perform DML operation (Insert, Update and Delete) in SQLite database in Android.

- Open res/values/strings.xml and add the following string element in the resource tag:

```
<string name="onClick">onClick</string>
```

- Start a new project named DMLDemo.
- Open res/layout/main.xml and insert the following:

```
<?xml  version="1.0" encoding="utf-8"?><LinearLayout  xmlns:android="http://schemas.android.com/apk/res/android"     android:orientation="horizontal"     android:layout_width="fill_parent"     android:layout_height="fill_parent">     <Button android:id="@+id/btnInsert"               android:text="Insert"               android:layout_width="wrap_content"               android:layout_height="wrap_content"               android:onClick="onClick"/>     <Button android:id="@+id/btnUpdate"               android:text="Update"               android:layout_width="wrap_content"               android:layout_height="wrap_content"               android:onClick="onClick"/>     <Button android:id="@+id/btnDelete"               android:text="Delete"               android:layout_width="wrap_content"               android:layout_height="wrap_content"               android:onClick="onClick"/></LinearLayout>
```

- Open the Activity file and insert the following code:

```
import android.app.Activity;import android.content.ContentValues;import android.database.sqlite.SQLiteDatabase;import android.os.Bundle;import android.view.View;import android.widget.Toast;  public class DatabaseActivity  extends Activity {    private SQLiteDatabase  db;          private String  table_name="StudentInfo";        private String  database_name="Test.db";               public static final String  KEY_ROWID =  "sid";        public static final String  KEY_NAME =  "name";        public static final String  KEY_AGE =  "age";        public static final String  KEY_COURSE =  "course";            @Override     public void onCreate(Bundle savedInstanceState) {         super.onCreate(savedInstanceState);         setContentView(R.layout.main);                 // create or open database file         db = openOrCreateDatabase(database_name , SQLiteDatabase.CREATE_IF_NECESSARY,                                                                                                                                                                   null);         db.setVersion(1);         db.setLocale(Locale.getDefault());         db.setLockingEnabled(true);                 // creating table in database         db.execSQL("CREATE TABLE IF NOT EXISTS "+table_name+" " +                         "( sid INTEGER PRIMARY KEY AUTOINCREMENT," +                         "  name TEXT," +                         "  age INTEGER," +                         "  course TEXT ); ");    }         // capture button id and perform function     public void onClick(View v)    {         switch(v.getId())        {                case R.id.btnInsert:                      Insert("Rohit",  "19",  "BBA");                       break;                case R.id.btnUpdate:                      Update(1,  "Rohit",  "20",  "BCA");                       break;                case R.id.btnDelete:                      Delete(1);                       break;        }    }         // inserting record in the database     public void Insert(String name, String age, String course)    {        ContentValues data=createContentValues(name, age, course);         db.insert(table_name,  null, data);        Toast.makeText(this,  "Record Inserted", Toast.LENGTH_SHORT).show();    }         // updating record in the database     public void Update(int sid, String name, String age, String course)    {        ContentValues updateValues = createContentValues(name, age,    course);         db.update(table_name, updateValues,  KEY_ROWID+"="+sid,  null);        Toast.makeText(this,  "Record Updated", Toast.LENGTH_SHORT).show();    }         // deleting record rom the database     public void Delete(int sid)    {         db.delete(table_name,  KEY_ROWID+"="+sid,  null);        Toast.makeText(this,  "Record Deleted", Toast.LENGTH_SHORT).show();    }         // return a content of the database     private ContentValues createContentValues(String name, String age, String course)          {    {              ContentValues values =  new ContentValues();              values.put(KEY_NAME, name);              values.put(KEY_AGE, age);              values.put(KEY_COURSE, course);               return values;    }}
```

##### · Run the application.

##

##### The output looks like below:

![Insert, Update, Delete in Android](https://www.mindstick.com/mindstickarticle/836467e3-f7aa-499f-a001-5a963ccc6104/images/81359d9b-4e1f-4883-819f-15b8f0922f14.png)

When user click on the Insert button record will be inserted in the database and update and delete operation also perform on their click.

##### You can check the database and its information by using adb shell in android. In order check the database information follow the steps given below:

1) Run the cmd (command prompt).

2) Go to the following location: d:\android-sdk_r13-windows\android-sdk-windows\platform-tools> (you have to user your own location).

3) Type adb shell and press enter, a # symbol will display.

4) Type sqlite3 /data/data/ [package name]/databases/database-name (Test.db) and press Enter.\
For e.g. sqlite3 /data/data/com.android.databaseDemo/databases/Test.db

5) Then type .tables in order to see the table present in the database.

6) It will show you a list tables present in the database.

\

---

Original Source: https://www.mindstick.com/articles/796/insert-update-delete-in-android

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.