Android sqlite how to check if a record exists

by 
public static boolean CheckIsDataAlreadyInDBorNot(String TableName,
        String dbfield, String fieldValue) {
    SQLiteDatabase sqldb = EGLifeStyleApplication.sqLiteDatabase;
    String Query = "Select * from " + TableName + " where " + dbfield + " = " + fieldValue;
    Cursor cursor = sqldb.rawQuery(Query, null);
        if(cursor.getCount() <= 0){
            cursor.close();
            return false;
        }
    cursor.close();
    return true;
}

I hope this is useful to you…
This function returns true if record already exists in db. Otherwise returns false.

More Related Contents:

  1. How to add multiple edit text and spinner data into SQLite database?
  2. Why does the application crash when I press the button to insert the values in the table? [duplicate]
  3. Pros and Cons of SQLite and Shared Preferences [closed]
  4. Share SQLite database between 2 android apps?
  5. Location of sqlite database on the device
  6. Android column ‘_id’ does not exist?
  7. Android: upgrading DB version and adding new table
  8. How do I view the SQLite database on an Android device? [duplicate]
  9. Android P – ‘SQLite: No Such Table Error’ after copying database from assets
  10. How to ignore accent in SQLite query (Android)
  11. Deleting Row in SQLite in Android
  12. How to disable the Clear Data button in Application info of Manage application
  13. How to convert image file data in a byte array to a Bitmap?
  14. Why do I get a “sqlite3: not found” error on a rooted Nexus One when I try to open a database using the adb shell?
  15. Android Persistence room: “Cannot figure out how to read this field from a cursor”
  16. SQLite Exception no such column when trying to select
  17. android java.lang.IllegalStateException: Couldn’t read row 0, col 0 from CursorWindow
  18. How can I insert image in a sqlite database
  19. Android Save images to SQLite or SDCard or memory
  20. Android Cursor with ORMLite to use in CursorAdapter
  21. What is The use of moveToFirst () in SQLite Cursors
  22. sqlite example program in android [closed]
  23. Create SQLite database in android
  24. How to check database on not rooted android device
  25. SQLite android column not found
  26. SQlite – Android – Foreign key syntax
  27. Inserting values to SQLite table in Android
  28. SQLiteOpenHelper onUpgrade() Confusion Android
  29. Using COLLATE in Android SQLite – Locales is ignored in LIKE statement
  30. SQLite Foreign Key

Leave a Comment