import java.util.Date;
import javax.persistence.AttributeOverride;
import javax.persistence.AttributeOverrides;
import javax.persistence.Column;
import javax.persistence.EmbeddedId;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.JoinColumn;
import javax.persistence.JoinColumns;
import javax.persistence.ManyToOne;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

/**
* Tcom generated by hbm2java
*/
@Entity
@Table(name="tcom"
    ,catalog="emsis"
)
public class Tcom  implements java.io.Serializable {


     private TcomId id;
     private Tbrand tbrand;
     private String comMatName;

    public Tcom() {
    }

   
    public Tcom(TcomId id, Tbrand tbrand) {
        this.id = id;
        this.tbrand = tbrand;
    }
    public Tcom(TcomId id, Tbrand tbrand, String comMatName) {
       this.id = id;
       this.tbrand = tbrand;
       this.comMatName = comMatName;
    }
   
     @EmbeddedId

   
    @AttributeOverrides( {
        @AttributeOverride(name="client", column=@Column(name="CLIENT", nullable=false) ),
        @AttributeOverride(name="comMatId", column=@Column(name="COM_MAT_ID", nullable=false) ) } )
    public TcomId getId() {
        return this.id;
    }
   
    public void setId(TcomId id) {
        this.id = id;
    }

@ManyToOne(fetch=FetchType.LAZY)
    @JoinColumns( {
        @JoinColumn(name="BRAND_ID", referencedColumnName="BRAND_ID", nullable=false, insertable=false, updatable=false),
        @JoinColumn(name="CLIENT", referencedColumnName="CLIENT", nullable=false, insertable=false, updatable=false) } )
    public Tbrand getTbrand() {
        return this.tbrand;
    }
   
    public void setTbrand(Tbrand tbrand) {
        this.tbrand = tbrand;
    }

    @Column(name="COM_MAT_NAME", length=80)
    public String getComMatName() {
        return this.comMatName;
    }
   
    public void setComMatName(String comMatName) {
        this.comMatName = comMatName;
    }
}

import javax.persistence.Column;
import javax.persistence.Embeddable;

/**
* TcomId generated by hbm2java
*/
@Embeddable
public class TcomId  implements java.io.Serializable {


     private int client;
     private int comMatId;

    public TcomId() {
    }

    public TcomId(int client, int comMatId) {
       this.client = client;
       this.comMatId = comMatId;
    }
   


    @Column(name="CLIENT", nullable=false)
    public int getClient() {
        return this.client;
    }
   
    public void setClient(int client) {
        this.client = client;
    }


    @Column(name="COM_MAT_ID", nullable=false)
    public int getComMatId() {
        return this.comMatId;
    }
   
    public void setComMatId(int comMatId) {
        this.comMatId = comMatId;
    }


   public boolean equals(Object other) {
         if ( (this == other ) ) return true;
       if ( (other == null ) ) return false;
       if ( !(other instanceof TcomId) ) return false;
       TcomId castOther = ( TcomId ) other;
         
       return (this.getClient()==castOther.getClient())
&& (this.getComMatId()==castOther.getComMatId());
   }
   
   public int hashCode() {
         int result = 17;
         
         result = 37 * result + this.getClient();
         result = 37 * result + this.getComMatId();
         return result;
   }   


}

import java.util.Date;
import java.util.HashSet;
import java.util.Set;
import javax.persistence.AttributeOverride;
import javax.persistence.AttributeOverrides;
import javax.persistence.Column;
import javax.persistence.EmbeddedId;
import javax.persistence.Entity;
import javax.persistence.FetchType;
import javax.persistence.OneToMany;
import javax.persistence.Table;
import javax.persistence.Temporal;
import javax.persistence.TemporalType;

/**
* Tbrand generated by hbm2java
*/
@Entity
@Table(name="tbrand"
    ,catalog="emsis"
)
public class Tbrand  implements java.io.Serializable {


     private TbrandId id;
     private String brandName;
     private int catGrpId;
     private Set<Tcom> tcoms = new HashSet<Tcom>(0);

    public Tbrand() {
    }

   
    public Tbrand(TbrandId id, int catGrpId) {
        this.id = id;
        this.catGrpId = catGrpId;
    }

    public Tbrand(TbrandId id, String brandName,  int catGrpId,  Set<Tcom> tcoms) {
       this.id = id;
       this.brandName = brandName;
       this.catGrpId = catGrpId;
       this.tcoms = tcoms;
    }
   
     @EmbeddedId

   
    @AttributeOverrides( {
        @AttributeOverride(name="brandId", column=@Column(name="BRAND_ID", nullable=false) ),
        @AttributeOverride(name="client", column=@Column(name="CLIENT", nullable=false) ) } )
    public TbrandId getId() {
        return this.id;
    }
   
    public void setId(TbrandId id) {
        this.id = id;
    }

       
    @Column(name="BRAND_NAME", length=80)
    public String getBrandName() {
        return this.brandName;
    }
   
    public void setBrandName(String brandName) {
        this.brandName = brandName;
    }

     
    @Column(name="CAT_GRP_ID", nullable=false)
    public int getCatGrpId() {
        return this.catGrpId;
    }
   
    public void setCatGrpId(int catGrpId) {
        this.catGrpId = catGrpId;
    }

@OneToMany(fetch=FetchType.LAZY, mappedBy="tbrand")
    public Set<Tcom> getTcoms() {
        return this.tcoms;
    }
   
    public void setTcoms(Set<Tcom> tcoms) {
        this.tcoms = tcoms;
    }

}



import javax.persistence.Column;
import javax.persistence.Embeddable;

/**
* TbrandId generated by hbm2java
*/
@Embeddable
public class TbrandId  implements java.io.Serializable {


     private int brandId;
     private int client;

    public TbrandId() {
    }

    public TbrandId(int brandId, int client) {
       this.brandId = brandId;
       this.client = client;
    }
   


    @Column(name="BRAND_ID", nullable=false)
    public int getBrandId() {
        return this.brandId;
    }
   
    public void setBrandId(int brandId) {
        this.brandId = brandId;
    }


    @Column(name="CLIENT", nullable=false)
    public int getClient() {
        return this.client;
    }
   
    public void setClient(int client) {
        this.client = client;
    }


   public boolean equals(Object other) {
         if ( (this == other ) ) return true;
       if ( (other == null ) ) return false;
       if ( !(other instanceof TbrandId) ) return false;
       TbrandId castOther = ( TbrandId ) other;
         
       return (this.getBrandId()==castOther.getBrandId())
&& (this.getClient()==castOther.getClient());
   }
   
   public int hashCode() {
         int result = 17;
         
         result = 37 * result + this.getBrandId();
         result = 37 * result + this.getClient();
         return result;
   }   


}

@RequestMapping("/saveCaption")
    public @ResponseBody
    String saveCaption(@RequestParam(value = "caption_name") String caption_name,
@RequestParam(value = "brand_id") String brand_id) {
        String ret = "E";
        try {
            List<Tbrand> list = tbrandDao.findAll();
            Tbrand tbrand = new Tbrand();
            for (Iterator<Tbrand> it = list.iterator(); it.hasNext();) {
                Tbrand tbrand1 = it.next();
                if (tbrand1.getId().getBrandId() == Integer.parseInt(brand_id)) {
                    tbrand.setId(tbrand1.getId());
                }
            }
            Tcom tcom = new Tcom();
            TcomId tcomId = new TcomId(800, 1);
            tcom.setId(tcomId);
            tcom.setComMatName(caption_name);
            tcom.setTbrand(tbrand);
            tcomDao.add(tcom);
            ret = "S";
        } catch (Exception ex) {
            ex.printStackTrace();
        } finally {
            return ret;
        }
    }