hibernate 注释关联表关系VO  demo


import glodon.td.model.GLProject;
import glodon.td.model.GLUserInfo;
import glodon.td.model.GLUserNumber;


import java.math.BigDecimal;
import java.util.Date;


/**
 * 
 * 出价记录
 * 
 * @version
 */
@Relations(base = GLBiddingRecord.class, value = {
//@Relation(refer = GLUserNumber.class, baseColumn = { "userNumberId" }, referColumn = { "id" }),
//@Relation(base = GLUserNumber.class, refer = GLUserInfo.class, baseColumn = "userId", referColumn = "sysId"),
//@Relation(refer = GLProject.class, baseColumn = "projectId", referColumn = "projectId") })
@Relation(refer = GLUserNumber.class, referColumn = "id", baseColumn = "userNumberId", type = RelationType.LEFT),
@Relation(refer = GLUserInfo.class, referColumn = "sysId", baseColumn = "userId", type = RelationType.LEFT),

@Relation(refer = GLProject.class, referColumn = "projectId", baseColumn = "projectId", type = RelationType.LEFT) })



// 以上关联生成的SQL语句

select  t1.colum1 t2.colum2....from table GLBiddingRecord left join GLBiddingRecord.projectid on  GLProject,...................前提条件是都要有PO

public class PrintBiddingRecordVO extends GLBiddingRecord {


/**
* 报价牌号
*/
@Field(clazz = GLUserNumber.class)
private String userNumber;


// 竞得价格
@Field(clazz = GLBiddingRecord.class)
private BigDecimal price;


// 创建时间
@Field(clazz = GLBiddingRecord.class)
private Date createTime;


//报价序号
@Field(clazz = GLBiddingRecord.class)
private Long serialNumber;


//加价幅度
@Field(clazz = GLProject.class)
private String addPrice;


//竞买者
@Field(clazz = GLUserInfo.class)
private String userName;


//出价幅度(不是项目的)
private String priceAdded;


public String getPriceAdded() {
return priceAdded;
}


public void setPriceAdded(String priceAdded) {
this.priceAdded = priceAdded;
}


public String getUserNumber() {
return userNumber;
}


public void setUserNumber(String userNumber) {
this.userNumber = userNumber;
}


public BigDecimal getPrice() {
return price;
}


public void setPrice(BigDecimal price) {
this.price = price;
}


public Date getCreateTime() {
return createTime;
}


public void setCreateTime(Date createTime) {
this.createTime = createTime;
}


public Long getSerialNumber() {
return serialNumber;
}


public void setSerialNumber(Long serialNumber) {
this.serialNumber = serialNumber;
}


public String getAddPrice() {
return addPrice;
}


public void setAddPrice(String addPrice) {
this.addPrice = addPrice;
}


public String getUserName() {
return userName;
}


public void setUserName(String userName) {
this.userName = userName;
}
}
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值