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版权协议,转载请附上原文出处链接和本声明。