mybatis分页查询-蒲公英云

mybatis分页查询

r囧r小猫 2023-07-18 09:11 158阅读 0赞

mybatis分页查询

1.通过PageHelper实现分页查询

分页controller

@RequestMapping(“/getRealtimeByCondition”)

public ResultCode getRealtimeByCondition(Map<String,Object> filters, @RequestParam  Integer pageNumber, @RequestParam Integer pageSize){ 
    PageHelper.startPage(pageNumber,pageSize);
    try { 
        return ResultCode.success(new PageInfo(appService.getRealtime()));
    }catch (Exception e){ 
        return ResultCode.error(e.getMessage());
    }
}

2.通过limit offset关键字查询

controller.java

@RequestMapping(“/findFloodByPage”)

public ResultCode findFloodByPage(@RequestParam  Integer pageNumber, @RequestParam Integer pageSize) { 
    if ("".equals(pageNumber) || pageNumber == null  ||  "".equals(pageSize) || pageSize == null ) { 
        return ResultCode.errorParam("参数不能为空！");
    }
    List<FloodEntity> list = new ArrayList<FloodEntity>();
    try { 
        list = floodService.findFloodByPage(pageNumber,pageSize);
    } catch (Exception e) { 
        e.printStackTrace();
        return ResultCode.error("信息获取失败");
    }
    return ResultCode.success(list);
}

service.java

public List findFloodByPageOrKey(String key, Integer pageNumber, Integer pageSize) {
```
    return floodMapper.findFloodByPageOrKey(key,(pageNumber-1)*pageSize,pageSize);
}
```

dao.java

//分页或关键字查询防洪点

List<FloodEntity> findFloodByPageOrKey(@Param("key_word")String key_word,@Param("pageNumber") Integer pageNumber, @Param("pageSize")Integer pageSize);