mybatis中使用分页插件需要添加的依赖,插件在mybatis-config.xml中的配置,以及使用的方式

发布时间 2023-09-12 17:13:05作者: 努力是一种常态

2023-09-12

导入的依赖

<dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>5.3.2</version>
</dependency>

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>



    <!--引入资源-->
    <properties resource="jdbc.properties"/>

    <settings>
        <!--开启驼峰命名-->
        <setting name="mapUnderscoreToCamelCase" value="true"/>
        <!--开启延迟加载-->
        <setting name="lazyLoadingEnabled" value="true"/>
        <setting name="aggressiveLazyLoading" value="false"/>
    </settings>
    <!--起别名-->
    <typeAliases>
        <package name="com.hh.pojo"/>
    </typeAliases>
    
    
    <plugins>
        <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
    </plugins>
    
    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"/>
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>
    <mappers>
        <!--        包扫描的方式-->
        <package name="com.hh.mapper"/>
    </mappers>
</configuration>

这一块是设置插件的拦截器

 测试

@Test
    public void testPage(){
        SqlSession sqlSession = SqlSessionUtils.getSqlSession();
        StoreHouseMapper mapper = sqlSession.getMapper(StoreHouseMapper.class);
        PageHelper.startPage(1,6);
        List<StoreHouse> list = mapper.selectAll();
        list.forEach(System.out::println);
        sqlSession.close();
    }