pageNo * pageSize(0-based)。ceil(totalCount/pageSize)。
public class Page {
public static final String ASC = "asc", DESC = "desc";
private int pageNo = 0;
private int pageSize = 20;
private String orderBy, order;
private boolean autoCount = true;
private List result = Collections.emptyList();
private long totalCount = -1;
// Getters/Setters 略...
public int getFirst() { return pageNo * pageSize; } // 0-based offset
public int getOffset() { return getFirst(); }
public long getTotalPages() {
if (totalCount < 0) return -1;
return (totalCount + pageSize - 1) / pageSize;
}
}
public Page queryUsers(Page page) {
SQLiteDatabase db = getReadableDatabase();
String sql = "SELECT * FROM users";
if (page.getOrderBy() != null) {
sql += " ORDER BY " + page.getOrderBy() + " " + page.getOrder();
}
sql += " LIMIT ? OFFSET ?";
Cursor c = db.rawQuery(sql, new String[]{String.valueOf(page.getPageSize()), String.valueOf(page.getOffset())});
List list = new ArrayList<>();
while (c.moveToNext()) {
list.add(cursorToUser(c));
}
c.close();
page.setResult(list);
if (page.isAutoCount()) {
page.setTotalCount(countAllUsers());
}
return page;
}
View footer = LayoutInflater.from(this).inflate(R.layout.list_footer, listView, false);
Button btnLoad = footer.findViewById(R.id.btnLoadMore);
listView.addFooterView(footer);
btnLoad.setOnClickListener(v -> {
currentPage++;
Page page = new Page<>(20);
page.setPageNo(currentPage);
loadPage(page);
});
listView.setOnScrollListener(new AbsListView.OnScrollListener() {
@Override public void onScrollStateChanged(AbsListView view, int scrollState) {}
@Override public void onScroll(AbsListView view, int firstVisible, int visibleCount, int totalCount) {
if (!isLoading && firstVisible + visibleCount >= totalCount && currentPage < totalPages) {
isLoading = true;
currentPage++;
Page page = new Page<>(20);
page.setPageNo(currentPage);
loadPage(page);
}
}
});
private void loadPage(Page page) {
executor.execute(() -> {
Page result = userDao.queryUsers(page);
runOnUiThread(() -> {
isLoading = false;
if (result.getResult() != null && !result.getResult().isEmpty()) {
adapter.appendData(result.getResult()); // 內部 addAll + notifyDataSetChanged
currentPage = result.getPageNo();
totalPages = (int) result.getTotalPages();
} else {
Toast.makeText(this, "無更多資料", Toast.LENGTH_SHORT).show();
}
});
});
}
public void appendData(List newData) {
int start = data.size();
data.addAll(newData);
notifyItemRangeInserted(start, newData.size()); // RecyclerView
// notifyDataSetChanged(); // ListView
}
PagingSource 定義資料來源(Room、網路、混合)。Pager 產生 Flow。PagingDataAdapter 配合 RecyclerView 自動處理分頁、預載入、錯誤重試、分隔線。RemoteMediator 實現網路+資料庫同步分頁。掌握分頁核心邏輯,無論手寫 Page 類或使用 Paging Library,都能構建流暢、高效的大量資料列表體驗。