mybatis-mp 之多表 join,非常简单
官网:https://mybatis-mp.cn 多表join List<SysUser> list=QueryChain.of(sysUserMapper) .select(SysUser.class) .from(SysUser.class) .join(SysUser.class,SysRole.class) .list(); join相同表 List<SysUser> list=QueryChain.of(sysUserMapper) .select(SysUser.class) .from(SysUser.class) .join(SysUser.class,1,SysUser.class,2,on->on.eq(SysUser::getId,1,SysUser::getRole_id,2)) .list(); join子查询 SubQuery subQuery=SubQuery.create("sub") .select(SysRole.class) .from(SysRole.class) .eq(Sy...
