@Override public Customer map(int index, ResultSet resultSet, StatementContext ctx) throws SQLException { Customer customer = new Customer(); customer.setId((UUID) resultSet.getObject("id")); customer.setSlug(resultSet.getString("slug")); customer.setEmail(resultSet.getString("email")); customer.setPhoneNumber(resultSet.getString("phone_number")); customer.setFirstName(resultSet.getString("first_name")); customer.setLastName(resultSet.getString("last_name")); customer.setCompany(resultSet.getString("company")); customer.setUserId((UUID) resultSet.getObject("agent_id")); return customer; } }
customer.setSlug(resultSet.getString("customer_slug")); customer.setEmail(resultSet.getString("email")); customer.setFirstName(resultSet.getString("first_name")); customer.setLastName(resultSet.getString("last_name")); customer.setPhoneNumber(resultSet.getString("phone_number"));
private boolean updateCustomerIfNecessary(Customer existingCustomer, Customer customer) { boolean update = false; if (existingCustomer.getFirstName() == null || !existingCustomer.getFirstName().equals(customer.getFirstName())) { update = true; existingCustomer.setFirstName(customer.getFirstName()); } if (existingCustomer.getLastName() == null || !existingCustomer.getLastName().equals(customer.getLastName())) { update = true; existingCustomer.setLastName(customer.getLastName()); } if (existingCustomer.getPhoneNumber() == null || !existingCustomer.getPhoneNumber().equals(customer.getPhoneNumber())) { update = true; existingCustomer.setPhoneNumber(customer.getPhoneNumber()); } if (existingCustomer.getCompany() == null || !existingCustomer.getCompany().equals(customer.getCompany())) { update = true; existingCustomer.setCompany(customer.getCompany()); } return update; } }
customer.setEmail(email); if (firstName != null) { customer.setFirstName(firstName);