hibernate中HQL范例大全

$下面介绍HQL语句的语法

1.from子句

from Person

表明从Person持久化类中选出全部的实例。

推荐：from Person as p

2.select子句

select p.name from Person as p

select p.name.firstName from Person as p

select new list(p.name, p.address) from Person as p

select new ClassTest(p.name, p.address) from Person as p (有前提)

select p.name as personName from Person as p

select new map(p.name as personName) from Person as p (与new map()结合更普遍)

3.聚集函数

avg,count,max,min,sum

select count(*) from Person

select max(p.age) from Person as p

select p.name || "" || p.address from Perso