关闭

Hibernate onetomany onetoone manytoone样例

1404人阅读 评论(0) 收藏 举报
分类:

数据表:

-- Create table
create table T_ASSET
(
  ID                         VARCHAR2(40 CHAR) not null,
  CREATE_DATE                TIMESTAMP(6),
  REMARKS                    VARCHAR2(4000 CHAR),
  UPDATE_DATE                TIMESTAMP(6),
  ASSET_CODE                 VARCHAR2(400 CHAR),
  COUNT                      FLOAT,
  EXPECTANCY_LIFE            NUMBER(19),
  MADE_DATE                  TIMESTAMP(6),
  MANUFACTURE_COUNTRY        VARCHAR2(400 CHAR),
  NAME                       VARCHAR2(400 CHAR),
  TYPE                       VARCHAR2(400 CHAR),
  USE_DATE                   TIMESTAMP(6),
  USE_LIFE                   NUMBER(19),
  WARRANTY_PERIOD            DATE,
  SUB_TYPE_ID                VARCHAR2(40 CHAR),
  MANUFACTURER_ID            VARCHAR2(40 CHAR),
  DETAIL_TYPE_ID             VARCHAR2(40 CHAR),
  ASSET_OWNER_INFO_ID        VARCHAR2(40 CHAR),
  UNIT_ID                    VARCHAR2(40 CHAR),
  MAIN_TYPE_ID               VARCHAR2(40 CHAR),
  STATE_ID                   VARCHAR2(40 CHAR),
  CONTRACT_ID                VARCHAR2(255 CHAR),
  PROJECT_ID                 VARCHAR2(255 CHAR),
  APPROVAL_SCRAP_DATE        TIMESTAMP(6),
  ASSET_PIC                  VARCHAR2(400 CHAR),
  COMPLETE_TRANS_ASSET_TYPE  VARCHAR2(400 CHAR),
  CONTRACT                   VARCHAR2(2000 CHAR),
  DETAIL_INSTALL_SITE        VARCHAR2(2000 CHAR),
  OPERATE_PROJECT_ASSET      VARCHAR2(400 CHAR),
  OPERATE_PROJECT_ASSET_DATE TIMESTAMP(6),
  OVERHAUL_RATE              VARCHAR2(400 CHAR),
  PROJECT_APP_DOC_NO         VARCHAR2(400 CHAR),
  PROJECT_NO                 VARCHAR2(2000 CHAR),
  SUPPLIER_ID                VARCHAR2(40),
  VERIFY_STATE               VARCHAR2(4),
  DATA_LIST                  VARCHAR2(100 CHAR),
  EQUIPMENT_LIST             VARCHAR2(4000 CHAR),
  OVERHAUL_FINAL_PRICE       FLOAT,
  CONTRACT_PRICE             FLOAT,
  DEPRECIATION_METHOD        VARCHAR2(255 CHAR),
  FACTORY_PRICE              FLOAT,
  ORIGINAL_VALUE             FLOAT
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 7M
    minextents 1
    maxextents unlimited
  );
-- Add comments to the columns 
comment on column T_ASSET.ID
  is '主键';
comment on column T_ASSET.CREATE_DATE
  is '创建时间';
comment on column T_ASSET.REMARKS
  is '备注';
comment on column T_ASSET.UPDATE_DATE
  is '修改时间';
comment on column T_ASSET.ASSET_CODE
  is '资产编码';
comment on column T_ASSET.COUNT
  is '资产数量';
comment on column T_ASSET.EXPECTANCY_LIFE
  is '资产预期使用寿命';
comment on column T_ASSET.MADE_DATE
  is '资产出厂日期';
comment on column T_ASSET.MANUFACTURE_COUNTRY
  is '资产产地';
comment on column T_ASSET.NAME
  is '资产名称';
comment on column T_ASSET.TYPE
  is '规格型号';
comment on column T_ASSET.USE_DATE
  is '资产供应日期';
comment on column T_ASSET.USE_LIFE
  is '设计使用年限';
comment on column T_ASSET.WARRANTY_PERIOD
  is '资产保修期';
comment on column T_ASSET.SUB_TYPE_ID
  is '资产中类ID';
comment on column T_ASSET.MANUFACTURER_ID
  is '资产制造商ID';
comment on column T_ASSET.DETAIL_TYPE_ID
  is '资产小类ID';
comment on column T_ASSET.ASSET_OWNER_INFO_ID
  is '资产权属信息ID';
comment on column T_ASSET.UNIT_ID
  is '资产单位信息ID';
comment on column T_ASSET.MAIN_TYPE_ID
  is '资产大类ID';
comment on column T_ASSET.STATE_ID
  is '资产状态ID';
comment on column T_ASSET.CONTRACT_ID
  is '合同ID';
comment on column T_ASSET.PROJECT_ID
  is '项目ID';
comment on column T_ASSET.APPROVAL_SCRAP_DATE
  is '资产批准报废时间';
comment on column T_ASSET.ASSET_PIC
  is '资产图片名称';
comment on column T_ASSET.COMPLETE_TRANS_ASSET_TYPE
  is '竣工移交资产类型';
comment on column T_ASSET.DETAIL_INSTALL_SITE
  is '资产安装地点';
comment on column T_ASSET.OPERATE_PROJECT_ASSET
  is '项目资产标示';
comment on column T_ASSET.OPERATE_PROJECT_ASSET_DATE
  is '资产交付日期';
comment on column T_ASSET.OVERHAUL_RATE
  is '大修频次';
comment on column T_ASSET.PROJECT_APP_DOC_NO
  is '立项或可研批复文号';
-- Create/Recreate primary, unique and foreign key constraints 
alter table T_ASSET
  add primary key (ID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 832K
    minextents 1
    maxextents unlimited
  );
alter table T_ASSET
  add constraint FK162C72529B5851C foreign key (UNIT_ID)
  references T_UNIT_MASTER (ID);
alter table T_ASSET
  add constraint FK162C725473A9FA4 foreign key (MAIN_TYPE_ID)
  references T_ASSET_TYPE (ID);
alter table T_ASSET
  add constraint FK162C725900B256A foreign key (STATE_ID)
  references T_ASSET_STATE (ID);
alter table T_ASSET
  add constraint FK162C725A08EF1B4 foreign key (ASSET_OWNER_INFO_ID)
  references T_ASSET_OWNER (ID);
alter table T_ASSET
  add constraint FK162C725A8E19A3C foreign key (DETAIL_TYPE_ID)
  references T_ASSET_TYPE (ID);
alter table T_ASSET
  add constraint FK162C725AC43720A foreign key (MANUFACTURER_ID)
  references T_ENTERPRISE (ID);
alter table T_ASSET
  add constraint FK162C725AD6DBCBA foreign key (PROJECT_ID)
  references T_PROJECT (ID);
alter table T_ASSET
  add constraint FK162C725D374E6DA foreign key (CONTRACT_ID)
  references T_CONTRACT (ID);
alter table T_ASSET
  add constraint FK162C725F8E7E12B foreign key (SUB_TYPE_ID)
  references T_ASSET_TYPE (ID);
alter table T_ASSET
  add constraint FK162C725FB274A6B foreign key (SUPPLIER_ID)
  references T_ENTERPRISE (ID);

-- Create table
create table T_EQUIPMENTS
(
  ID                  VARCHAR2(40 CHAR) not null,
  CREATE_DATE         TIMESTAMP(6),
  REMARKS             VARCHAR2(255 CHAR),
  UPDATE_DATE         TIMESTAMP(6),
  LOCATION            VARCHAR2(400 CHAR),
  MANUFACTURE_COUNTRY VARCHAR2(400 CHAR),
  NAME                VARCHAR2(400 CHAR),
  PRICE               FLOAT,
  SERVICE_LIFE        FLOAT,
  TYPE                VARCHAR2(400 CHAR),
  USE_DATE            TIMESTAMP(6),
  MANUFACTURER_ID     VARCHAR2(40 CHAR),
  SUPPLIER_ID         VARCHAR2(40 CHAR),
  ASSET_ID            VARCHAR2(40 CHAR)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate primary, unique and foreign key constraints 
alter table T_EQUIPMENTS
  add primary key (ID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table T_EQUIPMENTS
  add constraint FKA8E751703DAE015A foreign key (ASSET_ID)
  references T_ASSET (ID);
alter table T_EQUIPMENTS
  add constraint FKA8E75170762B962F foreign key (SUPPLIER_ID)
  references T_ENTERPRISE (ID);
alter table T_EQUIPMENTS
  add constraint FKA8E75170AC43720A foreign key (MANUFACTURER_ID)
  references T_ENTERPRISE (ID);

-- Create table
create table T_CONTRACT
(
  ID                          VARCHAR2(255 CHAR) not null,
  BUILD_SUPPLIER_ID           VARCHAR2(400 CHAR),
  BUILD_SUPPLIER_NAME         VARCHAR2(400 CHAR),
  CONTRACT_ATTACHMENT         VARCHAR2(400 CHAR),
  CONTRACT_CONTENT            VARCHAR2(4000 CHAR),
  CONTRACT_DESTORY_DATE       VARCHAR2(400 CHAR),
  CONTRACT_END_DATE           VARCHAR2(400 CHAR),
  CONTRACT_GROUPING           VARCHAR2(400 CHAR),
  CONTRACT_NAME               VARCHAR2(140 CHAR),
  CONTRACT_NO                 VARCHAR2(100 CHAR),
  CONTRACT_OWNER_EXECUTE_ID   VARCHAR2(400 CHAR),
  CONTRACT_OWNER_EXECUTE_NAME VARCHAR2(400 CHAR),
  CONTRACT_OWNER_ID           VARCHAR2(400 CHAR),
  CONTRACT_OWNER_NAME         VARCHAR2(1000 CHAR),
  CONTRACT_PASSED_DATE        VARCHAR2(400 CHAR),
  CONTRACT_PLAN_ID            VARCHAR2(400 CHAR),
  CONTRACT_PLAN_NO            VARCHAR2(400 CHAR),
  CONTRACT_PRICE              VARCHAR2(400 CHAR),
  CONTRACT_SIGNED_DATE        VARCHAR2(400 CHAR),
  CONTRACT_START_DATE         VARCHAR2(400 CHAR),
  CONTRACT_STATUS             VARCHAR2(200 CHAR),
  CONTRACT_TYPE               VARCHAR2(400 CHAR),
  CREATE_DATE                 VARCHAR2(400 CHAR),
  CREATE_TYPE                 VARCHAR2(200 CHAR),
  FINAL_PRICE                 VARCHAR2(400 CHAR),
  INVITE_BID_TYPE             VARCHAR2(400 CHAR),
  NATION_VERIFY_PRICE         VARCHAR2(100 CHAR),
  PAY_TYPE                    VARCHAR2(400 CHAR),
  PROJECT_ID                  VARCHAR2(100 CHAR),
  PROJECT_NAME                VARCHAR2(200 CHAR),
  PROJECT_NO                  VARCHAR2(400 CHAR),
  REGISTER_PERSON_LOGINNAME   VARCHAR2(100 CHAR),
  REGISTER_PERSON_NAME        VARCHAR2(200 CHAR),
  REMARK                      VARCHAR2(4000 CHAR),
  REMOVED                     VARCHAR2(400 CHAR),
  SELF_NO                     VARCHAR2(200 CHAR),
  UPDATE_DATE                 VARCHAR2(400 CHAR),
  VERIFY_PRICE                VARCHAR2(100 CHAR)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 5M
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate primary, unique and foreign key constraints 
alter table T_CONTRACT
  add primary key (ID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 320K
    minextents 1
    maxextents unlimited
  );


映射实体类:

package com.wonders.asset.model;

import java.util.Date;
import java.util.Set;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.OneToMany;
import javax.persistence.OneToOne;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

@Entity
@Table(name="T_ASSET")
public class Asset extends SystemInformation
{
  private String assetCode;
  private String name;
  private Double count;
  private String type;
  private String manufactureCountry;
  private Date madeDate;
  private Date useDate;
  private Long useLife;
  private Long expectancyLife;
  private Date WarrantyPeriod;
  private AssetType mainType;
  private AssetType subType;
  private AssetType DetailType;
  private UnitMaster unit;
  private Enterprise manufacturer;
  private Enterprise supplier;
  private AssetOwner assetOwnerInf;
  private AssetState state;
  private Set<Equipment> equipments;
  private Contract contract;
  private Project project;
  private String detailInstallSite;
  private Date approvalScrapDate;
  private String assetPic;
  private String overhaulRate;
  private String completeTransAssetType;
  private String operateProjectAsset;
  private Date operateProjectAssetDate;
  private String projectAppDocNo;
  private String projectNo;
  private String contractNo;
  private String verifyState;
  private String dataList;
  private String equipmentList;
  private Double overhaulFinalPrice;
  private Double factoryPrice;
  private Double contractPrice;
  private Double originalValue;
  private String depreciationMethod;

  @Column(name="VERIFY_STATE", nullable=true, length=4)
  public String getVerifyState()
  {
    return this.verifyState;
  }
  public void setVerifyState(String verifyState) {
    this.verifyState = verifyState;
  }
  @Column(name="ASSET_CODE", nullable=true, length=400)
  public String getAssetCode() { return this.assetCode; }

  public void setAssetCode(String assetCode) {
    this.assetCode = assetCode;
  }
  @Column(name="NAME", nullable=true, length=400)
  public String getName() {
    return this.name;
  }
  public void setName(String name) {
    this.name = name;
  }
  @Column(name="COUNT", nullable=true)
  public Double getCount() {
    return this.count;
  }
  public void setCount(Double count) {
    this.count = count;
  }
  @Column(name="TYPE", nullable=true, length=400)
  public String getType() {
    return this.type;
  }
  public void setType(String type) {
    this.type = type;
  }
  @Column(name="MANUFACTURE_COUNTRY", nullable=true, length=400)
  public String getManufactureCountry() {
    return this.manufactureCountry;
  }
  public void setManufactureCountry(String manufactureCountry) {
    this.manufactureCountry = manufactureCountry;
  }
  @Column(name="MADE_DATE", nullable=true)
  public Date getMadeDate() {
    return this.madeDate;
  }
  public void setMadeDate(Date madeDate) {
    this.madeDate = madeDate;
  }
  @Column(name="USE_DATE", nullable=true)
  public Date getUseDate() {
    return this.useDate;
  }
  public void setUseDate(Date useDate) {
    this.useDate = useDate;
  }
  @Column(name="USE_LIFE", nullable=true)
  public Long getUseLife() {
    return this.useLife;
  }
  public void setUseLife(Long useLife) {
    this.useLife = useLife;
  }
  @Column(name="EXPECTANCY_LIFE", nullable=true)
  public Long getExpectancyLife() {
    return this.expectancyLife;
  }
  public void setExpectancyLife(Long expectancyLife) {
    this.expectancyLife = expectancyLife;
  }
  @Temporal(TemporalType.DATE)
  @Column(name="WARRANTY_PERIOD", nullable=true, length=400)
  public Date getWarrantyPeriod() { return this.WarrantyPeriod; }

  public void setWarrantyPeriod(Date warrantyPeriod) {
    this.WarrantyPeriod = warrantyPeriod;
  }

  @OneToOne
  @JoinColumn(name="PROJECT_ID")
  public Project getProject() {
    return this.project;
  }
  public void setProject(Project project) {
    this.project = project;
  }
  @OneToOne
  @JoinColumn(name="MAIN_TYPE_ID")
  public AssetType getMainType() { return this.mainType; }

  public void setMainType(AssetType mainType) {
    this.mainType = mainType;
  }
  @OneToOne
  @JoinColumn(name="SUB_TYPE_ID")
  public AssetType getSubType() { return this.subType; }

  public void setSubType(AssetType subType) {
    this.subType = subType;
  }
  @OneToOne
  @JoinColumn(name="DETAIL_TYPE_ID")
  public AssetType getDetailType() { return this.DetailType; }

  public void setDetailType(AssetType detailType) {
    this.DetailType = detailType;
  }
  @OneToOne
  @JoinColumn(name="UNIT_ID")
  public UnitMaster getUnit() { return this.unit; }

  public void setUnit(UnitMaster unit) {
    this.unit = unit;
  }
  @OneToOne
  @JoinColumn(name="MANUFACTURER_ID")
  public Enterprise getManufacturer() { return this.manufacturer; }

  public void setManufacturer(Enterprise manufacturer) {
    this.manufacturer = manufacturer;
  }
  @OneToOne
  @JoinColumn(name="SUPPLIER_ID")
  public Enterprise getSupplier() { return this.supplier; }

  public void setSupplier(Enterprise supplier) {
    this.supplier = supplier; } 
  @OneToOne
  @JoinColumn(name="ASSET_OWNER_INFO_ID")
  public AssetOwner getAssetOwnerInf() { return this.assetOwnerInf; }

  public void setAssetOwnerInf(AssetOwner assetOwnerInf) {
    this.assetOwnerInf = assetOwnerInf;
  }

  @OneToOne
  @JoinColumn(name="STATE_ID")
  public AssetState getState()
  {
    return this.state;
  }
  public void setState(AssetState state) {
    this.state = state;
  }
  @OneToMany(cascade={javax.persistence.CascadeType.ALL}, fetch=FetchType.LAZY, mappedBy="asset")
  public Set<Equipment> getEquipments() {
    return this.equipments;
  }
  public void setEquipments(Set<Equipment> equipments) {
    this.equipments = equipments;
  }

  @ManyToOne
  @JoinColumn(name="contract_id")
  public Contract getContract()
  {
    return this.contract;
  }
  public void setContract(Contract contract) {
    this.contract = contract;
  }
  @Column(name="DETAIL_INSTALL_SITE", nullable=true, length=2000)
  public String getDetailInstallSite() {
    return this.detailInstallSite;
  }
  public void setDetailInstallSite(String detailInstallSite) {
    this.detailInstallSite = detailInstallSite;
  }
  @Column(name="APPROVAL_SCRAP_DATE", nullable=true)
  public Date getApprovalScrapDate() {
    return this.approvalScrapDate;
  }
  public void setApprovalScrapDate(Date approvalScrapDate) {
    this.approvalScrapDate = approvalScrapDate;
  }
  @Column(name="ASSET_PIC", nullable=true, length=400)
  public String getAssetPic() {
    return this.assetPic;
  }
  public void setAssetPic(String assetPic) {
    this.assetPic = assetPic;
  }
  @Column(name="OVERHAUL_RATE", nullable=true, length=400)
  public String getOverhaulRate() {
    return this.overhaulRate;
  }
  public void setOverhaulRate(String overhaulRate) {
    this.overhaulRate = overhaulRate;
  }
  @Column(name="COMPLETE_TRANS_ASSET_TYPE", nullable=true, length=400)
  public String getCompleteTransAssetType() {
    return this.completeTransAssetType;
  }
  public void setCompleteTransAssetType(String completeTransAssetType) {
    this.completeTransAssetType = completeTransAssetType;
  }
  @Column(name="OPERATE_PROJECT_ASSET", nullable=true, length=400)
  public String getOperateProjectAsset() {
    return this.operateProjectAsset;
  }
  public void setOperateProjectAsset(String operateProjectAsset) {
    this.operateProjectAsset = operateProjectAsset;
  }
  @Column(name="OPERATE_PROJECT_ASSET_DATE", nullable=true)
  public Date getOperateProjectAssetDate() {
    return this.operateProjectAssetDate;
  }
  public void setOperateProjectAssetDate(Date operateProjectAssetDate) {
    this.operateProjectAssetDate = operateProjectAssetDate;
  }
  @Column(name="PROJECT_APP_DOC_NO", nullable=true, length=400)
  public String getProjectAppDocNo() {
    return this.projectAppDocNo;
  }
  public void setProjectAppDocNo(String projectAppDocNo) {
    this.projectAppDocNo = projectAppDocNo;
  }
  @Column(name="PROJECT_NO", nullable=true, length=2000)
  public String getProjectNo() {
    return this.projectNo;
  }
  public void setProjectNo(String projectNo) {
    this.projectNo = projectNo;
  }
  @Column(name="CONTRACT", nullable=true, length=2000)
  public String getContractNo() {
    return this.contractNo;
  }
  public void setContractNo(String contractNo) {
    this.contractNo = contractNo;
  }
  @Column(name="DATA_LIST", nullable=true, length=100)
  public String getDataList() {
    return this.dataList;
  }
  public void setDataList(String dataList) {
    this.dataList = dataList;
  }
  @Column(name="EQUIPMENT_LIST", nullable=true, length=100)
  public String getEquipmentList() { return this.equipmentList; }

  public void setEquipmentList(String equipmentList) {
    this.equipmentList = equipmentList;
  }
  @Column(name="OVERHAUL_FINAL_PRICE", nullable=true, length=100)
  public Double getOverhaulFinalPrice() { return this.overhaulFinalPrice; }

  public void setOverhaulFinalPrice(Double overhaulFinalPrice) {
    this.overhaulFinalPrice = overhaulFinalPrice;
  }
  @Column(name="FACTORY_PRICE", nullable=true)
  public Double getFactoryPrice() {
    return this.factoryPrice;
  }
  public void setFactoryPrice(Double factoryPrice) {
    this.factoryPrice = factoryPrice;
  }
  @Column(name="CONTRACT_PRICE", nullable=true)
  public Double getContractPrice() {
    return this.contractPrice;
  }
  public void setContractPrice(Double contractPrice) {
    this.contractPrice = contractPrice;
  }
  @Column(name="ORIGINAL_VALUE", nullable=true)
  public Double getOriginalValue() {
    return this.originalValue;
  }
  public void setOriginalValue(Double originalValue) {
    this.originalValue = originalValue;
  }
  @Column(name="DEPRECIATION_MeTHOD", nullable=true)
  public String getDepreciationMethod() {
    return this.depreciationMethod;
  }
  public void setDepreciationMethod(String depreciationMethod) {
    this.depreciationMethod = depreciationMethod;
  }
}

package com.wonders.asset.model;

import java.util.Date;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.JoinColumn;
import javax.persistence.ManyToOne;
import javax.persistence.Table;

@Entity
@Table(name="T_EQUIPMENTS")
public class Equipment extends SystemInformation
{
  private String name;
  private String type;
  private String manufactureCountry;
  private Date useDate;
  private Double serviceLife;
  private String Location;
  private Double price;
  private Enterprise manufacturer;
  private Enterprise supplier;
  private Asset asset;

  @Column(name="NAME", nullable=true, length=400)
  public String getName()
  {
    return this.name;
  }
  public void setName(String name) {
    this.name = name;
  }
  @Column(name="TYPE", nullable=true, length=400)
  public String getType() {
    return this.type;
  }
  public void setType(String type) {
    this.type = type;
  }
  @Column(name="MANUFACTURE_COUNTRY", nullable=true, length=400)
  public String getManufactureCountry() {
    return this.manufactureCountry;
  }
  public void setManufactureCountry(String manufactureCountry) {
    this.manufactureCountry = manufactureCountry;
  }
  @Column(name="USE_DATE", nullable=true)
  public Date getUseDate() {
    return this.useDate;
  }
  public void setUseDate(Date useDate) {
    this.useDate = useDate;
  }
  @Column(name="SERVICE_LIFE", nullable=true)
  public Double getServiceLife() {
    return this.serviceLife;
  }
  public void setServiceLife(Double serviceLife) {
    this.serviceLife = serviceLife;
  }
  @Column(name="LOCATION", nullable=true, length=400)
  public String getLocation() {
    return this.Location;
  }
  public void setLocation(String location) {
    this.Location = location;
  }
  @Column(name="PRICE", nullable=true)
  public Double getPrice() {
    return this.price;
  }

  public void setPrice(Double price)
  {
    this.price = price;
  }
  @ManyToOne
  @JoinColumn(name="manufacturer_id")
  public Enterprise getManufacturer() { return this.manufacturer; }

  public void setManufacturer(Enterprise manufacturer) {
    this.manufacturer = manufacturer;
  }
  @ManyToOne
  @JoinColumn(name="supplier_id")
  public Enterprise getSupplier() { return this.supplier; }

  public void setSupplier(Enterprise supplier) {
    this.supplier = supplier;
  }
  @ManyToOne
  @JoinColumn(name="ASSET_ID")
  public Asset getAsset() { return this.asset; }

  public void setAsset(Asset asset) {
    this.asset = asset;
  }
}

package com.wonders.asset.model;

import java.io.Serializable;
import java.util.Set;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.OneToMany;
import javax.persistence.Table;
import org.hibernate.annotations.GenericGenerator;

@Entity
@Table(name="T_CONTRACT")
public class Contract
  implements Serializable
{
  private String id;
  private String buildSupplierId;
  private String buildSupplierName;
  private String contractAttachment;
  private String contractContent;
  private String contractName;
  private String contractNo;
  private String contractOwnerId;
  private String contractOwnerName;
  private String contractPassedDate;
  private String contractPlanId;
  private String contractPlanNo;
  private String contractPrice;
  private String contractSignedDate;
  private String contractStatus;
  private String contractType;
  private String createDate;
  private String payType;
  private String projectId;
  private String projectName;
  private String projectNo;
  private String remark;
  private String removed;
  private String updateDate;
  private String contractEndDate;
  private String contractStartDate;
  private String contractOwnerExecuteId;
  private String contractOwnerExecuteName;
  private String verifyPrice;
  private String finalPrice;
  private String inviteBidType;
  private String nationVerifyPrice;
  private String selfNo;
  private String createType;
  private String contractDestoryDate;
  private String registerPersonName;
  private String registerPersonLoginname;
  private String contractGrouping;
  private Set<Asset> assets;

  @Column(name="CONTRACT_DESTORY_DATE", nullable=true, length=40)
  public String getContractDestoryDate()
  {
    return this.contractDestoryDate;
  }

  public void setContractDestoryDate(String contractDestoryDate) {
    this.contractDestoryDate = contractDestoryDate;
  }
  @Column(name="CREATE_TYPE", nullable=true, length=200)
  public String getCreateType() {
    return this.createType;
  }

  public void setCreateType(String createType) {
    this.createType = createType;
  }
  @Column(name="SELF_NO", nullable=true, length=200)
  public String getSelfNo() {
    return this.selfNo;
  }

  public void setSelfNo(String selfNo) {
    this.selfNo = selfNo;
  }

  public void setId(String id) {
    this.id = id; } 
  @Id
  @GeneratedValue(generator="system.uuid")
  @GenericGenerator(name="system.uuid", strategy="uuid")
  @Column(name="ID")
  public String getId() { return this.id; }

  public void setBuildSupplierId(String buildSupplierId)
  {
    this.buildSupplierId = buildSupplierId;
  }
  @Column(name="BUILD_SUPPLIER_ID", nullable=true, length=40)
  public String getBuildSupplierId() {
    return this.buildSupplierId;
  }

  public void setBuildSupplierName(String buildSupplierName) {
    this.buildSupplierName = buildSupplierName;
  }
  @Column(name="BUILD_SUPPLIER_NAME", nullable=true, length=40)
  public String getBuildSupplierName() {
    return this.buildSupplierName;
  }

  public void setContractAttachment(String contractAttachment) {
    this.contractAttachment = contractAttachment;
  }
  @Column(name="CONTRACT_ATTACHMENT", nullable=true, length=40)
  public String getContractAttachment() {
    return this.contractAttachment;
  }

  public void setContractContent(String contractContent) {
    this.contractContent = contractContent;
  }
  @Column(name="CONTRACT_CONTENT", nullable=true, length=4000)
  public String getContractContent() {
    return this.contractContent;
  }

  public void setContractEndDate(String contractEndDate) {
    this.contractEndDate = contractEndDate;
  }
  @Column(name="CONTRACT_END_DATE", nullable=true, length=40)
  public String getContractEndDate() {
    return this.contractEndDate;
  }

  public void setContractName(String contractName) {
    this.contractName = contractName;
  }
  @Column(name="CONTRACT_NAME", nullable=true, length=140)
  public String getContractName() {
    return this.contractName;
  }

  public void setContractNo(String contractNo) {
    this.contractNo = contractNo;
  }
  @Column(name="CONTRACT_NO", nullable=true, length=100)
  public String getContractNo() {
    return this.contractNo;
  }

  public void setContractOwnerId(String contractOwnerId) {
    this.contractOwnerId = contractOwnerId;
  }
  @Column(name="CONTRACT_OWNER_ID", nullable=true, length=40)
  public String getContractOwnerId() {
    return this.contractOwnerId;
  }

  public void setContractOwnerName(String contractOwnerName) {
    this.contractOwnerName = contractOwnerName;
  }
  @Column(name="CONTRACT_OWNER_NAME", nullable=true, length=1000)
  public String getContractOwnerName() {
    return this.contractOwnerName;
  }

  public void setContractPassedDate(String contractPassedDate) {
    this.contractPassedDate = contractPassedDate;
  }
  @Column(name="CONTRACT_PASSED_DATE", nullable=true, length=40)
  public String getContractPassedDate() {
    return this.contractPassedDate;
  }

  public void setContractPlanId(String contractPlanId) {
    this.contractPlanId = contractPlanId;
  }
  @Column(name="CONTRACT_PLAN_ID", nullable=true, length=40)
  public String getContractPlanId() {
    return this.contractPlanId;
  }

  public void setContractPlanNo(String contractPlanNo) {
    this.contractPlanNo = contractPlanNo;
  }
  @Column(name="CONTRACT_PLAN_NO", nullable=true, length=40)
  public String getContractPlanNo() {
    return this.contractPlanNo;
  }

  public void setContractPrice(String contractPrice) {
    this.contractPrice = contractPrice;
  }
  @Column(name="CONTRACT_PRICE", nullable=true, length=40)
  public String getContractPrice() {
    return this.contractPrice;
  }

  public void setContractSignedDate(String contractSignedDate) {
    this.contractSignedDate = contractSignedDate;
  }
  @Column(name="CONTRACT_SIGNED_DATE", nullable=true, length=40)
  public String getContractSignedDate() {
    return this.contractSignedDate;
  }

  public void setContractStatus(String contractStatus) {
    this.contractStatus = contractStatus;
  }
  @Column(name="CONTRACT_STATUS", nullable=true, length=1)
  public String getContractStatus() {
    return this.contractStatus;
  }

  public void setContractType(String contractType) {
    this.contractType = contractType;
  }
  @Column(name="CONTRACT_TYPE", nullable=true, length=40)
  public String getContractType() {
    return this.contractType;
  }

  public void setCreateDate(String createDate) {
    this.createDate = createDate;
  }
  @Column(name="CREATE_DATE", nullable=true, length=40)
  public String getCreateDate() {
    return this.createDate;
  }

  public void setPayType(String payType) {
    this.payType = payType;
  }
  @Column(name="PAY_TYPE", nullable=true, length=400)
  public String getPayType() {
    return this.payType;
  }

  public void setProjectId(String projectId) {
    this.projectId = projectId;
  }
  @Column(name="PROJECT_ID", nullable=true, length=100)
  public String getProjectId() {
    return this.projectId;
  }

  public void setProjectName(String projectName) {
    this.projectName = projectName;
  }
  @Column(name="PROJECT_NAME", nullable=true, length=200)
  public String getProjectName() {
    return this.projectName;
  }

  public void setProjectNo(String projectNo) {
    this.projectNo = projectNo;
  }
  @Column(name="PROJECT_NO", nullable=true, length=40)
  public String getProjectNo() {
    return this.projectNo;
  }

  public void setRemark(String remark) {
    this.remark = remark;
  }
  @Column(name="REMARK", nullable=true, length=4000)
  public String getRemark() {
    return this.remark;
  }

  public void setRemoved(String removed) {
    this.removed = removed;
  }
  @Column(name="REMOVED", nullable=true, length=1)
  public String getRemoved() {
    return this.removed;
  }

  public void setUpdateDate(String updateDate) {
    this.updateDate = updateDate;
  }
  @Column(name="UPDATE_DATE", nullable=true, length=40)
  public String getUpdateDate() {
    return this.updateDate;
  }
  @Column(name="CONTRACT_START_DATE", nullable=true, length=40)
  public String getContractStartDate() {
    return this.contractStartDate;
  }

  public void setContractStartDate(String contractStartDate) {
    this.contractStartDate = contractStartDate;
  }
  @Column(name="CONTRACT_OWNER_EXECUTE_ID", nullable=true, length=40)
  public String getContractOwnerExecuteId() {
    return this.contractOwnerExecuteId;
  }

  public void setContractOwnerExecuteId(String contractOwnerExecuteId) {
    this.contractOwnerExecuteId = contractOwnerExecuteId;
  }
  @Column(name="CONTRACT_OWNER_EXECUTE_NAME", nullable=true, length=40)
  public String getContractOwnerExecuteName() {
    return this.contractOwnerExecuteName;
  }

  public void setContractOwnerExecuteName(String contractOwnerExecuteName) {
    this.contractOwnerExecuteName = contractOwnerExecuteName;
  }
  @Column(name="VERIFY_PRICE", nullable=true, length=100)
  public String getVerifyPrice() {
    return this.verifyPrice;
  }

  public void setVerifyPrice(String verifyPrice) {
    this.verifyPrice = verifyPrice;
  }
  @Column(name="FINAL_PRICE", nullable=true, length=100)
  public String getFinalPrice() {
    return this.finalPrice;
  }

  public void setFinalPrice(String finalPrice) {
    this.finalPrice = finalPrice;
  }
  @Column(name="INVITE_BID_TYPE", nullable=true, length=20)
  public String getInviteBidType() {
    return this.inviteBidType;
  }

  public void setInviteBidType(String inviteBidType) {
    this.inviteBidType = inviteBidType;
  }
  @Column(name="NATION_VERIFY_PRICE", nullable=true, length=100)
  public String getNationVerifyPrice() {
    return this.nationVerifyPrice;
  }

  public void setNationVerifyPrice(String nationVerifyPrice) {
    this.nationVerifyPrice = nationVerifyPrice;
  }
  @Column(name="REGISTER_PERSON_NAME", nullable=true, length=200)
  public String getRegisterPersonName() {
    return this.registerPersonName;
  }

  public void setRegisterPersonName(String registerPersonName) {
    this.registerPersonName = registerPersonName;
  }
  @Column(name="REGISTER_PERSON_LOGINNAME", nullable=true, length=100)
  public String getRegisterPersonLoginname() {
    return this.registerPersonLoginname;
  }

  public void setRegisterPersonLoginname(String registerPersonLoginname) {
    this.registerPersonLoginname = registerPersonLoginname;
  }
  @Column(name="CONTRACT_GROUPING", nullable=true, length=1)
  public String getContractGrouping() {
    return this.contractGrouping;
  }

  public void setContractGrouping(String contractGrouping) {
    this.contractGrouping = contractGrouping;
  }
  @OneToMany(cascade={javax.persistence.CascadeType.ALL}, fetch=FetchType.LAZY, mappedBy="contract")
  public Set<Asset> getAssets() {
    return this.assets;
  }

  public void setAssets(Set<Asset> assets) {
    this.assets = assets;
  }
}


0
1

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:7484913次
    • 积分:64756
    • 等级:
    • 排名:第31名
    • 原创:252篇
    • 转载:2678篇
    • 译文:3篇
    • 评论:700条
    文章分类
    最新评论