我可以将hibernate查询语言用于未映射到表的实体吗？ [英] Can I use hibernate query language for entities not mapped to a table?

问题描述

以下是我用来检索给定Hotel HolidayPackages的mySQL查询：

 选择
 pkg.idHolidayPackage，pkg.name 
 FROM 
假期包裹pkg 
 INNER JOIN 
假期包裹酒店hph打包pkg.idHolidayPackage = hph.idHolidayPackage 
 INNER JOIN 
 hotelroom hr ON hr.idHotelRoom = hph.idHotelRoom 
 WHERE 
 hr.idHotel = 1; 
  

我有POJO和映射：

• HolidayPackage


• 酒店


• HotelRoom
  

对于 HolidayPackageHotel 没有POJO。

有没有什么办法可以使用Criteria API或HQL来执行sql查询，而无需为HolidayPackageHotel创建POJO？

DB关系：

解决方案

没有。 您不能在HQL中使用未映射的实体。

如果要从查询中生成Bean列表 ResultSet转换器，它可以将查询结果（对象数组）转换为bean 。通过这样做，您将节省创建和填充POJO bean的开销。

阅读这里举例说明。

Following is the mySQL query that I am using to retrieve HolidayPackages for a given Hotel:

SELECT 
    pkg.idHolidayPackage, pkg.name
FROM
    holidaypackage pkg
        INNER JOIN
    holidaypackagehotel hph ON pkg.idHolidayPackage = hph.idHolidayPackage
        INNER JOIN
    hotelroom hr ON hr.idHotelRoom = hph.idHotelRoom
WHERE
    hr.idHotel = 1;

I have POJOs with mapping for:

• HolidayPackage
• Hotel
• HotelRoom

I don't have a POJO for HolidayPackageHotel.

Is there any way to use Criteria API or HQL to execute the sql query without creating a POJO for HolidayPackageHotel?

For the curios, DB relations:

解决方案

No. You can not use the un-mapped entities inside the HQL.

If you want to generate the List of beans from the query you can use the ResultSet transformers, which can convert the query results(object arrays) to beans. By doing this you will save the overhead of creating and filling the POJO beans.

Read here for an example.

这篇关于我可以将hibernate查询语言用于未映射到表的实体吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！