联表查询​

public class Demo {
    @Autowired
    private SysUserMapper sysUserMapper;

    public void page() {
        Pager<SysUser> pager= QueryChain.of(sysUserMapper)
                .join(SysUser::getRoleId, SysRole::getId)
                .like(SysUser::getUserName,"abc")
                .paging(Pager.of(1));
    }
}

public class Demo {
    @Autowired
    private SysUserMapper sysUserMapper;

    public void page() {
        Pager<SysUser> pager= QueryChain.of(sysUserMapper)
                .leftJoin(SSysUser::getRoleId, SysRole::getId)
                .like(SysUser::getUserName,"abc")
                .paging(Pager.of(1));
    }
}

public class Demo {
    @Autowired
    private SysUserMapper sysUserMapper;

    public void page() {
        Pager<SysUser> pager= QueryChain.of(sysUserMapper)
                .join(JoinMode.RIGHT, SysUser::getRoleId, SysRole::getId)
                .like(SysUser::getUserName,"abc")
                .paging(Pager.of(1));
    }
}

public class Demo {
    @Autowired
    private SysUserMapper sysUserMapper;

    public void page() {
        Pager<SysUser> pager= QueryChain.of(sysUserMapper)
                .join(JoinMode.FULL, SysUser::getRoleId, SysRole::getId)
                .like(SysUser::getUserName,"abc")
                .paging(Pager.of(1));
    }
}