一、书写配置类,存放所有数据源
@Configuration
public class DatasourceConfig {
@Value("${spring.datasource.url1}")
private String url1;
@Value("${spring.datasource.username1}")
private String username1;
@Value("${spring.datasource.password1}")
private String password1;
@Value("${spring.datasource.url2}")
private String url2;
@Value("${spring.datasource.username2}")
private String username2;
@Value("${spring.datasource.password2}")
private String password2;
@Bean("JdbcTemplate1")
public JdbcTemplate jdbcTemplate1(){
DriverManagerDataSource dataSource = new DriverManagerDataSource(url1,username1,password1);
return new JdbcTemplate(dataSource);
}
@Bean("JdbcTemplate2")
public JdbcTemplate jdbcTemplate2(){
DriverManagerDataSource dataSource = new DriverManagerDataSource(url2,username2,password2);
return new JdbcTemplate(dataSource);
}
}
二、使用数据源
@Autowired
@Qualifier("JdbcTemplate1")
private JdbcTemplate jdbcTemplate1;
@Autowired
@Qualifier("JdbcTemplate2")
private JdbcTemplate jdbcTemplate2;