count Database table row Number - Android Database

Description

count Database table row Number

Demo Code

//package com.book2s;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

public class Main {
    public static int countDataNum(SQLiteDatabase db, String TABLE_NAME) {

        String sql = " select count(*) from " + TABLE_NAME;
        Cursor cursor = db.rawQuery(sql, null);
        cursor.moveToLast();//from w  w w  .  j a va  2  s  .  co  m
        int count = cursor.getInt(0);
        return count;

    }
}

• Previous
• Next

Related Tutorials

• fetch All Countries' name from SQLiteDatabase by table name
• fetch Cursor By table name from SQLiteDatabase
• fetch List of String from SQLiteDatabase by table name
• Return the count of all records in a table matching a selection.
• Returns a single String from a query from Database.