How to get row count in sqlite using Android

Question

I am creating task manager  I have tasklist and I want when I click on particular tasklist name if it empty then it goes on Add Task activity but if it has 2 or 3 tasks then it shows me those tasks into it in list form   I am trying to get count in list  my database query is like   public Cursor getTaskCount long tasklist Id         SQLiteDatabase db   this getWritableDatabase        Cursor cursor  db rawQuery  SELECT COUNT     FROM     TABLE TODOTASK     WHERE     KEY TASK TASKLISTID                      new String     String valueOf tasklist Id          if cursor  null  amp  amp  cursor getCount    0            cursor moveToNext        return cursor          In My activity   list tasklistname setOnItemClickListener new OnItemClickListener          Override     public void onItemClick AdapterView lt   gt  arg0              android view View v  int position  long id                    db   new TodoTask Database getApplicationContext                     Cursor c   db getTaskCount id                   System out println c getCount                     if c getCount   gt 0                        System out println c                   Intent taskListID   new Intent getApplicationContext    AddTask List class                   task   adapter getItem position                   int taskList id   task getTaskListId                    taskListID putExtra  TaskList ID   taskList id                   startActivity taskListID                             else                   Intent addTask   new Intent getApplicationContext    Add Task class                   startActivity addTask                                       db close        but when I am clicking on tasklist name it is returning 1  bot number of tasks into it

User · Answer

Sooo simple to get row count   cursor   dbObj rawQuery  select count    from TABLE where COLUMN NAME    1     null   cursor moveToFirst    String count   cursor getString cursor getColumnIndex cursor getColumnName 0

User · Answer

I know it is been answered long time ago  but i would like to share this also   This code works very well   SQLiteDatabase db   this getReadableDatabase    long taskCount   DatabaseUtils queryNumEntries db  TABLE TODOTASK     BUT what if i dont want to count all rows and i have a condition to apply   DatabaseUtils have another function for this  DatabaseUtils longForQuery  long taskCount   DatabaseUtils longForQuery db   SELECT COUNT     FROM     TABLE TODOTASK     WHERE     KEY TASK TASKLISTID                  new String     String valueOf tasklist Id        The longForQuery documentation says      Utility method to run the query on the db and  return the value in the first column of the first row    public static long longForQuery SQLiteDatabase db  String query  String   selectionArgs    It is performance friendly and save you some time and boilerplate code   Hope this will help somebody someday

User · Answer

c getCount   returns 1 because the cursor contains a single row  the one with the real COUNT      The count you need is the int value of first row in cursor   public int getTaskCount long tasklist Id         SQLiteDatabase db   this getReadableDatabase        Cursor cursor  db rawQuery           SELECT COUNT     FROM     TABLE TODOTASK     WHERE     KEY TASK TASKLISTID                  new String     String valueOf tasklist Id               int count   0      if null    cursor          if cursor getCount    gt  0             cursor moveToFirst                  count   cursor getInt 0                     cursor close               db close        return count

User · Answer

Do you see what the DatabaseUtils queryNumEntries   does  It s awful  I use this   public int getRowNumberByArgs Object    args        String where   compileWhere args       String raw   String format  SELECT count    FROM  s WHERE  s    TABLE NAME  where       Cursor c   getWriteableDatabase   rawQuery raw  null       try           return  c moveToFirst      c getInt 0    0        finally           c close

User · Answer

Change your getTaskCount Method to this   public int getTaskCount long tasklist id       SQLiteDatabase db   this getWritableDatabase        Cursor cursor  db rawQuery  SELECT COUNT     FROM     TABLE TODOTASK     WHERE     KEY TASK TASKLISTID         new String     String valueOf tasklist id          cursor moveToFirst        int count  cursor getInt 0       cursor close        return count      Then  update the click handler accordingly   public void onItemClick AdapterView lt   gt  arg0  android view View v  int position  long id        db   new TodoTask Database getApplicationContext             Get task list id     int tasklistid   adapter getItem position  getTaskListId         if db getTaskCount tasklistid   gt  0                System out println c           Intent taskListID   new Intent getApplicationContext    AddTask List class           taskListID putExtra  TaskList ID   tasklistid           startActivity taskListID         else           Intent addTask   new Intent getApplicationContext    Add Task class           startActivity addTask

User · Answer

In order to query a table for the number of rows in that table  you want your query to be as efficient as possible  Reference   Use something like this          Query the Number of Entries in a Sqlite Table       public long QueryNumEntries         SQLiteDatabase db   this getReadableDatabase        return DatabaseUtils queryNumEntries db   table name

User · Answer

Using DatabaseUtils queryNumEntries     public long getProfilesCount         SQLiteDatabase db   this getReadableDatabase        long count   DatabaseUtils queryNumEntries db  TABLE NAME       db close        return count      or  more inefficiently   public int getProfilesCount         String countQuery    SELECT    FROM     TABLE NAME      SQLiteDatabase db   this getReadableDatabase        Cursor cursor   db rawQuery countQuery  null       int count   cursor getCount        cursor close        return count      In Activity   int profile counts   db getProfilesCount        db close

User · Answer

Use android database DatabaseUtils to get number of count   public long getTaskCount long tasklist Id            return DatabaseUtils queryNumEntries readableDatabase  TABLE NAME       It is easy utility that has multiple wrapper methods to achieve database operations

User · Answer

Once you get the cursor you can do      Cursor getCount

[android] How to get row count in sqlite using Android?

Examples related to android

Examples related to android-sqlite

Examples related to onitemclicklistener