String hql="select o.customer, o.tradeDate, o.status, o.amount"
+ " from Order as 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";
