Mybatis 探究之 执行器、二级缓存

CachingExecutor

测试程序

    /**
     * 测试二级缓存
     * <p>
     * doQuery(MappedStatement ms, Object parameter, RowBounds rowBounds, ResultHandler resultHandler, BoundSql boundSql)
     */
    @Test
    public void CachingExecutor() throws SQLException {
        Executor cachingExecutor = new CachingExecutor(new SimpleExecutor(configuration, transaction));
        MappedStatement ms = configuration.getMappedStatement(MybatisContact.SELECT);
        cachingExecutor.query(ms, "batchExecutor", MybatisContact.DEFAULT, MybatisContact.NO_RESULT_HANDLER);
        /**
         * 先走二级
         */
        cachingExecutor.commit(true);
        cachingExecutor.query(ms, "batchExecutor", MybatisContact.DEFAULT, MybatisContact.NO_RESULT_HANDLER);
        cachingExecutor.query(ms, "batchExecutor", MybatisContact.DEFAULT, MybatisContact.NO_RESULT_HANDLER);
    }

测试结果

Cache Hit Ratio [com.cuiyt.mapper.UserMapper]: 0.0
==>  Preparing: select * from user where name = ? 
==> Parameters: batchExecutor(String)
<==    Columns: id, name, pwd, type
<==        Row: 42, batchExecutor, batchExecutor, 1
<==      Total: 1
Cache Hit Ratio [com.cuiyt.mapper.UserMapper]: 0.5
Cache Hit Ratio [com.cuiyt.mapper.UserMapper]: 0.6666666666666666

CachingExecutor类信息

CachingExecutor

可以看到的是这个类中使用组合形式封装了一个执行器，以及事务管理器。 由于它是Executor的子类，所以也具有 Executor对应的方法， 来处理事务、查询、更新、缓存等。

public class CachingExecutor implements Executor {
    // 内部组合的形式封装了一个执行器
  private final Executor delegate;
  private final TransactionalCacheManager tcm = new TransactionalCacheManager();

  public CachingExecutor(Executor delegate) {
    this.delegate = delegate;
    delegate.setExecutorWrapper(this);
  }
}

这里是引用

查询方法

  @Override
  public <E> List<E> query(MappedStatement ms, Object parameterObject, RowBounds rowBounds, ResultHandler resultHandler) throws SQLException {
    BoundSql boundSql = ms.getBoundSql(parameterObject);
    CacheKey key = createCacheKey(ms, parameterObject, rowBounds, boundSql);
    return query(ms, parameterObject, rowBounds, resultHandler, key, boundSql);
  }

创建缓存的key

  @Override
  public CacheKey createCacheKey(MappedStatement ms, Object parameterObject, RowBounds rowBounds, BoundSql boundSql) {
    return delegate.createCacheKey(ms, parameterObject, rowBounds, boundSql);
  }

具体干活的方法

  @Override
  public <E> List<E> query(MappedStatement ms, Object parameterObject, RowBounds rowBounds, ResultHandler resultHandler, CacheKey key, BoundSql boundSql)
      throws SQLException {
      // 从MapperStatemenst中得到缓存， 可能mapper中没有设置启用缓存
      // 由此也可以看到 二级缓存是mapper级别的
    Cache cache = ms.getCache();
    if (cache != null) {
        // 如果需要的话刷新缓存
      flushCacheIfRequired(ms);
        // 可以用二级缓存， 并且用结果处理器
      if (ms.isUseCache() && resultHandler == null) {
        ensureNoOutParams(ms, boundSql);
        @SuppressWarnings("unchecked")
          // 从缓存中拿数据
        List<E> list = (List<E>) tcm.getObject(cache, key);
        if (list == null) {
                 // 没有缓存， 就使用内部的执行器的查询
                // 此时将会走分析一级缓存时候的那一套流程。
          list = delegate.<E> query(ms, parameterObject, rowBounds, resultHandler, key, boundSql);
          tcm.putObject(cache, key, list); // issue #578 and #116
        }
        return list;
      }
    }
      // 没有启用缓存， 就使用内部的执行器的查询
      // 此时将会走分析一级缓存时候的那一套流程。
    return delegate.<E> query(ms, parameterObject, rowBounds, resultHandler, key, boundSql);
  }