@Override
	public PhoneRecord getRecord(String email) {
		
		PhoneRecord record = null;
		Connection connection = null;
    	PreparedStatement statement = null;
    	try {
			connection = StorageProvider.INSTANCE.getConnection();
			statement = connection.prepareStatement(GET_RECORD_QUERY);
			statement.setString(1, email);
			ResultSet resultSet = statement.executeQuery();
			resultSet.next();
			record = parseRecordMainInfo(resultSet);
			Address address = parseAddress(resultSet);
			record.setAddress(address);
			Workplace workplace = parseWorkplace(resultSet);
			record.setWorkplace(workplace);
		} catch (SQLException e) {
			LOGGER.error("Failed to obtain connection:", e);
		} finally {
			closeResources(connection, statement);
		}
		return record;
	}