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();
}
|