private BidPK EMPejbCreate(Connection dbConn, Statement dbStmt, User owner, Item item, int amount)
throws CreateException, SQLException, RemoteException
{
CheckBidValid( dbConn, dbStmt, item, amount );
UserPK ownerPK = (UserPK) owner.getPrimaryKey();
fOwnerId = ownerPK.fId;
fOwnedId = owner.AllocateOwnedId();
ItemPK itemPK = (ItemPK) item.getPrimaryKey();
fItemKey1 = itemPK.fOwnerId;
fItemKey2 = itemPK.fOwnedId;
fAmount = amount;
fBidTime = Calendar.getInstance().getTime().getTime();
fDirty = false;
String insertSpec = "insert into BidTbl ";
insertSpec += "(ownerId, ownedId, itemKey1, itemKey2, amount, bidTimeHi, bidTimeLo) values ";
insertSpec += "(";
insertSpec += SQLForm( fOwnerId ) + ",";
insertSpec += SQLForm( fOwnedId ) + ",";
insertSpec += SQLForm( fItemKey1 ) + ",";
insertSpec += SQLForm( fItemKey2 ) + ",";
insertSpec += SQLForm( fAmount ) + ",";
insertSpec += SQLFormHi( fBidTime ) + ",";
insertSpec += SQLFormLo( fBidTime );
insertSpec += ")";
dbStmt.executeUpdate( insertSpec );
return new BidPK( fOwnerId, fOwnedId );
}
|