public interface IUserService {
    List<User> getAll();

    /**
     * 
     * @param page 當(dāng)前頁(yè)數(shù)
     * @param pageSize  每頁(yè)的總條數(shù)
     * @return
     */
    Page<User> getPage(int page, int pageSize);
}

@Service
public class UserServiceImpl extends ServiceImpl<UserMapper, User> implements IUserService {
    @Resource
    private UserMapper userMapper;

    @Override
    public List<User> getAll() {
        return this.getMapper().selectAll();
    }

    @Override
    public Page<User> getPage(int page, int pageSize) {
        // 查詢數(shù)據(jù)庫(kù)的條件 這邊可以根據(jù)自身需求進(jìn)行對(duì)應(yīng)條件添加
        // 可以自行查看源碼，這邊不加以闡述
        QueryWrapper queryWrapper = QueryWrapper.create();
        // selectPage 對(duì)應(yīng)的指定mapper的方法
        // page.of()內(nèi)的page 和 pageSize就對(duì)應(yīng)我們的參數(shù) 即頁(yè)數(shù)和行數(shù)
        // queryWrapper 查詢條件
        Page<User> pageInfo = userMapper.xmlPaginate("selectPage", Page.of(page, pageSize) , queryWrapper);
        return pageInfo;
    }
}

@Mapper
public interface UserMapper extends BaseMapper<User> {

    /**
     * flex的分頁(yè)配置
     * @return
     */
    long selectPage_COUNT();

    /**
     * 分頁(yè)
     * @return
     */
    List<User> selectPage();
}

<?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" >
<!--namespace根據(jù)自己需要?jiǎng)?chuàng)建的的mapper的路徑和名稱填寫(xiě)-->
<mapper namespace="org.wyq.studyone.mapper.UserMapper">
    <!--    分頁(yè)查詢-->
    <!--    resultType對(duì)應(yīng)的是你的實(shí)體類 User的路徑-->
    <select id="selectPage" resultType="org.wyq.studyone.entity.User">
        select *
        from `user` limit ${pageOffset}, ${pageSize}
    </select>

    <!--    flex分頁(yè)配置-->
    <select id="selectPage_COUNT" resultType="long">
        select count(*)
        from `user`
    </select>
</mapper>

Page<User> pageInfo = userMapper.xmlPaginate("selectPage", Page.of(page, pageSize) , queryWrapper);

default <E> Page<E> xmlPaginate(String dataSelectId, Page<E> page, QueryWrapper queryWrapper) {
    return this.xmlPaginate(dataSelectId, dataSelectId + "_COUNT", page, queryWrapper, (Map)null);
}

/*
 * Copyright 2013-2018 the original author or authors.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *      https://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package org.wyq.studyone.controller;

import com.mybatisflex.core.paginate.Page;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.wyq.studyone.entity.User;
import org.wyq.studyone.service.IUserService;

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

/**
 * @author <a href="mailto:chenxilzx1@gmail.com" rel="external nofollow" >theonefx</a>
 */
@Controller
public class UserController {
    @Resource
    private IUserService userService;

    @RequestMapping("/hello")
    @ResponseBody
    public String hello() {
        List<User> all = userService.getAll();
        return all.toString();
    }

    @RequestMapping("/page")
    @ResponseBody
    public String page(int page, int pageSize) {
        Page<User> pageInfo = userService.getPage(page, pageSize);
        return pageInfo.toString();
    }

}