Mybatis-plus的多表查询

最新推荐文章于 2024-08-15 17:49:57 发布

Alex镇

最新推荐文章于 2024-08-15 17:49:57 发布

阅读量508

点赞数

分类专栏：笔记文章标签： spring boot

本文链接：https://blog.csdn.net/weixin_48319193/article/details/123713039

版权

笔记专栏收录该内容

33 篇文章 0 订阅

订阅专栏

@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<MemProfileTrainingVo> queryWrapper = QueryGenerator.initQueryWrapper(trainingVo, req.getParameterMap());
        Page<MemProfileTrainingVo> page = new Page<MemProfileTrainingVo>(pageNo, pageSize);
        IPage<MemProfileTrainingVo> pageList = trainingService.getAll(page, queryWrapper);
        return Result.OK(pageList);
    }

@Service
public class MemTreatmentCaseTerminationTrainingServiceImpl
extends ServiceImpl<MemTreatmentCaseTerminationTrainingMapper , MemTreatmentCaseTerminationTraining>
    implements IMemTreatmentCaseTerminationTrainingService {

    @Autowired
    private MemTreatmentCaseTerminationTrainingMapper trainingMapper;

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

mapper

public interface MemTreatmentCaseTerminationTrainingMapper extends BaseMapper<MemTreatmentCaseTerminationTraining> {
    IPage<MemProfileTrainingVo> findByPage(Page<MemProfileTrainingVo> page,
                                           @Param(Constants.WRAPPER)QueryWrapper<MemProfileTrainingVo> queryWrapper);
}

<select id="findByPage" resultType="ycz....Vo">
        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}
    </select>