SQLite查询记录总数

public int getCount() {
  SQLiteDatabase db = dbOpenHelper.getReadableDatabase();
  Cursor cursor = db.rawQuery("select count(id) from table",null);
  cursor.moveToFirst();
  Long count = cursor.getInt(0);
  cursor.close();
  return count;
 }

 

posted @ 2015-11-17 16:50  安谧世界  阅读(11839)  评论(0编辑  收藏  举报