How to check whether the value is inserted or not in SQLite?

Question

How to check whether the value is inserted or not in Android?

I want to display

if inserted==true
   return true;
else
   return false;

This is my code:

SQLiteDatabase db = this.getWritableDatabase();
ContentValues contentValues = new ContentValues();
sqLiteDatabase.execSQL("INSERT INTO user VALUES (1,1,1,'admin','admin','21232f297a57a5a743894a0e4a801fc3','9986058114','8897456588','admin@admin.com','','Active','AD','admin')");

Check this https://stackoverflow.com/a/21151598/8448886 – Abhishek kumar Jan 28 '18 at 13:17 — Abhishek kumar, Jan 28 '18 at 13:17

score 1 · Accepted Answer · answered Jan 28 '18 at 13:22

Check By DataBase : https://stackoverflow.com/a/21151598/8448886

You can also use Log to check data is inserted on or not on your DataBaseHelper class.

  public boolean addData(String name , String sku, String upc , String price, String displaySize, int displaySizeYes, String status){
    db = this.getWritableDatabase();
    ContentValues contentValues = new ContentValues();
    contentValues.put(Constants.NAME, name );
    contentValues.put(Constants.SKU, sku );
    contentValues.put(Constants.UPC, upc );
    contentValues.put(Constants.PRICE, price );
    contentValues.put(Constants.DISPLAY_SIZE, displaySize );
    contentValues.put(Constants.DISPLAY_SIZE_YES, displaySizeYes );
    contentValues.put(Constants.STATUS, status );

    long result = db.insert(Constants.TABLE_NAME,null,contentValues);
    Log.e(TAG,""+upc+"  Inserted");

    if(result == -1) {
        return false;
    }else{
      //  Log.e(TAG,"value inserted");
        return true;
    }

}

Its not showing accepted , left side of the answer click on correct symbol @Aravind — Abhishek kumar, Jan 28 '18 at 13:39
Accept means check on correct symbol at starting of my answer below of voting up and down. — Abhishek kumar, Jan 29 '18 at 15:38
no issue , Now you have enough reputation to vote up too @Aravind — Abhishek kumar, Feb 08 '18 at 09:35

score 0 · Answer 2 · answered Aug 31 '21 at 13:28

public int numberOfRowsRecord() {
    db =  this.getReadableDatabase();
    return (int) DatabaseUtils.queryNumEntries(db, RECORD_TABLE_NAME);
}

Add this code in your helper class

this function return either number of row affected by this...

so you can check you value is inserted or not...

How to check whether the value is inserted or not in SQLite?

2 Answers2