ssm 使用 PageHelper 插件分页

梦里梦外; 2022-06-01 00:25 278阅读 0赞

先增加maven依赖:

1.  <dependency>  
2.      <groupId>com.github.pagehelper</groupId>  
3.      <artifactId>pagehelper</artifactId>  
4.      <version>4.0.0</version>  
5.  </dependency>

创建mybatis配置文件:mybatis-config.xml内容:

1.  <?xml version="1.0" encoding="UTF-8" ?>  
2.  <!DOCTYPE configuration  
3.  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"  
4.  "http://mybatis.org/dtd/mybatis-3-config.dtd">  
5.    
6.  <configuration>  
7.      <plugins>  
8.            
9.          <plugin interceptor="com.github.pagehelper.PageHelper">  
10.               
11.             <property name="dialect" value="oracle"/>  
12.               
13.               
14.               
15.             <property name="offsetAsPageNum" value="true"/>  
16.               
17.               
18.             <property name="rowBoundsWithCount" value="true"/>  
19.               
20.               
21.             <property name="pageSizeZero" value="true"/>  
22.               
23.               
24.               
25.             <property name="reasonable" value="true"/>  
26.               
27.               
28.               
29.               
30.             <property name="params" value="pageNum=start;pageSize=limit;"/>  
31.               
32.             <property name="supportMethodsArguments" value="true"/>  
33.               
34.             <property name="returnPageInfo" value="check"/>  
35.         </plugin>  
36.     </plugins>  
37. </configuration>

在Spring配置中配置sqlSessionFactory的时候引入配置文件

1.  <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">  
2.      <property name="dataSource" ref="dataSource" />  
3.      <property name="mapperLocations" value="classpath:joker/itq/im/mapping/\*.xml" />  
4.      <property name="configLocation" value="classpath:mybatis-config.xml" />  
5.  </bean>

测试代码:

1.  @RunWith(SpringJUnit4ClassRunner.**class)      **
2.  @ContextConfiguration(\{ "classpath\*:/spring-mybatis.xml"\})      
3.  **public class MyBatiasTest \{  **
4.      @Resource  
5.      **private ColumnMapper columnMapper;  **
6.      @Test  
7.      **public void test()\{  **
8.          PageHelper.startPage(1, 20); // 核心分页代码  
9.          List<Column> cls =  columnMapper.selectAll();  
10.         **for (Column column : cls) \{  **
11.             System.out.println(column.getBrcoName());  
12.         \}  
13.     \}  
14. \}