Example 13 - Storing Bid to DB
    public void EMPejbStore( Connection dbConn, Statement dbStmt ) 
    throws SQLException 
    {
        if ( !fDirty ) return;
    
        String dbSet = "update BidTbl set ";
        dbSet += "itemKey1="  + SQLForm( fItemKey1 )  + ",";
        dbSet += "itemKey2="  + SQLForm( fItemKey2 )  + ",";
        dbSet += "amount="    + SQLForm( fAmount )    + ",";
        dbSet += "bidTimeHi=" + SQLFormHi( fBidTime ) + ",";
        dbSet += "bidTimeLo=" + SQLFormLo( fBidTime ) + ",";
        dbSet += " where ";
        dbSet += "ownerId=" + SQLForm( fOwnerId ) + " AND ";
        dbSet += "ownedId=" + SQLForm( fOwnedId );
    
        dbStmt.executeUpdate( dbSet );
    }
            

Next Slide >>