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