springboot整合mybatis-plus实现多表分页查询的示例代码

      com.baomidou
      mybatis-plus-boot-starter
      3.1.1
    
     
      org.mybatis.spring.boot
      mybatis-spring-boot-starter
      2.0.1
    

server:
 port: 8080
spring:
 datasource:
  url: jdbc:mysql://localhost:3306/mybatisplus?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&useSSL=false&serverTimezone=UTC
  username: root
  password: 数据库密码
mybatis:
 mapper-locations: classpath*:mapper/*.xml

mybatis-plus:
 mapper-locations: classpath:/mapper/*Mapper.xml
logging:
 level:
  com.tuanzi.*: debug

省略import
@EnableTransactionManagement
@Configuration
@MapperScan("com.tuanzi.*.mapper*")
public class MybatisPlusConfig {

  /**
   * 分页插件
   */
  @Bean
  public PaginationInterceptor paginationInterceptor(){
    return new PaginationInterceptor();
  }
}

@RestController
@RequestMapping("/user")
public class UserController {

  @Autowired
  UserService userService;

  /**
   * 多表关联，分页查询(1对1)
   * @param page
   * @return
   */
  @RequestMapping("/findAll")
  public Result> findAll(@RequestBody Page page){

     return userService.pages(page);

  }

  /**
   * 多表关联，分页查询(1对多)
   * @param page
   * @return
   */
  @RequestMapping("/selectAll")
  public Result> selectAll(@RequestBody Page page){

    return userService.pageList(page);

  }
}

public interface UserService extends IService {

  Result> pages(Page page);

  Result> pageList(Page page);
}

@Service
public class UserServiceImpl extends ServiceImpl implements UserService {

  @Autowired
  UserMapper userMapper;
  @Override
  public Result> pages(Page page) {
    IPage userIPage = userMapper.Pages(page);
    return Result.getSuccess("分页查询成功",userIPage);
  }

  @Override
  public Result> pageList(Page page) {
    IPage userIPage = userMapper.pageList(page);
    return Result.getSuccess("分页查询成功",userIPage);
  }
}

@Mapper
@Repository
public interface UserMapper extends BaseMapper {

  IPage Pages(@Param("page") Page page);

  IPage pageList(@Param("page") Page page);
}

    select a.id id,a.name name,a.age age,a.email email,b.position position,b.user_id user_id from user a LEFT JOIN work b on a.id=b.user_id
  
  
    select a.id id,a.name name,a.age age,a.email email,b.position position,b.user_id user_id from user a LEFT JOIN work b on a.id=b.user_id