springboot配置mybatis数据源

最新推荐文章于 2024-07-26 15:01:45 发布

Mint6

最新推荐文章于 2024-07-26 15:01:45 发布

阅读量1.1k

点赞数

分类专栏： mybatis 文章标签： springboot mybatis mysql yaml datasource

本文链接：https://blog.csdn.net/Mint6/article/details/91349579

版权

mybatis 专栏收录该内容

22 篇文章 0 订阅

订阅专栏

1.启动类得加上扫描包scanBasePackages

@SpringBootApplication(exclude={DataSourceAutoConfiguration.class},scanBasePackages = {"com.fast.framework","com.fast.web"})
public class FastbootWebApplication {

    public static void main(String[] args) {
        SpringApplication.run(FastbootWebApplication.class, args);
    }

}

2.yaml数据源参数，使用的hikari数据库连接池

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    type: com.zaxxer.hikari.HikariDataSource
    hikari:
      jdbc-url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true
      username: root
      password: root
      max-lifetime: 1765000
      maximum-pool-size: 15

3.包与数据源对应

@Configuration
@MapperScan(basePackages = "com.fast.framework.dao", sqlSessionTemplateRef = "sqlSessionTemplatePrimary")
public class MysqlPrimary {

    @Bean(name = "datsourcePrimary")
    @ConfigurationProperties(prefix = "spring.datasource.primary")
    public DataSource primaryDatsource() {
        return DataSourceBuilder.create().build();
    }

    @Bean(name = "sqlSessionFactoryPrimary")
    public SqlSessionFactory primarySqlSession(@Qualifier("datsourcePrimary") DataSource dataSource) throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(dataSource);
        bean.setMapperLocations(new PathMatchingResourcePatternResolver().getResources("classpath*:/mapper/*.xml"));
        bean.setTypeAliasesPackage("");
        return bean.getObject();
    }

    @Bean(name = "sqlSessionTemplatePrimary")
    public SqlSessionTemplate mainsql(@Qualifier("sqlSessionFactoryPrimary") SqlSessionFactory sqlSessionFactory) {
        return new SqlSessionTemplate(sqlSessionFactory);
    }

    @Bean(name = "datsourcePrimaryManager")
    public DataSourceTransactionManager primaryTransactionManager(@Qualifier("datsourcePrimary") DataSource dataSource) {
        return new DataSourceTransactionManager(dataSource);
    }
}

总结：这个如果想配置更多，可以多添加几个类，把数据源和包位置关系配置对就好了。