PageHelper分页插件

1.导入jar包

      可以根据下面的地址下载最新的 jar 包

      https://oss.sonatype.org/content/repositories/releases/com/github/pagehelper/pagehelper/

2.在application_mapper.xml进行配置

<!-- 实例化SqlSessionFactory -->
       <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
       		<!-- 注入dataSource -->
       		<property name="dataSource" ref="dataSource"></property>
       		<!-- 配置分页插件拦截器 -->
       		<property name="plugins">
       			<list>
       				<bean class="com.github.pagehelper.PageHelper">
       					<property name="properties">
       						<props>
       							<prop key="dialect">mysql</prop>
       						</props>
       					</property>
       				</bean>
       			</list>
       		</property>
       </bean>

3.测试

PageHelper.startPage(pageNum,pageSize)

@Test
public void testMysqlPageHelper(){
         ApplicationContext ac = new ClassPathXmlApplicationContext("application_mapper.xml","application_service.xml");
         RolesService rolesService=(RolesService) ac.getBean("rolesServiceImpl");
         /**
          * Page封装了分页的参数信息
          * ***/
         Page page=PageHelper.startPage(2, 3);
         List<RolesVo> rvoList=rolesService.loadRolesAllService();
         for(RolesVo r:rvoList){
             System.out.println(r.getRoleid()+"\t"+r.getRolename());
         }
         System.out.println("============"+page.getTotal());
}