楼主的做法没错啊?按你的配置,我测试通过了,SQL如下:Hibernate: insert into T_User (userName, password, id) values (?, ?, ?)
Hibernate: insert into T_Address (descr, id) values (?, ?)
Hibernate: select user0_.id as id0_, user0_.userName as userName1_0_, user0_.password as password1_0_, user0_1_.descr as descr2_0_ from T_User user0_ inner join T_Address user0_1_ on user0_.id=user0_1_.id where user0_.id=?你所说的“上面的映射文件生成的SQL如下”,是怎么得到转译后的Sql的?
Hibernate: insert into T_Address (descr, id) values (?, ?)
Hibernate: select user0_.id as id0_, user0_.userName as userName1_0_, user0_.password as password1_0_, user0_1_.descr as descr2_0_ from T_User user0_ inner join T_Address user0_1_ on user0_.id=user0_1_.id where user0_.id=?你所说的“上面的映射文件生成的SQL如下”,是怎么得到转译后的Sql的?
btw:我上面的SQL是我转译后的(查找->替换),Hibernate生成的SQL不大好看明白:)
你的表:
JAM <fk> ────→ID <pk>
而实体类是这样:
String jam; // 即JAM_CONFIG的DESC字段 你是不是只想查询的时候让RoadSectionStatus的属性jam映射到JAM_CONFIG表中的DESC字段啊,但是save or update的时候怎么办呢..又不想映射JAM_CONFIG表,好古怪的要求,使用many-to-one很容易解决的问题...
看看文档先
----
可以肯定,join是无法满足你的要求的。另外,按照现在的映射方式,你打算如何修改某个RoadSectionStatus对象的属性JAM_CONFIG....