【SSM-Mybatis】PageHelper

1.pom.xml

  <!-- https://mvnrepository.com/artifact/com.github.jsqlparser/jsqlparser -->
        <dependency>
            <groupId>com.github.jsqlparser</groupId>
            <artifactId>jsqlparser</artifactId>
            <version>1.1</version>
        </dependency>

        <!-- https://mvnrepository.com/artifact/com.github.pagehelper/pagehelper -->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>5.1.2</version>
        </dependency>

2.直接在之前World上做演示

**PageHelper.offsetPage( a, b); 相当于limit a,b

PageInfo pageInfo =new PageInfo (worlds);
System.out.println(“总数：”+pageInfo.getTotal());

public class PageHelperTest {
    @Test
    public void worldt() throws IOException {
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        SqlSession session = sqlSessionFactory.openSession();

        PageHelper.offsetPage(1, 5);
        //相当于limit 1,5

        listAll(session);

        session.commit();
        session.close();


    }
    private static void listAll(SqlSession session){
        List<World> worlds = session.selectList("listWorld");
        for (World w:worlds
        ) {
            System.out.println(w);
        }
        PageInfo pageInfo =new PageInfo (worlds);
        System.out.println("总数："+pageInfo.getTotal());
        System.out.println(pageInfo);

    }
}