hibernate3.0 like子句處理中文有一個(gè)問題, 3.1已得到修正。3.0版可以通過設(shè)置參數(shù)解決。改正如下:
String str = "張";
String hql = "from Customer c where c.name like ?";
Query query = session.createQuery(hql).setString(0, str+"_");
String str = "張";
String hql = "from Customer c where c.name like ?";
Query query = session.createQuery(hql).setString(0, str+"_");
2016-09-15
String hql = "SELECT new Map(c.name AS cname,c.price AS cprice,c.seller.name AS sname,c.category AS ccategory) FROM Commodity AS c "
+ " WHERE c.price >=10 AND c.category LIKE '%書%' ORDER BY c.seller.name,c.price DESC,c.name ASC ";
+ " WHERE c.price >=10 AND c.category LIKE '%書%' ORDER BY c.seller.name,c.price DESC,c.name ASC ";
2016-09-13
String hql = "SELECT o.customer.name,o.tradeDate AS tradeDate,o.status AS status,o.amount AS amount FROM Order AS o "
+ " WHERE (o.tradeDate BETWEEN '2005-05-01' AND '2015-06-01') AND o.status IN ('已經(jīng)貨','已付款') AND o.amount > 1000 ORDER BY o.status ASC,o.tradeDate DESC,o.amount DESC";
+ " WHERE (o.tradeDate BETWEEN '2005-05-01' AND '2015-06-01') AND o.status IN ('已經(jīng)貨','已付款') AND o.amount > 1000 ORDER BY o.status ASC,o.tradeDate DESC,o.amount DESC";
2016-09-13
全部都沒加泛型。List返回時(shí),最好加上Object泛型,即List<Object>;Map返回時(shí),最好加上String,Object泛型,即Map<String,Object>
2016-09-13