Spring boot 配置 SqlSessionFactory

亦凉 2022-05-08 14:50 370阅读 0赞

**Spring官方提供了比较完善的数据库配置，但是某些情况下需要自己手动加载(如：配置多数据源)**  
以下是我搜集并整理出来的一个configuration，不足之处或错误请大家提出并指正

package cn.xt.config;
    
    import org.mybatis.spring.SqlSessionFactoryBean;
    import org.slf4j.Logger;
    import org.slf4j.LoggerFactory;
    import org.springframework.beans.factory.annotation.Value;
    import org.springframework.context.annotation.Bean;
    import org.springframework.context.annotation.Configuration;
    import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
    
    import javax.naming.Context;
    import javax.naming.InitialContext;
    import javax.sql.DataSource;
    
    /**
     * SqlSession配置
     */
    @Configuration
    public class SqlSessionConfig {
    
        private Logger logger = LoggerFactory.getLogger(SqlSessionConfig.class);
    
        @Value("${spring.datasource.jndi-name}")
        private String dataSourceJndiName;
    
        @Value("${mybatis.mapper-locations}")
        private String mapperLocations;
    
        @Bean
        public SqlSessionFactoryBean createSqlSessionFactory() {
            SqlSessionFactoryBean sqlSessionFactoryBean = null;
            try {
                // 加载JNDI配置
                Context context = new InitialContext();
                DataSource dataSource = (DataSource)context.lookup(dataSourceJndiName);
    
                // 实例SessionFactory
                sqlSessionFactoryBean = new SqlSessionFactoryBean();
                // 配置数据源
                sqlSessionFactoryBean.setDataSource(dataSource);
    
                // 加载MyBatis配置文件
                PathMatchingResourcePatternResolver resourcePatternResolver = new PathMatchingResourcePatternResolver();
                // 能加载多个，所以可以配置通配符(如：classpath*:mapper/**/*.xml)
                sqlSessionFactoryBean.setMapperLocations(resourcePatternResolver.getResources(mapperLocations));
                // 配置mybatis的config文件(我目前用不上)
                // sqlSessionFactoryBean.setConfigLocation("mybatis-config.xml");
            } catch (Exception e) {
                logger.error("创建SqlSession连接工厂错误：{}", e);
            }
            return sqlSessionFactoryBean;
        }
    }

yml中，JNDI的 配置

spring:
      # db
      datasource:
        jndi-name: 'java:comp/env/jdbc/spring_db'
        
    # mybatis config
    mybatis:
      mapper-locations: classpath*:mapper/**/*.xml

tomcat的context.xml 中的配置