what is the query to check whether data is present in Sqlite database in android?

Question

I parsed the json data and put these values in database(Sqlite database). Next time when i open the activity it again parsed the data and put these values in database. so i want to check first whether data is in sqlite?, if so then i need to skip parsing. And just get these values from database. how can i do this?

Simple SELECT Query which returns Cursor with data is enough for this. — user370305
– user370305, Commented Aug 21, 2012 at 5:21
I'm not sure what you mean. Try to check if you can read data from SQLite: SELECT * FROM YourTable — Bruno Bieri
– Bruno Bieri, Commented Aug 21, 2012 at 5:22

Chirag · Accepted Answer · 2012-08-21 05:22:29Z

1

Try this.

public int isDataAvailable()
    {
        int total = 0;
        try
        {
            Cursor c = null;
            c = db.rawQuery("select id from mycoupon", null);

            if(c.getCount() != 0)
                total = c.getCount();

            c.close();
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        return total; 
    }

If there are no records in table then it returns 0 otherwise returns no of records.

answered Aug 21, 2012 at 5:22

Chirag

56.9k29 gold badges155 silver badges199 bronze badges

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

1 Comment

Chirag Over a year ago

@Brinda-user1594986 Always Welcome

Collectives™ on Stack Overflow

what is the query to check whether data is present in Sqlite database in android?

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related