本文整理了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
暂无
代码示例来源: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();
}
}
内容来源于网络,如有侵权,请联系作者删除!