springboot整合mybatis+pagehelper(分页)

maven导入需要的框架插件

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.1.7.RELEASE</version>
        <relativePath/> <!-- lookup parent from repository -->
    </parent>
    <groupId>com.example</groupId>
    <artifactId>pagingtest</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>pagingtest</name>
    <description>Demo project for Spring Boot</description>

    <properties>
        <java.version>1.8</java.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.0</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>compile</scope>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>



        <!-- 分布插件 -->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>5.1.1</version>
        </dependency>
        <!-- Spring Boot集成 pagehelper-->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.10</version>
        </dependency>

    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
            </plugin>
        </plugins>
    </build>

</project>

配置application.yml

#数据库驱动号密
spring:
  datasource:
    username: root
    password: 201314
    url: jdbc:mysql://127.0.0.1:3306/depot?zeroDateTimeBehavior=convertToNull&serverTimezone=GMT%2b8&useSSL=true
    # url: jdbc:mysql://127.0.0.1:3306/test
    driverClassName : com.mysql.cj.jdbc.Driver
    # driverClassName: oracle.jdbc.driver.OracleDriver
#mybatis
mybatis:
  mapper-locations : classpath:mapper/*.xml
  #entity包
  type-aliases-package : java.com.example.pagingtest.entity
  #驼峰
  configuration:
      map-underscore-to-camel-case : true

#分页配置
#https://github.com/pagehelper/Mybatis-PageHelper/blob/master/wikis/zh/HowToUse.md
pagehelper:
  helperDialect : mysql
  reasonable : true
  supportMethodsArguments : true
  params : count=countSql

项目结构

配置xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.pagingtest.mapper.UserMapper">
    <select id="getUsers" resultType="com.example.pagingtest.entity.User">
        select * from `user`
    </select>
</mapper>

entity

package com.example.pagingtest.entity;

import lombok.Data;

@Data
public class User {
    private Integer userId;
    private String userName;
}

mapper

package com.example.pagingtest.mapper;

import com.example.pagingtest.entity.User;
import com.github.pagehelper.Page;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface UserMapper {
    Page<User> getUsers();
}

service

package com.example.pagingtest.service;

import com.example.pagingtest.entity.User;
import com.github.pagehelper.Page;
import com.github.pagehelper.PageInfo;

public interface UserService {
    Page<User> getUsers(int pageNo,int pageSize);
    PageInfo<User> getusers(int pageNo,int pageSize);
}

serviceImpl
这边两个方法都可以，选取一个使用

package com.example.pagingtest.service.impl;

import com.example.pagingtest.entity.User;
import com.example.pagingtest.mapper.UserMapper;
import com.example.pagingtest.service.UserService;
import com.github.pagehelper.Page;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class UserServiceImpl implements UserService {
    @Autowired
    private UserMapper userMapper;

    /**
     * 1.5.*版本的
     * @param pageNo
     * @param pageSize
     * @return
     */
    @Override
    public Page<User> getUsers(int pageNo,int pageSize) {
        //将参数传给这个方法就可以实现物理分页了，非常简单。
        PageHelper.startPage(pageNo,pageSize);
        return userMapper.getUsers();
    }

    /**
     * 2.0以上的版本
     * @param pageNo
     * @param pageSize
     * @return
     */
    @Override
    public PageInfo<User> getusers(int pageNo, int pageSize) {
        PageHelper.startPage(pageNo, pageSize);
        List<User> userDomains = userMapper.getUsers();
        PageInfo result = new PageInfo(userDomains);
        return result;
    }
}

controller

package com.example.pagingtest.controller;

import com.example.pagingtest.entity.User;
import com.example.pagingtest.service.UserService;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.*;

import javax.annotation.Resource;
import java.util.List;

@Controller
@RequestMapping("/test")
public class UserController {
    @Resource
    private UserService userService;

    @GetMapping("/users")
    @ResponseBody
    public PageInfo<User> lists(@RequestParam(defaultValue = "1") int pageNo,
                                @RequestParam(defaultValue = "10") int pageSize) {
        System.out.println("xxxx");
        return userService.getusers(pageNo,pageSize);
    }

    @GetMapping("/userss")
    @ResponseBody
    public List<User> listss(@RequestParam(defaultValue = "1") int pageNo,
                                @RequestParam(defaultValue = "10") int pageSize) {
        System.out.println("xxxx--------------------->");
        return userService.getUsers(pageNo,pageSize);
    }

}

使用Postman测试

引用