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

港控/mmm° 2022-05-13 11:24 122阅读 0赞

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)