Java tutorial
/* * Copyright (c) 2012, Mayocat <hello@mayocat.org> * * This Source Code Form is subject to the terms of the Mozilla Public * License, v. 2.0. If a copy of the MPL was not distributed with this * file, You can obtain one at http://mozilla.org/MPL/2.0/. */ package org.mayocat.shop.payment.store.jdbi.mapper; import java.io.IOException; import java.sql.ResultSet; import java.sql.SQLException; import java.util.Map; import java.util.UUID; import org.mayocat.shop.payment.model.GatewayCustomerData; import org.skife.jdbi.v2.StatementContext; import org.skife.jdbi.v2.tweak.ResultSetMapper; import org.slf4j.Logger; import org.slf4j.LoggerFactory; import com.fasterxml.jackson.core.type.TypeReference; import com.fasterxml.jackson.databind.ObjectMapper; import com.fasterxml.jackson.datatype.guava.GuavaModule; /** * Mapper for {@link GatewayCustomerData} * * @version $Id: f1aea28a7f14d38385553ef2555ce6861bfd8ae5 $ */ public class GatewayCustomerDataMapper implements ResultSetMapper<GatewayCustomerData> { @Override public GatewayCustomerData map(int index, ResultSet resultSet, StatementContext ctx) throws SQLException { UUID customerId = (UUID) resultSet.getObject("customer_id"); String gateway = resultSet.getString("gateway"); ObjectMapper mapper = new ObjectMapper(); mapper.registerModule(new GuavaModule()); try { Map<String, Object> data = mapper.readValue(resultSet.getString("customer_data"), new TypeReference<Map<String, Object>>() { }); return new GatewayCustomerData(customerId, gateway, data); } catch (IOException e) { final Logger logger = LoggerFactory.getLogger(GatewayCustomerDataMapper.class); logger.error("Failed to de-serialize gateway customer data", e); return null; } } }