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(); }