我正在尝试在CellTable中实现分页,但当前显示的是“ 10个记录中的1-10个”而不是“ 1000个记录中的1-10个”.我不确定在哪里可以更新总记录数.我的AsyncDataProvider看起来像这样:
AsyncDataProvider latestProvider = new AsyncDataProvider() {
@Override
protected void onRangeChanged(HasData display) {
final int start = display.getVisibleRange().getStart();
int length = display.getVisibleRange().getLength();
AsyncCallback> callback = new AsyncCallback>() {
@Override
public void onFailure(Throwable caught) {
Window.alert(caught.getMessage());
}
@Override
public void onSuccess(List result) {
updateRowData(start, result);
}
};
// The remote service that should be implemented
service.getOutletPage(start, length, callback);
}
};
我用来获取记录的SQL与此类似:
SELECT *
FROM (SELECT outlet_id,
outlet_name,
image,
ROWNUM rn
FROM ( SELECT outlet_id outlet_id,
account_name outlet_name,
image_score image,
FROM outlets)
ORDER BY OOI.created_on DESC, OOI.account_name))
WHERE rn > ? AND rn < ?
在准备好的语句中,问号由开始和结束范围代替.