# 查詢分頁
分頁是用到比較多的模塊,如想實現分頁,需加selectForPage然后傳args.getPageParams()接收參數,系統會自動解析生成分頁,并返回總頁數,當前頁數,總條數,列表模塊數據。當然也可以不加selectForPage或不加select方法,只相當于傳sql語句;下面是示例,一起看下吧!
分頁查詢示例
```java
Page<RowData> rowData = Db.name("tg_task").where("status", 1).selectForPage(args.getPageParams());
或
Query<RowData> rowData = Db.name("tg_task").where("status", 1);
```
分頁遍歷示例
```java
Page<RowData> rowData = Db.name("tg_task").where("status", 1).rowDataCallback(new RowDataCallback<RowData, Integer>() {
@Override
public void onData(RowData data, Integer index) {
data.set("abc", 123);
}
}).selectForPage(args.getPageParams());
或
Query<RowData> rowData = Db.name("tg_task").where("status", 1).rowDataCallback(new RowDataCallback<RowData, Integer>() {
@Override
public void onData(RowData data, Integer index) {
data.set("abc",123);
}
});
```
運行結果
```java
{
"code": 1,
"msg": "success",
"data": {
"total": 2,
"pageSize": 100,
"page": 1,
"pageTotalNum": 1,
"rows": [
{
"abc": 123,
"end_time": "1628352000",
"remark": "",
"title": "李白的【2021-08-06到2021-08-08】工作任務",
"addtime": "1628219679"
},
{
"abc": 123,
"end_time": "1628352000",
"remark": "",
"title": "2222",
"addtime": "1628239735"
}
]
}
}
```