java多数据源配置

配置类

数据库配置类

package com.kingki.config.ds;

import com.alibaba.druid.pool.DruidDataSource;
import org.apache.ibatis.plugin.Interceptor;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.ObjectProvider;
import org.springframework.boot.autoconfigure.jdbc.DataSourceBuilder;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;
import tk.mybatis.spring.annotation.MapperScan;

import javax.annotation.Resource;
import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.SQLException;

@Configuration
@MapperScan(
        basePackages = {TestDatasourceConfig.MAPPER_PACKAGE},
        sqlSessionFactoryRef = "testSqlSessionTemplate")
public class TestDatasourceConfig {

    /**
     * 日志打印
     */
    private static final Logger logger = LoggerFactory.getLogger(TestDatasourceConfig.class);

    /**
     * 本配置类所对应的数据库
     */
    private static final String DB_PREFIX = "spring.datasource-test";

    /**
     * Mapper存放路径
     */
    protected final static String MAPPER_XML_AREA = "classpath*:mapperTest/*.xml";

    /**
     * Dao存放路径
     */
    protected final static String MAPPER_PACKAGE = "com.kingki.*.daoTest";

    /**
     * 数据源对象
     */
    @Resource(name = "testDataSource")//注入的是下方的数据库连接池返回的对象
    private DataSource testDataSource;

    /**
     * 数据库连接池设置
     */
    @Bean(name = "testDataSource")
    @ConfigurationProperties(prefix = DB_PREFIX)
    public DataSource dataSource() {
        return DataSourceBuilder.create().type(DruidDataSource.class).build();
    }

    /**
     * 数据库事务管理器
     */
    @Bean(name = "testTransationManager")
    public DataSourceTransactionManager transationManager(){
        DataSourceTransactionManager tm
                = new DataSourceTransactionManager(getDs());//传入数据源
        tm.setEnforceReadOnly(true);//只读设置
        return tm;
    }

    @Bean(name = "testSqlSessionTemplate")
    public SqlSessionFactory sqlSessionTemplate() throws Exception {
        final SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(getDs());//数据源
        bean.setMapperLocations(
                new PathMatchingResourcePatternResolver()
                        .getResources(MAPPER_XML_AREA));//mapper路径
        bean.setTypeAliasesPackage("com.kingki.*.entity");

		//初始化配置，可以不使用
        //SqlSessionFactoryUtils.init(bean,interceptorsProvider.getIfAvailable());

        return bean.getObject();
    }
    @Resource
    private ObjectProvider<Interceptor[]> interceptorsProvider;


    private DataSource defaultDs;

    /**
     * 数据源设置
     */
    public DataSource getDs(){
        if(defaultDs != null) {
            return defaultDs;
        }
        DataSource thisDs = testDataSource;
        Connection conn = null;
        try {
            conn = thisDs.getConnection();
        } catch (Exception e) {
            logger.error("只读数据源初始化失败，使用默认数据源。",e);
        }finally {
            if(conn != null) {
                try {
                    conn.close();
                } catch (SQLException e) {
                    logger.error("只读数据源Connection关闭失败。",e);
                }
            }
        }
        defaultDs = thisDs;
        return defaultDs;
    }

}

SqlSessionFactory工具类

package com.kingki.config.ds;

import java.util.Properties;

import org.apache.ibatis.plugin.Interceptor;
import org.apache.ibatis.session.AutoMappingBehavior;
import org.apache.ibatis.session.Configuration;
import org.apache.ibatis.session.LocalCacheScope;
import org.mybatis.spring.SqlSessionFactoryBean;

import tk.mybatis.mapper.autoconfigure.SpringBootVFS;


public class SqlSessionFactoryUtils {
	
	public static void init(SqlSessionFactoryBean bean,Interceptor[] interceptorList) {
		Configuration config = new Configuration();
        config.setCacheEnabled(false);
        config.setAutoMappingBehavior(AutoMappingBehavior.FULL);
        config.setLogPrefix("com.kingki.sql.");
        config.setLocalCacheScope(LocalCacheScope.STATEMENT);
        // 	config.setJdbcTypeForNull(JdbcType.NULL);
        
        bean.setConfiguration(config);
        bean.setVfs(SpringBootVFS.class);
        //Interceptor interceptor = new PageInterceptor();
        Properties properties = new Properties();

        //properties.setProperty("supportMethodsArguments", "true");
        //properties.setProperty("returnPageInfo", "check");
        properties.setProperty("reasonable", "true");
        properties.setProperty("params", "count=countSql");
        properties.setProperty("mappers", "");
        //interceptor.setProperties(properties);
        bean.setPlugins(interceptorList);
	}
}

application中数据库部分的配置

spring:
  thymeleaf:
        mode: LEGACYHTML5
  datasource:
    name: kingki_test
    url: jdbc:mysql://192.168.3.1:3306/kingki_test
    username: root
    password: root
    driver-class-name: com.mysql.jdbc.Driver
    type: com.alibaba.druid.pool.DruidDataSource
    maxActive: 20
    initialSize: 1
    maxWait: 60000
    minIdle: 1
    timeBetweenEvictionRunsMillis: 60000
    minEvictableIdleTimeMillis: 300000
    validationQuery: select 'x'
    testWhileIdle: true
    testOnBorrow: false
    testOnReturn: false
    poolPreparedStatements: true
    maxOpenPreparedStatements: 20

注意点

Dao所存放的包名要与配置类一致

Mapper所存放的包名要与配置类一致

转载请注明来源 https://blog.csdn.net/qq_44048958/article/details/107234634