SpringBoot——MyBatisPlus分页查询

短命女 2021-10-18 14:38 707阅读 0赞

# 1.配置分页类 #

package com.youyou.address.config;
    
    import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    import org.springframework.transaction.annotation.EnableTransactionManagement;
    
    //Spring boot方式
    @EnableTransactionManagement(proxyTargetClass = true)
    @Configuration
    public class MybatisPlusConfig {
    
        /**
         * 分页插件
         */
        @Bean
        public PaginationInterceptor paginationInterceptor() {
            return new PaginationInterceptor();
        }
    }

# 2.service代码 #

因为我们是使用集成 过来的方法，所以不需要写dao层方法。

package com.youyou.address.service;
    
    import com.baomidou.mybatisplus.core.metadata.IPage;
    import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
    import com.youyou.address.dao.ContacterDao;
    import com.youyou.address.entity.ContacterEO;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    import org.springframework.transaction.annotation.Transactional;
    
    import java.util.List;
    
    @Service
    @Transactional
    public class ContacterService {
    
        @Autowired
        private ContacterDao dao;
    
    
        /**
         * 分页查询
         * @param page
         * @return
         */
        public IPage<ContacterEO> findByPage(Page<ContacterEO> page){
            return   dao.selectPage(page, null);
    
        }
    
      
    }

# 3.controller代码 #

@ApiOperation(value = "分页查询")
        @GetMapping("/findByPage")
        public IPage<ContacterEO> findByPage(int pageNo , int pageSize) {
            Page<ContacterEO> page = new Page<>(pageNo,pageSize);
    
            return service.findByPage(page);
        }

测试一下结果如下：

查询参数：

![2018110415155553.png][]

查询结果：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xwODQwMzEyNjk2_size_16_color_FFFFFF_t_70][]

[2018110415155553.png]: /images/20211018/0360fd10b4ef410eaa60f3b1c2323856.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2xwODQwMzEyNjk2_size_16_color_FFFFFF_t_70]: /images/20211018/23ab6b3295b448898fddf35bfc1a6eb4.png