springboot+mybatis 多数据源(含事务)

1.配置文件

server.port=9000
spring.application.name=springboot


mybatis.type-aliases-package=olading.springboot.springboot.entity

spring.datasource.p.driverClassName = com.mysql.jdbc.Driver
//注意，一定是jdbc-url，否则系统启动异常
spring.datasource.p.jdbc-url =jdbc:mysql://localhost/root?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
spring.datasource.p.username = root
spring.datasource.p.password = root
//这里第二个数据源利用了相同的配置，懒得替换了
spring.datasource.s.driverClassName = com.mysql.jdbc.Driver
spring.datasource.s.jdbc-url =jdbc:mysql://localhost/root?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
spring.datasource.s.username = root
spring.datasource.s.password = root


mybatis.config-locations=classpath:mybatis/mybatis-config.xml
mybatis.mapper-locations=classpath:mybatis/mapper/*.xml

2. 配置（关键）

@Configuration
@MapperScan(basePackages = "olading.springboot.springboot.mapper.p",sqlSessionTemplateRef ="pSqlSessionTemplate" )
@MapperScan(basePackages = "olading.springboot.springboot.mapper.s",sqlSessionTemplateRef = "sSqlSessionTemplate")
public class MyConfig {
   
    @Bean(name = "pDataSource")
    @ConfigurationProperties(prefix = "spring.datasource.p")
    @Primary
    public DataSource pDataSource() {
   
        return DataSourceBuilder.create().build();
    }

    @Bean(name = "pSqlSessionFactory")
    @Primary
    public SqlSessionFactory pSqlSessionFactory(@Qualifier("pDataSource")DataSource dataSource) throws Exception {
   
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(dataSource);
        bean.setMa