Integer pageSize = queryPageBean.getPageSize(); Integer pageNum = queryPageBean.getCurrentPage(); String queryString = queryPageBean.getQueryString(); Integer currentPage = (pageNum-1)*pageSize;//当前页计算成limit需要的数值 List<Cash> page = cashMapper.findCashListByPage(currentPage, pageSize,queryString);
手动将参数计算,重新传入sql语句 Mapper.xml文件中sql如下:
<!--分页查询提现列表--> <select id="findByPage" parameterType="Map" resultType="com.chuang.pojo.Cash"> SELECT * FROM t_cash <if test="queryString != null and queryString.length > 0"> where username = #{queryString} </if> limit #{currentPage},#{pageSize} </select>
<el-pagination class="pagiantion" @current-change="handleCurrentChange" :current-page="pagination.currentPage" :page-size="pagination.pageSize" layout="total, prev, pager, next, jumper" :total="pagination.total"> </el-pagination>
element-ui配置完成分页后,点击页码数字,current-page并没有变化,请求传进去的参数还是原来的。
加上".sync"后生效,成功传入参数
<el-pagination class="pagiantion" @current-change="handleCurrentChange" :current-page.sync="pagination.currentPage" :page-size="pagination.pageSize" layout="total, prev, pager, next, jumper" :total="pagination.total"> </el-pagination>