第五篇:Configuration-3之TypeHandler

本文详细介绍了MyBatis中的TypeHandler,它是处理Java对象与数据库字段类型转换的关键组件。TypeHandler接口及其实现如BaseTypeHandler提供了基本操作,并允许自定义扩展。在初始化时,MyBatis会通过TypeHandlerRegistry注册默认和用户定义的TypeHandler。在使用时,可以通过XML配置或注解指定TypeHandler,以实现特定字段的类型转换。此外,文章还解析了TypeHandler的源码,展示了如何处理不同配置情况。

这一篇只讲TypeHandler,这个类型转换器是mybatis中比较重要的东西,它是用来处理Java对象字段类型和数据库字段类型对应的一个处理器,相当重要,扩展性也很强1.

首先先看下他的一个基本定义

基本定义

基本结构

public interface TypeHandler<T> {

  /**
   * 设置参数到PreparedStatement中
   */
  void setParameter(PreparedStatement ps, int i, T parameter, JdbcType jdbcType) throws SQLException;

  /**
   * 获取名字获取类型
   */
  T getResult(ResultSet rs, String columnName) throws SQLException;

  /**
   * 根据索引获取类型
   */
  T getResult(ResultSet rs, int columnIndex) throws SQLException;

  /**
   * 根据索引获取类型
   */
  T getResult(CallableStatement cs, int columnIndex) throws SQLException;

}


这里使用了一个模板设计模式,看看它的一个子类


public abstract class BaseTypeHandler<T> extends TypeReference<T> implements TypeHandler<T> {

  protected Configuration configuration;

  public void setConfiguration(Configuration c) {
    this.configuration = c;
  }

  @Override
  public void setParameter(PreparedStatement ps, int i, T parameter, JdbcType jdbcType) throws SQLException {
    if (parameter == null) {
      if (jdbcType == null) {
        throw new TypeException("JDBC requires that the JdbcType must be specified for all nullable parameters.");
      }
      try {
        ps.setNull(i, jdbcType.TYPE_CODE);
      } catch (SQLException e) {
        throw new TypeException("Error setting null for parameter #" + i + " with JdbcType " + jdbcType + " . " +
                "Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. " +
                "Cause: " + e, e);
      }
    } else {
      try {
        setNonNullParameter(ps, i, parameter, jdbcType);
      } catch (Exception e) {
        throw new TypeException("Error setting non null for parameter #" + i + " with JdbcType " + jdbcType + " . " +
                "Try setting a different JdbcType for this parameter or a different configuration property. " +
                "Cause: " + e, e);
      }
    }
  }

  @Override
  public T getResult(ResultSet rs, String columnName) throws SQLException {
    T result;
    try {
      result = getNullableResult(rs, columnName);
    } catch (Exception e) {
      throw new ResultMapException("Error attempting to get column '" + columnName + "' from result set.  Cause: " + e, e);
    }
    if (rs.wasNull()) {
      return null;
    } else {
      return result;
    }
  }

  @Override
  public T getResult(ResultSet rs, int columnIndex) throws SQLException {
    T result;
    try {
      result = getNullableResult(rs, columnIndex);
    } catch (Exception e) {
      throw new ResultMapException("Error attempting to get column #" + columnIndex+ " from result set.  Cause: " + e, e);
    }
    if (rs.wasNull()) {
      return null;
    } else {
      return result;
    }
  }

  @Override
  public T getResult(CallableStatement cs, int columnIndex) throws SQLException {
    T result;
    try {
      result = getNullableResult(cs, columnIndex);
    } catch (Exception e) {
      throw new ResultMapException("Error attempting to get column #" + columnIndex+ " from callable statement.  Cause: " + e, e);
    }
    if (cs.wasNull()) {
      return null;
    } else {
      return result;
    }
  }

  public abstract void setNonNullParameter(PreparedStatement ps, int i, T parameter, JdbcType jdbcType) throws SQLException;

  public abstract T getNullableResult(ResultSet rs, String columnName) throws SQLException;

  public abstract T getNullableResult(ResultSet rs, int columnIndex) throws SQLException;

  public abstract T getNullableResult(CallableStatement cs, int columnIndex) throws SQLException;

}



这个类其实就是统一处理异常了,子类在实现的时候就不需要考虑异常问题了,直接当成正常的来写就行,而且这个类还组合了Configuration对象,子类就可以使用这个对象获取整个运行环境的内容数据



所以我们一般都是继承这个类,可以看个稍微简单点的处理器,String类型我们开发过程中是一定要用的



public class StringTypeHandler extends BaseTypeHandler<String> {

  @Override
  public void setNonNullParameter(PreparedStatement ps, int i, String parameter, JdbcType jdbcType)
      throws SQLException {
    ps.setString(i, parameter);
  }

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

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

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


实现是不是很简单!对吧,这个是一个基本结构

初始加载

Mybatis所有属性的设置都是用通过这个类型转换器进行处理的,那么String,Integer这些他是在哪里加载的呢,可以从TypeHandlerRegistry找到答案


Configuration对象有这么一句代码

 protected final TypeHandlerRegistry typeHandlerRegistry = new TypeHandlerRegistry();


一上来就创建了一个TypeHandlerRegistry对象,然后可以看到这个对象的构造器,进行了很多基本的注册


public TypeHandlerRegistry() {
    register(Boolean.class, new BooleanTypeHandler());
    register(boolean.class, new BooleanTypeHandler());
    register(JdbcType.BOOLEAN, new BooleanTypeHandler());
    register(JdbcType.BIT, new BooleanTypeHandler());
}

这里就不一个个写了,可以具体看到代码里面去,初始化的时候就注册了很多转换器


这个是一个初始化的位置,也不是很复杂,就是知道一下即可

基本使用

基本使用可以参考官方文档


https://mybatis.org/mybatis-3/zh/configuration.html#typeHandlers



先定义一个类型转换器


// ExampleTypeHandler.java
@MappedJdbcTypes(JdbcType.VARCHAR)
public class ExampleTypeHandler extends BaseTypeHandler<String> {

  @Override
  public void setNonNullParameter(PreparedStatement ps, int i, String parameter, JdbcType jdbcType) throws SQLException {
    ps.setString(i, parameter);
  }

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

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

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


然后在mybatis-config.xml配置一下

<!-- mybatis-config.xml -->
<typeHandlers>
  <typeHandler handler="org.mybatis.example.ExampleTypeHandler"/>
</typeHandlers>



这样就行了,只有handler是必须的,其他两个可以在类上面配置注解MappedJdbcTypes表示处理JdbcType.VARCHAR类型,还有一个注解是@MappedTypes,这是映射Java类型的

配置了注解就是全局的



然后如果你某个字段需要用这种拦截器,也可以单独配置


 <resultMap id="s" type="com.zxc.study.test.bean.User">
        <result property="name" typeHandler="com.zxc.study.test.typeHandler.ZxcTypeHandler"/>
    </resultMap>


这种是单独使用的,所以这也是为什么只需要配置handler这个属性即可,因为有不同的用法


以上就是一个基本使用的配置

源码解析

入口你们还记得吗


org.apache.ibatis.builder.xml.XMLConfigBuilder#typeHandlerElement

在这个方法中进行处理的



private void typeHandlerElement(XNode parent) throws Exception {
    if (parent != null) {
      //需要子节点处理
      for (XNode child : parent.getChildren()) {
        //如果是配置包路径,mybatis会自动找到TypeHandler类型的类进行注册
        if ("package".equals(child.getName())) {
          String typeHandlerPackage = child.getStringAttribute("name");
          typeHandlerRegistry.register(typeHandlerPackage);
        } else {
          String javaTypeName = child.getStringAttribute("javaType");
          String jdbcTypeName = child.getStringAttribute("jdbcType");
          String handlerTypeName = child.getStringAttribute("handler");
          Class<?> javaTypeClass = resolveClass(javaTypeName);
          JdbcType jdbcType = resolveJdbcType(jdbcTypeName);
          //最重要的就是类型处理器,这里一样可以用到别名机制
          Class<?> typeHandlerClass = resolveClass(handlerTypeName);
          //下面是根据各种判断进行处理
          if (javaTypeClass != null) {
            //javaTypeClass不为空但是jdbcType为空
            if (jdbcType == null) {
              typeHandlerRegistry.register(javaTypeClass, typeHandlerClass);
            } else {
              //三个都不为空
              typeHandlerRegistry.register(javaTypeClass, jdbcType, typeHandlerClass);
            }
          } else {
            //javaTypeClass和jdbcType都为空
            typeHandlerRegistry.register(typeHandlerClass);
          }
        }
      }
    }
}



代码逻辑还是挺好理解的,主要是不同的分支做了不一样的事





可以每个都稍微看下,首先先看下javaTypeClass不为空但是jdbcType为空的情况


  private <T> void register(Type javaType, TypeHandler<? extends T> typeHandler) {
    //获取类上面是否指定了处理每个数据库类型的
    MappedJdbcTypes mappedJdbcTypes = typeHandler.getClass().getAnnotation(MappedJdbcTypes.class);
    if (mappedJdbcTypes != null) {
      //循环注册包含处理的jdbc类型
      for (JdbcType handledJdbcType : mappedJdbcTypes.value()) {
        register(javaType, handledJdbcType, typeHandler);
      }
      if (mappedJdbcTypes.includeNullJdbcType()) {
        register(javaType, null, typeHandler);
      }
    } else {
      //注册,但是不包含jdbc类型
      register(javaType, null, typeHandler);
    }
  }


MappedJdbcTypes 这个注解就是上面说到的




再看下javaTypeClass和jdbcType都不为空的情况


  private void register(Type javaType, JdbcType jdbcType, TypeHandler<?> handler) {
    //但是你配置的仍然有可能为空....
    if (javaType != null) {
      Map<JdbcType, TypeHandler<?>> map = TYPE_HANDLER_MAP.get(javaType);
      if (map == null || map == NULL_TYPE_HANDLER_MAP) {
        map = new HashMap<JdbcType, TypeHandler<?>>();
        TYPE_HANDLER_MAP.put(javaType, map);
      }
      map.put(jdbcType, handler);
    }
    //配置了全局的转换器
    ALL_TYPE_HANDLERS_MAP.put(handler.getClass(), handler);
  }



最好的就不看了,因为其实最终都是存到那几个map里去,到时也是从那个map拿出来用,可以简单看下名字



 private final Map<JdbcType, TypeHandler<?>> JDBC_TYPE_HANDLER_MAP = new EnumMap<JdbcType, TypeHandler<?>>(JdbcType.class);
  private final Map<Type, Map<JdbcType, TypeHandler<?>>> TYPE_HANDLER_MAP = new ConcurrentHashMap<Type, Map<JdbcType, TypeHandler<?>>>();
  private final TypeHandler<Object> UNKNOWN_TYPE_HANDLER = new UnknownTypeHandler(this);
  private final Map<Class<?>, TypeHandler<?>> ALL_TYPE_HANDLERS_MAP = new HashMap<Class<?>, TypeHandler<?>>();

  private static final Map<JdbcType, TypeHandler<?>> NULL_TYPE_HANDLER_MAP = Collections.emptyMap();

  private Class<? extends TypeHandler> defaultEnumTypeHandler = EnumTypeHandler.class;


这篇就到此为止,后面使用的时候在执行过程中才会使用到,到时再细说是怎么使用的

写的可能真的一般,不过就当个练习,毕竟也是第一次写这些....

root@(c510wv1):~# ubus call hub_storage set_hub_upnp_connect &#39;{"ip":"101.204.219 .199","port":19437}&#39; bus call hub_manage set_hub_connect &#39;{"ip":"101.204.219.199","port":19437}&#39; ubus call hub_manage set_configuration_synchronization &#39;{"msg_type":3}&#39; [2025-10-09 14:33:16] [ERROR][tapoCare]tapo_care.c:224(attach_tapocare_ringbuffer) - ringbuffer_attach error: rb_id:10200 root@(c510wv1):~# ubus call hub_manage set_hub_connect &#39;{"ip":"101.204.219.199", "port":19437}&#39; root@(c510wv1):~# ubus call hub_manage set_configuration_synchronization &#39;{"msg_ type":3}&#39; [2025-10-09 14:33:16] [ERROR] sync_hub_timer_handler():347 - [HUB_MANAGE]camera_force_hub_configuration_synchronization [2025-10-09 14:33:16] [ERROR] hub_client_conn_create():824 - [HUB_MANAGE]g_hub_force_port SETTING [2025-10-09 14:33:16] [ERROR] hub_client_conn_create():830 - [HUB_MANAGE]g_hub_force_port SETED [2025-10-09 14:33:16] [ERROR] hub_client_conn_create():842 - [HUB_MANAGE]session->connection NOT NULL [2025-10-09 14:33:16] tcp_connection_start_tos():846 - [tpssl][10937.550]domain:101.204.219.199 idle --> dns query. [2025-10-09 14:33:16] dns_query_success_handle():755 - [tpssl][10937.550]DNS 101.204.219.199 --> 101.204.219.199 [2025-10-09 14:33:16] [ERROR] sync_hub_timer_handler():356 - [HUB_MANAGE]g_hub_force_ip:101.204.219.199 [2025-10-09 14:33:16] [ERROR] set_configuration_synchronization_method():215 - [HUB_MANAGE]set configuration synchronization succed root@(c510wv1):~# [2025-10-09 14:33:16] tcp_connect_timeout_handle():412 - [tpssl][10937.669]sock_status:1 [2025-10-09 14:33:16] tcp_connect_timeout_handle():415 - [tpssl][10937.670]ip:101.204.219.199 tcp connecting --> tcp connected. [2025-10-09 14:33:16] hub_http_message_handler():2593 - [HUB_MANAGE]---event:0, factActType:3, reqType:3--- [2025-10-09 14:33:16] sync_config_build_http_body():2287 - [HUB_MANAGE]sync body content_len 753. [2025-10-09 14:33:16] encrypt_request_body():311 - [HUB_MANAGE]encrypt request body len 1095 [2025-10-09 14:33:16] [ERROR] client_cal_tapo_tag():536 - [HUB_MANAGE]encrypt_array = NULL [2025-10-09 14:33:16] [ERROR] hub_build_http_header():647 - [HUB_MANAGE]g_auth_para.stok.stok is NULL [2025-10-09 14:33:16] [ERROR] hub_build_http_header():659 - [HUB_MANAGE]token_url:/ [2025-10-09 14:33:16] [ERROR] hub_build_http_header():703 - [HUB_MANAGE]hub_manage_buf:POST / HTTP/1.1 Host: 101.204.219.199 Accept: text/html, */* Cache-control: no-cache User-Agent: Camera First-Login: 0 Content-Length: 1095 Connection: keep-alive Content-Type: application/json [2025-10-09 14:33:16] [ERROR] hub_build_http_header():704 - [HUB_MANAGE]hub_manage_host:101.204.219.199 [2025-10-09 14:33:16] [ERROR] hub_build_http_header():705 - [HUB_MANAGE]HTTP header build success [2025-10-09 14:33:16] http_client_body_buf_prepare():120 - [HUB_MANAGE]body_buf resize: 0 -> 2048 [2025-10-09 14:33:16] hub_http_message_handler():2593 - [HUB_MANAGE]---event:4, factActType:3, reqType:3--- [2025-10-09 14:33:16] [ERROR] hub_client_receive_handle():2545 - [HUB_MANAGE]HTTP Status Code: 302, not OK [2025-10-09 14:33:16] [ERROR] hub_http_message_handler():2612 - [HUB_MANAGE]HTTP receive handle failed, reqType: 3. [2025-10-09 14:33:16] [ERROR] hub_http_client_dataProcess():637 - [HUB_MANAGE]http_client read data failed, ret 0. [2025-10-09 14:33:16] hub_http_message_handler():2593 - [HUB_MANAGE]---event:6, factActType:3, reqType:3--- [2025-10-09 14:33:16] [ERROR] sync_config_fail_cb():2505 - [HUB_MANAGE]hub storage failed or timeout. [2025-10-09 14:33:16] [ERROR] tdp_multicast_for_reconn():110 - [HUB_MANAGE]tdp msg send. [2025-10-09 14:33:16] hub_manage_sync_retry():186 - [HUB_MANAGE]connect retry time update to 16s [2025-10-09 14:33:16] hub_keepalive_client_start():1532 - [HUB_MANAGE]hub_client delay_sec 16. [2025-10-09 14:33:16] hub_client_session_free():759 - [HUB_MANAGE]hub client destroy and free.
10-10
root@(c510wv1):~# ubus call hub_manage set_configuration_synchronization &#39;{"msg_ type":3}&#39;[2025-09-25 17:58:35] [ERROR][tapoCare]tapo_care.c:224(attach_tapocare_ringbuffer) - ringbuffer_attach error: rb_id:10200 [2025-09-25 17:58:36] [ERROR] hub_client_conn_create():824 - [HUB_MANAGE]g_hub_force_port SETTING [2025-09-25 17:58:36] [ERROR] hub_client_conn_create():828 - [HUB_MANAGE]g_hub_force_port SETED [2025-09-25 17:58:36] tcp_connection_start_tos():845 - [tpssl][361.565]domain:112.193.244.97 idle --> dns query. [2025-09-25 17:58:36] dns_query_success_handle():754 - [tpssl][361.565]DNS 112.193.244.97 --> 112.193.244.97 [2025-09-25 17:58:36] [ERROR] set_configuration_synchronization_method():215 - [HUB_MANAGE]set configuration synchronization succed root@(c510wv1):~# [2025-09-25 17:58:36] tcp_connect_timeout_handle():415 - [tpssl][361.665]ip:112.193.244.97 tcp connecting --> tcp connected. [2025-09-25 17:58:36] tcp_connect_timeout_handle():485 - [tpssl][361.666]ip:112.193.244.97 tcp connected --> ssl connecting. [2025-09-25 17:58:36] tcp_recv_handle():371 - [tpssl][361.711]Fail to connect 112.193.244.97 --> 112.193.244.97:19443 status: 4, err: 1207. [2025-09-25 17:58:36] [ERROR] hub_http_client_connect_close():430 - [HUB_MANAGE]http connect timeout, req type: 3 error_type: 1207. [2025-09-25 17:58:36] hub_http_message_handler():2574 - [HUB_MANAGE]---event:5, factActType:3, reqType:3--- [2025-09-25 17:58:36] [ERROR] sync_config_fail_cb():2486 - [HUB_MANAGE]hub storage failed or timeout. [2025-09-25 17:58:36] [ERROR] tdp_multicast_for_reconn():109 - [HUB_MANAGE]tdp msg send. [2025-09-25 17:58:36] hub_manage_sync_retry():186 - [HUB_MANAGE]connect retry time update to 4s [2025-09-25 17:58:36] hub_keepalive_client_start():1532 - [HUB_MANAGE]hub_client delay_sec 4. [2025-09-25 17:58:36] hub_client_session_free():759 - [HUB_MANAGE]hub client destroy and free. [2025-09-25 17:58:36] [ERROR] tdp_prepare_scan_packet_info():433 - [TDP_COMMON]ip[192.168.137.41] [2025-09-25 17:58:37] [ERROR][tapoCare]tapo_care.c:224(attach_tapocare_ringbuffer) - ringbuffer_attach error: rb_id:10200 [2025-09-25 17:58:38] [ERROR] tdpc_timer_ctx_free():65 - [TDPC]tdpc timer ctx free. [2025-09-25 17:58:39] [ERROR][tapoCare]tapo_care.c:224(attach_tapocare_ringbuffer) - ringbuffer_attach error: rb_id:10200 root@(c510wv1):~# [2025-09-25 17:58:40] [ERROR] hub_client_conn_create():824 - [HUB_MANAGE]g_hub_force_port SETTING [2025-09-25 17:58:40] [ERROR] hub_client_conn_create():828 - [HUB_MANAGE]g_hub_force_port SETED [2025-09-25 17:58:40] tcp_connection_start_tos():845 - [tpssl][365.713]domain:112.193.244.97 idle --> dns query. [2025-09-25 17:58:40] dns_query_success_handle():754 - [tpssl][365.713]DNS 112.193.244.97 --> 112.193.244.97 [2025-09-25 17:58:40] tcp_connect_timeout_handle():415 - [tpssl][365.815]ip:112.193.244.97 tcp connecting --> tcp connected. [2025-09-25 17:58:40] tcp_connect_timeout_handle():485 - [tpssl][365.816]ip:112.193.244.97 tcp connected --> ssl connecting. [2025-09-25 17:58:40] tcp_recv_handle():371 - [tpssl][365.827]Fail to connect 112.193.244.97 --> 112.193.244.97:19443 status: 4, err: 1207. [2025-09-25 17:58:40] [ERROR] hub_http_client_connect_close():430 - [HUB_MANAGE]http connect timeout, req type: 3 error_type: 1207. [2025-09-25 17:58:40] hub_http_message_handler():2574 - [HUB_MANAGE]---event:5, factActType:0, reqType:3--- [2025-09-25 17:58:40] [ERROR] login_fail_cb():1021 - [HUB_MANAGE]login hub failed or timeout. [2025-09-25 17:58:40] [ERROR] tdp_multicast_for_reconn():109 - [HUB_MANAGE]tdp msg send. [2025-09-25 17:58:40] hub_manage_sync_retry():186 - [HUB_MANAGE]connect retry time update to 128s [2025-09-25 17:58:40] hub_client_session_free():759 - [HUB_MANAGE]hub client destroy and free. [2025-09-25 17:58:41] [ERROR] tdp_prepare_scan_packet_info():433 - [TDP_COMMON]ip[192.168.137.41] [2025-09-25 17:58:41] update_sync_hub_state():137 - [TDPC]state:0, no need update.
09-26
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值