How to find the length of a SQLite android table?

Question

Java

I want to implement a start window where I will set a password if there are no rows in the table. Otherwise, launch another activity. How to get the length of a table or check if a row exists in a table.

Answer 1

long rowCount  = DatabaseUtils.queryNumEntries(db, TABLE_NAME);

or

long rowCount = DatabaseUtils.longForQuery(db, "SELECT COUNT(*) FROM table_name", null);