分页实例如下(结合springMVC):
分页相关的,只需要传页码和一页的数据条数;返回就返回一页的数据.
传入的rows为一页的数据量.
@RequestMapping("/list")
public Result list(Orderhistory orderhistory,
@RequestParam(value = "page", defaultValue = "1", required = false) int page,
@RequestParam(value = "rows", defaultValue = "20", required = false) int rows) {
Result result =new Result();
int total = objSQLRichService.count(orderhistory); //可以用上缓存,提交效率
List<Orderhistory> list=objSQLRichService.select(orderhistory, (page-1)*rows, rows);
result.setRows(list);
result.setTotal(total);//返回的总数据条数,有些前端框架需要.
return result;
}
更改详情,可参考: