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 && cursor.getCount()!=0)           cursor.moveToNext();     return cursor; }     

In My activity:

list_tasklistname.setOnItemClickListener(new OnItemClickListener() {     @Override     public void onItemClick(AdapterView<?> 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()>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.

Answer 1

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();