Mybatis-plus-join使用、mybatis连表

发布时间 2023-09-04 11:51:52作者: 笑~笑
public interface PlanDayMapper  extends MPJBaseMapper<PwPlanDayPO> {
}
        MPJLambdaWrapper<PwPlanDayPO> wrapper = MPJWrappers.lambdaJoin(PwPlanDayPO.class);
        wrapper.leftJoin(SysStaffPO.class,SysStaffPO::getStaffId,PwPlanDayPO::getLeadCode)
                .eq(PwPlanDayPO::getId,"14026b06-d626-4099-adfe-91679f41cac2")
                .select(PwPlanDayPO::getCode)
                .selectAs(SysStaffPO::getStaffId,PwPlanDayPO::getLeadCode);
        List<TSscPlanDayDto> dayDtos = planDayMapper.selectJoinList(TSscPlanDayDto.class, wrapper);

生成的sql

SELECT t.`code`,t1.`STAFF_ID` AS leadCode FROM PW_PLAN_DAY t LEFT JOIN SYS_STAFF t1 ON (t1.`STAFF_ID` = t.`lead_code`) WHERE (t.`id` = '14026b06-d626-4099-adfe-91679f41cac2')
                 

引入依赖

        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.4.3.4</version>
        </dependency>

        <dependency>
            <groupId>com.github.yulichang</groupId>
            <artifactId>mybatis-plus-join-boot-starter</artifactId>
            <version>1.4.6</version>
        </dependency>