*
* CREATE TABLE comments ( * id INTEGER UNSIGNED NOT NULL UNIQUE, * from_user_id INTEGER, * to_user_id INTEGER, * item_id INTEGER, * rating INTEGER, * date DATETIME, * comment TEXT * PRIMARY KEY(id), * INDEX from_user (from_user_id), * INDEX to_user (to_user_id), * INDEX item (item_id) * ); ** @author Emmanuel Cecchet and Julie Marguerite * @version 1.0 */ public abstract class CommentBean implements EntityBean { private EntityContext entityContext; private transient boolean isDirty; // used for the isModified function /*****************************/ /* Abstract accessor methods */ /*****************************/ /** * Set comment id. * * @since 1.0 */ public abstract void setId(Integer id); /** * Get comment's id. * * @return comment id */ public abstract Integer getId(); /** * Get the user id of the author of the comment * * @return author user id */ public abstract Integer getFromUserId(); /** * Get the user id of the user this comment is about. * * @return user id this comment is about */ public abstract Integer getToUserId(); /** * Get the item id which is the primary key in the items table. * * @return item id */ public abstract Integer getItemId(); /** * Get the rating associated to this comment. * * @return rating */ public abstract int getRating(); /** * Time of the Comment in the format 'YYYY-MM-DD hh:mm:ss' * * @return comment time */ public abstract String getDate(); /** * Get the comment text. * * @return comment text */ public abstract String getComment(); /** * Set a new user identifier for the author of the comment. * This id must match the primary key of the users table. * * @param id author user id */ public abstract void setFromUserId(Integer id); /** * Set a new user identifier for the user this comment is about. * This id must match the primary key of the users table. * * @param id user id comment is about */ public abstract void setToUserId(Integer id); /** * Set a new item identifier. This id must match * the primary key of the items table. * * @param id item id */ public abstract void setItemId(Integer id); /** * Set a new rating for the ToUserId. * * @param Rating an
int value
*/
public abstract void setRating(int Rating);
/**
* Set a new date for this comment
*
* @param newDate comment date
*/
public abstract void setDate(String newDate);
/**
* Set a new comment for ToUserId from FromUserId.
*
* @param newComment Comment
*/
public abstract void setComment(String newComment);
/**
* This method is used to create a new Comment Bean.
* The date is automatically set to the current date when the method is called.
*
* @param FromUserId user id of the comment author, must match the primary key of table users
* @param ToUserId user id of the user this comment is about, must match the primary key of table users
* @param ItemId item id, must match the primary key of table items
* @param Rating user (ToUserId) rating given by the author (FromUserId)
* @param Comment comment text
*
* @return pk primary key set to null
* @exception CreateException if an error occurs
*/
public CommentPK ejbCreate(Integer FromUserId, Integer ToUserId, Integer ItemId, int Rating, String Comment) throws CreateException
{
// Connecting to IDManager Home interface thru JNDI
IDManagerLocalHome home = null;
IDManagerLocal idManager = null;
try
{
InitialContext initialContext = new InitialContext();
home = (IDManagerLocalHome)initialContext.lookup(
"java:comp/env/ejb/IDManager");
}
catch (Exception e)
{
throw new EJBException("Cannot lookup IDManager: " +e);
}
try
{
IDManagerPK idPK = new IDManagerPK();
idManager = home.findByPrimaryKey(idPK);
setId(idManager.getNextCommentID());
setFromUserId(FromUserId);
setToUserId(ToUserId);
setItemId(ItemId);
setRating(Rating);
setDate(TimeManagement.currentDateToString());
setComment(Comment);
}
catch (Exception e)
{
throw new EJBException("Cannot create comment: " +e);
}
return null;
}
/** This method just set an internal flag to
reload the id generated by the DB */
public void ejbPostCreate(Integer FromUserId, Integer ToUserId, Integer ItemId, int Rating, String Comment)
{
isDirty = true; // the id has to be reloaded from the DB
}
/** Persistence is managed by the container and the bean
becomes up to date */
public void ejbLoad()
{
isDirty = false;
}
/** Persistence is managed by the container and the bean
becomes up to date */
public void ejbStore()
{
isDirty = false;
}
/** This method is empty because persistence is managed by the container */
public void ejbActivate(){}
/** This method is empty because persistence is managed by the container */
public void ejbPassivate(){}
/** This method is empty because persistence is managed by the container */
public void ejbRemove() throws RemoveException {}
/**
* Sets the associated entity context. The container invokes this method
* on an instance after the instance has been created.
*
* This method is called in an unspecified transaction context.
*
* @param context An EntityContext interface for the instance. The instance should
* store the reference to the context in an instance variable.
* @exception EJBException Thrown by the method to indicate a failure
* caused by a system-level error.
*/
public void setEntityContext(EntityContext context)
{
entityContext = context;
}
/**
* Unsets the associated entity context. The container calls this method
* before removing the instance. This is the last method that the container
* invokes on the instance. The Java garbage collector will eventually invoke
* the finalize() method on the instance.
*
* This method is called in an unspecified transaction context.
*
* @exception EJBException Thrown by the method to indicate a failure
* caused by a system-level error.
*/
public void unsetEntityContext()
{
entityContext = null;
}
/**
* Returns true if the beans has been modified.
* It prevents the EJB server from reloading a bean
* that has not been modified.
*
* @return a boolean value
*/
public boolean isModified()
{
return isDirty;
}
/**
* Display comment information as an HTML table row
*
* @return a String containing HTML code
* @since 1.0
*/
public String printComment(String userName)
{
return "\n"; } }