//pageSize:每页的记录数
//pageNum:第几页,从1开始
public List<Account> queryPage(int pageSize, int pageNum) {
String index = (pageNum - 1) * pageSize + ""; // 分页时的起始索引
String count = pageSize + ""; // 查询多少条数据
List<Account> list = new ArrayList<Account>();
SQLiteDatabase db = helper.getReadableDatabase();
Cursor c = db.rawQuery("SELECT * FROM account LIMIT ?,?", new String[] { index, count });
while (c.moveToNext()) {
int id = c.getInt(0);
String name = c.getString(1);
int balance = c.getInt(2);
list.add(new Account(id, name, balance));
}
c.close();
db.close();
return list;
}
SQLite数据库的分页查询
最新推荐文章于 2025-06-28 13:26:08 发布