请hibernate高手帮忙解决@ManyToOne的问题,有点急
一共两个表T_Customer表
@Entity
@Table(name = "T_Customer")
public class Tcustomer {
private java.lang.Integer customerType;
@Column(name = "CustomerType", unique = false, nullable = true, insertable = true, updatable = true, length = 10)
public java.lang.Integer getCustomerType() {
return this.customerType;
}
public void setCustomerType(java.lang.Integer value) {
this.customerType = value;
}
}
T_Data_Dic表
@Entity
@Table(name = "T_Data_Dic")
public class TdataDic extends BaseEntity implements java.io.Serializable{
private java.lang.Integer id;
private java.lang.String itemValue;
private java.lang.String itemTableName;
private java.lang.String itemColName;
public void setId(java.lang.Integer value) {
this.id = value;
}
@Id @GeneratedValue(generator="custom-id")
@GenericGenerator(name="custom-id", strategy = "increment")
@Column(name = "ID", unique = true, nullable = false, insertable = true, updatable = true, length = 10)
public java.lang.Integer getId() {
return this.id;
}
@Column(name = "ItemValue", unique = false, nullable = true, insertable = true, updatable = true, length = 200)
public java.lang.String getItemValue() {
return this.itemValue;
}
public void setItemValue(java.lang.String value) {
this.itemValue = value;
}
@Column(name = "ItemTableName", unique = false, nullable = true, insertable = true, updatable = true, length = 200)
public java.lang.String getItemTableName() {
return this.itemTableName;
}
public void setItemTableName(java.lang.String value) {
this.itemTableName = value;
}
@Column(name = "ItemColName", unique = false, nullable = true, insertable = true, updatable = true, length = 200)
public java.lang.String getItemColName() {
return this.itemColName;
}
public void setItemColName(java.lang.String value) {
this.itemColName = value;
}
}
我要实现的sql是
select * from T_Customer t1
left join T_Data_Dic t2 on t2.ItemTableName='str1' and t2.ItemColName='str2' and t1.CustomerType=t2.ItemValue
请帮忙配置下@ManyToOne好吗? --------------------编程问答-------------------- 没人帮忙,沉了,顶一下 --------------------编程问答-------------------- 配置下外键关联不就行了吗 --------------------编程问答-------------------- 除 --------------------编程问答-------------------- 怎么设?我第一次用,谢谢
补充:Java , Web 开发