以前写mybatis分页,先要写一个count查询,然后再写一个真正分页查询的语句,效率比较低
List<RentDO> list = rentDAO.selectByPage(paramVO, sqlStr, status, (pageIndex - 1) * pageSize, pageSize);
PageVO<RentDO> pageVO = new PageVO<>();
pageVO.setTotal(rentDAO.count(paramVO, sqlStr
以前写mybatis分页,先要写一个count查询,然后再写一个真正分页查询的语句,效率比较低
List<RentDO> list = rentDAO.selectByPage(paramVO, sqlStr, status, (pageIndex - 1) * pageSize, pageSize);
PageVO<RentDO> pageVO = new PageVO<>();
pageVO.setTotal(rentDAO.count(paramVO, sqlStr