Question

SQL 转换成 HQL

Answer 1

先,我要给你提点建议,你这个查询不用那么麻烦的,sql不是有group by吗,用那个即可

SELECT merchant_area as name,count(*) as num
FROM merchant
GROUP BY merchant_area

改成HQL为
SELECT m.merchantArea AS name,COUNT(m.ID) AS num FROM Merchant AS m GROUP BY m.merchantArea

Answer 2

将里面的表对象替换为，对应的bean对象....
你必须进行了对象对表的映射文件配置...

Answer 3

是要工具吗？
建议你学习一下hibernate，其实HQL语句和SQL语句非常的相似，很容易上手。