springboot + gradle + mybatis 使用pagehelper实现分页

1、依赖坐标，必须使用springboot的pagehelper

group 'zhanSystem'
version '1.0'

apply plugin: 'java'
apply plugin: 'maven'

sourceCompatibility = 1.8
targetCompatibility = 1.8

buildscript {
    repositories {
        mavenLocal()
        maven { url "http://maven.aliyun.com/nexus/content/groups/public/"}
        jcenter()
    }
    dependencies {
        classpath("org.springframework.boot:spring-boot-gradle-plugin:2.1.1.RELEASE")
    }
}

dependencies {
    compile("org.apache.commons:commons-lang3:3.8.1")
    compile("org.apache.commons:commons-collections4:4.2")
    compile("com.alibaba:fastjson:1.2.47")
    compile("org.projectlombok:lombok:1.18.4")
    compile("tk.mybatis:mapper-spring-boot-starter:2.1.1")
    compile("com.github.pagehelper:pagehelper-spring-boot-starter:1.2.10")
}


//打包源代码
task sourcesJar(type: Jar, dependsOn: classes) {
    classifier = 'sources'
    from sourceSets.main.allSource
}

artifacts {
    archives sourcesJar
}

//上传资源配置
uploadArchives {
    repositories {
        mavenDeployer {
            //上传资源到Maven私服
            repository(url: "http://172.17.0.150:8081/repository/3rdParty/") {
                authentication(userName:"admin",password:"admin123")
            }
            pom.version ="$project.version"
            pom.artifactId ="$project.name"
            pom.groupId ="$project.group"
        }
    }
}

 

2、application.properties中的配置。

spring.profiles.active=dev

#端口号
server.port=8069
#mybatis配置
mybatis.mapperLocations = classpath:mapper/*.xml
mybatis.type-aliases-package =com.zhan.app.deploy.api.domain

# 分页插件
pagehelper.offsetAsPageNum=true
pagehelper.rowBoundsWithCount=true
pagehelper.pageSizeZero=true
pagehelper.reasonable=false
pagehelper.params=pageNum=pageHelperStart;pageSize=pageHelperRows;
pagehelper.supportMethodsArguments=false

3、代码中实际运用

package com.zhan.app.deploy.server;

import com.alibaba.dubbo.config.annotation.Service;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.zhan.app.deploy.api.domain.AppCheckIos;
import com.zhan.app.deploy.api.service.IAppCheckIosService;
import com.zhan.app.deploy.dao.AppCheckIosDao;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Component;
import javax.annotation.Resource;
import java.util.Date;
import java.util.List;


@Slf4j
@Component
@Service(version = "1.0.0",timeout = 3000,interfaceClass = IAppCheckIosService.class)
public class AppCheckIosServiceImpl implements IAppCheckIosService {

    @Resource
    private AppCheckIosDao appCheckIosDao;


    /**
     * 分页查询
     * @param query     查询条件
     * @param pageNum   当前页 默认从1开始
     * @param pageSize  每页展示的个数
     * @return  List
     */
    @Override
    public PageInfo<AppCheckIos> selectPageList(AppCheckIos query, Integer pageNum, Integer pageSize) {
        /** startPage 后面必须是查询list的代码**/
        PageHelper.startPage(pageNum, pageSize);
        List<AppCheckIos> list = appCheckIosDao.select(query);
        return new PageInfo<>(list);
    }

}