SQLite in Android How to update a specific row

Question

I ve been trying to update a specific row for a while now  and it seems that there are two ways to do this  From what I ve read and tried  you can just use the   execSQL String sql  method   or the   update String table  ContentValues values  String whereClause  String   whereArgs  method    Let me know if this is incorrect as I am new to android and very new to SQL    So let me get to my actual code   myDB update TableName    Field1  Field2  Field3       VALUES   Bob   19   Male      where  id   1   null     I am trying to accomplish this   Update Field1  Field2  and Field3 where the primary key   id  is equal to 1   Eclipse gives me a red line right underneath the word  update  and gives me this explanation      The method update String  ContentValues  String  String    in the type   SQLiteDatabase is not applicable for the arguments  String  String    String  null    I m guessing I m not assigning the ContentValues correctly  Can anyone point me in the right direction

User · Answer

use this code in your DB           public boolean updatedetails long rowId String name  String address                 ContentValues args   new ContentValues           args put KEY ROWID  rowId                    args put KEY NAME  name          args put KEY ADDRESS  address          int i    mDb update DATABASE TABLE  args  KEY ROWID         rowId  null       return i  gt  0           for updating in your sample java use this code      DB open             try                  capture the data from UI               String name     EditText findViewById R id name   getText   toString   trim                  String address   EditText findViewById R id address   getText   toString   trim                     open Db               pdb open                     Save into DBS               pdb updatedetails RowId  name  address                 Toast makeText this   Modified Successfully   Toast LENGTH SHORT  show                  pdb close                  startActivity new Intent this  sample class                  finish             catch  Exception e                Log e TAG AVV   errorrrrr                   e printStackTrace                  pdb close

User · Answer

I personally prefere  update for its convenience  But execsql will work same   You are right with your guess that the problem is your content values  You should create a ContentValue Object and put the values for your database row there    This code should fix your example    ContentValues data new ContentValues     data put  Field1   bob     data put  Field2  19    data put  Field3   male     DB update Tablename  data    id     id  null

User · Answer

you can try this     db execSQL  UPDATE DB TABLE SET YOUR COLUMN  newValue  WHERE id 6

User · Answer

For updates  need to call setTransactionSuccessfull for changes to get committed like so   db beginTransaction    try       db update           db setTransactionSuccessfull       changes get rolled back if this not called   finally      db endTransaction       commit or rollback

User · Answer

I will demonstrate with a complete example  Create your database this way      import android content Context     import android database sqlite SQLiteDatabase     import android database sqlite SQLiteOpenHelper      class DBHelper context  Context    SQLiteOpenHelper context  DATABASE NAME  null  DATABASE VERSION            override fun onCreate db  SQLiteDatabase                val createProductsTable     CREATE TABLE     Business TABLE                             Business idKey     INTEGER PRIMARY KEY AUTOINCREMENT                          Business KEY a     TEXT                          Business KEY b     TEXT                          Business KEY c     TEXT                          Business KEY d     TEXT                          Business KEY e     TEXT                 db execSQL createProductsTable                    override fun onUpgrade db  SQLiteDatabase  oldVersion  Int  newVersion  Int                   Drop older table if existed  all data will be gone                db execSQL  DROP TABLE IF EXISTS     Business TABLE                 Create tables again             onCreate db                     companion object                 version number to upgrade database version               each time if you Add  Edit table  you need to change the               version number              private val DATABASE VERSION   1                 Database Name             private val DATABASE NAME    business db                    Then create a class to facilitate CRUD -  Create Read Update Delete  class Business       var a  String    null     var b  String    null     var c  String    null     var d  String    null     var e  String    null      companion object              Labels table name         const val TABLE    Business             Labels Table Columns names         const val rowIdKey     id          const val idKey    id          const val KEY a    a          const val KEY b    b          const val KEY c    c          const val KEY d    d          const val KEY e    e            Now comes the magic  import android content ContentValues import android content Context      class SQLiteDatabaseCrud context  Context            private val dbHelper  DBHelper   DBHelper context           fun updateCart id  Int  mBusiness  Business                val db   dbHelper writableDatabase             val valueToChange   mBusiness e             val values   ContentValues   apply                   put Business KEY e  valueToChange                            db update Business TABLE  values   id  id   null              db close      Closing database connection                   you must create your ProductsAdapter which must return a CursorAdapter  So in an activity just call the function like this  internal var cursor  Cursor    null internal lateinit var mProductsAdapter  ProductsAdapter   mSQLiteDatabaseCrud   SQLiteDatabaseCrud this      try           val mBusiness   Business           mProductsAdapter   ProductsAdapter this  c   todoCursor  flags   0          lstProducts adapter   mProductsAdapter           lstProducts onItemClickListener   OnItemClickListener   parent  view  position  arg3 - gt                  val cur   mProductsAdapter getItem position  as Cursor                 cur moveToPosition position                  val id   cur getInt cur getColumnIndexOrThrow Business idKey                    mBusiness e    this will replace the 0 in a specific position                  mSQLiteDatabaseCrud  updateCart id  mBusiness                          cursor   dataBaseMCRUD   productsList         mProductsAdapter swapCursor cursor        catch  e  Exception            Log d  ExceptionAdapter       e

User · Answer

if your sqlite row has a unique id or other equivatent  you can use where clause  like this  update      where id    here is your unique row id

User · Answer

hope this ll help you   public boolean updatedetails long rowId  String address           SQLiteDatabase mDb  this getWritableDatabase       ContentValues args   new ContentValues       args put KEY ROWID  rowId                args put KEY ADDRESS  address     return mDb update DATABASE TABLE  args  KEY ROWID         rowId  null  gt 0

User · Answer

SQLiteDatabase myDB   this getWritableDatabase     ContentValues cv   new ContentValues    cv put key1 value1       cv put key2 value2     All values are your updated values  here you are                         putting these values in a ContentValues object                                           int val myDB update TableName  cv  key name        new String   value     if val gt 0     Successfully Updated else    Updation failed

User · Answer

Can try like this   ContentValues values new ContentValues    values put  name   aaa    values put  publisher   ppp    values put  price   111     int id sqdb update  table name  values  bookid  5  and booktype  comic   null

User · Answer

just try this way    String strFilter     id     Id    ContentValues args   new ContentValues      args put KEY TITLE  title     myDB update  titles   args  strFilter  null

User · Answer

At first create a ContentValues object    ContentValues cv   new ContentValues    cv put  Field1   Bob    cv put  Field2   19      Then use the update method  Note  the third argument is the where clause  The     is a placeholder  It will be replaced with the fourth argument  id   myDB update MY TABLE NAME  cv    id       new String   id      This is the cleanest solution to update a specific row

User · Answer

You try this one update method in SQLite   int id  ContentValues con   new ContentValues    con put TITLE  title   con put AREA  area   con put DESCR  desc   con put TAG  tag   myDataBase update TABLE  con  KEY ID         id null

User · Answer

just give rowId and type of data that is going to be update in ContentValues   public void updateStatus String id   int status    SQLiteDatabase db   this getWritableDatabase     ContentValues data   new ContentValues     data put  status   status    db update TableName  data   columnName           id   null

User · Answer

Method for updation in SQLite   public void updateMethod String name  String updatename       String query  update students set email     where name           String   selections  updatename  name       Cursor cursor db rawQuery query  selections

User · Answer

Simple way   String strSQL    UPDATE myTable SET Column1   someValue WHERE columnId      someValue   myDataBase execSQL strSQL

User · Answer

public long fillDataTempo String table       String   table   new String 1       tabela 0    table       ContentValues args   new ContentValues        args put DBOpenHelper DATA HORA  new Date   toString         args put DBOpenHelper NOME TABELA  nome tabela       return db update DATABASE TABLE  args  STRING     LIKE     tabela

User · Answer

Here is some simple sample code for update      First declare this  private DatabaseAppHelper dbhelper  private SQLiteDatabase db      initialize the following  dbhelper new DatabaseAppHelper this           db dbhelper getWritableDatabase        updation code   ContentValues values  new ContentValues                    values put DatabaseAppHelper KEY PEDNAME  ped name                   values put DatabaseAppHelper KEY PEDPHONE  ped phone                   values put DatabaseAppHelper KEY PEDLOCATION  ped location                   values put DatabaseAppHelper KEY PEDEMAIL  ped emailid                   db update DatabaseAppHelper TABLE NAME  values   DatabaseAppHelper KEY ID            null       put ur id instead of the  question mark  is a function in my shared preference

User · Answer

First make a ContentValues object   ContentValues cv   new ContentValues    cv put  quot Field1 quot   quot Bob quot      These Fields should be your String values of actual column names cv put  quot Field2 quot   quot 19 quot    cv put  quot Field2 quot   quot Male quot     Then use the update method  it should work now  myDB update TableName  cv   quot  id     quot   new String   id

User · Answer

public void updateRecord ContactModel contact        database   this getReadableDatabase        ContentValues contentValues   new ContentValues        contentValues put COLUMN FIRST NAME  contact getFirstName         contentValues put COLUMN LAST NAME  contact getLastName         contentValues put COLUMN NUMBER contact getNumber         contentValues put COLUMN BALANCE contact getBalance         database update TABLE NAME  contentValues  COLUMN ID           new String   contact getID          database close

[java] SQLite in Android How to update a specific row

Examples related to java

Examples related to android

Examples related to sql

Examples related to eclipse

Examples related to sqlite