MybatisPlus 关联分页查询

首先开启MybatisPlus 分页 往Boot添加以下代码即可

@EnableTransactionManagement
@Configuration
public class MybatisPlusConfig {
    /**
     * 分页配置
     *
     * @return
     */
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        return new PaginationInterceptor();
    }
}

Mapper

@Mapper
@Repository
public interface RoleMapper extends BaseMapper<Role> {

    List<Role> selectRoleUsersPage(Page<Role> page,@Param("par") RequestPar par);
}

Mapper.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.demo.mapper.RoleMapper">
    <select id="selectRoleUsersPage" resultType="com.example.demo.po.Role">
        SELECT
        a.*,b.user_name
        FROM role a
        LEFT JOIN user b
        ON a.user_id = b.id
        <where>
            <if test="par.userId != null">
                a.user_id = #{par.userId}
            </if>
            <if test="par.userName != null and par.userName!=''">
                and  b.user_name like '%${par.userName}%'
            </if>
        </where>
        ORDER BY a.create_time desc
    </select>
</mapper>

Service

/**
 * @author Administrator
 * @date 2020/12/7
 */
@Service
public class RoleServiceImpl extends ServiceImpl<RoleMapper, Role> implements RoleService {

    @Autowired
    private RoleMapper roleMapper;

    /**
     * 关联查询分页
     * @param pageIndex 当前页数
     * @param pageSize  页数大小
     * @param par       参数
     * @return
     */
    @Override
    public Page<Role> selectUserListPage(Integer pageIndex, Integer pageSize, RequestPar par) {
        Page<Role> page = new Page<>(pageIndex, pageSize);
        page.setRecords(roleMapper.selectRoleUsersPage(page, par));
        return page;
    }
}

Controller

@RestController
@RequestMapping("/role")
public class RoleController {

    private static final Logger logger = LoggerFactory.getLogger(RoleController.class);

    @Autowired
    private RoleService roleService;

    /**
     * @param par
     * @param pageIndex
     * @param pageSize
     * @return
     */
    @RequestMapping(value = "/getRolePage")
    public Object getRolePage(RequestPar par,
                              @RequestParam(value = "pageIndex", defaultValue = "1") Integer pageIndex, @RequestParam(value = "pageSize", defaultValue = "1") Integer pageSize) {
        return roleService.selectUserListPage(pageIndex, pageSize, par);
    }
}