NamedParameterJdbcTemplate多数据源指定数据源

蓝bluee

已于 2023-06-12 15:27:17 修改

阅读量666

点赞数

文章标签： mybatis java spring sql

于 2023-06-12 15:25:26 首次发布

本文链接：https://blog.csdn.net/qq_35106903/article/details/131164072

版权

实战例子记录

pom

        <!-- https://mvnrepository.com/artifact/com.github.miemiedev/mybatis-paginator -->
        <dependency>
            <groupId>com.github.miemiedev</groupId>
            <artifactId>mybatis-paginator</artifactId>
            <version>1.2.17</version>
        </dependency>

config

package com.config;

import com.github.miemiedev.mybatis.paginator.OffsetLimitInterceptor;
import com.zaxxer.hikari.HikariDataSource;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.jdbc.DataSourceBuilder;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;

import javax.sql.DataSource;

@Configuration
@MapperScan(basePackages = "com.dao.gp", sqlSessionFactoryRef = "gpSqlSessionFactory")
public class GpDatasourceConfig {
    private String mapperLocal = "com/dao/gp/**/*Mapper.xml";

    @ConfigurationProperties(prefix = "spring.datasource.gp")
    @Bean("GpDatasource")
    public DataSource gpDataSource()