【springboot】SpringBoot和mybatis集成多数据源后sql无法打印的问题

1.application.properties：

#单数据源情况下，此配置会生效
#多数据源情况下，则需要在代码中将此配置添加，否则sqlSessionFactory无法去获取当前配置
mybatis.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
mybatis.configuration.map-underscore-to-camel-case=true
mybatis.configuration.default-fetch-size=100
mybatis.configuration.default-statement-timeout=3000
mybatis.mapper-locations=classpath:mapper/*.xml

2.DynamicDataSourceConfiguration代理数据源配置:

package org.jingniu.config.db;

import com.alibaba.druid.spring.boot.autoconfigure.DruidDataSourceBuilder;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.boot.autoconfigure.MybatisProperties;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.context.annotation.Primary;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import org.springframework.transaction.PlatformTransactionManager;

import javax.sql.DataSource;
import java.util.HashMap;
import java.util.Map;

/**
 * @author luofeng
 * @description:数据源注入spring
 */
@Configuration
public class DynamicDataSourceConfiguration {


	//多数据源配置：mysql的slave_database_01
    @Bean
    @ConfigurationProperties(prefix = "multiple.datasource.slave_database_01")
    public DataSource dbOther01() {
        return DruidDataSourceBuilder.create().build();
    }
    
	//多数据源配置：sqlserver的sqlserver
    @Bean
    @ConfigurationProperties(prefix = "multiple.datasource.sqlserver")
    public DataSource sqlServer() {
        return DruidDataSourceBuilder.create().build();
    }

	//多数据源配置：mysql的default_database，默认主库
    @Bean
    @Primary
    @ConfigurationProperties(prefix = "multiple.datasource.default_database")
    public DataSource dbDefault() {
        //此处可设置连接池的其他信息，需要在配置文件取出
//        DruidDataSource wdataSource = new DruidDataSource();
//        wdataSource.setDriverClassName(wdriverClass);
        return DruidDataSourceBuilder.create().build();
    }

	//取配置文件中的这个属性
    @Value("${mybatis.mapper-locations}")
    private String mapper;
    /**
     * 核心动态数据源
     * @return 数据源实例
     */
    @Bean
    public DataSource dynamicDataSource() {
        DynamicRoutingDataSource dataSource = new DynamicRoutingDataSource();
        dataSource.setDefaultTargetDataSource(dbDefault());
        DynamicDataSourceContextHolder.set(DataSourceKey.DB_DEFAULT_DATABASE);
        Map<Object, Object> dataSourceMap = new HashMap<>(2);
        dataSourceMap.put(DataSourceKey.DB_DEFAULT_DATABASE, dbDefault());
        dataSourceMap.put(DataSourceKey.DB_OTHER_DATABASE_01, dbOther01());
        dataSourceMap.put(DataSourceKey.DB_SQLSERVER, sqlServer());
        dataSource.setTargetDataSources(dataSourceMap);
        return dataSource;
    }

    @Bean(name = "sqlSessionFactory")
    public SqlSessionFactory sqlSessionFactory(MybatisProperties mybatisProperties) throws Exception {
        SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
        sqlSessionFactoryBean.setDataSource(dynamicDataSource());
        //sqlSessionFactoryBean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources(mapper));
        //读取mybatis的属性配置信息，作为sqlSessionFactory的属性，交由spring管理
        sqlSessionFactoryBean.setConfiguration(mybatisProperties.getConfiguration());
        return sqlSessionFactoryBean.getObject();
    }

    @Bean
    public SqlSessionTemplate sqlSessionTemplate(@Qualifier("sqlSessionFactory") SqlSessionFactory sqlSessionFactory) throws Exception {
        return new SqlSessionTemplate(sqlSessionFactory);
    }

    /**
     * 事务管理
     *
     * @return 事务管理实例
     */
    @Bean
    public PlatformTransactionManager platformTransactionManager() {
        return new DataSourceTransactionManager(dynamicDataSource());
    }
}