Hibernate中关于hibernate hql select new map的用法详解

使用案例

String queryStr = "select new Map(c.id as id,c.name as name,c.pycode as pycode,c.postcode as postcode,"
				+ "c.areacode as areacode,c.sProvince.name as pname) from City c where c.sProvince.name=?";

说明:new map与new Map都行,无大小写之分.

用法出处

https://docs.jboss.org/hibernate/orm/3.3/reference/en/html/queryhql.html#queryhql-select

(Hibernate Reference paragraph 14.6底部)

This is most useful when used together with select new map:

select new map( max(bodyWeight) as max, min(bodyWeight) as min, count(*) as n )
from Cat cat

This query returns a Map from aliases to selected values.