添加依赖
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.0</version>
</dependency>
在启动类编辑
@Bean
public MybatisPlusInterceptor mybatisPlusInterceptor() {
MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.H2));
return interceptor;
}
Mapper层编写
IPage<User> getList(Page<Object> page);
xml文件编写SQL
<select id="getList" resultMap="getUserDate">
select * from user
<!-- select * from user 最后不能添加;号-->
</select>
Test测试
@Test
void Test01(){
Page<Object> page = new Page<>(0, 2);
List<User> records = userMapper.getList(page).getRecords();
records.forEach(item->System.out.println(item));
}
评论
登录后参与技术讨论,分享你的经验与见解。
登录 / 注册暂无评论