예제 #1
0
 /** 查询全部的黑名单号码 */
 public List<BlackNumberInfo> findAll() {
   // 得到可读的数据库
   SQLiteDatabase db = helper.getReadableDatabase();
   Cursor cursor =
       db.query("blackinfo", new String[] {"number", "mode"}, null, null, null, null, null);
   List<BlackNumberInfo> blackNumberInfos = new ArrayList<BlackNumberInfo>();
   while (cursor.moveToNext()) {
     BlackNumberInfo info = new BlackNumberInfo();
     String number = cursor.getString(0);
     String mode = cursor.getString(1);
     info.setMode(mode);
     info.setNumber(number);
     blackNumberInfos.add(info);
   }
   cursor.close();
   db.close();
   SystemClock.sleep(3000);
   return blackNumberInfos;
 }
예제 #2
0
 /**
  * 分批加载数据
  *
  * @param startIndex 从哪个位置开始加载数据
  * @param maxCount 最多加载几条数据
  */
 public List<BlackNumberInfo> findPart2(int startIndex, int maxCount) {
   // 得到可读的数据库
   SQLiteDatabase db = helper.getReadableDatabase();
   Cursor cursor =
       db.rawQuery(
           "select number,mode from blackinfo order by _id desc limit ? offset ?",
           new String[] {String.valueOf(maxCount), String.valueOf(startIndex)});
   List<BlackNumberInfo> blackNumberInfos = new ArrayList<BlackNumberInfo>();
   while (cursor.moveToNext()) {
     BlackNumberInfo info = new BlackNumberInfo();
     String number = cursor.getString(0);
     String mode = cursor.getString(1);
     info.setMode(mode);
     info.setNumber(number);
     blackNumberInfos.add(info);
   }
   cursor.close();
   db.close();
   SystemClock.sleep(1000);
   return blackNumberInfos;
 }
예제 #3
0
 /**
  * 分页查询数据库的记录
  *
  * @param pagenumber 第几页,页码 从第0页开始
  * @param pagesize 每一个页面的大小
  */
 public List<BlackNumberInfo> findPart(int pagenumber, int pagesize) {
   // 得到可读的数据库
   SQLiteDatabase db = helper.getReadableDatabase();
   Cursor cursor =
       db.rawQuery(
           "select number,mode from blackinfo limit ? offset ?",
           new String[] {String.valueOf(pagesize), String.valueOf(pagesize * pagenumber)});
   List<BlackNumberInfo> blackNumberInfos = new ArrayList<BlackNumberInfo>();
   while (cursor.moveToNext()) {
     BlackNumberInfo info = new BlackNumberInfo();
     String number = cursor.getString(0);
     String mode = cursor.getString(1);
     info.setMode(mode);
     info.setNumber(number);
     blackNumberInfos.add(info);
   }
   cursor.close();
   db.close();
   SystemClock.sleep(30);
   return blackNumberInfos;
 }