Mybatis-plus分页和Element的Pagination分页组件

一.Mybatis-plus实现分页查询

1.Controller层 T:所要查询的对象实体 page:当前页码 limit:每页记录数 IPage pageModel = adService.selectPage(page, limit); List records = pageModel.getRecords(); long total = pageModel.getTotal();

@ApiOperation("推荐类别分页列表") @GetMapping("list/{page}/{limit}") public R listPage(@ApiParam(value = "当前页码",required = true)@PathVariable long page,@ApiParam(value = "每页记录数",required = true)@PathVariable long limit){ IPage<AdVo> pageModel = adService.selectPage(page, limit); List<AdVo> records = pageModel.getRecords(); long total = pageModel.getTotal(); return R.ok().data("total", total).data("rows", records); }

2.ServiceImpl层

实现Service层的 selectPage接口

public IPage<AdVo> selectPage(long page, long limit) { QueryWrapper<AdVo> queryWrapper = new QueryWrapper<>(); queryWrapper.orderByAsc("a.type_id", "a.sort"); //创建分页对象 Page<AdVo> pageParam = new Page<>(page, limit); List<AdVo> records = baseMapper.selectPageByQueryWrapper(pageParam, queryWrapper); pageParam.setRecords(records); return pageParam; }

3.Mapper层

实现baseMapper.selectPageByQuery方法

@Param(Constants.WRAPPER) ：相当于@Param(“ew”),与mapper.xml中${ew.customSqlSegment}拼接where子句

List<AdVo> selectPageByQueryWrapper(Page<AdVo> pageParam,@Param(Constants.WRAPPER) QueryWrapper<AdVo> queryWrapper); }

4.mapper.xml

<select id="selectPageByQueryWrapper" resultType="com.atguigu.guli.service.cms.entity.vo.AdVo"> SELECT a.id, a.title, a.sort, t.title AS type FROM cms_ad a LEFT JOIN cms_ad_type t ON a.type_id = t.id ${ew.customSqlSegment} </select>

二、Pagination分页组件 1.list.vue

<template> <div> <!-- 分页组件 --> <el-pagination :current-page="page" :total="total" :page-size="limit" :page-sizes="[5, 10, 20, 30, 40, 50, 100]" style="padding: 30px 0; text-align: center;" layout="total, sizes, prev, pager, next, jumper" @size-change="changePageSize" @current-change="changeCurrentPage" /> </div> </template> export default { // 定义数据模型 data() { return { list: [], // 列表 total: 0, // 总记录数 page: 1, // 页码 limit: 10 // 每页记录数 } }, // 定义方法 methods: { fetchData() { // 调用api adTypeApi.pageList(this.page, this.limit).then(response => { this.list = response.data.rows this.total = response.data.total }) }, // 每页记录数改变，size：回调参数，表示当前选中的“每页条数” changePageSize(size) { this.limit = size this.fetchData() }, // 改变页码，page：回调参数，表示当前选中的“页码” changeCurrentPage(page) { this.page = page this.fetchData() },

附录：list.vue

<template> <div class="app-container"> <!-- 工具按钮 --> <div style="margin-bottom: 10px"> <router-link to="/ad/type-create"> <el-button type="primary" size="mini" icon="el-icon-edit">添加推荐位</el-button> </router-link> </div> <!-- 表格 --> <el-table :data="list" border stripe> <el-table-column label="#" width="50"> <template slot-scope="scope"> {{ (page - 1) * limit + scope.$index + 1 }} </template> </el-table-column> <el-table-column prop="title" label="推荐位名称" /> <el-table-column label="操作" width="200" align="center"> <template slot-scope="scope"> <router-link :to="'/ad/type-edit/'+scope.row.id"> <el-button type="primary" size="mini" icon="el-icon-edit">修改</el-button> </router-link> <el-button type="danger" size="mini" icon="el-icon-delete" @click="removeById(scope.row.id)">删除</el-button> </template> </el-table-column> </el-table> <!-- 分页组件 --> <el-pagination :current-page="page" :total="total" :page-size="limit" :page-sizes="[5, 10, 20, 30, 40, 50, 100]" style="padding: 30px 0; text-align: center;" layout="total, sizes, prev, pager, next, jumper" @size-change="changePageSize" @current-change="changeCurrentPage" /> </div> </template> <script> import adTypeApi from '@/api/adType' export default { // 定义数据模型 data() { return { list: [], // 列表 total: 0, // 总记录数 page: 1, // 页码 limit: 10 // 每页记录数 } }, // 页面渲染成功后获取数据 created() { this.fetchData() }, // 定义方法 methods: { fetchData() { // 调用api adTypeApi.pageList(this.page, this.limit).then(response => { this.list = response.data.rows this.total = response.data.total }) }, // 每页记录数改变，size：回调参数，表示当前选中的“每页条数” changePageSize(size) { this.limit = size this.fetchData() }, // 改变页码，page：回调参数，表示当前选中的“页码” changeCurrentPage(page) { this.page = page this.fetchData() }, // 根据id删除数据 removeById(id) { this.$confirm('此操作将永久删除该记录, 是否继续?', '提示', { confirmButtonText: '确定', cancelButtonText: '取消', type: 'warning' }).then(() => { return adTypeApi.removeById(id) }).then((response) => { this.fetchData() this.$message.success(response.message) }).catch(error => { // 当取消时会进入catch语句:error = 'cancel' // 当后端服务抛出异常时：error = 'error' if (error === 'cancel') { this.$message.info('取消删除') } }) } } } </script>