Returning single result from ResultSet

Hi,

This may sound stupid and simple but can someone help me return the result of the following query:

......

statement3 = connection.createStatement();

rs3 = statement3.executeQuery("SELECT MAX(Amount) FROM Bids WHERE LotID='"+LotID+"'");

.....

the result of rs3 should contain just 1 'Amount' value but i dont know how to extract it. I know how to use the

while(rs3.next){

.....}

but as there is only 1 result do i need to use this or is there a simpler way of returning the value of 'Amount'

thanks

[575 byte] By [haggard17a] at [2007-11-27 11:05:21]