jpaQueryFactory 使用

QTbOrderInfo tbOrderInfo = QTbOrderInfo.tbOrderInfo;
Calendar calendar = Calendar.getInstance();
calendar.add(Calendar.HOUR,-2);
Predicate predicate = tbOrderInfo.suspendStatus.eq(SuspendStatusEnum.SUSPEND.getCode())
        .and(tbOrderInfo.orderState.gt(2))
        .and(tbOrderInfo.operatorId.eq("2222222"))
        .and(tbOrderInfo.userStopTime.after(new Timestamp(calendar.getTime().getTime())));
List<TbOrderInfo> tbOrderInfos = jpaQueryFactory.select(Projections.fields(TbOrderInfo.class,lxTbOrderInfo.orderId,TbOrderInfo.connectorId, TbOrderInfo.orderState, TbOrderInfo.suspendStatus))
        .from(TbOrderInfo)
        .where(predicate)
        .fetch();

版权声明:本文为qdqht2009原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。