hibernate从多个表中的多个列定义类

发布于 2024-11-01 21:40:18 字数 810 浏览 1 评论 0原文

我有一个带有一些数据字段的类：

class Call{
roomId
roomDisplay
roomLocation
typeId
name
staffAidId
}

现在我想使用 java 中的 hibernate 注释来映射它但我使用的原始 sql 查询是这样的：

SELECT 
    c.roomId, 
    r.display, 
    r.location, 
    c.typeId, 
    c.staffAidId, 
    s.firstname,
  s.lastname
FROM callalert c 
JOIN staffmember s  
LEFT JOIN roomGroup g ON g.groupId = s.roomGroupId 
LEFT JOIN room r ON r.roomId = g.roomId
WHERE s.staffId = 4444 AND c.roomId = g.roomId

有没有办法映射它换句话说：有没有办法将不同表中的列映射到 1 个自定义类？该类不是 1 个表的直接表示并且从涉及的所有表中，并非所有列都被使用

编辑

我尝试了视图解决方案：

使用上述查询创建了一个视图然后我尝试使用 Netbeans 生成休眠类我生成了 2 个类：类 Calls 和可嵌入类 CallId

在搜索互联网后，

会发生这种情况，因为 hibernate 需要一个主键，因此它自己创建一个主键，我如何确保只生成 1 个类？如何为视图提供主键（好的主键是基础表的主键之一）。我该如何设置？

原文

i have a class with some datafields:

class Call{
roomId
roomDisplay
roomLocation
typeId
name
staffAidId
}

now i would like to map this using hibernate annotations in java
but the original sql query that i used was something like this:

SELECT 
    c.roomId, 
    r.display, 
    r.location, 
    c.typeId, 
    c.staffAidId, 
    s.firstname,
  s.lastname
FROM callalert c 
JOIN staffmember s  
LEFT JOIN roomGroup g ON g.groupId = s.roomGroupId 
LEFT JOIN room r ON r.roomId = g.roomId
WHERE s.staffId = 4444 AND c.roomId = g.roomId

is there a way to map this
in other words:
is there a way to map columns from different tables to 1 custom class?
the class is no direct representation of 1 table
and from all the tables that are involved, not all columns are used

edit

I tried the view solution:

created a view with the above query
then I try to generate the hibernate classes using Netbeans
and I generates 2 classes:
the class Calls and an Embeddable class CallId

after searching the Internet this happens because hibernate needs a primary key so it creates one himself

how can I make sure only 1 class gets generated?
how do I give a view a primary key (a good primary key would be 1 of the primary keys of the underlying tables). how do i set this?

分享到QQ

分享到微博