mybatis-plus使用IPage分页

1、pom文件

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <scope>runtime</scope>
</dependency>
<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>3.1.1</version>
</dependency>
<dependency>
    <groupId>org.apache.shardingsphere</groupId>
    <artifactId>sharding-jdbc-spring-boot-starter</artifactId>
    <version>4.1.1</version>
</dependency>

2、分页查询

2.1、方式1 - 通过 BaseMapper 的 page 方法

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.tryonce.page.PageParam;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.util.StringUtils;

public class AppBookInfoServiceImpl extends ServiceImpl<AppBookInfoMapper, AppBookInfo> implements AppBookInfoService {
	
	@Override
	public IPage<AppBookInfo> getPage(PageParam<AppBookInfoQuery> pageParam) {
	    Page<AppBookInfo> platformPage = new Page<>(pageParam.getCurrent(), pageParam.getPageSize());
	    QueryWrapper<AppBookInfo> qw = new QueryWrapper<>();
	    AppBookInfoQuery appBookInfoQuery = pageParam.getCondition();
	    if (null != appBookInfoQuery) {
	        if (null != appBookInfoQuery.getId()) {
	            qw.eq("id", appBookInfoQuery.getId());
	        }
	    }
	    qw.orderByAsc("book_order");
	    return this.page(platformPage, qw);
	}

}

2.2、方式2 - 通过自定义sql

mapper

public interface TestMapper extends BaseMapper<Test> {

    @Select("select * from test where user_code = #{userCode} ")
    IPage<Test> selectPage(@Param("page") Page page, @Param("userCode") String userCode);

}

service

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.tryonce.entity.Test;
import com.tryonce.mapper.TestMapper;
import com.tryonce.page.PageParam;
import com.tryonce.service.TestService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;

@Slf4j
@Service
public class TestServiceImpl extends ServiceImpl<TestMapper, Test> implements TestService {
    @Resource
    private TestMapper testMapper;

    @Override
    public IPage<Test> getPage(PageParam<Test> pageParam) {
        Page<Test> platformPage = new Page<>(pageParam.getCurrent(), pageParam.getPageSize());
        testMapper.selectPage(platformPage, pageParam.getCondition().getUserCode());
        return platformPage;
    }

}