/** * Get the intersection of the given Boolean expressions * * @param exprs * @return */ @Nullable public static BooleanExpression allOf(BooleanExpression... exprs) { return BooleanExpression.allOf(exprs); }
/** * 查询用户名称在集合userNames中的所有用户集 * @param userIds * 用户名称组, * @return * 满足name in userNames && 状态标示位为有效的用户 */ public List<UserEntity> getUsersByIds(List<String> userIds) { QUserEntity qUserEntity = QUserEntity.userEntity; JPAQuery query = getQuery(); query.from(qUserEntity); query.where( BooleanExpression.allOf( qUserEntity.id.in(userIds) ) ); return query.list(qUserEntity); }
/** * 查询用户名称在集合userNames中的所有用户集 * @param userNames * 用户名称组, * @return * 满足name in userNames && 状态标示位为有效的用户 */ public List<UserEntity> getUsersByNames(List<String> userNames) { QUserEntity qUserEntity = QUserEntity.userEntity; JPAQuery query = getQuery(); query.from(qUserEntity); query.where( BooleanExpression.allOf( qUserEntity.loginName.in(userNames), qUserEntity.status.eq(StatusEnum.STATUS_VALID) ) ); return query.list(qUserEntity); }