SpringBoot配置多数据源

最新推荐文章于 2024-07-24 10:11:49 发布

MyFreeIT

最新推荐文章于 2024-07-24 10:11:49 发布

阅读量58

点赞数

分类专栏： Spring 文章标签： spring boot java 多数据源

创作源自于MyFreeIT

本文链接：https://blog.csdn.net/MyFreeIT/article/details/130651878

版权

Spring 专栏收录该内容

43 篇文章 0 订阅

订阅专栏

yml 文件

spring:
  datasource:
    primary:
      jdbc-url: jdbc:mysql://localhost:3306/
      mybook?useUnicode=true&characterEncoding=utf-8
      username: root
      password: ENC(BHwwNZhfnSS9QLRiWYLuMw==)
      driver-class-name: com.mysql.cj.jdbc.Driver
      
    secondary:
      jdbc-url: jdbc:mysql://localhost:3306/
      mybook2?useUnicode=true&characterEncoding=utf-8
      username: root
      password: ENC(BHwwNZhfnSS9QLRiWYLuMw==)
      driver-class-name: com.mysql.cj.jdbc.Driver

config

@Configuration
public class DataSourceConfig {
	
	@Primary
	@Bean("primaryDataSource")
	@ConfigurationProperties(prefix="spring.datasource.primary")
	public DataSource primaryDataSource() {
		return DataSourceBuilder.create().build();
	}
	
	@Bean("secondaryDataSource")
	@ConfigurationProperties(prefix="spring.datasource.secondary")
	public DataSource secondaryDataSource() {
		return DataSourceBuilder.create().build();
	}
	@Bean("primaryJdbcTemplate")
	public JdbcTemplate primaryJdbcTemplate
	(@Qualifier("primaryDataSource")DataSource dataSource) {
		return new JdbcTemplate(dataSource);
	}
	@Bean("secondaryJdbcTemplate")
	public JdbcTemplate secondaryJdbcTemplate
	(@Qualifier("secondaryDataSource")DataSource dataSource) {
		return new JdbcTemplate(dataSource);
	}
}

DAO

@Repository
public class OrderDAO {
	
	@Resource
	private JdbcTemplate primaryJdbcTemplate;

	//select order by id
	public Order findById(Long id,JdbcTemplate jdbcTemplate) {
		if(jdbcTemplate==null) {jdbcTemplate=primaryJdbcTemplate;}
		String sql = "SELECT * from bookorder WHERE id=?";
		return jdbcTemplate.queryForObject(sql,
		new BeanPropertyRowMapper<>(Order.class),new Object[] {id});
	}
}

Service

@Service
public class OrderServiceImpl implements OrderService{

	@Resource
	private OrderDAO orderDAO;
	
	@Resource
	private JdbcTemplate primaryJdbcTemplate;
	@Resource
	private JdbcTemplate secondaryJdbcTemplate;
	
	@Override
	public Order getOrderById(Long id) {
		return orderDAO.findById(id,null);
	}

	@Override
	public List<Order> getAll(Order order) {
		return orderDAO.findOrderList(order,null);
	}

	@Override
	public void saveOrder(Order order) {
		orderDAO.saveOrder(order,primaryJdbcTemplate);
		orderDAO.saveOrder(order,secondaryJdbcTemplate);
	}
}