Example 14 - Bid Creation
    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 );
    }
            

Next Slide >>