Jackson中objectMapper的特殊用法

本文章主要介绍Jackson中一种特殊的类 Jackson2ObjectMapperBuilder,此类可以特殊的时间格式进行处理，例如OffsetDateTime。

Jackson.jar下载；https://mvnrepository.com/artifact/com.alibaba/fastjson/1.2.54

接下来介绍json和java之间的相互转化：

---

package com.top.mamanger.pjmanager.typehandler;

import java.io.IOException;
import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.apache.ibatis.type.BaseTypeHandler;
import org.apache.ibatis.type.JdbcType;
import org.springframework.http.converter.json.Jackson2ObjectMapperBuilder;

import com.fasterxml.jackson.core.JsonProcessingException;
import com.fasterxml.jackson.databind.ObjectMapper;
import com.fasterxml.jackson.databind.SerializationFeature;

import lombok.extern.slf4j.Slf4j;


@Slf4j
public class JsonbTypeHandler<T> extends BaseTypeHandler<T> {

    private static final ObjectMapper objectMapper = new Jackson2ObjectMapperBuilder()
            .featuresToDisable(SerializationFeature.WRITE_DATES_AS_TIMESTAMPS).build();
    private Class<T> valueType;

    /**
     * @param valueType
     *            把json字符串转换为Java对象时指定的java类类型
     *
     */
    public JsonbTypeHandler(Class<T> valueType) {
        this.valueType = valueType;
    }

   /**
     *  对象转化为json字符串
     */
    @Override
    public void setNonNullParameter(PreparedStatement ps, int i, T parameter, JdbcType jdbcType)
            throws SQLException {
        String jsonString = null;
        try {
            jsonString = JsonbTypeHandler.objectMapper.writeValueAsString(parameter);
        }
        catch (JsonProcessingException e) {
            log.error("method: setNonNullParameter, error:" + e.toString());
        }
        ps.setString(i, jsonString);
    }

  
    @Override
    public T getNullableResult(ResultSet rs, String columnName) throws SQLException {
        return this.string2Object(rs.getString(columnName));
    }


    @Override
    public T getNullableResult(ResultSet rs, int columnIndex) throws SQLException {
        return this.string2Object(rs.getString(columnIndex));
    }


    @Override
    public T getNullableResult(CallableStatement cs, int columnIndex) throws SQLException {
        return this.string2Object(cs.getString(columnIndex));
    }

    /**
     * @param jsonString
     *            用来转换为Java对象的json字符串
     * @return
     *         转换后的java对象
     */
    private T string2Object(String jsonString) {
        if (jsonString != null) {
            try {
                T result = JsonbTypeHandler.objectMapper.readValue(jsonString, this.valueType);
                return result;
            }
            catch (IOException e) {
                log.error("method: string2Object, error:" + e.toString());
            }
        }
        return null;
    }

}