Update data in SQLite

"Update data in SQLite" 

   In previous blog we have studied about CREATE,INSERT,SELECT,DELETE operation on SQLite. We missed up about UPDATE operation. Today we are going to learn how to update data in SQLite table.

  If you understand how to insert data in SQLite, then it is very easy to learn UPDATE. Lets see following code snippet, here i have created two methods one for update mobile number and one for update email. The update() method is used for performing update operation. It contains Table name, content values and where clause. Just copy and paste this method in previous project's SQLiteHelper.java file.

  

//update number public long updateMobileData(String number) { SQLiteDatabase sqLiteDatabase = this.getWritableDatabase(); ContentValues contentValues = new ContentValues(); contentValues.put(COL2, number); long result = sqLiteDatabase.update(TableName, contentValues, COL2 + "=?", new String[]{number}); //update data where name and number in table. return result; } //update email public long updateEmailData(String email) { SQLiteDatabase sqLiteDatabase = this.getWritableDatabase(); ContentValues contentValues = new ContentValues(); contentValues.put(COL3, email); long result = sqLiteDatabase.update(TableName, contentValues, COL3 + "=?", new String[]{email}); //update data where name and number in table. return result; }

 Now create design for showing edit option. See following code: Just replace two textview of number and email in single_view_name.xml file as shown in following block of code.
  <TextView android:id="@+id/tvNumber" android:layout_width="wrap_content" android:layout_height="wrap_content" android:drawableRight="@android:drawable/ic_menu_edit" android:gravity="center" android:text="9970346575" android:textColor="@color/colorPrimary" android:textSize="15dp" /> <TextView android:id="@+id/tvEmail" android:layout_width="wrap_content" android:layout_height="wrap_content" android:drawableRight="@android:drawable/ic_menu_edit" android:gravity="center" android:text="swapnil@gmail.com" android:textColor="@color/colorPrimary" android:textSize="15dp" />

Add click listener for drawable right of textview using touch listener as shown in following code block. Add this two listener in your adapter class.(RecyclerDataAdapter.java).

//Get drawable of textview listener recyclerClass.tvNumber.setOnTouchListener(new View.OnTouchListener() { @Override public boolean onTouch(View v, MotionEvent event) { final int DRAWABLE_LEFT = 0; final int DRAWABLE_TOP = 1; final int DRAWABLE_RIGHT = 2; final int DRAWABLE_BOTTOM = 3; if (event.getAction() == MotionEvent.ACTION_UP) { if (event.getRawX() >= (recyclerClass.tvNumber.getRight() - recyclerClass.tvNumber.getCompoundDrawables()[DRAWABLE_RIGHT].getBounds().width())) { Intent i = new Intent(context, UpdateActivity.class); i.putExtra("hintOld", "Old number"); i.putExtra("hintNew", "New number"); i.putExtra("textOld", recyclerClass.tvNumber.getText().toString()); i.putExtra("WhatUpdate", "number"); return true; } } return false; } }); //Get drawable of textview listener recyclerClass.tvEmail.setOnTouchListener(new View.OnTouchListener() { @Override public boolean onTouch(View v, MotionEvent event) { final int DRAWABLE_LEFT = 0; final int DRAWABLE_TOP = 1; final int DRAWABLE_RIGHT = 2; final int DRAWABLE_BOTTOM = 3; if (event.getAction() == MotionEvent.ACTION_UP) { if (event.getRawX() >= (recyclerClass.tvEmail.getRight() - recyclerClass.tvEmail.getCompoundDrawables()[DRAWABLE_RIGHT].getBounds().width())) { Intent i = new Intent(context, UpdateActivity.class); i.putExtra("hintOld", "Old Email"); i.putExtra("hintNew", "New Email"); i.putExtra("textOld", recyclerClass.tvEmail.getText().toString()); i.putExtra("WhatUpdate", "email"); return true; } } return false; } });

Now create one activity for update data form showing. Here i have created UpdateActivity.java. 
import android.content.Intent; import android.os.Bundle; import android.support.annotation.Nullable; import android.support.v7.app.AppCompatActivity; import android.text.InputType; import android.view.View; import android.widget.Button; import android.widget.EditText; import android.widget.Toast; import com.example.sqlitewithrecyclerview.Database.SQLiteHelper; public class UpdateActivity extends AppCompatActivity { private EditText etOldValue, etNewValue; private Button btnUpdate; @Override protected void onCreate(@Nullable Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.update_view); etOldValue = findViewById(R.id.etOldValue); etNewValue = findViewById(R.id.etNewValue); btnUpdate = findViewById(R.id.btnUpdate); Intent i = getIntent(); String hintNew = i.getStringExtra("hintNew"); String TextOld = i.getStringExtra("textOld"); final String chkWhatUpdate = i.getStringExtra("WhatUpdate"); etOldValue.setText(TextOld); etNewValue.setHint(hintNew); etOldValue.setEnabled(false); if (chkWhatUpdate.equals("number")) { etNewValue.setInputType(InputType.TYPE_CLASS_NUMBER); } else if (chkWhatUpdate.equals("email")) { etNewValue.setInputType(InputType.TYPE_TEXT_VARIATION_EMAIL_ADDRESS); } etOldValue.setHint(TextOld); btnUpdate.setOnClickListener(new View.OnClickListener() { @Override public void onClick(View v) { if (chkValidation(etNewValue, etOldValue)) { SQLiteHelper sqLiteHelper = new SQLiteHelper(UpdateActivity.this); if (chkWhatUpdate.equals("number")) { long result = sqLiteHelper.updateMobileData(etOldValue.getText().toString(), etNewValue.getText().toString()); //for update number if (result > 0) { Toast.makeText(UpdateActivity.this, "Number updated successfully", Toast.LENGTH_SHORT).show(); Intent i = new Intent(UpdateActivity.this, MainActivity.class); startActivity(i); UpdateActivity.this.finish(); } else { Toast.makeText(UpdateActivity.this, "Number updatation failed", Toast.LENGTH_SHORT).show(); } } else { long result = sqLiteHelper.updateEmailData(etOldValue.getText().toString(), etNewValue.getText().toString()); //for update email if (result > 0) { Toast.makeText(UpdateActivity.this, "Email updated successfully", Toast.LENGTH_SHORT).show(); Intent i = new Intent(UpdateActivity.this, MainActivity.class); startActivity(i); UpdateActivity.this.finish(); } else { Toast.makeText(UpdateActivity.this, "Email updatation failed", Toast.LENGTH_SHORT).show(); } } } } }); } private boolean chkValidation(EditText etNewValue, EditText etOldValue) { if (etNewValue.getText().toString() != null && etOldValue.getText().toString() != null) { return true; } else { Toast.makeText(this, "Please enter all fields.", Toast.LENGTH_SHORT).show(); return false; } } }

Now create xml file for creating form design.

<?xml version="1.0" encoding="utf-8"?> <linearlayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:layout_height="match_parent" android:orientation="vertical"> <android.support.design.widget.TextInputLayout style="@style/Widget.MaterialComponents.TextInputEditText.OutlinedBox" android:layout_width="match_parent" android:layout_height="wrap_content"> <EditText android:id="@+id/etOldValue" android:layout_width="match_parent" android:layout_height="wrap_content" android:background="@null" android:textSize="14dp" /> </android.support.design.widget.TextInputLayout> <android.support.design.widget.TextInputLayout style="@style/Widget.MaterialComponents.TextInputEditText.OutlinedBox" android:layout_width="match_parent" android:layout_height="wrap_content" android:layout_marginTop="10dp"> <EditText android:id="@+id/etNewValue" android:layout_width="match_parent" android:layout_height="wrap_content" android:background="@null" android:textSize="14dp" /> </android.support.design.widget.TextInputLayout> <Button android:id="@+id/btnUpdate" android:layout_width="250dp" android:layout_height="wrap_content" android:layout_gravity="center" android:layout_marginTop="20dp" android:background="@color/colorPrimary" android:text="UPDATE" android:textColor="#fff" android:textSize="14dp" /> </LinearLayout>

Now run your app and see the result.

Happy coding!!!

Click Here To Download Full Code

Get full code