String hql = "select new list(o.customer.name,o.tradedate,o.status,o.amount) from Order o where o.tradedate between ‘2015-05-01’ and ‘2015-06-01’and o.status in ('已发货','已付款') and o.amount > 1000 order by o.status asc ,o.tradedate desc , o.amount desc;
String hql = " select new map(c.name,c.price,c.seller) from Commodity c where c.category like '%书%' and c.price > = 10 order by c.seller.name , c.price desc , c.name asc";
