Springboot整合pagehelper

pom文件

<dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>

        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.2</version>
        </dependency>

        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <version>1.2.5</version>
        </dependency>

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.xcc.sp_web_socket.dao.TestPageDao">

    <!-- 获取 -->
    <select id="getUserById" resultType="com.xcc.sp_web_socket.model.User" parameterType="int">
		select  id,name,passwd,age
		FROM  sys_user
		WHERE  id= #{id,jdbcType=INTEGER }
	</select>

	<!-- 获取 -->
	<select id="getUser" resultType="com.xcc.sp_web_socket.model.User" parameterType="com.xcc.sp_web_socket.model.User">
		select  id,name,passwd,age
		FROM  sys_user
	</select>

</mapper>

dao层

import com.xcc.sp_web_socket.model.User;
import org.springframework.stereotype.Repository;

import java.util.List;

/**
 * @author : 徐长城
 * @des：
 * @date : 2019/10/20 11:46
 */
@Repository
public interface TestPageDao {

    User getUserById(int id);

    List<User> getUser();
}

service层

import com.github.pagehelper.Page;
import com.github.pagehelper.PageInfo;
import com.xcc.sp_web_socket.model.User;

import java.util.List;

/**
 * @author : 徐长城
 * @des：
 * @date : 2019/10/20 11:59
 */
public interface TestPageService {

    User getUserById(int id);

    PageInfo<User> getUser(int pageNum,int pageSize);
}

service实现层

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

/**
 * @author : 徐长城
 * @des：
 * @date : 2019/10/20 11:59
 */
@Service
public class TestPageServiceImpl implements TestPageService {

    @Autowired
    private TestPageDao testPageDao;

    @Override
    public User getUserById(int id) {
        return testPageDao.getUserById(id);
    }

    @Override
    public PageInfo<User> getUser(int pageNum,int pageSize) {
        PageHelper.startPage(pageNum,pageSize);
        List<User> all = testPageDao.getUser();
        PageInfo<User> info = new PageInfo(all);
        return info;
    }
}

Controller层

import org.springframework.web.bind.annotation.RestController;

import java.util.List;

/**
 * @author : 徐长城
 * @des：
 * @date : 2019/10/20 12:01
 */
@RestController
@RequestMapping("/page")
public class TestPageController {

    @Autowired
    private TestPageServiceImpl testPageService;

    @GetMapping("/getUser")
    public User getUser(String id){
        return testPageService.getUserById(Integer.valueOf(id));
    }

    @GetMapping("/getUserPage")
    public PageInfo<User> getUserPage(String p, String s){
        return testPageService.getUser(Integer.valueOf(p),Integer.valueOf(s));
    }
}

配置文件

#数据库连接配置信息
spring.datasource.driverClassName = com.mysql.cj.jdbc.Driver
spring.datasource.url = jdbc:mysql://localhost:3306/sb_test?serverTimezone=UTC
spring.datasource.username = root
spring.datasource.password = admin

mybatis.mapperLocations=classpath:mybatis/*.xml
mybatis.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

pagehelper.helperDialect=mysql
pagehelper.reasonable=true
pagehelper.support-methods-arguments=true

数据库

http://127.0.0.1:8081/page/getUserPage?p=1&s=2

http://127.0.0.1:8081/page/getUserPage?p=2&s=2