Mybatis-plus的多表查询

@Data
@AllArgsConstructor
@NoArgsConstructor
@Accessors(chain = true)
@EqualsAndHashCode(callSuper = false)
public class MemProfileTrainingVo extends MemTreatmentCaseTerminationTraining implements Serializable {

    private String name;

    private Integer gender;

    @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd")
    @DateTimeFormat(pattern="yyyy-MM-dd")
    private Date birthDate;


    private String currentYearSchool;
    
    private String currentYearClass;
    
}

一个表是全部内容，一个表是一些内容，一对一的关系

@GetMapping(value = "/list/{caseId}")
    public Result queryPageList(MemProfileTrainingVo trainingVo,
                                   @RequestParam(name="pageNo", defaultValue="1") Integer pageNo,
                                   @RequestParam(name="pageSize", defaultValue="10") Integer pageSize,
                                   HttpServletRequest req,
                                   @PathVariable(value = "caseId")String caseId
    ) {

        QueryWrapper queryWrapper = QueryGenerator.initQueryWrapper(trainingVo, req.getParameterMap());
        Page page = new Page(pageNo, pageSize);
        IPage pageList = trainingService.getAll(page, queryWrapper);
        return Result.OK(pageList);
    }

@Service
public class MemTreatmentCaseTerminationTrainingServiceImpl
extends ServiceImpl
    implements IMemTreatmentCaseTerminationTrainingService {

    @Autowired
    private MemTreatmentCaseTerminationTrainingMapper trainingMapper;

    @Override
    public IPage getAll(Page page, QueryWrapper queryWrapper) {
        return trainingMapper.findByPage(page,queryWrapper);
    }
}

mapper

public interface MemTreatmentCaseTerminationTrainingMapper extends baseMapper {
    IPage findByPage(Page page,
                                           @Param(Constants.WRAPPER)QueryWrapper queryWrapper);
}

        SELECT
            p.`name`,
            p.`gender`,
            p.`birth_date`,
            p.`current_year_class`,
            p.`current_year_school`,
            tt.*
        FROM `mem_treatment_case_profile` p INNER JOIN `mem_treatment_case_termination_training` tt
                                                    ON p.`id` = tt.`case_id` ${ew.customSqlSegment}