Example 17 - Bid Finder (by item)
    private Enumeration EMPejbFindBidsByItem( Connection dbConn, Statement dbStmt, Item item ) 
    throws SQLException, RemoteException
    {
        Vector pkv = new Vector();
        ItemPK ipk = ( ItemPK ) item.getPrimaryKey();
    
        String selSpec = "select ownerId,ownedId from BidTbl where ";
        selSpec += "itemKey1=";
        selSpec += SQLForm( ipk.fOwnerId );
        selSpec += " AND ";
        selSpec += "itemKey2=";
        selSpec += SQLForm( ipk.fOwnedId );
        ResultSet rs = dbStmt.executeQuery( selSpec );
    
        while ( rs.next() ) 
        {
            BidPK pk = new BidPK();
            pk.fOwnerId = rs.getString("ownerId");
            pk.fOwnedId = rs.getInt("ownedId");
            pkv.addElement( (Object) pk );
        }
    
        return pkv.elements();
    }
            

Next Slide >>