@Override public Address map(int index, ResultSet resultSet, StatementContext ctx) throws SQLException { Address address = new Address(); address.setId((UUID) resultSet.getObject("address_id")); address.setCustomerId((UUID) resultSet.getObject("customer_id")); address.setCompany(resultSet.getString("company")); address.setFullName(resultSet.getString("full_name")); address.setStreet(resultSet.getString("street")); address.setStreetComplement(resultSet.getString("street_complement")); address.setZip(resultSet.getString("zip")); address.setCity(resultSet.getString("city")); address.setCountry(resultSet.getString("country")); address.setType(resultSet.getString("type")); address.setNote(resultSet.getString("note")); return address; } }
billing.setId((UUID) resultSet.getObject("billing_address_id")); billing.setFullName(resultSet.getString("billing_address_full_name")); billing.setStreet(resultSet.getString("billing_address_street")); billing.setStreetComplement(resultSet.getString("billing_address_street_complement")); billing.setZip(resultSet.getString("billing_address_zip")); delivery.setId((UUID) resultSet.getObject("delivery_address_id")); delivery.setFullName(resultSet.getString("delivery_address_full_name")); delivery.setStreet(resultSet.getString("delivery_address_street")); delivery.setStreetComplement(resultSet.getString("delivery_address_street_complement")); delivery.setZip(resultSet.getString("delivery_address_zip"));
billingAddress.setFullName(fullName(firstName, lastName)); billingAddress.setStreet(billingStreet); billingAddress.setZip(billingZip); billingAddress.setCity(billingCity); deliveryAddress.setFullName(fullName(firstName, lastName)); deliveryAddress.setStreet(street); deliveryAddress.setZip(zip); deliveryAddress.setCity(city);