mybatis-plus的分页插件

1. 配置分页插件
   创建MybatisPlusConfig.java

import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

@Configuration
public class MybatisPlusConfig{

    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.ORACLE));
        return interceptor;
    }
}

2、查询方法

//page一定要在第一位，其次是条件
IPage page = new Page<User>(current, size);
IPage<User> list= userDao.getUserList(page, params);
return new PageUtils(list);

3、映射文件

<select id="getUserList"  parameterType="map" resultType="com.test.pojo.User">
    select * from user where name = #{params.name, jdbcType=VARCHAR}
</select>