MyBatis Plus插件机制与执行流程原理分析

布满荆棘的人生 2022-12-04 08:38 422阅读 0赞

# 【1】MyBatis Plus插件 #

MyBatis Plus提供了`分页插件PaginationInterceptor`、`执行分析插件SqlExplainInterceptor`、`性能分析插件PerformanceInterceptor`以及`乐观锁插件OptimisticLockerInterceptor`。

Mybatis 通过插件 (Interceptor) 可以做到`拦截四大对象相关方法`的执行 ,根据需求完成相关数据的动态改变。注意，这句话是核心哦。

## **四大对象** ##

*  Executor
 *  StatementHandler
 *  ParameterHandler
 *  ResultSetHandler

四大对象的每个对象在创建时，都会执行`interceptorChain.pluginAll()`，会经过每个插件对象的 `plugin()`方法，目的是为`当前的四大对象创建代理`。代理对象就可以拦截到四大对象相关方法的执行，因为要执行四大对象的方法需要经过代理 。

**四大插件对各自感兴趣的对象、方法、参数如下**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center]

## ① xml下插件的配置 ##

如下所示：

## ② springboot下注册插件 ##

这里以分页插件为例：

@Bean
     public PaginationInterceptor paginationInterceptor() {
         PaginationInterceptor paginationInterceptor = new PaginationInterceptor();
         // 设置请求的页面大于最大页后操作， true调回到首页，false 继续请求  默认false
         // paginationInterceptor.setOverflow(false);
         // 设置最大单页限制数量，默认 500 条，-1 不受限制
         // paginationInterceptor.setLimit(500);
         // 开启 count 的 join 优化,只针对部分 left join
         paginationInterceptor.setCountSqlParser(new JsqlParserCountOptimize(true));
         return paginationInterceptor;
     }

## ③ SqlExplainInterceptor ##

SQL执行分析拦截器，全类名是`com.baomidou.mybatisplus.plugins.SqlExplainInterceptor`，只支持 MySQL5.6.3以上版本。

该插件的作用是分析 `DELETE UPDATE`语句 ,防止小白或者恶意进行`DELETE UPDATE`全表操作，不建议在生产环境中使用会造成性能下降，

在插件的底层通过SQL语句分析命令 `Explain` 分析当前的 SQL语句，根据结果集中的 `Extra`列来断定当前是否全表操作。

## ④ 性能分析插件 ##

性能分析拦截器，全类名是`com.baomidou.mybatisplus.plugins.PerformanceInterceptor`，用于输出每条 SQL 语句及其执行时间。SQL性能执行分析 ,开发环境使用 超过指定时间，停止运行。

## ⑤ 乐观锁插件 ##

全类名是`com.baomidou.mybatisplus.plugins.OptimisticLockerInterceptor`。如果想实现如下需求 : 当要更新一条记录的时候，希望这条记录没有被别人更新，就可以使用该插件进行判断。

**乐观锁的实现原理(@Version 用于注解实体字段，必须要有) :**

*  取出记录时，获取当前 version
 *  更新时，带上这个version
 *  执行更新时，set version = yourVersion+1 where version = yourVersion
 *  如果 version不对，就更新失败

## ⑥ InterceptorChain ##

拦截器链，内部维护了一个私有常量`List<Interceptor> interceptors`，其pluginAll方法为遍历interceptors并调用每个拦截器的plugin方法。

public class InterceptorChain {
    
      private final List<Interceptor> interceptors = new ArrayList<Interceptor>();
    
      public Object pluginAll(Object target) {
        for (Interceptor interceptor : interceptors) {
          target = interceptor.plugin(target);
        }
        return target;
      }
    //添加拦截器到链表中
      public void addInterceptor(Interceptor interceptor) {
        interceptors.add(interceptor);
      }
      //获取链表中的拦截器
      public List<Interceptor> getInterceptors() {
        return Collections.unmodifiableList(interceptors);
      }
    }

在创建SqlSessionFactory会把MybatisSqlSessionFactoryBean.plugins放到InterceptorChain.interceptors 中。

--------------------

# 【2】获取sqlSessionFactoryBean #

如下图所示，在系统启动时会初始化定义的bean。`DefaultListableBeanFactory.preInstantiateSingletons`方法中会从beanDefinitionNames中获取bean name然后依次创建。

这里可以看到RootBeanDefinition是`com.baomidou.mybatisplus.spring.MybatisSqlSessionFactoryBean`。  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 1]

## ① 获取bean的过程中bean属性 ##

如下所示，在getBean过程中可以看到bean的属性：

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 2]  
这里属性为plugins,会在bean的实例化时(populateBean)为属性赋值–也就是说会创建四个插件实例。

## ② createBean ##

第一次获取bean的时候会走到`AbstractAutowireCapableBeanFactory.createBean`进行bean的创建。

/**
     创建一个bean实例，为bean实例设置属性值，调用post-processors-bean后置处理器
     */
    @Override
    protected Object createBean(String beanName, RootBeanDefinition mbd, Object[] args) throws BeanCreationException {
    //...暂时忽略其他代码
    
    //这里会拿到bean的class类型
    Class<?> resolvedClass = resolveBeanClass(mbd, beanName);
    	try {
    // 这里会首先触发BeanPostProcessors ，如果这里能获取到bean则直接返回，不再走doCreateBean
    		Object bean = resolveBeforeInstantiation(beanName, mbdToUse);
    		if (bean != null) {
    			return bean;
    		}
    	}
    //...暂时忽略其他代码
    
    //如果上面没有获取到bean，则会走doCreateBean--这也是创建bean的核心过程
    	Object beanInstance = doCreateBean(beanName, mbdToUse, args);
    //...暂时忽略其他代码
    	return beanInstance;
    }

如下图所示此时sqlSessionFactoryBean拿到的class为  
`com.baomidou.mybatisplus.spring.MybatisSqlSessionFactoryBean`，不再是Mybatis自身的哦。![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 3]

在AbstractAutowireCapableBeanFactory.resolveBeforeInstantiation中就会分别执行bean后置处理器的前置和后置方法。

protected Object resolveBeforeInstantiation(String beanName, RootBeanDefinition mbd) {
    	Object bean = null;
    	if (!Boolean.FALSE.equals(mbd.beforeInstantiationResolved)) {
    		// Make sure bean class is actually resolved at this point.
    		if (!mbd.isSynthetic() && hasInstantiationAwareBeanPostProcessors()) {
    			Class<?> targetType = determineTargetType(beanName, mbd);
    			if (targetType != null) {
    				bean = applyBeanPostProcessorsBeforeInstantiation(targetType, beanName);
    				if (bean != null) {
    					bean = applyBeanPostProcessorsAfterInitialization(bean, beanName);
    				}
    			}
    		}
    		mbd.beforeInstantiationResolved = (bean != null);
    	}
    	return bean;
    }

执行后置处理器的前置方法如下所示：

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 4]

## ③ doCreateBean ##

AbstractAutowireCapableBeanFactory.doCreateBean是创建bean的核心方法，这会为`bean属性赋值并会触发bean后置处理器、InitializingBean以及自定init方法`等。

protected Object doCreateBean(final String beanName, final RootBeanDefinition mbd, final Object[] args)
    	throws BeanCreationException {
    
    // Instantiate the bean.--实例化bean
    BeanWrapper instanceWrapper = null;
    if (mbd.isSingleton()) {
    	instanceWrapper = this.factoryBeanInstanceCache.remove(beanName);
    }
    if (instanceWrapper == null) {
    //获取bean的包装对象-这里很重要
    	instanceWrapper = createBeanInstance(beanName, mbd, args);
    }
    final Object bean = (instanceWrapper != null ? instanceWrapper.getWrappedInstance() : null);
    Class<?> beanType = (instanceWrapper != null ? instanceWrapper.getWrappedClass() : null);
    mbd.resolvedTargetType = beanType;
    
    // Allow post-processors to modify the merged bean definition.
    synchronized (mbd.postProcessingLock) {
    	if (!mbd.postProcessed) {
    		try {
    //调用MergedBeanDefinitionPostProcessors的postProcessMergedBeanDefinition方法
    			applyMergedBeanDefinitionPostProcessors(mbd, beanType, beanName);
    		}
    		catch (Throwable ex) {
    			throw new BeanCreationException(mbd.getResourceDescription(), beanName,
    					"Post-processing of merged bean definition failed", ex);
    		}
    		mbd.postProcessed = true;
    	}
    }
    //...
    //这里暂时忽略其他代码
    
    // Initialize the bean instance.--初始化bean实例
    Object exposedObject = bean;
    try {
    //如下方法很重要
    	populateBean(beanName, mbd, instanceWrapper);
    	if (exposedObject != null) {
    	//这里会调用initializeBean方法
    		exposedObject = initializeBean(beanName, exposedObject, mbd);
    	}
    }
    //...
    
    // Register bean as disposable.
    try {
    	registerDisposableBeanIfNecessary(beanName, bean, mbd);
    }
    //...
    return exposedObject;
    }

## ④ populateBean ##

顾名思义，为bean实例属性赋值。

**AbstractAutowireCapableBeanFactory.populateBean**

protected void populateBean(String beanName, RootBeanDefinition mbd, BeanWrapper bw) {
    //获取属性值列表
    PropertyValues pvs = mbd.getPropertyValues();
    
    //...该种符号表示暂时忽略其他代码
    
    //在为bean属性赋值前，给InstantiationAwareBeanPostProcessors 机会修改bean的状态
    //应用场景如支持字段注入
    boolean continueWithPropertyPopulation = true;
    
    //循环调用InstantiationAwareBeanPostProcessors 的postProcessAfterInstantiation方法
    if (!mbd.isSynthetic() && hasInstantiationAwareBeanPostProcessors()) {
    	for (BeanPostProcessor bp : getBeanPostProcessors()) {
    		if (bp instanceof InstantiationAwareBeanPostProcessor) {
    			InstantiationAwareBeanPostProcessor ibp = (InstantiationAwareBeanPostProcessor) bp;
    			if (!ibp.postProcessAfterInstantiation(bw.getWrappedInstance(), beanName)) {
    				continueWithPropertyPopulation = false;
    				break;
    			}
    		}
    	}
    }
    
    if (!continueWithPropertyPopulation) {
    	return;
    }
    //解析autowire注解字段，进行主动注入
    if (mbd.getResolvedAutowireMode() == RootBeanDefinition.AUTOWIRE_BY_NAME ||
    		mbd.getResolvedAutowireMode() == RootBeanDefinition.AUTOWIRE_BY_TYPE) {
    	MutablePropertyValues newPvs = new MutablePropertyValues(pvs);
    
    	// Add property values based on autowire by name if applicable.
    	if (mbd.getResolvedAutowireMode() == RootBeanDefinition.AUTOWIRE_BY_NAME) {
    		autowireByName(beanName, mbd, bw, newPvs);
    	}
    
    	// Add property values based on autowire by type if applicable.
    	if (mbd.getResolvedAutowireMode() == RootBeanDefinition.AUTOWIRE_BY_TYPE) {
    		autowireByType(beanName, mbd, bw, newPvs);
    	}
    
    	pvs = newPvs;
    }
    
    boolean hasInstAwareBpps = hasInstantiationAwareBeanPostProcessors();
    boolean needsDepCheck = (mbd.getDependencyCheck() != RootBeanDefinition.DEPENDENCY_CHECK_NONE);
    
    //循环调用InstantiationAwareBeanPostProcessors 的postProcessPropertyValues方法
    if (hasInstAwareBpps || needsDepCheck) {
    	PropertyDescriptor[] filteredPds = filterPropertyDescriptorsForDependencyCheck(bw, mbd.allowCaching);
    	if (hasInstAwareBpps) {
    		for (BeanPostProcessor bp : getBeanPostProcessors()) {
    			if (bp instanceof InstantiationAwareBeanPostProcessor) {
    				InstantiationAwareBeanPostProcessor ibp = (InstantiationAwareBeanPostProcessor) bp;
    				pvs = ibp.postProcessPropertyValues(pvs, filteredPds, bw.getWrappedInstance(), beanName);
    				if (pvs == null) {
    					return;
    				}
    			}
    		}
    	}
    	if (needsDepCheck) {
    		checkDependencies(beanName, mbd, filteredPds, pvs);
    	}
    }
    //在这里为属性赋值，会进行类型转换，这里注意关键词deep copy
    //如果是引用类型且bean没有存在，则会进行bean的创建过程
    applyPropertyValues(beanName, mbd, bw, pvs);
    }

如下图所示在创建sqlSessionFactoryBean过程中会创建其属性globalConfiguration对象：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 5]  
如下图所示在创建sqlSessionFactoryBean过程中(从左侧的方法顺序就可以看出来)会创建其属性`PaginationInterceptor`对象：

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 6]  
如下图所示在创建sqlSessionFactoryBean过程中(从左侧的方法顺序就可以看出来)会创建其属性`SqlExplainInterceptor`对象：

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 7]  
如下图所示在创建sqlSessionFactoryBean过程中(从左侧的方法顺序就可以看出来)会创建其属性`PerformanceInterceptor`对象：

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 8]  
如下图所示在创建sqlSessionFactoryBean过程中(从左侧的方法顺序就可以看出来)会创建其属性`OptimisticLockerInterceptor`对象：

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 9]

--------------------

## ⑤ initializeBean ##

**AbstractAutowireCapableBeanFactory.initializeBean源码如下：**

protected Object initializeBean(final String beanName, final Object bean, RootBeanDefinition mbd) {
    	if (System.getSecurityManager() != null) {
    		AccessController.doPrivileged(new PrivilegedAction<Object>() {
    			@Override
    			public Object run() {
    				invokeAwareMethods(beanName, bean);
    				return null;
    			}
    		}, getAccessControlContext());
    	}
    	else {
    	//调用意识/通知方法
    		invokeAwareMethods(beanName, bean);
    	}
    
    	Object wrappedBean = bean;
    	if (mbd == null || !mbd.isSynthetic()) {
    	//调用bean后置处理器的前置方法
    		wrappedBean = applyBeanPostProcessorsBeforeInitialization(wrappedBean, beanName);
    	}
    	//调用初始化方法
    	try {
    		invokeInitMethods(beanName, wrappedBean, mbd);
    	}
    	catch (Throwable ex) {
    		throw new BeanCreationException(
    				(mbd != null ? mbd.getResourceDescription() : null),
    				beanName, "Invocation of init method failed", ex);
    	}
    
    	if (mbd == null || !mbd.isSynthetic()) {
    	//	//调用bean后置处理器的后置方法
    		wrappedBean = applyBeanPostProcessorsAfterInitialization(wrappedBean, beanName);
    	}
    	return wrappedBean;
    }

**AbstractAutowireCapableBeanFactory.invokeInitMethods方法源码如下：**

protected void invokeInitMethods(String beanName, final Object bean, RootBeanDefinition mbd)
    			throws Throwable {
    
    	boolean isInitializingBean = (bean instanceof InitializingBean);
    	if (isInitializingBean && (mbd == null || !mbd.isExternallyManagedInitMethod("afterPropertiesSet"))) {
    		if (logger.isDebugEnabled()) {
    			logger.debug("Invoking afterPropertiesSet() on bean with name '" + beanName + "'");
    		}
    		//调用InitializingBean.afterPropertiesSet
    		if (System.getSecurityManager() != null) {
    			try {
    				AccessController.doPrivileged(new PrivilegedExceptionAction<Object>() {
    					@Override
    					public Object run() throws Exception {
    						((InitializingBean) bean).afterPropertiesSet();
    						return null;
    					}
    				}, getAccessControlContext());
    			}
    			catch (PrivilegedActionException pae) {
    				throw pae.getException();
    			}
    		}
    		else {
    			((InitializingBean) bean).afterPropertiesSet();
    		}
    	}
    //调用自定义初始化方法
    	if (mbd != null) {
    		String initMethodName = mbd.getInitMethodName();
    		if (initMethodName != null && !(isInitializingBean && "afterPropertiesSet".equals(initMethodName)) &&
    				!mbd.isExternallyManagedInitMethod(initMethodName)) {
    			invokeCustomInitMethod(beanName, bean, mbd);
    		}
    	}
    }

如下图所示，MybatisSqlSessionFactoryBean同样实现了InitializingBean接口。那么我们就需要注意其afterPropertiesSet方法了。  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 10]

--------------------

## ⑥ afterPropertiesSet ##

`MybatisSqlSessionFactoryBean.afterPropertiesSet`如下所示，代码很简短只是创建了sqlSessionFactory。

@Override
    public void afterPropertiesSet() throws Exception {
        notNull(dataSource, "Property 'dataSource' is required");
     //sqlSessionFactoryBuilder在populateBean的applyPropertyValues过程中已经存在！
        notNull(sqlSessionFactoryBuilder, "Property 'sqlSessionFactoryBuilder' is required");
        state((configuration == null && configLocation == null) || !(configuration != null && configLocation != null),
            "Property 'configuration' and 'configLocation' can not specified with together");
    
        this.sqlSessionFactory = buildSqlSessionFactory();
    }

进入`afterPropertiesSet()`方法前`MybatisSqlSessionFactoryBean`如下所示：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 11]

**我们看一下sqlSessionFactory，这是一段很长的过程：**

protected SqlSessionFactory buildSqlSessionFactory() throws Exception {
        Configuration configuration;
        // TODO 加载自定义 MybatisXmlConfigBuilder
        MybatisXMLConfigBuilder xmlConfigBuilder = null;
        if (this.configuration != null) {
            configuration = this.configuration;
            if (configuration.getVariables() == null) {
                configuration.setVariables(this.configurationProperties);
            } else if (this.configurationProperties != null) {
                configuration.getVariables().putAll(this.configurationProperties);
            }
        } else if (this.configLocation != null) {
     //通常如果配置了configLocation会从这里创建MybatisXMLConfigBuilder，
     //其构造方法又创建了MybatisConfiguration
            xmlConfigBuilder = new MybatisXMLConfigBuilder(this.configLocation.getInputStream(), null, this.configurationProperties);
            configuration = xmlConfigBuilder.getConfiguration();
        } else {
            if (LOGGER.isDebugEnabled()) {
                LOGGER.debug("Property 'configuration' or 'configLocation' not specified, using default MyBatis Configuration");
            }
            // TODO 使用自定义配置
            configuration = new MybatisConfiguration();
            if (this.configurationProperties != null) {
                configuration.setVariables(this.configurationProperties);
            }
        }
    
        if (this.objectFactory != null) {
            configuration.setObjectFactory(this.objectFactory);
        }
    
        if (this.objectWrapperFactory != null) {
            configuration.setObjectWrapperFactory(this.objectWrapperFactory);
        }
    
        if (this.vfs != null) {
            configuration.setVfsImpl(this.vfs);
        }
    
        if (hasLength(this.typeAliasesPackage)) {
            // TODO 支持自定义通配符
            String[] typeAliasPackageArray;
            if (typeAliasesPackage.contains("*") && !typeAliasesPackage.contains(",")
                && !typeAliasesPackage.contains(";")) {
                typeAliasPackageArray = PackageHelper.convertTypeAliasesPackage(typeAliasesPackage);
            } else {
                typeAliasPackageArray = tokenizeToStringArray(this.typeAliasesPackage,
                    ConfigurableApplicationContext.CONFIG_LOCATION_DELIMITERS);
            }
            if (typeAliasPackageArray == null) {
                throw new MybatisPlusException("not find typeAliasesPackage:" + typeAliasesPackage);
            }
            for (String packageToScan : typeAliasPackageArray) {
                configuration.getTypeAliasRegistry().registerAliases(packageToScan,
                    typeAliasesSuperType == null ? Object.class : typeAliasesSuperType);
                if (LOGGER.isDebugEnabled()) {
                    LOGGER.debug("Scanned package: '" + packageToScan + "' for aliases");
                }
            }
        }
    
        // TODO 自定义枚举类扫描处理
        if (hasLength(this.typeEnumsPackage)) {
            Set<Class> classes = null;
            if (typeEnumsPackage.contains("*") && !typeEnumsPackage.contains(",")
                && !typeEnumsPackage.contains(";")) {
                classes = PackageHelper.scanTypePackage(typeEnumsPackage);
            } else {
                String[] typeEnumsPackageArray = tokenizeToStringArray(this.typeEnumsPackage,
                    ConfigurableApplicationContext.CONFIG_LOCATION_DELIMITERS);
                if (typeEnumsPackageArray == null) {
                    throw new MybatisPlusException("not find typeEnumsPackage:" + typeEnumsPackage);
                }
                classes = new HashSet<Class>();
                for (String typePackage : typeEnumsPackageArray) {
                    classes.addAll(PackageHelper.scanTypePackage(typePackage));
                }
            }
            // 取得类型转换注册器
            TypeHandlerRegistry typeHandlerRegistry = configuration.getTypeHandlerRegistry();
            for (Class cls : classes) {
                if (cls.isEnum()) {
                    if (IEnum.class.isAssignableFrom(cls)) {
                        typeHandlerRegistry.register(cls.getName(), com.baomidou.mybatisplus.handlers.EnumTypeHandler.class.getCanonicalName());
                    } else {
                        // 使用原生 EnumOrdinalTypeHandler
                        typeHandlerRegistry.register(cls.getName(), org.apache.ibatis.type.EnumOrdinalTypeHandler.class.getCanonicalName());
                    }
                }
            }
        }
    
        if (!isEmpty(this.typeAliases)) {
            for (Class<?> typeAlias : this.typeAliases) {
                configuration.getTypeAliasRegistry().registerAlias(typeAlias);
                if (LOGGER.isDebugEnabled()) {
                    LOGGER.debug("Registered type alias: '" + typeAlias + "'");
                }
            }
        }
    //这里会遍历plugins然后调用     configuration.addInterceptor(plugin);
    //--这会把plugin放到InterceptorChain.interceptors中
        if (!isEmpty(this.plugins)) {
            for (Interceptor plugin : this.plugins) {
                configuration.addInterceptor(plugin);
                if (LOGGER.isDebugEnabled()) {
                    LOGGER.debug("Registered plugin: '" + plugin + "'");
                }
            }
        }
    
        if (hasLength(this.typeHandlersPackage)) {
            String[] typeHandlersPackageArray = tokenizeToStringArray(this.typeHandlersPackage,
                ConfigurableApplicationContext.CONFIG_LOCATION_DELIMITERS);
            for (String packageToScan : typeHandlersPackageArray) {
                configuration.getTypeHandlerRegistry().register(packageToScan);
                if (LOGGER.isDebugEnabled()) {
                    LOGGER.debug("Scanned package: '" + packageToScan + "' for type handlers");
                }
            }
        }
    
        if (!isEmpty(this.typeHandlers)) {
            for (TypeHandler<?> typeHandler : this.typeHandlers) {
                configuration.getTypeHandlerRegistry().register(typeHandler);
                if (LOGGER.isDebugEnabled()) {
                    LOGGER.debug("Registered type handler: '" + typeHandler + "'");
                }
            }
        }
    
        if (this.databaseIdProvider != null) {//fix #64 set databaseId before parse mapper xmls
            try {
                configuration.setDatabaseId(this.databaseIdProvider.getDatabaseId(this.dataSource));
            } catch (SQLException e) {
                throw new NestedIOException("Failed getting a databaseId", e);
            }
        }
    
        if (this.cache != null) {
            configuration.addCache(this.cache);
        }
    
        if (xmlConfigBuilder != null) {
            try {
                xmlConfigBuilder.parse();
    
                if (LOGGER.isDebugEnabled()) {
                    LOGGER.debug("Parsed configuration file: '" + this.configLocation + "'");
                }
            } catch (Exception ex) {
                throw new NestedIOException("Failed to parse config resource: " + this.configLocation, ex);
            } finally {
                ErrorContext.instance().reset();
            }
        }
    
        if (this.transactionFactory == null) {
            this.transactionFactory = new SpringManagedTransactionFactory();
        }
    
        configuration.setEnvironment(new Environment(this.environment, this.transactionFactory, this.dataSource));
        // 设置元数据相关
        GlobalConfigUtils.setMetaData(dataSource, globalConfig);
        SqlSessionFactory sqlSessionFactory = this.sqlSessionFactoryBuilder.build(configuration);
        // TODO SqlRunner
        SqlRunner.FACTORY = sqlSessionFactory;
        // TODO 缓存 sqlSessionFactory
        globalConfig.setSqlSessionFactory(sqlSessionFactory);
        // TODO 设置全局参数属性
        globalConfig.signGlobalConfig(sqlSessionFactory);
        if (!isEmpty(this.mapperLocations)) {
            if (globalConfig.isRefresh()) {
                //TODO 设置自动刷新配置 减少配置
                new MybatisMapperRefresh(this.mapperLocations, sqlSessionFactory, 2,
                    2, true);
            }
            for (Resource mapperLocation : this.mapperLocations) {
                if (mapperLocation == null) {
                    continue;
                }
    
                try {
                    // TODO  这里也换了噢噢噢噢
                    XMLMapperBuilder xmlMapperBuilder = new XMLMapperBuilder(mapperLocation.getInputStream(),
                        configuration, mapperLocation.toString(), configuration.getSqlFragments());
                    xmlMapperBuilder.parse();
                } catch (Exception e) {
                    throw new NestedIOException("Failed to parse mapping resource: '" + mapperLocation + "'", e);
                } finally {
                    ErrorContext.instance().reset();
                }
    
                if (LOGGER.isDebugEnabled()) {
                    LOGGER.debug("Parsed mapper file: '" + mapperLocation + "'");
                }
            }
        } else {
            if (LOGGER.isDebugEnabled()) {
                LOGGER.debug("Property 'mapperLocations' was not specified or no matching resources found");
            }
        }
        return sqlSessionFactory;
    }

**上面代码主要做了如下事情：**

*  获取MybatisXMLConfigBuilder对象
 *  获取Configuration对象-MybatisConfiguration
 *  配置对象Configuration添加插件`configuration.addInterceptor(plugin)`;其会添加到InterceptorChain.interceptors中
 *  xmlConfigBuilder.parse()对configuration做进一步处理
 *  获取SpringManagedTransactionFactory用来创建SpringManagedTransaction
 *  获取一个DefaultSqlSessionFactory实例对象
 *  globalConfig.setSqlSessionFactory(sqlSessionFactory)中会创建`MybatisSqlSessionTemplate--SqlSession`的实现类
 *  解析mapperLocation对应的一个个mapper配置文件，使用助手builderAssistant的addMappedStatement方法将一个个结点添加配置对象中–`这里可以理解为解析SQL完成`
 *  其他属性设置等等

也就是说，在`MybatisSqlSessionFactoryBean.afterPropertiesSet`方法执行结束后，SqlSessionFactory、SqlSessionTemplate、Configuration等都已存在！

# 【3】查询执行流程分析之实例准备 #

## ① employeeMapper ##

示例代码如下：

List<Employee > emps = employeeMapper.selectPage(page, null);

如下图所示，此时我们获取到的employeeMapper其实是个代理对象：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 12]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 13]  
**1.1如下所示，会执行`MapperProxy.invoke`方法**

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 14]  
**1.2 判断SQLtype**

MapperMethod.execute中会根据SqlCommand.type进行类型判断：

public Object execute(SqlSession sqlSession, Object[] args) {
        Object result;
        switch (command.getType()) {
          case INSERT: {
          Object param = method.convertArgsToSqlCommandParam(args);
            result = rowCountResult(sqlSession.insert(command.getName(), param));
            break;
          }
          case UPDATE: {
            Object param = method.convertArgsToSqlCommandParam(args);
            result = rowCountResult(sqlSession.update(command.getName(), param));
            break;
          }
          case DELETE: {
            Object param = method.convertArgsToSqlCommandParam(args);
            result = rowCountResult(sqlSession.delete(command.getName(), param));
            break;
          }
          case SELECT:
          //这里根据method的返回类型执行不同方法
            if (method.returnsVoid() && method.hasResultHandler()) {
              executeWithResultHandler(sqlSession, args);
              result = null;
            } else if (method.returnsMany()) {
              result = executeForMany(sqlSession, args);
            } else if (method.returnsMap()) {
              result = executeForMap(sqlSession, args);
            } else if (method.returnsCursor()) {
              result = executeForCursor(sqlSession, args);
            } else {
              Object param = method.convertArgsToSqlCommandParam(args);
              result = sqlSession.selectOne(command.getName(), param);
            }
            break;
          case FLUSH:
            result = sqlSession.flushStatements();
            break;
          default:
            throw new BindingException("Unknown execution method for: " + command.getName());
        }
        if (result == null && method.getReturnType().isPrimitive() && !method.returnsVoid()) {
          throw new BindingException("Mapper method '" + command.getName() 
              + " attempted to return null from a method with a primitive return type (" + method.getReturnType() + ").");
        }
        return result;
      }

--------------------

**1.3 MapperMethod.executeForMany**

解析参数然后调用sqlSession获取结果。

private <E> Object executeForMany(SqlSession sqlSession, Object[] args) {
        List<E> result;
        //解析参数为map结构
        Object param = method.convertArgsToSqlCommandParam(args);
        //判断是否拥有RowBounds参数---也就是是否需要分页
        if (method.hasRowBounds()) {
          RowBounds rowBounds = method.extractRowBounds(args);
          result = sqlSession.<E>selectList(command.getName(), param, rowBounds);
        } else {
        //如果不需要分页，则会查询所有符合条件的结果
          result = sqlSession.<E>selectList(command.getName(), param);
        }
        // issue #510 Collections & arrays support
        //判断返回数组还是集合
        if (!method.getReturnType().isAssignableFrom(result.getClass())) {
          if (method.getReturnType().isArray()) {
            return convertToArray(result);
          } else {
            return convertToDeclaredCollection(sqlSession.getConfiguration(), result);
          }
        }
        return result;
      }

## ② `sqlSession.<E>selectList(command.getName(), param, rowBounds)` ##

**2.1 SqlSessionTemplate.selectList**

public <E> List<E> selectList(String statement, Object parameter, RowBounds rowBounds) {
        return this.sqlSessionProxy.<E> selectList(statement, parameter, rowBounds);
      }

这里调用其`代理对象`来执行方法，sqlSessionProxy如下所示：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 15]  
如下图所示，其来到了`SqlSessionTemplate$SqlSessionInterceptor.invoke`方法中(`SqlSessionInterceptor是SqlSessionTemplate的内部类`)：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 16]

**2.2 SqlSessionInterceptor**

这里会获取SqlSession 实例对象，根据SqlSession 和参数反射调用Method 获取结果。

private class SqlSessionInterceptor implements InvocationHandler {
        @Override
        public Object invoke(Object proxy, Method method, Object[] args) throws Throwable {
        //这里获取SqlSession 实例对象
          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;
          } catch (Throwable t) {
            Throwable unwrapped = unwrapThrowable(t);
            if (SqlSessionTemplate.this.exceptionTranslator != null && unwrapped instanceof PersistenceException) {
              // release the connection to avoid a deadlock if the translator is no loaded. See issue #22
              closeSqlSession(sqlSession, SqlSessionTemplate.this.sqlSessionFactory);
              sqlSession = null;
              Throwable translated = SqlSessionTemplate.this.exceptionTranslator.translateExceptionIfPossible((PersistenceException) unwrapped);
              if (translated != null) {
                unwrapped = translated;
              }
            }
            throw unwrapped;
          } finally {
            if (sqlSession != null) {
              closeSqlSession(sqlSession, SqlSessionTemplate.this.sqlSessionFactory);
            }
          }
        }
      }

## ③ 获取sqlSession ##

这里是真实获取一个sqlsession实例对象。SqlSessionUtils.getSqlSession如下所示：

public static SqlSession getSqlSession(SqlSessionFactory sessionFactory, ExecutorType executorType, PersistenceExceptionTranslator exceptionTranslator) {
    //断言sessionFactory不为null
        notNull(sessionFactory, NO_SQL_SESSION_FACTORY_SPECIFIED);
     //断言executorType不为null
        notNull(executorType, NO_EXECUTOR_TYPE_SPECIFIED);
    
    //获取SqlSessionHolder  先尝试从holder中获取SqlSession 
        SqlSessionHolder holder = (SqlSessionHolder) TransactionSynchronizationManager.getResource(sessionFactory);
    //如果获取的session不为null，则直接返回
        SqlSession session = sessionHolder(executorType, holder);
        if (session != null) {
          return session;
        }
    
        if (LOGGER.isDebugEnabled()) {
          LOGGER.debug("Creating a new SqlSession");
        }
    //如果上面没有获取到sqlsession，则使用sessionFactory创建一个session 
        session = sessionFactory.openSession(executorType);
    //获取一个SessionHolder，并把括号内参数赋予给SessionHolder
        registerSessionHolder(sessionFactory, executorType, exceptionTranslator, session);
    //返回获取的sqlsession
        return session;
      }

**3.1 sessionFactory.openSession**

DefaultSqlSessionFactory.openSession如下所示：

public SqlSession openSession(ExecutorType execType) {
        return openSessionFromDataSource(execType, null, false);
      }

**继续往下跟踪openSessionFromDataSource：**

private SqlSession openSessionFromDataSource(ExecutorType execType, TransactionIsolationLevel level, boolean autoCommit) {
    Transaction tx = null;
    try {
    //根据MybatisConfiguration获取environment ：其有数据源、transactionFactory等
    final Environment environment = configuration.getEnvironment();
    //获取事务工厂
    final TransactionFactory transactionFactory = getTransactionFactoryFromEnvironment(environment);
    //获取事务
    tx = transactionFactory.newTransaction(environment.getDataSource(), level, autoCommit);
    
    //获取执行器，这里很重要哦会调用interceptorChain.pluginAll
    final Executor executor = configuration.newExecutor(tx, execType);
    //返回一个DefaultSqlSession实例
    return new DefaultSqlSession(configuration, executor, autoCommit);
    } catch (Exception e) {
    closeTransaction(tx); // may have fetched a connection so lets call close()
    throw ExceptionFactory.wrapException("Error opening session.  Cause: " + e, e);
    } finally {
    ErrorContext.instance().reset();
    }
    }

--------------------

## ④ configuration.newExecutor ##

获取执行器对象并第一次调用interceptorChain.pluginAll。这里来到了Configuration.newExecutor方法处：

public Executor newExecutor(Transaction transaction, ExecutorType executorType) {
        executorType = executorType == null ? defaultExecutorType : executorType;
        executorType = executorType == null ? ExecutorType.SIMPLE : executorType;
        Executor executor;
        //根据不同ExecutorType获取不同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);
        }
        //会调用插件
        executor = (Executor) interceptorChain.pluginAll(executor);
        return executor;
      }

首先会根据ExecutorType创建不同的Executor，如`批处理BatchExecutor`、ReuseExecutor、SimpleExecutor以及缓存处理CachingExecutor。Executor是Mybatis的核心负责SQL动态语句的生成以及查询缓存的维护。

而BatchExecutor、ReuseExecutor、SimpleExecutor实例化的构造方法都会走到BaseExecutor构造方法，可以看到执行器Executor持有了事务对象transaction 、缓存对象localCache 、出参缓存对象localOutputParameterCache 、配置对象configuration 以及包装执行器对象wrapper -其也是Executor类型。

protected BaseExecutor(Configuration configuration, Transaction transaction) {
        this.transaction = transaction;
        this.deferredLoads = new ConcurrentLinkedQueue<DeferredLoad>();
        this.localCache = new PerpetualCache("LocalCache");
        this.localOutputParameterCache = new PerpetualCache("LocalOutputParameterCache");
        this.closed = false;
        this.configuration = configuration;
        this.wrapper = this;
      }

**获取sqlsession时序图如下**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 17]

--------------------

## ⑤ InterceptorChain.pluginAll ##

会挨个调用插件，如果该插件对当前对象感兴趣就会对其包装生成代理对象。

此时包括的插件如下图所示：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 18]  
如下代码所示，会遍历拦截器然后调用每个拦截器的plugin方法，这里target为CachingExecutor。

public Object pluginAll(Object target) {
      for (Interceptor interceptor : interceptors) {
        target = interceptor.plugin(target);
      }
      return target;
    }

**5.1`PaginationInterceptor.plugin`如下，其只会对StatementHandler起作用。**

@Intercepts({@Signature(type = StatementHandler.class, method = "prepare", args = {Connection.class, Integer.class})})
    public class PaginationInterceptor extends SqlParserHandler implements Interceptor {
    //...
    }

plugin方法如下：

public Object plugin(Object target) {
        if (target instanceof StatementHandler) {
            return Plugin.wrap(target, this);
        }
        return target;
    }

**5.2`SqlExplainInterceptor.plugin`(目前只支持 MYSQL-5.6.3 以上版本)如下所示，其对Executor起作用。**

@Intercepts({@Signature(type = Executor.class, method = "update", args = {MappedStatement.class, Object.class})})
    public class SqlExplainInterceptor implements Interceptor {
    //...
    }

plugin方法如下：

public Object plugin(Object target) {
         if (target instanceof Executor) {
             return Plugin.wrap(target, this);
         }
         return target;
     }

**Plugin.wrap方法，会生成一个target代理对象**

public static Object wrap(Object target, Interceptor interceptor) {
    //获取感兴趣的类与类的方法
      Map<Class<?>, Set<Method>> signatureMap = getSignatureMap(interceptor);
      //获取目标类型，这里为class org.apache.ibatis.executor.CachingExecutor
      Class<?> type = target.getClass();
      //获取所有type.getInterfaces()且在signatureMap 中的有
      Class<?>[] interfaces = getAllInterfaces(type, signatureMap);
      if (interfaces.length > 0) {
        return Proxy.newProxyInstance(
            type.getClassLoader(),
            interfaces,
            new Plugin(target, interceptor, signatureMap));
      }
      return target;
    }

**5.3PerformanceInterceptor.plugin,其对StatementHandler起作用**

@Intercepts({@Signature(type = StatementHandler.class, method = "query", args = {Statement.class, ResultHandler.class}),
        @Signature(type = StatementHandler.class, method = "update", args = {Statement.class}),
        @Signature(type = StatementHandler.class, method = "batch", args = {Statement.class})})
    public class PerformanceInterceptor implements Interceptor {
    //...
    }

plugin方法如下所示：

public Object plugin(Object target) {
         if (target instanceof StatementHandler) {
             return Plugin.wrap(target, this);
         }
         return target;
     }

**5.4 OptimisticLockerInterceptor.plugin,其对Executor起作用**

@Intercepts({@Signature(type = Executor.class, method = "update", args = {MappedStatement.class, Object.class})})
    public class OptimisticLockerInterceptor implements Interceptor {
    //...
    }

同样调用Plugin.wrap返回一个动态代理对象。

public Object plugin(Object target) {
          if (target instanceof Executor) {
              return Plugin.wrap(target, this);
          }
          return target;
      }

**这时target如下所示：**

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 19]  
**插件会产生目标对象的代理对象，多个插件就会产生多层代理。创建动态代理的时候，是按照插件配置顺序创建层层代理对象。执行目标方法的之后，按照逆向顺序执行。**

![在这里插入图片描述][20201030101115709.png_pic_center]

--------------------

## ⑥ 依次返回到SqlSessionUtils.getSqlSession处 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 20]  
这里会根据session, executorType, exceptionTranslator实例化一个SqlSessionHolder。

**然后会依次返回，返回到③获取sqlsession处：**

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 21]

那么接下来就该`Object result = method.invoke(sqlSession, args)`使用刚获取到的sqlsession以及参数反射调用具体方法了。这里method为`public abstract java.util.List org.apache.ibatis.session.SqlSession.selectList(java.lang.String,java.lang.Object,org.apache.ibatis.session.RowBounds)`

参数如下图所示：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 22]

--------------------

# 【4】查询执行流程分析之查询过程 #

## ① DefaultSqlSession.selectList ##

这里的statement其实就是方法的完整描述，如`com.jane.mp.mapper.EmployeeMapper.selectPage`，RowBounds 是用来进行分页的。这里的executor是`org.apache.ibatis.executor.CachingExecutor@433ffad1`

public <E> List<E> selectList(String statement, Object parameter, RowBounds rowBounds) {
      try {
        MappedStatement ms = configuration.getMappedStatement(statement);
        return executor.query(ms, wrapCollection(parameter), rowBounds, Executor.NO_RESULT_HANDLER);
      } catch (Exception e) {
        throw ExceptionFactory.wrapException("Error querying database.  Cause: " + e, e);
      } finally {
        ErrorContext.instance().reset();
      }
    }

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 23]  
需要注意的是，这里的executor为代理对象：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 24]

## ② Plugin.invoke ##

代码如下所示：

public Object invoke(Object proxy, Method method, Object[] args) throws Throwable {
      try {
      //获取感兴趣的方法
        Set<Method> methods = signatureMap.get(method.getDeclaringClass());
        if (methods != null && methods.contains(method)) {
          return interceptor.intercept(new Invocation(target, method, args));
        }
        return method.invoke(target, args);
      } catch (Exception e) {
        throw ExceptionUtil.unwrapThrowable(e);
      }
    }

首先从signatureMap中获取`method.getDeclaringClass()`对应的方法，然后判断methods 是否包含method。如果包含，则调用`interceptor.intercept`方法(可以理解为插件开始起作用了)；如果不包含，则直接执行`method.invoke(target, args)`。

如下图所示，这里target为代理对象，`interceptor为OptimisticLockerInterceptor`。  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 25]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 26]  
Executor会被OptimisticLockerInterceptor、SqlExplainInterceptor处理(二者都处理update方法)，所以会进行两次代理。那么在这里也同样会进行两次解析。

**第二次来到invoke方法如下图所示：**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 27]

--------------------

## ③ CachingExecutor.query ##

代码如下所示：

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);
      }

首先使用ms.getBoundSql获取了boundSql对象如下：  
![在这里插入图片描述][20200909162601936.png_pic_center]  
createCacheKey(ms, parameterObject, rowBounds, boundSql)创建缓存key。这个方法很有意思，它自己并不处理而是使用了其委派对象delegate去处理(这里可以联想一下设计模式的`委派模式`)，如下所示：

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

**我们再回顾下CachingExecutor的构造方法：**

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);
      }
      //...
      }

然后我们依次返回查看获取到的CacheKey`-1113517040:-1225312459:com.jane.mp.mapper.EmployeeMapper.selectPage:0:1:SELECT id AS id,last_name AS lastName,email,gender,age,version FROM tbl_employee:MybatisSqlSessionFactoryBean`

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 28]

## ④ CachingExecutor.query ##

这里会首先判断缓存是否存在，如果缓存存在则尝试从缓存里面根据CacheKey 获取结果，如果结果获取不到则执行查询并再次放到缓存里面；如果缓存不存在则直接直接查询。

public <E> List<E> query(MappedStatement ms, Object parameterObject, RowBounds rowBounds, ResultHandler resultHandler, CacheKey key, BoundSql boundSql)
          throws SQLException {
          //获取缓存，首先从缓存里面获取，如果缓存获取不到则执行查询并放到缓存里面
        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);
      }

这里delegate为SimpleExecutor实例对象。

## ⑤ BaseExecutor.query ##

SimpleExecutor会调用父类BaseExecutor的query方法：

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) {
            // issue #482
            clearLocalCache();
          }
        }
        return list;
      }

## ⑥ BaseExecutor.queryFromDatabase ##

private <E> List<E> queryFromDatabase(MappedStatement ms, Object parameter, RowBounds rowBounds, ResultHandler resultHandler, CacheKey key, BoundSql boundSql) throws SQLException {
        List<E> list;
        localCache.putObject(key, EXECUTION_PLACEHOLDER);
        try {
        //执行查询
          list = doQuery(ms, parameter, rowBounds, resultHandler, boundSql);
        } finally {
          localCache.removeObject(key);
        }
        localCache.putObject(key, list);
        if (ms.getStatementType() == StatementType.CALLABLE) {
          localOutputParameterCache.putObject(key, parameter);
        }
        return list;
      }

## ⑦ SimpleExecutor.doQuery ##

@Override
      public <E> List<E> doQuery(MappedStatement ms, Object parameter, RowBounds rowBounds, ResultHandler resultHandler, BoundSql boundSql) throws SQLException {
        Statement stmt = null;
        try {
        //获取环境配置信息
          Configuration configuration = ms.getConfiguration();
          //获取语句处理器
          StatementHandler handler = configuration.newStatementHandler(wrapper, ms, parameter, rowBounds, resultHandler, boundSql);
          //准备statement
          stmt = prepareStatement(handler, ms.getStatementLog());
          return handler.<E>query(stmt, resultHandler);
        } finally {
          closeStatement(stmt);
        }
      }

需要注意的是newStatementHandler中会调用interceptorChain.pluginAll方法。那么此时如果项目配置了分页插件和性能分析插件，就会生效。

public StatementHandler newStatementHandler(Executor executor, MappedStatement mappedStatement, Object parameterObject, RowBounds rowBounds, ResultHandler resultHandler, BoundSql boundSql) {
       StatementHandler statementHandler = new RoutingStatementHandler(executor, mappedStatement, parameterObject, rowBounds, resultHandler, boundSql);
       statementHandler = (StatementHandler) interceptorChain.pluginAll(statementHandler);
       return statementHandler;
     }

StatementHandler：处理sql语句预编译，设置参数等相关工作；  
ParameterHandler：设置预编译参数用的  
ResultHandler：处理结果集  
TypeHandler：在整个过程中，进行数据库类型和javaBean类型的映射。

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center]: /images/20221123/8f2a71de0d5e48cb8ad9544d29bd306b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 1]: /images/20221123/741a665c7d7744ebb12495b81067445f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 2]: /images/20221123/f63363b329a64b40b927a74ef75b6460.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 3]: /images/20221123/7c2f67913b654b63be2b00fbdbd38553.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 4]: /images/20221123/dd6faef1197c440780ac3074c2124f3f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 5]: /images/20221123/95466c805d2541c5b53fa7ccb97a8de8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 6]: /images/20221123/dc0731e0deb24be9ae75272302121d56.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 7]: /images/20221123/18bb0f2ac8e54100b5e405f9f13fedc4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 8]: /images/20221123/a1574830cf024cb98d82617fbb83f81f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 9]: /images/20221123/cb52484919ae405eac0f8bf81719ba86.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 10]: /images/20221123/acc1ab1cd3524cd98b6e363db6a39024.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 11]: /images/20221123/cb6b8479e7694b058c15599c7ef552e0.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 12]: /images/20221123/0db5b7200d1e45fe91da002585b7e0db.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 13]: /images/20221123/9101d0bf7aab47ffa9a9bdb1f3ae319c.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 14]: /images/20221123/5e6f89e34ef74216adc74d44605a937f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 15]: /images/20221123/57e83657ddf041d3b51739df91fdb9b4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 16]: /images/20221123/a60393e8fcc141dcbab0016efc183778.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 17]: /images/20221123/06a7838ec02842498ac3485815acadae.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 18]: /images/20221123/e1ca57259ac04107952e4fee48aef711.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 19]: /images/20221123/1ee1071efe3b4584a406376ddae4c0e4.png
[20201030101115709.png_pic_center]: /images/20221123/94539e71812e44889da0db7ab5ab75ca.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 20]: /images/20221123/2dd1ef586d8747dea8fa0848292ae295.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 21]: /images/20221123/6dbdb23d00a541138862ec12b8ae76e2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 22]: /images/20221123/671c375e2e574a3f86e66f61345a8deb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 23]: /images/20221123/fda4abaac31244ccb0cfa48c07a9598f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 24]: /images/20221123/f01af0b03765422a8cc8e8a98f5673e6.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 25]: /images/20221123/8af66e94d5e947ab98b7a9471e4e6f03.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 26]: /images/20221123/4cd43aac23c7499a87a560ed15760ba8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 27]: /images/20221123/55ceda02eda24cc4a7e91f1d171c3223.png
[20200909162601936.png_pic_center]: /images/20221123/3034b417a4d1454981666c045750b7e2.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0owODA2MjQ_size_16_color_FFFFFF_t_70_pic_center 28]: /images/20221123/97a842b321aa4cb7b3b97700f2a6df55.png