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="pag