PreparedStatement getOrder = conn.prepareStatement( "SELECT quantity, price, extension FROM orders WHERE custId=?" ); getOrder.setInt( 1, custId ); ResultSet r = getOrder.executeQuery(); while ( r.next() ) { int quantity = r.getInt( 1 ); int price = r.getInt( 2 ); // alternate access by field name int extension = r.getLong( "extension" ); ... r.close(); break; ... }