java - 将sql查询转换为hql

Question

SELECT recipe.name,SUM(salesdetails.quantity::integer),recipe.price As Quantity 
FROM (salesinfo JOIN salesdetails ON salesinfo.sessionid=salesdetails.salesinfo_sessionid) 
JOIN recipe ON salesdetails.recipe_id=recipe.id group by salesdetails.recipe_id,recipe.name,recipe.price 
ORDER BY SUM(salesdetails.quantity::integer) DESC;

谁能给我这个的 hql 查询吗？

Answer 1

如果您不熟悉 HQL 并且想要使用相同的查询，那么您可以使用 Hibernate 的 native 查询功能来完成，如下所示:

@QUERY(value="SELECT recipe.name, SUM(salesdetails.quantity:: 
INTEGER),recipe.price AS Quantity
FROM (salesinfo
JOIN salesdetails ON salesinfo.sessionid=salesdetails.salesinfo_sessionid)
JOIN recipe ON salesdetails.recipe_id=recipe.id
GROUP BY salesdetails.recipe_id,recipe.name,recipe.price
ORDER BY SUM(salesdetails.quantity:: INTEGER) DESC", nativeQuery = TRUE)

但我建议您首先尝试将其转换为 HQL 查询，然后如果出现任何问题，您应该在此处询问，而不是直接询问转换后的查询。同时这会有所帮助。