1 2 3 4 5 6 7
| Query query = em.createQuery("SELECT po.customerId.customerId, MAX(po.shippingCost), MIN(po.shippingCost), COUNT(po.orderNum) countligne, COUNT(DISTINCT po.productId.productId) " +
"FROM PurchaseOrder po WHERE po.customerId.customerId = :Id GROUP BY po.customerId.customerId");
query.setParameter("Id", id);
Object[] objMinAndMaxResult = ((List<Object[]>)query.getResultList()).get(0);
System.out.println("objMinAndMaxResult.length = " + objMinAndMaxResult.length);
for (int i = 0; i < objMinAndMaxResult.length; i++)
System.out.println(String.format("objMinAndMaxResult[%d] = %s: ", i, objMinAndMaxResult[i])); |
Partager