currentIndex 起始索引
showCount每页多少条
// 构建page分页参数
Page page = new Page();
// 设置每页显示记录数
if (showCount == null) {
page.setShowCount(20);
} else {
page.setShowCount(showCount);
}
// 设置查询记录起始索引
if(currentPage==null){
page.setCurrentIndex(0);
}else{
int currentIndex = (currentPage - 1) * showCount;
page.setCurrentIndex(currentIndex);
}
// 设置检索条件
PageData pd = new PageData();
page.setPd(pd);
可以这么写接口
@RequestMapping(value = "/listLandProjectInfo", produces = "application/json;charset=utf-8")
public String listProjectInfo(
@RequestParam(value = "createUser", required = false) String createUser,
@RequestParam(value = "areaName", required = false) String areaName,
@RequestParam(value = "layerName", required = false) String layerName,
@RequestParam(value = "showCount", required = false) Integer showCount,
@RequestParam(value = "currentPage", required = false) Integer currentPage) {
// 构建page分页参数
Page page = new Page();
// 设置每页显示记录数
if (showCount == null) {
page.setShowCount(20);
} else {
page.setShowCount(showCount);
}
// 设置查询记录起始索引
if(currentPage==null){
page.setCurrentIndex(0);
}else{
int currentIndex = (currentPage - 1) * showCount;
page.setCurrentIndex(currentIndex);
}
// 设置检索条件
PageData pd = new PageData();
if (StringUtil.isNotBlank(createUser)) {
pd.put("create_user", createUser);
}
if (StringUtil.isNotBlank(areaName)) {
pd.put("area_name", areaName);
}
if (StringUtil.isNotBlank(layerName)) {
pd.put("layer_name", layerName);
}
page.setPd(pd);
JSONObject resultJson = new JSONObject();
try {
// 根据条件查询数据
List<PageData> list = landProjectInfoService.dataListPage(page);
resultJson.put("RespCode", Const.REQUEST_CODE_SUCCESS);
resultJson.put("RespMessage",
Const.REQUEST_MSG_MAP.get(Const.REQUEST_CODE_SUCCESS));
resultJson.put("Body", JSONArray.fromObject(list));
} catch (Exception e) {
e.printStackTrace();
resultJson.put("RespCode", Const.REQUEST_CODE_ERROR);
resultJson.put("RespMessage",
Const.REQUEST_MSG_MAP.get(Const.REQUEST_CODE_ERROR));
resultJson.put("ErrorMessage", e.getMessage());
}
return resultJson.toString();
}