Mybatis-plus的兩種分頁方案

底層的邏輯是寫出最終執行的sql或者selectPage方法等，中間需要配置相應的page攔截器。

注意：如沒有配置攔截器，直接執行就會存在total的值為0，此方法無效。

1. 基于MP的IPage接口實現

使用步驟：

• 引入pom配置

<dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-boot-starter</artifactId>
</dependency>

• 配置分頁攔截器

@Configuration
public class MybatisPlusConfig {/*** 新的分頁插件,一緩和二緩遵循mybatis的規則,需要設置 		  MybatisConfiguration#useDeprecatedExecutor = false 避免緩存出現問題*/@Beanpublic MybatisPlusInterceptor mybatisPlusInterceptor() {MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.H2));return interceptor;}
}

• 執行測試

@Testpublic void testSelectPage(){Page<User> page = new Page<>(0, 5);page.addOrder(OrderItem.asc("age"));page.setOptimizeCountSql(false);//關閉自動優化Page<User> userIPage = userMapper.selectPage(page, Wrappers.<User>lambdaQuery().eq(User::getAge, 19).like(User::getName, "bob"));assertThat(page).isSameAs(userIPage);log.error("總條數 -------------> {}", userIPage.getTotal());log.error("當前頁數 -------------> {}", userIPage.getCurrent());log.error("當前每頁顯示數 -------------> {}", userIPage.getSize());List<User> records = userIPage.getRecords();assertThat(records).isNotEmpty();}

2. 基于PageHelper的第三方組件實現

• 引入配置

<dependency><groupId>com.baomidou</groupId><artifactId>mybatis-plus-boot-starter</artifactId><!-- pagehelper 包含該依賴存在版本沖突，因此不建議和 mp 一起混用 --><exclusions><exclusion><groupId>com.github.jsqlparser</groupId><artifactId>jsqlparser</artifactId></exclusion></exclusions>
</dependency>
<dependency><groupId>com.github.pagehelper</groupId><artifactId>pagehelper</artifactId><version>5.1.11</version>
</dependency>

• 配置攔截器

@Configuration
public class MyBatisPlusConfig {// 基于PageHelper@BeanPageInterceptor pageInterceptor() {PageInterceptor pageInterceptor = new PageInterceptor();Properties properties = new Properties();properties.setProperty("helperDialect", "mysql");pageInterceptor.setProperties(properties);  // 由此可進入源碼，return pageInterceptor;}}

• 執行測試

@Test
void test() {// pagehelperMap<String, Object> params = new HashMap<>();params.put("name", "%");PageHelper.startPage(3, 2);List<User> list = userMapper.pageUser(params);System.out.println("list.size=" + info.getList().size());log.info(JSONUtil.toJsonStr(info.getList()));System.out.println("page.total=" + info.getTotal());
}
########分隔符#########
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.pimee.bootmybatisplus.mapper.UserMapper"><select id="pageUser" resultType="com.pimee.bootmybatisplus.model.User">select id, name, age, email from user<where><if test="name!=null and name!=''">name like #{name}</if></where></select>
</mapper>
########分隔符#########
@Mapper
public interface UserMapper extends BaseMapper<User> {/*** 分頁列表* @return*/List<User> pageUser(Map<String, Object> params);
}

測試代碼在這：https://gitee.com/pianjiao006/boot-spring/tree/master/boot-mybatis-plus

https://gitee.com/pianjiao006/boot-spring.git