com.baomidou.mybatisplus.core.conditions.query.QueryWrapper.select()方法的使用及代码示例

x33g5p2x  于2022-01-28 转载在 其他  
字(7.6k)|赞(0)|评价(0)|浏览(806)

本文整理了Java中com.baomidou.mybatisplus.core.conditions.query.QueryWrapper.select方法的一些代码示例,展示了QueryWrapper.select的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。QueryWrapper.select方法的具体详情如下:
包路径:com.baomidou.mybatisplus.core.conditions.query.QueryWrapper
类名称:QueryWrapper
方法名:select

QueryWrapper.select介绍

暂无

代码示例

代码示例来源:origin: baomidou/mybatis-plus

@Override
public QueryChainWrapper<T> select(Predicate<TableFieldInfo> predicate) {
  wrapperChildren.select(predicate);
  return typedThis;
}

代码示例来源:origin: baomidou/mybatis-plus

@Override
public QueryChainWrapper<T> select(String... columns) {
  wrapperChildren.select(columns);
  return typedThis;
}

代码示例来源:origin: baomidou/mybatis-plus

@Override
public QueryChainWrapper<T> select(Class<T> entityClass, Predicate<TableFieldInfo> predicate) {
  wrapperChildren.select(entityClass, predicate);
  return typedThis;
}

代码示例来源:origin: baomidou/mybatis-plus

@Override
public QueryWrapper<T> select(Predicate<TableFieldInfo> predicate) {
  return select(entityClass, predicate);
}

代码示例来源:origin: baomidou/mybatis-plus

public QueryWrapper(T entity, String... columns) {
  super.setEntity(entity);
  super.initNeed();
  this.select(columns);
}

代码示例来源:origin: baomidou/mybatis-plus

@Test
@Order(6)
void testCountDistinctUseLambda() {
  LambdaQueryWrapper<CommonData> lambdaQueryWrapper =
    new QueryWrapper<CommonData>().select("distinct test_int, test_str").lambda();
  int count = commonDataMapper.selectCount(lambdaQueryWrapper);
  Assertions.assertEquals(1, count);
}

代码示例来源:origin: baomidou/mybatis-plus

@Test
@Order(5)
void testLogicCountDistinctUseLambda() {
  LambdaQueryWrapper<CommonLogicData> lambdaQueryWrapper =
    new QueryWrapper<CommonLogicData>().select("distinct test_int").lambda();
  int count = commonLogicMapper.selectCount(lambdaQueryWrapper);
  Assertions.assertEquals(1, count);
}

代码示例来源:origin: baomidou/mybatis-plus

@Test
@Order(1)
void testCountDistinct() {
  QueryWrapper<CommonData> distinct = new QueryWrapper<>();
  distinct.select("distinct test_int");
  distinct.eq("test_int", 25).or().eq("test_str", "test");
  int count = commonDataMapper.selectCount(distinct);
  Assertions.assertEquals(1, count);
}

代码示例来源:origin: baomidou/mybatis-plus

@Test
@Order(2)
void testCountDistinctTwoColumn() {
  QueryWrapper<CommonData> distinct = new QueryWrapper<>();
  distinct.select("distinct test_int, test_str");
  distinct.eq("test_int", 25).or().eq("test_str", "test");
  int count = commonDataMapper.selectCount(distinct);
  Assertions.assertEquals(1, count);
}

代码示例来源:origin: baomidou/mybatis-plus

@Test
@Order(3)
void testLogicCountDistinct() {
  QueryWrapper<CommonLogicData> distinct = new QueryWrapper<>();
  distinct.select("distinct test_int");
  distinct.eq("test_int", 25).or().eq("test_str", "test");
  int count = commonLogicMapper.selectCount(distinct);
  Assertions.assertEquals(1, count);
}

代码示例来源:origin: baomidou/mybatis-plus

@Test
@Order(10)
void testSelectPageWithDistinct() {
  QueryWrapper<CommonData> queryWrapper = new QueryWrapper<>();
  queryWrapper.select("distinct test_int, test_str");
  queryWrapper.eq("test_int", 25).or().eq("test_str", "test");
  IPage<CommonData> page = commonDataMapper.selectPage(new Page<>(1, 10), queryWrapper);
  Assertions.assertEquals(1, page.getTotal());
  Assertions.assertNotNull(page.getRecords().get(0));
}

代码示例来源:origin: baomidou/mybatis-plus

@Test
@Order(10)
void testEntityWrapperSelectSql() {
  QueryWrapper<H2User> ew = new QueryWrapper<>();
  ew.select("test_id as testId, name, age");
  List<H2User> list = userService.list(ew);
  for (H2User u : list) {
    Assertions.assertNotNull(u.getTestId());
    Assertions.assertNotNull(u.getName());
    Assertions.assertNull(u.getPrice());
  }
}

代码示例来源:origin: baomidou/mybatis-plus

@Test
void d9_testSetSelect() {
  commonMapper.selectList(new QueryWrapper<>(new CommonData()).select(TableFieldInfo::isCharSequence));
  commonMapper.selectList(new QueryWrapper<>(new CommonData().setTestStr("")));
  commonMapper.selectList(new QueryWrapper<>(new CommonData().setTestStr("")).orderByAsc("test_int"));
  commonMapper.selectList(new QueryWrapper<>(new CommonData().setTestStr("").setTestInt(12)).orderByAsc("test_int"));
  mysqlMapper.selectList(Wrappers.query(new MysqlData().setTestStr("")));
  mysqlMapper.selectList(Wrappers.lambdaQuery(new MysqlData().setTestStr("")).orderByAsc(MysqlData::getGroup));
  mysqlMapper.selectList(Wrappers.lambdaQuery(new MysqlData().setTestStr("").setGroup(1)).orderByAsc(MysqlData::getGroup));
}

代码示例来源:origin: com.baomidou/mybatis-plus-extension

@Override
public QueryChainWrapper<T> select(Class<T> entityClass, Predicate<TableFieldInfo> predicate) {
  wrapperChildren.select(entityClass, predicate);
  return typedThis;
}

代码示例来源:origin: com.baomidou/mybatis-plus-extension

@Override
public QueryChainWrapper<T> select(String... columns) {
  wrapperChildren.select(columns);
  return typedThis;
}

代码示例来源:origin: com.baomidou/mybatis-plus-extension

@Override
public QueryChainWrapper<T> select(Predicate<TableFieldInfo> predicate) {
  wrapperChildren.select(predicate);
  return typedThis;
}

代码示例来源:origin: yujunhao8831/spring-boot-start-current

@Override
public List< Role > listByUserId ( Long userId ) {
  final List< Object > roleIds = userRoleService.listObjs( new QueryWrapper< UserRole >().eq( "user_id" , userId )
                                              .select( "role_id" ) );
  if ( CollectionUtils.isEmpty( roleIds ) ) {
    return null;
  }
  return new ArrayList<>( super.listByIds( roleIds.parallelStream()
                          .map( Object::toString )
                          .collect( Collectors.toList() ) ) );
}

代码示例来源: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;
}

代码示例来源:origin: ocubexo/springboot-restful-starter

@Override
public SignInView signIn(SignInData data) {
  // 找到对应name的用户
  User user = userMapper.selectOne(new QueryWrapper<User>().select("id,name,password").eq("name", data.getName()));
  // 判断用户是否存在
  if (user != null) {
    // 校验密码
    if(data.getPassword().equals(user.getPassword())) {
      // 校验通过,登陆成功,返回Token
      SignInView signInView = new SignInView();
      // 生成AccessToken
      signInView.setAccessToken(tokenService.generate(TokenSubject.ACCESS,user.getId()));
      // 生成RrefreshToken,有效期为24小时
      signInView.setRefreshToken(tokenService.generate(TokenSubject.REFRESH,user.getId(),24));
      return signInView;
    } else {
      // 自定义异常示范
      throw new PasswordErrorException();
    }
  } else {
    // 抛出用户不存在的服务异常
    throw new UserNotFoundException();
  }
}

相关文章