分页

public PageInfo<User> getPage(int pageNum, int pageSize) {
		PageInfo<User> userPageInfo = new PageInfo<>();

//		数据
		List<User> users = userMapper.getPage((pageNum-1)*pageSize,pageSize);
//		总数
		Integer totle = userMapper.totle();
			userPageInfo.setData(users);
			userPageInfo.setTotal(totle);

		return userPageInfo;

    <select id="getPage" resultType="com.example.demo.model.User">
         select * from sys_user limit #{pageNum},#{pageSize}
    </select>
    <select id="totle" resultType="java.lang.Integer">
        select count(*) count from sys_user
    </select>

pagehelper

先引入依赖

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

public PageInfo getPage1(int pageNum, int pageSize) {
		// 开启分页
		PageHelper.startPage(pageNum,pageSize);
		List<User> users =userMapper.getPage1();
		PageInfo pageInfo = new PageInfo(users);
		return pageInfo;
	}

    <select id="getPage1" resultType="com.example.demo.model.User">
        select * from sys_user
    </select>