我算是看明白了,這hql語(yǔ)句就是sql的簡(jiǎn)化版,而且省了自己挨個(gè)去接收查詢結(jié)果值得步驟了,
2018-02-02
第二題
String hql = "select o.customer.name, o.tradedate, o.status, o.amount " +
"from t_order o " +
"where o.tradedate between '2015-05-01' and '2015-06-01' " +
"and o.status in ('已發(fā)貨', '已付款') and o.amount > 1000 " +
"order by o.status, o.tradedate desc, o.amount desc";
String hql = "select o.customer.name, o.tradedate, o.status, o.amount " +
"from t_order o " +
"where o.tradedate between '2015-05-01' and '2015-06-01' " +
"and o.status in ('已發(fā)貨', '已付款') and o.amount > 1000 " +
"order by o.status, o.tradedate desc, o.amount desc";
2018-01-31
打卡
第一題
String hql = "select c.name, c.price, c.category, c.seller.name " +
"from t_commodity c " +
"where c.category like '%書(shū)%' and c.price >= 10 " +
"order by c.seller.name, c.price desc, c.name";
第一題
String hql = "select c.name, c.price, c.category, c.seller.name " +
"from t_commodity c " +
"where c.category like '%書(shū)%' and c.price >= 10 " +
"order by c.seller.name, c.price desc, c.name";
2018-01-31
只要from字句的情況下,hibernate默認(rèn)會(huì)查詢?cè)摮志没惖乃袑?shí)例,及該持久化類映射配置的所有屬性信息。當(dāng)hibernate框架,將HQL語(yǔ)句解析成SQL語(yǔ)句的時(shí)候,就會(huì)查詢?cè)摮志没愑成涞臄?shù)據(jù)表中,所有的映射字段信息,并將返回的結(jié)果封裝為該持久化類的對(duì)象集合。
2018-01-18