定义的一个EntityBean,里面的一个字段是用令一个Bean的外键.但是怎么用ejbql查询出来?/**
*
* @ejb.finder
* query="SELECT OBJECT(a) FROM s_qualitytarget as a"
* signature="java.util.Collection findAll()"
*
* @ejb.finder
*query="SELECT OBJECT(a) FROM s_qualitytarget as a WHERE a.date=?1 and product_id = ?2 "
* signature="java.util.Collection findByProductIDAndDate(java.lang.String productID,java.lang.String date)"
*
**/public abstract class QualitytargetEntityBean implements EntityBean { /**
* The ejbCreate method
* @ejb.create-method
*/
public java.lang.String ejbCreate(java.lang.String id) throws javax.ejb.CreateException {
setId(id);
setState(0);
return null;
} /**
* Returns the id
* @return the id
*
* @ejb.persistent-field
* @ejb.persistence
* column-name="id"
* jdbc-type="VARCHAR"
* sql-type="VARCHAR(50)"
* @ejb.pk-field
* @ejb.interface-method
*/
public abstract java.lang.String getId(); /**
* Sets the id
*
* @param java.lang.String the new id value
*
* @ejb.interface-method
*/
public abstract void setId(java.lang.String id); /**
* Returns the date
* @return the date
*
* @ejb.persistent-field
* @ejb.persistence
* column-name="date"
* jdbc-type="VARCHAR"
* sql-type="VARCHAR(20)"
*
* @ejb.interface-method
*/
public abstract java.lang.String getDate(); /**
* Sets the date
*
* @param java.lang.String the new date value
*
* @ejb.interface-method
*/
public abstract void setDate(java.lang.String date); /**
* @ejb.interface-method
* @ejb.transaction
* type="Supports"
*/
public abstract QualitytargetValue getQualitytargetValue(); /**
* @ejb.interface-method
*/
public abstract void setQualitytargetValue(QualitytargetValue value); /**
* @ejb.interface-method
* @ejb.relation
* name="product-qualitytargets"
* role-name="qualitytarget-belongs_to-product"
* cascade-delete="no"
*
* @jboss.relation
* fk-column="product_id"
* related-pk-field="id"
* fk-contraint="foreign-key"
*
*/
public abstract ProductEntityLocal getProduct(); /**
* @ejb.interface-method
*/
public abstract void setProduct(ProductEntityLocal product);}其中,productEntityLocal的ID,如何写到这个实体BEAN的QL语句中?急.
*
* @ejb.finder
* query="SELECT OBJECT(a) FROM s_qualitytarget as a"
* signature="java.util.Collection findAll()"
*
* @ejb.finder
*query="SELECT OBJECT(a) FROM s_qualitytarget as a WHERE a.date=?1 and product_id = ?2 "
* signature="java.util.Collection findByProductIDAndDate(java.lang.String productID,java.lang.String date)"
*
**/public abstract class QualitytargetEntityBean implements EntityBean { /**
* The ejbCreate method
* @ejb.create-method
*/
public java.lang.String ejbCreate(java.lang.String id) throws javax.ejb.CreateException {
setId(id);
setState(0);
return null;
} /**
* Returns the id
* @return the id
*
* @ejb.persistent-field
* @ejb.persistence
* column-name="id"
* jdbc-type="VARCHAR"
* sql-type="VARCHAR(50)"
* @ejb.pk-field
* @ejb.interface-method
*/
public abstract java.lang.String getId(); /**
* Sets the id
*
* @param java.lang.String the new id value
*
* @ejb.interface-method
*/
public abstract void setId(java.lang.String id); /**
* Returns the date
* @return the date
*
* @ejb.persistent-field
* @ejb.persistence
* column-name="date"
* jdbc-type="VARCHAR"
* sql-type="VARCHAR(20)"
*
* @ejb.interface-method
*/
public abstract java.lang.String getDate(); /**
* Sets the date
*
* @param java.lang.String the new date value
*
* @ejb.interface-method
*/
public abstract void setDate(java.lang.String date); /**
* @ejb.interface-method
* @ejb.transaction
* type="Supports"
*/
public abstract QualitytargetValue getQualitytargetValue(); /**
* @ejb.interface-method
*/
public abstract void setQualitytargetValue(QualitytargetValue value); /**
* @ejb.interface-method
* @ejb.relation
* name="product-qualitytargets"
* role-name="qualitytarget-belongs_to-product"
* cascade-delete="no"
*
* @jboss.relation
* fk-column="product_id"
* related-pk-field="id"
* fk-contraint="foreign-key"
*
*/
public abstract ProductEntityLocal getProduct(); /**
* @ejb.interface-method
*/
public abstract void setProduct(ProductEntityLocal product);}其中,productEntityLocal的ID,如何写到这个实体BEAN的QL语句中?急.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货