Java BooleanBuilder.or方法代码示例

import com.querydsl.core.BooleanBuilder; //导入方法依赖的package包/类
@ExtDirectMethod(STORE_READ)
@Transactional(readOnly = true)
public ExtDirectStoreResult<User> read(ExtDirectStoreReadRequest request) {

	JPQLQuery<User> query = this.jpaQueryFactory.selectFrom(QUser.user);
	if (!request.getFilters().isEmpty()) {
		StringFilter filter = (StringFilter) request.getFilters().iterator().next();

		BooleanBuilder bb = new BooleanBuilder();
		bb.or(QUser.user.loginName.containsIgnoreCase(filter.getValue()));
		bb.or(QUser.user.lastName.containsIgnoreCase(filter.getValue()));
		bb.or(QUser.user.firstName.containsIgnoreCase(filter.getValue()));
		bb.or(QUser.user.email.containsIgnoreCase(filter.getValue()));

		query.where(bb);
	}
	query.where(QUser.user.deleted.isFalse());

	QuerydslUtil.addPagingAndSorting(query, request, User.class, QUser.user);
	QueryResults<User> searchResult = query.fetchResults();

	return new ExtDirectStoreResult<>(searchResult.getTotal(),
			searchResult.getResults());
}
 

import com.querydsl.core.BooleanBuilder; //导入方法依赖的package包/类
@Override
public void extend(@Nonnull RequirementSearchContext context) {
    QVariableInstanceEntity variableEntity = new QVariableInstanceEntity(variableName);
    RequirementSearchQuery query = context.getQuery();
    RequirementSearchAliases $ = context.getAliases();

    createSelect(variableEntity, context);

    query.leftJoin($.flowInstance.variables, variableEntity).on(variableEntity.name.eq(variableName));

    QuickFilter quickFilter = context.getQuickFilter();
    if (context.getQuickFilter().hasFilter()) {
        BooleanBuilder filterBooleanBuilder = new BooleanBuilder();
        for (FilterToken token : quickFilter.listFilterTokens()) {
            BooleanBuilder tokenBooleanBuilder = new BooleanBuilder();
            for (String filter : token.getAllPossibleMatches()) {
                tokenBooleanBuilder.or(toChar(variableEntity).likeIgnoreCase(filter));
            }
            filterBooleanBuilder.and(tokenBooleanBuilder);
        }
        query.getQuickFilterWhereClause().or(filterBooleanBuilder);
    }
}
 

import com.querydsl.core.BooleanBuilder; //导入方法依赖的package包/类
/**
 * Adds a global contains text filter on the provided attributes.
 * WARNING: this creates a very inefficient query. If you have many entity
 * instances to query, use instead an indexed text search solution for better
 * performance.
 * @param text the text to look for
 * @param query
 * @param globalSearchAttributes the list of attributes to perform the
 *        filter on
 * @return the updated query
 */
protected JPQLQuery<T> applyGlobalSearch(String text, JPQLQuery<T> query,
    Path<?>... globalSearchAttributes) {
  if (text != null && !StringUtils.isEmpty(text) && globalSearchAttributes.length > 0) {
    BooleanBuilder searchCondition = new BooleanBuilder();
    for (int i = 0; i < globalSearchAttributes.length; i++) {
      Path<?> path = globalSearchAttributes[i];
      if (path instanceof StringPath) {
        StringPath stringPath = (StringPath) path;
        searchCondition.or(stringPath.containsIgnoreCase(text));
      } else if (path instanceof NumberExpression) {
        searchCondition.or(((NumberExpression<?>) path).like("%".concat(text).concat("%")));
      }
    }
    return query.where(searchCondition);
  }
  return query;
}
 

import com.querydsl.core.BooleanBuilder; //导入方法依赖的package包/类
private void appendFilterByQuickFilter() {
    if (ctx.getQuickFilter().hasFilter()) {
        BooleanBuilder filterBooleanBuilder = new BooleanBuilder();
        for (FilterToken token : quickFilter.listFilterTokens()) {
            BooleanBuilder tokenBooleanBuilder = new BooleanBuilder();
            for (String filter : token.getAllPossibleMatches()) {
                tokenBooleanBuilder.or(buildQuickFilterBooleanExpression($, filter));
            }
            filterBooleanBuilder.and(tokenBooleanBuilder);
        }
        query.getQuickFilterWhereClause().or(filterBooleanBuilder);
    }
}
 

import com.querydsl.core.BooleanBuilder; //导入方法依赖的package包/类
private boolean isLastAdmin(Long id) {
	JPAQuery<Integer> query = this.jpaQueryFactory.select(Expressions.ONE)
			.from(QUser.user);
	BooleanBuilder bb = new BooleanBuilder();
	bb.or(QUser.user.authorities.eq(Authority.ADMIN.name()));
	bb.or(QUser.user.authorities.endsWith("," + Authority.ADMIN.name()));
	bb.or(QUser.user.authorities.contains("," + Authority.ADMIN.name() + ","));
	bb.or(QUser.user.authorities.startsWith(Authority.ADMIN.name() + ","));

	query.where(QUser.user.id.ne(id).and(QUser.user.deleted.isFalse())
			.and(QUser.user.enabled.isTrue()).and(bb));
	return query.fetchFirst() == null;
}