怎样用hibernate的hql查询查询成map或list

//HQL-Associations

Stringhql="selects.name,p.name,p.pricefromProductpinnerjoinp.supplierass";

Queryquery=session.createQuery(hql);

List results = query.list();

//HQL-Delete

Stringhql="deletefromProductwherename=:name";

Queryquery=session.createQuery(hql);

query.setString("name","Product1");

int rowCount = query.executeUpdate();

//HQL-Function

Stringhql="selectmin(product.price),max(product.price)fromProductproduct";

Queryquery=session.createQuery(hql);

List results = query.list();

//HQL-FetchAssociationsHQLInnerJoin

Stringhql="fromSuppliersinnerjoinfetchs.productsasp";

Queryquery=session.createQuery(hql);

List results = query.list();

//HQL-NamedParameters

Stringhql="fromProductwhereprice>:price";

Queryquery=session.createQuery(hql);

query.setDouble("price",2.0);

Listresults=query.list();

Stringhql="fromProductasproductwhereproduct.supplier=:supplier";

Queryquery=session.createQuery(hql);

query.setEntity("supplier",supplier);

List results = query.list();

//HQL-Update

Stringhql="updateSuppliersetname=:newNamewherename=:name";

Queryquery=session.createQuery(hql);

query.setString("name","SupplierName1");

query.setString("newName","s1");

int rowCount = query.executeUpdate();

//HQL-where

Stringhql="fromProductwhereprice>2.0andnamelike'P%'";

Queryquery=session.createQuery(hql);

List results = query.list();

//HQL-Map

Stringhql="selectnewmap(usr.nameasuserName,usr.passwordaspassword)fromUserusr";

Queryquery=session.createQuery(hql);

Listlist=query.list();

Mapgoods=(Map)list.get(0);

【注】

Stringhql="selectnewmap(usr.nameasuserName,usr.passwordaspassword)　fromcom.jason.Userusr";

Stringhql="selectnewmap(usr.nameasuserName,usr.passwordaspassword)fromcom.jason.Userusr";

由于from之前的空格，引起unexpectedtoken:　from

//select new

给一个构建函数： public class Department(Department d, Integer employeeSize)

然后写成这样： SELECT new Department(department, count(employee.id)) FROM .....

//查询其中几个字段,添加new map(),注意map里的m是小写的。也不需要导入包，这样通过query.list()出来的list里存放的不再是默认的Object数组了，而是map集合了   
120. String hql = " select new map(name,passwd) from Users";   
121. Query query = session.createQuery(hql);   
122. //默认查询出来的list里存放的是一个Object数组，但是在这里list里存放的不再是默认的Object数组了，而是Map集合了   
123. List<Map> list = query.list();   
124. for(Map user : list){   
125. //一条记录里所有的字段值都是map里的一个元素,key是字符串0,1,2,3....，value是字段值   
126. //如果将hql改为：String hql = " select new map(name as username,passwd as password) from Users";,那么key将不是字符串0,1,2...了，而是"username","password"了   
127. String name = (String)user.get("0");//get("0");是get(key),注意:0,1,2...是字符串，而不是整形   
128. String passwd = (String)user.get("1");   
129.   
130. System.out.println(name + " : " + passwd);   
131. }   
132. /**   
133. 输出结果为：   
134. name1 : password1   
135. name2 : password2   
136. name3 : password3   
137. */   
138.//查询其中几个字段,添加new map(),注意map里的m是小写的。也不需要导入包，这样通过query.list()出来的list里存放的不再是默认的Object数组了，而是map集合了   
139. String hql = " select new map(name,passwd) from Users";   
140. Query query = session.createQuery(hql);   
141. //默认查询出来的list里存放的是一个Object数组，但是在这里list里存放的不再是默认的Object数组了，而是Map集合了   
142. List<Map> list = query.list();   
143. for(Map user : list){   
144. //一条记录里所有的字段值都是map里的一个元素,key是字符串0,1,2,3....，value是字段值   
145. //如果将hql改为：String hql = " select new map(name as username,passwd as password) from Users";,那么key将不是字符串0,1,2...了，而是"username","password"了   
146. String name = (String)user.get("0");//get("0");是get(key),注意:0,1,2...是字符串，而不是整形   
147. String passwd = (String)user.get("1");   
148.   
149. System.out.println(name + " : " + passwd);   
150. }   
151. /**   
152. 输出结果为：   
153. name1 : password1   
154. name2 : password2   
155. name3 : password3   
156. */