String hql ="select new map(c.name as name,c.price as price,c.category as category,c.seller.name as sname) "
+ "from Commodity c "
+" where c.category like '%書%' and c.price>10 "
+"order by c.seller.name,c.price desc,c.name";
String hql = "select new map(o.customer.name as name,o.tradeDate as date,o.status as status,o.amount as amount) "
+ "from Order o where o.tradeDate between '2015-01-01' and '2016-01-01' and o.amount>1000"
+ "and o.status in ('已發(fā)貨','已付款') order by o.status ,o.tradeDate desc,o.amount desc";
