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-05-30' and o.status in ('已发货','已付款') and o.amount>500"
+ " order by o.status asc, o.tradeDate desc, o.amount desc";
String hql = "select new Commodity(c.name, c.price, c.seller) from Commodity c"
+ " where c.price>=10 and c.category like '%书%'"
+ " order by c.seller.name asc, c.price desc, c.name asc";
