select new map(o.customer.name as customerName, o.tradedate as tradedate, o.status as status, o.amount as amount ) from OrderForm o where o.tradedate between '2015-05-01' and '2015-06-01' and (o.status='已付款' or o.status='已发货') and o.amount>1000 order by o.status asc, o.tradedate desc, o.amount desc
第一题
String hql = "select new map(c.name as name,c.price as price,c.seller.name as sellername, c.category as category) from Commondity c"
+ " where c.category like '%书%' and c.price >=10 order by c.seller.name,c.price desc, c.name asc";
select c.name,c.price,c.seller,c.category from commodity c where c.category like %书% and c.price>=10 order by c.seller.name asc,c.price desc,c.name asc;
