select o.customer,o.tradeDate,o.status,o.amount from Order o where o.tradeDate between 2015-05-01 and 2015-06-01 and o.status = '已發(fā)貨' or o.status = '已付款' and o.amount > 1000 order by o.status asc,o.tradeDate desc,o.amount desc
select seller0_.ID as ID1_0_, seller0_.NAME as NAME2_0_, seller0_.TEL as TEL3_0_, seller0_.ADDRESS as ADDRESS4_0_, seller0_.WEBSITE as WEBSITE5_0_, seller0_.STAR as STAR6_0_, seller0_.BUSINESS as BUSINESS7_0_ from SELLER seller0_
String hql = " from Commodity c order by seller.id asc,c.price desc,c.name asc ";
我覺得吧，最好是把別名也加上去，不然后面那個name都不知道是Commodity.name還是seller.name，容易給新手造成困擾。
