mybatis的缓存

一级缓存

在执行器executor的查询方法中

 
@Override
public <E> List<E> query(MappedStatement ms, Object parameter, RowBounds
	rowBounds, ResultHandler resultHandler) throws SQLException {
	BoundSql boundSql = ms.getBoundSql(parameter);
	// 根据参数生成一个缓存的key
	CacheKey key = createCacheKey(ms, parameter, rowBounds, boundSql); 
	return query(ms, parameter, rowBounds, resultHandler, key, boundSql);
}

@SuppressWarnings("unchecked")
@Override
public <E> List<E> query(MappedStatement ms, Object parameter, RowBounds rowBounds, ResultHandler resultHandler, CacheKey key, BoundSql boundSql) throws SQLException {
	···
	//从缓存娶
	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);
	}
	···
}
private <E> List<E> queryFromDatabase(MappedStatement ms, Object parameter, RowBounds rowBounds, ResultHandler resultHandler, CacheKey key, BoundSql boundSql) throws SQLException {
	List<E> list;
	//在这里放一个占位符，当其他相同的sql进来的时候查询这个key发现它被占了，就不会去查询数据库，等着从缓存里面去取
	localCache.putObject(key, EXECUTION_PLACEHOLDER);
	 try {
		list = doQuery(ms, parameter, rowBounds, resultHandler, boundSql);
	 } finally {
	 	//容错移除key
		localCache.removeObject(key); 
	}
		//扔进缓存
		localCache.putObject(key, list);
		//存储过程缓存处理
		if (ms.getStatementType() == StatementType.CALLABLE) {
			localOutputParameterCache.putObject(key, parameter); 
		}
	  return list;
}

二级缓存

二级缓存的原理和一级缓存原理一样，第一次查询，会将数据放入缓存中，然后第二次查询则会直接去缓存中取。但是一级缓存是基于sqlSession的，而二级缓存是基于mapper文件的namespace的，也就是说多个sqlSession可以共享一个mapper中的二级缓存区域，并且如果两个mapper的namespace相同，即使是两个mapper,那么这两个mapper中执行sq|查询到的数据也将存在相同的二级缓存区域中

开启二级缓存

//springmvc中全局配置sqlmapconfig.xml加入
<settings>
	<setting name="cacheEnabled" value="true"/> 
</settings>

//在要开启的mapper.xml中加入
<cache></cache>

perpetualcache是二级mybatis默认实现缓存功能的类，这里的二级缓存默认也使用这个类

开启缓存后，缓存的pojo需要实现serializable接口

 //开启二级缓存后不使用二级缓存时
<select id="selectUserByUserId" useCache="false" resultType="com.pojo.User" parameterType="int">
	select * from user where id=#{id}
</select>

在同一个namespace中有insert、update、delete时可以使用flushCache="true"来刷新缓存

二级缓存生效：在CachingExecutor中看查询方法

@Override
  public <E> List<E> query(MappedStatement ms, Object parameterObject, RowBounds rowBounds, ResultHandler resultHandler, CacheKey key, BoundSql boundSql)
      throws SQLException {
     //在这里去mappedstatement中去拿cache的实现类，默认perpetualcache
    Cache cache = ms.getCache();
    //如果它启用二级缓存
    if (cache != null) {
      flushCacheIfRequired(ms);
      if (ms.isUseCache() && resultHandler == null) {
        ensureNoOutParams(ms, parameterObject, boundSql);
        //这里去二级缓存里面拿数据 tcm是TransactionalCacheManager，它的getobject方法会去这个MappedStatement使用的cache中取值
        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); 
        }
        return list;
      }
    }
    return delegate.<E> query(ms, parameterObject, rowBounds, resultHandler, key, boundSql);
  }

使用redis作为二级缓存

 
<dependency> 
	<groupId>org.mybatis.caches</groupId>
	<artifactId>mybatis-redis</artifactId>
	<version>1.0.0-beta2</version>
</dependency>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
	<mapper namespace="com.mapper.IUserMapper">
	<cache type="org.mybatis.caches.redis.RedisCache" />
	<select id="findAll" resultType="com.pojo.User" useCache="true"> 
		select * from user
	</select>