How to know if specific row is empty in Android SQlite database

Question

I have to retrieve Sqlite database table rows of images.But some rows have no data , that is empty columns are there is database tables.

Here is my database table image

In the above image , there is one ProfilePICURL column some rows have no data.I have check the length of retrieve ProfilePICURL string , but not work.So how can i check the row is null. Thanks.

Here is my retrieve method

public void LoadProfilePics()
            {
                db = myDBHelper.getWritableDatabase();

                Cursor cursor = db.rawQuery("select * from Inspector ", null);
                if (cursor.moveToFirst())
                {
                do {

                String strProfile_Pics = cursor.getString(cursor.getColumnIndex("ProfilePICURL"));
                String strDownLoadStatus = cursor.getString(cursor.getColumnIndex("DownLoadStatus"));
                if(strDownLoadStatus.equals("0") && strProfile_Pics.length() != 0)
                {
                    String URL_downLoadProfilePic = namespace + "/DownloadFile/FilePathMobile/PROFILEPICPATH/FileName/" + strProfile_Pics;
                    newFolder = new File(Environment.getExternalStorageDirectory().getPath() + File.separator + "classNKK_ProfilePic");
                    download_PngFileImgLoader(URL_downLoadProfilePic, newFolder, strProfile_Pics);
                    updatedArrayList.add(strProfile_Pics);
                    Log.e("URL_downLoadProfilePic ", " ==========>" + URL_downLoadProfilePic);

                }

            } while (cursor.moveToNext());
        }
        cursor.close();

            }

Why not use a WHERE clause in the query itself?

camelCaseCoder
– camelCaseCoder

2016-02-17 11:02:06 +00:00
Commented Feb 17, 2016 at 11:02 — camelCaseCoder
– camelCaseCoder, Commented Feb 17, 2016 at 11:02

Fabio Venturi Pastor · Accepted Answer · 2016-02-17 11:08:34Z

1

try this:

     String strProfile_Pics = cursor.getString(cursor.getColumnIndex("ProfilePICURL"));
       if(strDownLoadStatus.equals("0") && 
            strProfile_Pics != null && 
               !strProfile_Pics.trim().isEmpty()){
         //do stuff
         }

edited Feb 17, 2016 at 11:08

answered Feb 17, 2016 at 11:03

Fabio Venturi Pastor

2,5293 gold badges22 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rajan Kali · Accepted Answer · 2016-02-17 11:09:09Z

0

Try this query

  Cursor cursor = db.rawQuery("select * from Inspector where profilePICURL IS NULL ", null);

This query will return all the empty/null rows of Profile pic Url.

answered Feb 17, 2016 at 11:09

Rajan Kali

13.1k3 gold badges27 silver badges37 bronze badges

1 Comment

p. ld Over a year ago

I don't have to retrieve empty/null rows of Profile pic.I want to avoid empty/null rows while download the Profile pic.

Collectives™ on Stack Overflow

How to know if specific row is empty in Android SQlite database

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related