public List<BlackInfo> findAll() {
List<BlackInfo> list = new ArrayList<BlackInfo>();
SQLiteDatabase db = helper.getReadableDatabase();
// "select number,type from blacklist;"
String sql =
"select "
+ BlackListDB.BlackList.COLUMN_NUMBER
+ ","
+ BlackListDB.BlackList.COLUMN_TYPE
+ " from "
+ BlackListDB.BlackList.TABLE_NAME;
Cursor cursor = db.rawQuery(sql, null);
if (cursor != null) {
while (cursor.moveToNext()) {
String number = cursor.getString(0);
int type = cursor.getInt(1);
BlackInfo info = new BlackInfo();
info.number = number;
info.type = type;
list.add(info);
}
cursor.close();
}
db.close();
return list;
}
public int findType(String number) {
SQLiteDatabase db = helper.getReadableDatabase();
// select type from 表名 where number=?;
String sql =
"select "
+ BlackListDB.BlackList.COLUMN_TYPE
+ " from "
+ BlackListDB.BlackList.TABLE_NAME
+ " where "
+ BlackListDB.BlackList.COLUMN_NUMBER
+ "=?";
String[] selectionArgs = new String[] {number};
Cursor cursor = db.rawQuery(sql, selectionArgs);
int type = -1;
if (cursor != null) {
if (cursor.moveToNext()) {
type = cursor.getInt(0);
}
cursor.close();
}
db.close();
return type;
}
