mybatis（三）：mybatis自定义分页

由于之前mybatis的版本较低，以至于在自定义分页的时候，只能返回列表，总量还是得自己调用count方法，现在升级了mybatis版本之后，对自定义分页进行改造，让其能返回page，代码如下：

 

pom依赖，mybatis版本在3.1.1

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

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
            <version>2.0.0.RELEASE</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.38</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
            <version>2.0.0.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.34</version>
        </dependency>

    </dependencies>

 

引入分页插件

package test.mybatis.plus.config;


import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

@Configuration
public class MybatisConfig {

    /**
     * mybatis的分页插件
     *
     * @return PaginationInterceptor
     */
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        return new PaginationInterceptor();
    }

}

 

dao层

package test.mybatis.plus.mapper;

import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import test.mybatis.plus.entity.Person;

import java.util.List;

@Mapper
public interface PersonMapper extends BaseMapper<Person> {

    List<Person> selectByAge(Integer age);

    IPage<Person> myPagePersonByAge(Page<Person> page, @Param(Constants.WRAPPER) Wrapper<Person> wrapper);

    IPage<Person> myPagePersonByAge2(Page<Person> page,@Param("age") Integer age);
}

 

PersonMapper.xml

<?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="test.mybatis.plus.mapper.PersonMapper">
    <select id="selectByAge" resultType="test.mybatis.plus.entity.Person" parameterType="Integer">
        select t.* from person t where age = #{age}
    </select>

    <select id="myPagePersonByAge" resultType="test.mybatis.plus.entity.Person">
        select t.* from person t ${ew.customSqlSegment}
    </select>

    <select id="myPagePersonByAge2" resultType="test.mybatis.plus.entity.Person" parameterType="Integer">
        select t.* from person t where t.age = #{age}
    </select>
</mapper>

 

其中第一只ew.customSqlSegment是一种固定写法，第二种根据参数自己定义。

其余的就是service和controller了，这个就不在赘述了。可以去看下上一篇博客吧。