@query不能使用QueryDSL谓词

Question

我需要@query的原因是应用基于身份验证主体的安全性。

@Query("select o from Orders o where ?#{principal.username} = o.username")

存储库的完整代码：

public interface OrderRepository extends JpaRepository<Order, Integer>, QuerydslPredicateExecutor<Order>{

    @Override
    @Query("select o from Orders o where ?#{principal.username} = o.username")
    Page<Order> findAll(Predicate predicate, Pageable pageable);
}

Answer 1

使用QueryDSL谓词，可以使用query builder创建用于创建查询的类

像这样：

    public class OrderPredicates {

    private OrderPredicates() {

    }

     public static Predicate findByCriteria(OrderSearchCriteria orderSearchCriteria) {

            QOrder order = QOrder.order;
            BooleanBuilder builder = new BooleanBuilder();
           if(orderSearchCriteria.getUsername!=null){
            builder.or(order.username
                        .eq(orderSearchCriteria.getUsername));
           }

            //Some other predicates

            return builder;
        }
}

但是，如果您想要按主体添加一个顺序列表，则可以创建一个临时查询

@Query("from Orders o where o.username = :username")
Page<Order> findAllByUser(@Param(value="username") String username, Pageable pageable);