Android SQLite Update Statement

Question

I need to implement SQLite in my application  I followed this tutorial   Creating and using databases in Android one  Everything is working fine  I inserted 1 row with 5 columns  Now I want to update value of 1 column only and others will be remain same   There is one update method in tutorial but it needs all the parameters  however I want to update only one column

User · Answer

You can use the code below   String strFilter     id     Id  ContentValues args   new ContentValues    args put KEY TITLE  title   myDB update  titles   args  strFilter  null

User · Answer

It s all in the tutorial how to do that        ContentValues args   new ContentValues        args put columnName  newValue       db update DATABASE TABLE  args  KEY ROWID         rowId  null     Use ContentValues to set the updated columns and than the update   method in which you have to specifiy  the table and a criteria to only update the rows you want to update

User · Answer

I use this class to handle database I hope it will help some one in future    Happy coding    public class Database    private static class DBHelper extends SQLiteOpenHelper                   Database name             private static final String DB NAME    db name                   Table Names             public static final String TABLE CART    DB CART                     Cart Table Columns             public static final String CART ID PK     id     Primary key      public static final String CART DISH NAME    dish name       public static final String CART DISH ID    menu item id       public static final String CART DISH QTY    dish qty       public static final String CART DISH PRICE    dish price                   String to create reservation tabs table             private final String CREATE TABLE CART    CREATE TABLE IF NOT EXISTS                 TABLE CART                       CART ID PK     INTEGER PRIMARY KEY                  CART DISH NAME     TEXT                   CART DISH ID     TEXT                   CART DISH QTY     TEXT                   CART DISH PRICE     TEXT           public DBHelper Context context            super context  DB NAME  null  2                Override     public void onCreate SQLiteDatabase db            db execSQL CREATE TABLE CART                 Override     public void onUpgrade SQLiteDatabase db  int arg1  int arg2            db execSQL  DROP TABLE IF EXISTS     CREATE TABLE CART           onCreate db                               CART handler                public static class Cart                    Check if Cart is available or not                param context         return             public static boolean isCartAvailable Context context             DBHelper dbHelper   new DBHelper context           SQLiteDatabase db   dbHelper getReadableDatabase            boolean exists   false           try               String query    SELECT   FROM     DBHelper TABLE CART              Cursor cursor   db rawQuery query  null               exists    cursor getCount    gt  0               cursor close                db close              catch  SQLiteException e                db close                       return exists                         Insert values in cart table                param context         param dishName         param dishPrice         param dishQty         return             public static boolean insertItem Context context  String itemId  String dishName  String dishPrice  String dishQty             DBHelper dbHelper   new DBHelper context           SQLiteDatabase db   dbHelper getWritableDatabase            ContentValues values   new ContentValues            values put DBHelper CART DISH ID       itemId           values put DBHelper CART DISH NAME       dishName           values put DBHelper CART DISH PRICE       dishPrice           values put DBHelper CART DISH QTY       dishQty            try               db insert DBHelper TABLE CART  null  values               db close                return true            catch  SQLiteException e                db close                return false                                  Check for specific record by name                param context         param dishName         return             public static boolean isItemAvailable Context context  String dishName             DBHelper dbHelper   new DBHelper context           SQLiteDatabase db   dbHelper getReadableDatabase            boolean exists   false           String query    SELECT   FROM     DBHelper TABLE CART     WHERE                     DBHelper CART DISH NAME            String valueOf dishName                   try               Cursor cursor   db rawQuery query  null                exists    cursor getCount    gt  0               cursor close               catch  SQLiteException e                 e printStackTrace                db close                        return exists                        Update cart item by item name                param context         param dishName         param dishPrice         param dishQty         return             public static boolean updateItem Context context  String itemId  String dishName  String dishPrice  String dishQty             DBHelper dbHelper   new DBHelper context           SQLiteDatabase db   dbHelper getWritableDatabase            ContentValues values   new ContentValues            values put DBHelper CART DISH ID  itemId           values put DBHelper CART DISH NAME  dishName           values put DBHelper CART DISH PRICE  dishPrice           values put DBHelper CART DISH QTY  dishQty            try                String   args   new String   dishName               db update DBHelper TABLE CART  values  DBHelper CART DISH NAME         args                db close                  return true            catch  SQLiteException e                db close                 return false                                  Get cart list                param context         return             public static ArrayList lt CartModel gt  getCartList Context context             DBHelper dbHelper   new DBHelper context           SQLiteDatabase db   dbHelper getReadableDatabase             ArrayList lt CartModel gt  cartList   new ArrayList lt  gt              try               String query    SELECT   FROM     DBHelper TABLE CART                     Cursor cursor   db rawQuery query  null                 for  cursor moveToFirst     cursor isAfterLast    cursor moveToNext                       cartList add new CartModel                          cursor getString cursor getColumnIndex DBHelper CART DISH ID                            cursor getString cursor getColumnIndex DBHelper CART DISH NAME                            cursor getString cursor getColumnIndex DBHelper CART DISH QTY                            Integer parseInt cursor getString cursor getColumnIndex DBHelper CART DISH PRICE                                                   db close               catch  SQLiteException e                db close                      return cartList                       Get total amount of cart items                param context         return             public static String getTotalAmount Context context             DBHelper dbHelper   new DBHelper context           SQLiteDatabase db   dbHelper getReadableDatabase             double totalAmount   0 0           try               String query    SELECT   FROM     DBHelper TABLE CART                     Cursor cursor   db rawQuery query  null                 for  cursor moveToFirst     cursor isAfterLast    cursor moveToNext                       totalAmount   totalAmount   Double parseDouble cursor getString cursor getColumnIndex DBHelper CART DISH PRICE                              Double parseDouble cursor getString cursor getColumnIndex DBHelper CART DISH QTY                                db close                catch  SQLiteException e                db close                        if  totalAmount    0 0              return             else             return      totalAmount                         Get item quantity                param context         param dishName         return             public static String getItemQty Context context  String dishName             DBHelper dbHelper   new DBHelper context           SQLiteDatabase db   dbHelper getReadableDatabase             Cursor cursor   null          String query    SELECT   FROM     DBHelper TABLE CART     WHERE     DBHelper CART DISH NAME            dishName                 String quantity    0            try               cursor   db rawQuery query  null                if  cursor getCount    gt  0                     cursor moveToFirst                    quantity   cursor getString cursor                          getColumnIndex DBHelper CART DISH QTY                     return quantity                            catch  SQLiteException e                e printStackTrace                       return quantity                         Delete cart item by name                param context         param dishName             public static void deleteCartItem Context context  String dishName            DBHelper dbHelper   new DBHelper context           SQLiteDatabase db   dbHelper getReadableDatabase             try                String   args   new String   dishName               db delete DBHelper TABLE CART  DBHelper CART DISH NAME         args                db close              catch  SQLiteException e                db close                e printStackTrace                          End of cart class         Delete database table        param context     public static void deleteCart Context context        DBHelper dbHelper   new DBHelper context       SQLiteDatabase db   dbHelper getReadableDatabase         try            db execSQL  DELETE FROM     DBHelper TABLE CART          catch  SQLiteException e            e printStackTrace                  Usage      if Database Cart isCartAvailable context            Database deleteCart context

User · Answer

The SQLiteDatabase object depends on the type of operation on the database   More information  visit the official website   https   developer android com training basics data-storage databases html UpdateDbRow  It explains how to manipulate consultations on the SQLite database   INSERT ROW  Gets the data repository in write mode  SQLiteDatabase db   mDbHelper getWritableDatabase      Create a new map of values  where column names are the keys  ContentValues values   new ContentValues    values put FeedEntry COLUMN NAME ENTRY ID  id   values put FeedEntry COLUMN NAME TITLE  title   values put FeedEntry COLUMN NAME CONTENT  content     Insert the new row  returning the primary key value of the new row  long newRowId  newRowId   db insert       FeedEntry TABLE NAME       FeedEntry COLUMN NAME NULLABLE       values     UPDATE ROW  Define  where  part of query   String selection   FeedEntry COLUMN NAME ENTRY ID     LIKE       Specify arguments in placeholder order   String   selectionArgs     String valueOf rowId       SQLiteDatabase db   mDbHelper getReadableDatabase      New value for one column  ContentValues values   new ContentValues    values put FeedEntry COLUMN NAME TITLE  title     Which row to update  based on the ID  String selection   FeedEntry COLUMN NAME ENTRY ID     LIKE     String   selectionArgs     String valueOf rowId         int count   db update      FeedReaderDbHelper FeedEntry TABLE NAME      values      selection      selectionArgs

User · Answer

you can always execute SQL   update  your table  set  your column  value   for example   update Foo set Bar 125

User · Answer

You can try   db execSQL  UPDATE DB TABLE SET YOUR COLUMN  newValue  WHERE id 6       Or    ContentValues newValues   new ContentValues    newValues put  YOUR COLUMN    newValue     db update  YOUR TABLE   newValues   id 6   null     Or  ContentValues newValues   new ContentValues    newValues put  YOUR COLUMN    newValue     String   args   new String    user1    user2    db update  YOUR TABLE   newValues   name   OR name     args

[android] Android SQLite: Update Statement

Examples related to android

Examples related to sql

Examples related to sqlite