本文整理了Java中com.baomidou.mybatisplus.core.conditions.query.QueryWrapper.in
方法的一些代码示例,展示了QueryWrapper.in
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。QueryWrapper.in
方法的具体详情如下:
包路径:com.baomidou.mybatisplus.core.conditions.query.QueryWrapper
类名称:QueryWrapper
方法名:in
[英]用于生成嵌套 sql
故 sqlSelect 不向下传递
[中]用于生成嵌套 sql
故 sqlSelect不向下传递
代码示例来源:origin: baomidou/mybatis-plus
@Test
void testFunc() {
QueryWrapper<User> queryWrapper = new QueryWrapper<User>()
.isNull("nullColumn").or().isNotNull("notNullColumn")
.orderByAsc("id").orderByDesc("name")
.groupBy("id", "name").groupBy("id2", "name2")
.in("inColl", getList()).or().notIn("notInColl", getList())
.in("inArray").notIn("notInArray", 1, 2, 3)
.inSql("inSql", "1,2,3,4,5").notInSql("inSql", "1,2,3,4,5")
.having("sum(age) > {0}", 1).having("id is not null");
logSqlSegment("测试 Func 下的方法", queryWrapper);
logParams(queryWrapper);
}
代码示例来源:origin: cn.org.faster/faster-admin
/**
* 根据角色id列表查询角色权限关系列表
*
* @param roleIdList 角色id列表
* @return 权限列表
*/
public List<SysRolePermission> selectByRoleIdList(List<Long> roleIdList) {
if (CollectionUtils.isEmpty(roleIdList)) {
return Collections.emptyList();
}
return super.baseMapper.selectList(new QueryWrapper<SysRolePermission>()
.select("distinct(permission_id) as permissionId")
.in("role_id", roleIdList)
);
}
代码示例来源:origin: yujunhao8831/spring-boot-start-current
@Override
@CacheEvict( value = GlobalCacheConstant.USER_DETAILS_SERVICE_NAMESPACE, allEntries = true, condition = "#result != null" )
public boolean deleteRelatePermissionResource ( List< PermissionResourceVO > vos ) {
final List< Long > resourceIds = vos.parallelStream()
.map( PermissionResourceVO::getId )
.collect( Collectors.toList() );
// 删除资源
AssertUtils.isTrue( ! super.removeByIds( resourceIds ) , "资源删除失败" );
// 删除相关角色资源中间表信息
final List< Object > middleIds = rolePermissionResourceService.listObjs(
new QueryWrapper< RolePermissionResource >().in( "permission_resource_id" , resourceIds )
.select( "id" )
);
if ( CollectionUtils.isNotEmpty( middleIds ) ) {
AssertUtils.isTrue( ! rolePermissionResourceService.removeByIds( middleIds.parallelStream()
.map( Object::toString )
.collect( Collectors.toList() ) ) ,
"资源删除失败" );
}
return true;
}
内容来源于网络,如有侵权,请联系作者删除!