springboot下使用JdbcTemplate和MongoTemplate链接多个mongodb源+sql源

本文介绍了如何在SpringBoot应用中使用JdbcTemplate和MongoTemplate同时连接多个MongoDB数据源以及SQL数据源。配置文件application.yml中详细配置了数据源，DBConfig.java为配置类。注意，当MongoDB的URI中包含特殊字符如'@'时，需要进行URL编码。此外，使用twoMongoTemplate会导致插入数据时自动生成 '_class' 键，如要避免，可以参照oneMongoTemplate的配置。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

application.yml配置

db:
  mongo:
    one: "mongodb://[user]:[pwd]@[ip]:[port]/[db]"
    two: "mongodb://[user]:[pwd]@[ip]:[port]/[db]"
  sql:
     url:"jdbc:sqlserver://ip;DatabaseName=;instanceName="
     user: "test"
     pwd: "test"
     driver: "com.microsoft.sqlserver.jdbc.SQLServerDriver"

配置类：DBConfig.java

@Configuration
public class DBConfig {

    @Value("${db.sql.url}")
    private String sqlUrl;
    @Value("${db.sql.user}")
    private String sqlUsername;
    @Value("${db.sql.pwd}")
    private String sqlPassword;
    @Value("${db.sql.driver}")
    private String sqlDriver;

    @Value("${db.mongo.one}")
    private String mongoOneUri;

    @Value("${db.mongo.two}")
    private String mongoTwoUri;

    @Bean(name = "sqlDataSource")
    public DataSource sourceDataSource() {
        DruidDataSource dataSource = new DruidDataSource();
        dataSource.setDriverClassName(sqlDriver);
        dataSource.setUrl(sqlUrl);
        dataSource.setUsername(sqlUsername);
        dataSource.setPassword(sqlPassword);
        return dataSource;
    }

    @Bean(name = "oneMongoFactory")
    @Primary
    public MongoDbFactory oneMongoDbFactory() throws Exception {
        return new SimpleMongoDbFactory(new MongoClientURI(mongoOneUri));
    }

    @Bean(name = "twoMongoDbFactory")
    public MongoDbFactory twoMongoDbFactory() throws Exception {
        return new SimpleMongoDbFactory(new MongoClientURI(mongoTwoUri));
    }

    @Bean(name = "sqlJdbcTemplate")
    public JdbcTemplate JdbcTemplate(@Qualifier("sqlDataSource") DataSource dataSource) {
        return new JdbcTemplate(dataSource);
    }

    @Bean(name = "oneMongoTemplate")
    @Primary
    public MongoTemplate oneMongoTemplate(@Qualifier("oneMongoFactory") MongoDbFactory mongoDbFactory) {
        MappingMongoConverter mappingMongoConverter = new MappingMongoConverter(new DefaultDbRefResolver(mongoDbFactory),
                new MongoMappingContext());
        mappingMongoConverter.setTypeMapper(new DefaultMongoTypeMapper(null));
        return new MongoTemplate(mongoDbFactory, mappingMongoConverter);
    }

    @Bean(name = "twoMongoTemplate")
    public MongoTemplate twoMongoTemplate(@Qualifier("twoMongoDbFactory") MongoDbFactory mongoDbFactory) {
        return new MongoTemplate(mongoDbFactory);
    }