【Mybatis】三大组件之Executor，以及一级二级缓存分析

mybatis的sql执行过程中，涉及到三大组件：Executor，StatementHandler，ResultSetHandler。
本章主要分析Executor。

基类org.apache.ibatis.executor.BaseExecutor

修改方法

  @Override
  public int update(MappedStatement ms, Object parameter) throws SQLException {
   
    ErrorContext.instance().resource(ms.getResource()).activity("executing an update").object(ms.getId());
    if (closed) {
   
      throw new ExecutorException("Executor was closed.");
    }
    // 修改前会清空一级缓存
    clearLocalCache();
    // 子类实现修改逻辑
    return doUpdate(ms, parameter);
  }

更新方法会清空所有缓存。

查询方法

  public <E> List<E> query(MappedStatement ms, Object parameter, RowBounds rowBounds, ResultHandler resultHandler) throws SQLException {
   
  	// 解析sql，参数，判断是否拼接；解析出paramtermapping；即#{}
    BoundSql boundSql = ms.getBoundSql(parameter);
    // 创建缓存key；
    CacheKey key = createCacheKey(ms, parameter, rowBounds, boundSql);
    return query(ms, parameter, rowBounds, resultHandler, key, boundSql);
 }
	
	// 缓存key
  public CacheKey createCacheKey(MappedStatement ms, Object parameterObject, RowBounds rowBounds, BoundSql boundSql) {
   
    if (closed) {
   
      throw new ExecutorException("Executor was closed.");
    }
    CacheKey cacheKey = new CacheKey();
    // 涉及的参数有id,偏移量，取值个数，sql,参数，环境id
    cacheKey.update(ms.getId());
    cacheKey.update(rowBounds.getOffset());
    cacheKey.update(rowBounds.getLimit());
    cacheKey.update(boundSql.getSql());
    List<ParameterMapping> parameterMappings = boundSql.getParameterMappings();
    TypeHandlerRegistry typeHandlerRegistry = ms.getConfiguration().getTypeHandlerRegistry();
    // mimic DefaultParameterHandler logic
    for (ParameterMapping parameterMapping : parameterMappings) {
   
      if (parameterMapping.getMode() != ParameterMode.OUT) {
   
        Object value;
        String propertyName = parameterMapping.getProperty();
        if (boundSql.hasAdditionalParameter(propertyName)) {
   
          value = boundSql.getAdditionalParameter(propertyName);
        } else if (parameterObject == null) {
   
          value = null;
        } else if (typeHandlerRegistry.hasTypeHandler(parameterObject.getClass())) {
   
          value = parameterObject;
        } else {
   
          MetaObject metaObject = configuration.newMetaObject(parameterObject);
          value = metaObject.getValue(propertyName);
        }
        cacheKey.update(value);
      }
    }
    if (configuration.getEnvironment() != null) {
   
      // issue #176
      cacheKey.update(configuration.getEnvironment().getId());
    }
    return cacheKey;
  }

  public <E> List<E> query(MappedStatement ms, Object parameter, RowBounds rowBounds, ResultHandler resultHandler, CacheKey key, BoundSql boundSql) throws SQLException {
   
    ErrorContext.instance().resource(ms.getResource()).activity("executing a query").object(ms.getId());
    if (closed) {
   
      throw new ExecutorException("Executor was closed.");
    }
    // 如果设置了flushcache参数，就会前清空缓存，再查询。
    if (queryStack == 0 && ms.isFlushCacheRequired()) {
   
      clearLocalCache();
    }
    List<E> list;
    try {
   
    	// 先从缓存找。
      queryStack++;
      list = resultHandler == null ? (List<E>) localCache.getObject(key) : null;
      if (list != null) {
   
        handleLocallyCachedOutputParameters(ms, key, parameter, boundSql);
      } else {
   
      // 如果没有才会真正的取查询
        list = queryFromDatabase(ms, parameter, rowBounds, resultHandler, key, boundSql);
      }
    } finally {
   
      queryStack--;
    }
    if (queryStack == 0) {
   
      for (DeferredLoad deferredLoad : deferredLoads) {
   
        deferredLoad.load();
      }
      // issue #601
      deferredLoads.clear();
      // 如果全局配置了STATEMENT，会清空缓存，默认是Session.
      if (configuration.getLocalCacheScope() == LocalCacheScope.STATEMENT) {
   
        // issue #482
        clearLocalCache();