Spring利用继承DelegatingDataSource实现多数据源切换
根据用户所在的区域切换到自己区域的数据源，
自定义DataSource继承org.springframework.jdbc.datasource.DelegatingDataSource并且重写
?public Connection getConnection() throws SQLException方法
public Connection getConnection() throws SQLException { AgilityUserBean userBean = ThreadContext.getUser(); if(userBean != null){System.out.println("the system will user " + dataSourceName + userBean.getLocale() + " dataSource");ds = ApplicationContext.getInstance().getBean(dataSourceName + userBean.getLocale()); if(ds == null){ throw new SQLException("can't find the dataSource for this region."); } setTargetDataSource((DataSource)ds); }else{ System.out.println("System use default dataSource " + dataSourceName); } Assert.state(getTargetDataSource() != null, "targetDataSource is required"); Connection con = null; try { con = getTargetDataSource().getConnection(); } catch (SQLException e) { logger.error("Error occured during connection request. Thread name = " + Thread.currentThread().getName()); logger.error("Listing binded to thread resources..."); throw e; } return con; }?
经过简单的验证可行，不知道这样是否完全正确，希望大家拍砖！
?
?