Spring boot Mybatis-plus自定义分页插件关联多表查询

自定义个数据类型，用于解析两表联合查询返回的数据。
entity

@Data
public class UserCompany implements Serializable {

    private static final long serialVersionUID = 1L;
    private int userId;
    private String userName;
    private String fullName;

}

接口地址
Controller

	@RequestMapping("/selectCompanyNameById")
    public IPage<UserCompany> selectCompanyNameById(@RequestParam("current") int current, @RequestParam("size") int size, @RequestParam("userName") String userName){
        return userService.selectCompanyNameById(current,size,userName);
    }

根据 user表和entity表 两表关联查询出来的字段合并 并返回
调用 Mybatis-plus 分页插件基础接口
Mapper

@Repository
public interface UserMapper extends BaseMapper<User> {
    @Select("select entity.full_name,user.user_id,user.user_name from user inner join entity on user.company = entity.entity_id")
    IPage<UserCompany> selectCompanyNameById(IPage<UserCompany> page , QueryWrapper<UserCompany> wrapper);
}

方法接口
services

public interface UserService extends IService<User> {

    IPage<UserCompany> selectCompanyNameById(int current, int size , String userName);
}

接口实现类
serviceImpl

@Override
    public IPage<UserCompany> selectCompanyNameById(int current, int size , String userName){
        Page<UserCompany> page = new Page<>(current,size);
        QueryWrapper<UserCompany> wrapper = new QueryWrapper<>();
        IPage<UserCompany> userIPage = userMapper.selectCompanyNameById(page , wrapper);
        return userIPage;
    }