例如:
表1
marketTable
(
int marId primary key;
......
int operator foreign key(name) references employTable;//操作者
int verifier foreign key(name) references employTable;//审核者
)
表2
employTable
(
int empId primary key;
varchar(100) name;
......
)
如表,表一两个字段都要引用表2同的同一字段,hibernate应该怎么配置?
如果用注解的方式应该这样:
@OnetoMany
@JoinColumns({
@JoinColumn(name = "operator", referencedColumnName = employOperator")
})
Set employOperators;
@OnetoMany
@JoinColumns({
@JoinColumn(name = "verifier", referencedColumnName =employVerifier")
})
Set employVerifiers;
在使用hib 应该以面向对象的角度考虑了
class marketTable
int marId;
employ en1;
employ en2;
.....
class employ :
int empId ,
string name
[code="java"]
class marketTable
int marId;
employ employOperator;
employ employVerifier;
映射文件用两个many-to-one
[/code]