final PreparedStatement getOrder = conn.prepareStatement( "SELECT quantity, price, extension FROM orders WHERE custId=?" ); getOrder.setInt( 1, custId ); ResultSet rs = getOrder.executeQuery(); while ( rs.next() ) // note next will be called to navigate to the first result { int quantity = rs.getInt( 1 ); int price = rs.getInt( 2 ); // alternate access by field name int extension = rs.getLong( "extension" ); ... rs.close(); break; ... }