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;    }

?

经过简单的验证可行，不知道这样是否完全正确，希望大家拍砖！

?

?