hibernate 的join fetch问题。。

Question

比如我有个员工类User，1个地址类Address
[code="java"]
public class User{
int id;
Address add;
}

public class Address{
int id;
int userId;
}

[/code]
mapping中2者没有任何关联
我想问下能不能不配置mapping关系，直接用hql通过user的id查询user时把address同时查出来
这个是我自己写的个hql
[code="java"]
from User as user left join fetch user.acc as acc on user.id=acc.userId where user.id=1";
[/code]
不过有错误。。。希望哪位能指点下小弟

Answer 1

不对，不做映射怎么用hql啊？
sql:select * from user(表名) as user left join address(表名) as add on user.id(外键)=add.userid where user.id=1