目錄

• • 1. jar包依賴
  • 2. mybatis核心文件配置
  • 3. 簡(jiǎn)簡(jiǎn)單單分頁(yè)

1. jar包依賴

<!--分頁(yè)助手--><dependency><groupId>com.github.pagehelper</groupId><artifactId>pagehelper</artifactId><version>5.2.0</version></dependency><!-- java sql parser --><dependency><groupId>com.github.jsqlparser</groupId><artifactId>jsqlparser</artifactId><version>3.2</version></dependency></dependencies>

2. mybatis核心文件配置

<!-- 分頁(yè)助手配置 --><plugins><plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin></plugins>

3. 簡(jiǎn)簡(jiǎn)單單分頁(yè)

// 分頁(yè)查詢@Testpublic void test3() {SqlSession sqlSession = getSession();if (sqlSession != null) {UserMapper userMapper = sqlSession.getMapper(UserMapper.class);// 第二頁(yè) 每頁(yè)查三條數(shù)據(jù)PageHelper.startPage(2, 3);List<User> userList = userMapper.selectAllUser();System.out.println(userList);sqlSession.close();}}// 分頁(yè)查詢獲取分頁(yè)具體信息@Testpublic void test4() {SqlSession sqlSession = getSession();if (sqlSession != null) {UserMapper userMapper = sqlSession.getMapper(UserMapper.class);// 第一頁(yè) 查三條PageHelper.startPage(1, 3);List<User> userList = userMapper.selectAllUser();PageInfo userPageInfo = new PageInfo<>(userList);System.out.println("當(dāng)前頁(yè)：" + userPageInfo.getPageNum());System.out.println("總頁(yè)數(shù)：" + userPageInfo.getPages());System.out.println("總行數(shù)：" + userPageInfo.getTotal());System.out.println("每頁(yè)行數(shù)：" + userPageInfo.getPageSize());System.out.println("下一頁(yè)：" + userPageInfo.getNextPage());System.out.println("上一頁(yè)：" + userPageInfo.getPrePage());sqlSession.close();}}

• 插件開(kāi)源地址

https://github.com/pagehelper/Mybatis-PageHelper/blob/master/wikis/en/HowToUse.md

總結(jié)

以上是生活随笔為你收集整理的分页查询插件PageHelper 5.x版本的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。