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";
String hql = "select new list(c.name,c.price,seller.name"
+ ",c.category) from Commodity c where c.category like '%书%' and c.price >= 10 "
+ "order by seller.name asc,c.price desc,c.name asc ";
