分页插件,datatable还是PageHelper

今天项目组要做分页,以前用的都是datatable,这次换成PageHelper,感觉简单很多

1.下载com.github.pagehelper,放在service层

2. 在mybatis中配置 SqlMapConfig.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 >

      <!-- 配置分页插件 -->

      < plugins >

            < plugin interceptor = "com.github.pagehelper.PageHelper" >

                      

           < property name = "dialect" value = "mysql" />

            </ plugin >

      </ plugins >

</ configuration >

3.service层

public class TestPageHelper {

 

      @Test

      public void testPageHelper() {

            //创建一个spring容器,加载spring容器下的applicationContext-dao.xml,里面配置了SqlMapConfig.xml

            ApplicationContext applicationContext = new ClassPathXmlApplicationContext( "classpath:spring/applicationContext-*.xml" );

            //从spring容器中获得 Mapper 的代理对象

            TbItemMapper mapper = applicationContext .getBean(TbItemMapper. class );

            //创建查询商品的查询条件

            TbItemExample example = new TbItemExample();

            //分页处理

            PageHelper. startPage (2, 10);

            List<TbItem> list = mapper .selectByExample( example );

            //取商品列表

            for (TbItem tbItem : list ) {

                  System. out .println( tbItem .getTitle());

            }

            //取分页信息

            PageInfo<TbItem> pageInfo = new PageInfo<>( list );

            long total = pageInfo .getTotal();

            System. out .println( "总数：" + total );

           

      }

}

4.效果