Mybatis使用自定义类型转换Postgresql

主要目的

为了解决从数据库取出来之后再手动转换为javaBean的问题。
主要用mybatis提供的Handler来把处理前置

• 添加转换类

  
  
  
  import com.fasterxml.jackson.core.JsonProcessingException;
  import com.fasterxml.jackson.databind.ObjectMapper;
  import org.apache.ibatis.logging.Log;
  import org.apache.ibatis.logging.LogFactory;
  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;
  
  /**
   * @author lyy
   * @description
   * @date 2019/5/28
   */
  public class MyStateTypeHandler extends BaseTypeHandler {
      private final static Log log = LogFactory.getLog(MyStateTypeHandler.class);
      private static ObjectMapper objectMapper;
      private Class type;
      static {
          objectMapper = new ObjectMapper();
      }
      public MyStateTypeHandler(Class type) {
          if(log.isTraceEnabled()) {
              log.trace("JsonTypeHandler(" + type + ")");
          }
          if (type == null) {
              throw new IllegalArgumentException("Type argument cannot be null");
          }
          this.type = type;
      }
  
      private  T parse(String json) {
          try {
              if(json == null || json.length() == 0) {
                  return null;
              }
              return objectMapper.readValue(json, type);
          } catch (IOException e) {
              throw new RuntimeException(e);
          }
      }
  
      private String toJsonString(Object obj) {
          try {
              return objectMapper.writeValueAsString(obj);
          } catch (JsonProcessingException e) {
              throw new RuntimeException(e);
          }
      }
      @Override
      public void setNonNullParameter(PreparedStatement preparedStatement, int i, T t, JdbcType jdbcType) throws SQLException {
          preparedStatement.setString(i, toJsonString(t));
      }
  
      @Override
      public T getNullableResult(ResultSet resultSet, String s) throws SQLException {
          return (T) parse(resultSet.getString(s));
      }
  
      @Override
      public T getNullableResult(ResultSet resultSet, int i) throws SQLException {
          return (T) parse(resultSet.getString(i));
  
      }
  
      @Override
      public T getNullableResult(CallableStatement callableStatement, int i) throws SQLException {
  
          return (T) parse(callableStatement.getString(i));
      }
  }
  
  

• 引用转换类

• 其它的与正常的调用结果相同

• 附一个Blob到Bean的转换

  
  
  import org.apache.ibatis.type.BaseTypeHandler;
  import org.apache.ibatis.type.JdbcType;
  import org.apache.ibatis.type.MappedJdbcTypes;
  import org.apache.ibatis.type.MappedTypes;
  
  import javax.sql.rowset.serial.SerialBlob;
  import java.io.UnsupportedEncodingException;
  import java.sql.*;
  
  /**
   * @author lyy
   * @description
   * @date 2019/6/11
   */
  @MappedJdbcTypes(JdbcType.OTHER) // 可有可无
  @MappedTypes(Blob.class)
  public class MyBlobTypeHander extends BaseTypeHandler