android - 计算 sqlite，android 中特定列值的出现次数？

Question

我有一个表，其中特定列的值重复了多次。我想计算它发生了多少次。

假设数据库的“选择”列在表中重复了 5 次。如何计算？

这是我正在使用的代码

    public String getCountSelect() {
    String count = "";
    String selectQuery = "SELECT COUNT ( " + KEY_DEALER_NAME + " )  FROM "
            + TABLE_DEALER + " WHERE " + KEY_DEALER_NAME + " = 'Select'";
    Log.e("", selectQuery);
    SQLiteDatabase db = this.getWritableDatabase();
    Cursor cursor = db.rawQuery(selectQuery, null);
    if (cursor.moveToFirst()) {
        do {


            Log.e("", cursor.getString(cursor
                    .getColumnIndex(KEY_DEALER_NAME)));
        } while (cursor.moveToNext());
    }
    db.close();
    return count;
}

Answer 1

试试这个

 String selectQuery = "SELECT " + KEY_DEALER_NAME + "  FROM "
        + TABLE_DEALER + " WHERE " + KEY_DEALER_NAME + " = 'Select'";

 Cursor cursor = db.rawQuery(selectQuery, null);

 int total_count=cursor.getCount();

游标 .getCount() 方法返回受影响的总行数。