1.查询前N条记录:
public Cursor query(String sql,String[] selectionArgs){
SQLiteDatabase db=
dbHelper.getReadableDatabase();
return db.rawQuery(sql,selectionArgs);
}
String sql2="SELECT * FROM "+ DetectDao.DETECT_TABLE+" order by "+DetectDao.KEY_ID+" limit 20";
cursor=DetectDao.getInstance(MyService.this).query(sql2, null);
DetectDao.KEY_ID是自增ID。
2.删除前N条记录: