MyBatisPlus插件扩展_PaginationInterceptor分页插件的使用

末蓝、 2023-08-17 17:12 65阅读 0赞

## 实现 ##

#### 配置插件 ####

来到项目下的applicationContext.xml中配置sqlSessionFactoryBean的地方。

<bean id="sqlSessionFactoryBean" class="com.baomidou.mybatisplus.spring.MybatisSqlSessionFactoryBean">
      
      <property name="dataSource" ref="dataSource"></property>
      <property name="configLocation" value="classpath:mybatis-config.xml"></property>
      
      <property name="typeAliasesPackage" value="com.badao.beans"></property> 
      
      <property name="globalConfig" ref="globalConfiguration"></property> 
      
      <property name="plugins">
       <list>
        
        <bean class="com.baomidou.mybatisplus.plugins.PaginationInterceptor"></bean>
       </list>
      </property> 
     </bean>

#### 测试分页插件 ####

编写单元测试

/*** * 分页插件 */
     @Test
     public void testPagePlugin() { 
      Page<Employee> page = new Page<Employee>(1,2);
       List<Employee> list=employeeMapper.selectPage(page, null);
      for ( Employee employee : list) { 
       System.out.println("*******************"+employee.getName());
      }
      System.out.println("获取分页信息");
      System.out.println("总条数"+page.getTotal());
      System.out.println("当前页码"+page.getCurrent());
      System.out.println("总页码"+page.getPages());
      System.out.println("每页显示的条数"+page.getSize());
      System.out.println("是否有上一页"+page.hasPrevious());
      System.out.println("是否有下一页"+page.hasNext());
      
      //将查询的结果直接封装到page对象中
      page.setRecords(list);
      
     }

#### Page对象 ####

实现分页辅助类  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMjQxOTU3_size_16_color_FFFFFF_t_70]  
继承了Pagination,所以也继承了方法。  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMjQxOTU3_size_16_color_FFFFFF_t_70 1]

#### 运行单元测试 ####

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMjQxOTU3_size_16_color_FFFFFF_t_70 2]

本文转载自：https://blog.csdn.net/BADAO\_LIUMANG\_QIZHI/article/details/89599657

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMjQxOTU3_size_16_color_FFFFFF_t_70]: /images/20230808/af4f324c2a6d44e0914d175c04343dad.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMjQxOTU3_size_16_color_FFFFFF_t_70 1]: /images/20230808/4d888156052747f8b9df1b481513ee3e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQwMjQxOTU3_size_16_color_FFFFFF_t_70 2]: /images/20230808/f1fa0071cc9b49afbb784a98a7818dad.png