typeHandler=backStage.typehandler.JsonTypeHandler"Map类型转出工具

import com.fasterxml.jackson.core.JsonProcessingException;
import com.fasterxml.jackson.databind.ObjectMapper;
import backStage.exception.SystemException;
import org.apache.commons.lang.StringUtils;
import org.apache.ibatis.type.BaseTypeHandler;
import org.apache.ibatis.type.JdbcType;

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


public class JsonTypeHandler extends BaseTypeHandler {

    private final ObjectMapper mapper = new ObjectMapper();

    @Override
    public void setNonNullParameter(PreparedStatement preparedStatement, int i, Object o, JdbcType jdbcType) throws SQLException {
        try {
            if (o != null) {
                String value = this.mapper.writeValueAsString(o);
                preparedStatement.setString(i, value);
            }
        } catch (JsonProcessingException e) {
            e.printStackTrace();
        }
    }

    @Override
    public Object getNullableResult(ResultSet resultSet, String s) throws SQLException {
        Object o = null;
        String value = resultSet.getString(s);

        try {
            if(!StringUtils.isBlank(value)){
                o = this.mapper.readValue(value, Object.class);
            }
        } catch (IOException e) {
            throw new SystemException(e.getMessage(),e);
        }
        return o;
    }

    @Override
    public Object getNullableResult(ResultSet resultSet, int i) {
        return null;
    }

    @Override
    public Object getNullableResult(CallableStatement callableStatement, int i) {
        return null;
    }
}

注意：如要先数据库存储map格式的数据应该对前台传回的String字符串做如下处理

new ObjectMapper().writeValueAsString(string)