mybatis cache 导致 密码重复解密，报错

Error while decrypting: str=123456

// 123456 是明文密码

@Transactional(rollbackFor = Exception.class, transactionManager = JpaConfig.TRANSACTION_MANAGER)
public void sureConfirmation(...) {
  meetingRepo.saveMeetingBrandActionLog(logs)

}

public void saveMeetingBrandActionLog(logs) { logs.forEach(this::saveMeetingBrandActionLog); }

public void saveMeetingBrandActionLog(log) { 
  // queryInfo 里面会
  // - 1. 去 db 查询 info
  // - 2. 解密 密码
  // 这里执行多次的话，只有第一次会成功，第二次开始，就把明文密码传入 解密方法了。
  BizBrandOperateInfo operateInfo = bizBrandOperateInfoService.queryInfo( 
    BizSourceEnum.fpo, 
    log.getBizBrandId()
  );

// org.apache.ibatis.binding.MapperProxy#invoke
@Override
public Object invoke(Object proxy, Method method, Object[] args) throws Throwable {
  try {
  // todo，这是啥
    if (Object.class.equals(method.getDeclaringClass())) {
      return method.invoke(this, args);
    } else {
      // here !!
      return cachedInvoker(method).invoke(proxy, method, args, sqlSession);
    }
  } catch (Throwable t) {
    throw ExceptionUtil.unwrapThrowable(t);
  }
}

// org.mybatis.spring.SqlSessionTemplate.SqlSessionInterceptor#invoke
private class SqlSessionInterceptor implements InvocationHandler {
  @Override
  public Object invoke(Object proxy, Method method, Object[] args) throws Throwable {
    SqlSession sqlSession = getSqlSession(SqlSessionTemplate.this.sqlSessionFactory,
        SqlSessionTemplate.this.executorType, SqlSessionTemplate.this.exceptionTranslator);
    try {
      Object result = method.invoke(sqlSession, args);
      if (!isSqlSessionTransactional(sqlSession, SqlSessionTemplate.this.sqlSessionFactory)) {
        // force commit even on non-dirty sessions because some databases require
        // a commit/rollback before calling close()
        sqlSession.commit(true);
      }
      return result;

{mappedStatement.id}

// 没有带参数，所有多个同名方法，这里是相同的，
// 那么后面 sql 也可能相同，参数数量也可能相同，
// 然后，再全部传 null。忽略类型的话，两个查询的 cacheKey 貌似就是一样的了。
// 1. todo 再看下这里面几个数字参数的定义。
// 2. 两个不同地方的完全相同的查询，返回相同的结果，也是正常的。
:{原始方法名} 

:{rowBounds.offset}:{rowBounds.limit}
:{boundSql.sql}  // 完整的 sql
:{所有 param value 的拼接}

@Override
public CacheKey createCacheKey(MappedStatement ms, Object parameterObject, RowBounds rowBounds, BoundSql boundSql) {
  if (closed) {
    throw new ExecutorException("Executor was closed.");
  }
  CacheKey cacheKey = new CacheKey();
  cacheKey.update(ms.getId());
  cacheKey.update(rowBounds.getOffset());
  cacheKey.update(rowBounds.getLimit());
  cacheKey.update(boundSql.getSql());
  
  
  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);
  }
}
  
  
  cacheKey 内容：

733920730:-108631220:com.kezaihui.smart.biz.task.dao.BizBrandOperateInfoDao.findByBizBrandId:0:2147483647:select
         
        `id`,
        `source`,
        `biz_brand_id`,
        `biz_brand_name`,
        `biz_brand_alias`,
        `start_date`,
        `expire_date`,
        `expire_type`,
        `shop_count`,
        `create_time`,
        `update_time`,
        `delete_time`,

        `kai_dian_bao_account`,
        `kai_dian_bao_pwd`,
        `kai_dian_bao_info`,
        `category`,
        `budget`,
        `expect`,
        `now_urgent`
     
        from biz_brand_operate_info
        where `source` = ? and biz_brand_id = ?
         
        and delete_time = '1970-01-01 00:00:00':fpo:39365

public Executor newExecutor(Transaction transaction, ExecutorType executorType) {
  executorType = executorType == null ? defaultExecutorType : executorType;
  executorType = executorType == null ? ExecutorType.SIMPLE : executorType;
  Executor executor;
  if (ExecutorType.BATCH == executorType) {
    executor = new BatchExecutor(this, transaction);
  } else if (ExecutorType.REUSE == executorType) {
    executor = new ReuseExecutor(this, transaction);
  } else {
    executor = new SimpleExecutor(this, transaction);
  }
  if (cacheEnabled) { 
    executor = new CachingExecutor(executor);
  }
  // 这里，pagehelper interceptor 注册上去了。
  executor = (Executor) interceptorChain.pluginAll(executor);
  return executor;
}

// 每次查询结束后，
// 默认 put 缓存。

// 如果 配置了 localCacheScope = statement 的话，
// 再去 clear cache？？？
if (configuration.getLocalCacheScope() == LocalCacheScope.STATEMENT) {
  // issue #482
  clearLocalCache();
}

@Override
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.");
  }
  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();
    if (configuration.getLocalCacheScope() == LocalCacheScope.STATEMENT) {
      // ##### 2. clear cache
      // issue #482
      clearLocalCache();
    }
  }
  return list;
}

// before
flushLocalCacheAfterEachStatement=false|true
// after
localCacheScope=session|statement

// before
configuration.setClearLocalCacheAfterEachStatement(booleanValueOf(props.getProperty("flushLocalCacheAfterEachStatement"), false));
// after
configuration.setLocalCacheScope(LocalCacheScope.valueOf(stringValueOf(props.getProperty("localCacheScope"), "SESSION")));

// 默认值是 session
<setting name="localCacheScope" value="STATEMENT"/>