SQLite数据库的添删改查 - 数据库编程

son(id, name, phone);
}
return null;
}
/**
* 分页获取记录
* @param offset 跳过前面多少条记录
* @param maxResult 每页获取的记录数
* @return
*/
public List getScrollData(int offset, int maxResult){
List persons = new ArrayList();
SQLiteDatabase db = dbOpenHelper.getReadableDatabase();
Cursor cursor = db.rawQuery("select * from person order by id asc limit , ",
new String[]{String.valueOf(offset), String.valueOf(maxResult)});

while(cursor.moveToNext()){
int id = cursor.getInt(cursor.getColumnIndex("id"));
String phone = cursor.getString(cursor.getColumnIndex("phone"));

String name = cursor.getString(cursor.getColumnIndex("name"));
persons.add(new Person(id, name, phone));
}
cursor.close();
return persons;
}
/**
* 获取记录总数
* @return
*/
public long getCount(){
SQLiteDatabase db = dbOpenHelper.getReadableDatabase();
Cursor cursor = db.rawQuery("select count(*) from person", null);
cursor.moveToFirst();
long count = cursor.getLong(0);
cursor.close();
return count;
}
}

作者“亨利摩根的专栏”

SQLite数据库的添删改查(二)