SQLite Update

MainActivity.java

import android.database.Cursor;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;
import android.widget.Toast;
 public class MainActivity extends AppCompatActivity {
  DataBaseHelper myDb;
  EditText txtId, txtName, txtSurName, txtMarks;
  Button btnClick;
  @Override 
   protected void onCreate(Bundle savedInstanceState) {
   super.onCreate(savedInstanceState);
   setContentView(R.layout.activity_main);
   myDb = new DataBaseHelper(this);
   txtId = (EditText) findViewById(R.id.idID);
   txtName = (EditText) findViewById(R.id.idName);
   txtSurName = (EditText) findViewById(R.id.idSurname);
   txtMarks = (EditText) findViewById(R.id.idMarks);
   btnClick = (Button) findViewById(R.id.idBtn);
   btnClick.setOnClickListener(new View.OnClickListener() {
    @Override 
     public void onClick(View v) {
     ClickMe();
   }
  });
 }
  private void ClickMe() {
   String id = txtId.getText().toString();
   String name = txtName.getText().toString();
   String surname = txtSurName.getText().toString();
   String marks = txtMarks.getText().toString();
   Boolean result = myDb.updateData(id, name, surname, marks);
  
  if (result == true) {
    Toast.makeText(this, "Data Updated Successfully", Toast.LENGTH_SHORT).show();
   
  } else {
    Toast.makeText(this, "No Rows Affected", Toast.LENGTH_SHORT).show();
  }
 }
}

DBHelper.java

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
 
  public class DataBaseHelper extends SQLiteOpenHelper {
  public static final String DATABASE_NAME = "Student.db";
  public static final String TABLE_NAME = "Student_table";
  public static final String COL_1 = "ID";
  public static final String COL_2 = "NAME";
  public static final String COL_3 = "SURNAME";
  public static final String COL_4 = "MARKS";
  public DataBaseHelper(Context context) {
   super(context, DATABASE_NAME, null, 1);
  
 }
 @Override 
  public void onCreate(SQLiteDatabase db) {
   db.execSQL("CREATE TABLE " + TABLE_NAME + " (ID INTEGER PRIMARY KEY AUTOINCREMENT,NAME TEXT,SURNAME TEXT,MARKS INTEGER)");
  
 }
  @Override 
   public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
   db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME);
  
 }
  public boolean updateData(String id, String name, String surname, String marks) {
   SQLiteDatabase db = this.getWritableDatabase();
   ContentValues contentValues = new ContentValues();
   contentValues.put(COL_2, name);
   contentValues.put(COL_3, surname);
   contentValues.put(COL_4, marks);
   int result = db.update(TABLE_NAME, contentValues, "ID =?", new String[] {
   id
  });
  
  if (result > 0) {
   
   return true;
   
  } else 
   {
   return false;
  }
 }
}

activity_main.xml

<?xml version="1.0" encoding="utf-8"?>  
<LinearLayout
    xmlns:android="http://schemas.android.com/apk/res/android" 
    xmlns:tools="http://schemas.android.com/tools" 
     android:layout_width="match_parent" 
     android:layout_height="match_parent"
     android:paddingBottom="@dimen/activity_vertical_margin" 
     android:paddingLeft="@dimen/activity_horizontal_margin"
     android:paddingRight="@dimen/activity_horizontal_margin"
     android:paddingTop="@dimen/activity_vertical_margin" 
     tools:context="anu.com.sqlite.MainActivity" 
     android:orientation="vertical">
    
    <EditText 
     android:id="@+id/idID" 
     android:layout_width="match_parent" 
     android:layout_height="wrap_content" 
     android:hint="ID" /> 
    
    <EditText 
     android:id="@+id/idName" 
     android:layout_width="match_parent" 
     android:layout_height="wrap_content" 
     android:hint="NAME" />
    
    <EditText 
     android:id="@+id/idSurname"
     android:layout_width="match_parent" 
     android:layout_height="wrap_content"
     android:hint="SURNAME" />
    
    <EditText 
     android:id="@+id/idMarks" 
     android:layout_width="match_parent"
     android:layout_height="wrap_content" 
     android:inputType="number" 
     android:hint="MARKS" />
    
    <Button 
     android:id="@+id/idBtn" 
     android:layout_width="match_parent" 
     android:layout_height="wrap_content"
     android:background="#FFCC65"
     android:text="UPDATE" /> 
</LinearLayout> 

Share this

Author : Android Code Tutorial