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