动态设置数据源的方法

一个需求，数据源账户和密码还有连接地址是从前台页面传入Spring的配置文件的，如何动态的设置数据源呢？经过研究发现使用动态代理可以解决这个问题（Spring提供了org.springframework.beans.factory.config.MethodInvokingFactoryBean）

代码如下所示

package com.capinfo.test;
/**
 * 用于设置 数据源的 连接、密码等。
 * @author capinfo
 *
 */
public class DataSourceParms {
    private static String url;//连接地址
    private static String username;//用户名
    private static String password;//密码

    public static  String getUrl() {
        return url;
    }
    public static void setUrl(String url) {
        DataSourceParms.url = url;
    }
    public static  String getUsername() {
        return username;
    }
    public static  void setUsername(String username) {
        DataSourceParms.username = username;
    }
    public static  String getPassword() {
        return password;
    }
    public static  void setPassword(String password) {
        DataSourceParms.password = password;
    }

}

**需要注意的是一定要设置为 static的方法否则就会报错。

<?xml version="1.0" encoding="UTF-8"?>  
<beans xmlns="http://www.springframework.org/schema/beans"  
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  
       xmlns:aop="http://www.springframework.org/schema/aop"  
       xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd  
                           http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd"  
       default-lazy-init="true"> 

   <bean id="dataSourceKingBase" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">
        <!-- 基本属性 url、user、password  jdbc:kingbase://1.0.7.101:54321/OFFICIALV2  SYSTEM WLH62128876-->  
        <property name="url">
            <ref local="urlHelper"/>
        </property>  
        <property name="username">
            <ref local="nameHelper"/>
        </property>  
        <property name="password">
            <ref local="pswHelper"/>
        </property>
        <property name="driverClassName" value="com.kingbase.Driver"></property>  

        <!-- 配置初始化大小、最小、最大 -->  
        <property name="initialSize" value="1" />  
        <property name="minIdle" value="1" />   
        <property name="maxActive" value="20" />  

        <!-- 配置获取连接等待超时的时间 -->  
        <property name="maxWait" value="60000" />  

        <!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 -->  
        <property name="timeBetweenEvictionRunsMillis" value="60000" />  

        <!-- 配置一个连接在池中最小生存的时间，单位是毫秒 -->  
        <property name="minEvictableIdleTimeMillis" value="300000" />  

        <property name="validationQuery" value="SELECT 'x'" />  
        <property name="testWhileIdle" value="true" />  
        <property name="testOnBorrow" value="false" />  
        <property name="testOnReturn" value="false" />  

        <!-- 打开PSCache，并且指定每个连接上PSCache的大小 -->  
        <property name="poolPreparedStatements" value="true" />  
        <property name="maxPoolPreparedStatementPerConnectionSize" value="20" />  

        <!-- 配置监控统计拦截的filters，去掉后监控界面sql无法统计 -->  
        <property name="filters" value="stat" />   
    </bean>

    <bean id="transactionManagerOracle"
            class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSourceOracle" />
    </bean>


     <bean id="jdbcTemplateKingBase" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSourceKingBase" />
    </bean>


     <bean id="urlHelper"
        class="org.springframework.beans.factory.config.MethodInvokingFactoryBean">
        <property name="targetClass">
            <value>com.capinfo.test.DataSourceParms</value>
        </property>
        <!-- 必须全是静态的方法 -->
        <property name="targetMethod">
            <value>getUrl</value>
        </property>
    </bean>

    <bean id="nameHelper"
        class="org.springframework.beans.factory.config.MethodInvokingFactoryBean">
        <property name="targetClass">
            <value>com.capinfo.test.DataSourceParms</value>
        </property>
        <property name="targetMethod">
            <value>getUsername</value>
        </property>
    </bean>


    <bean id="pswHelper"
        class="org.springframework.beans.factory.config.MethodInvokingFactoryBean">
        <property name="targetClass">
            <value>com.capinfo.test.DataSourceParms</value>
        </property>
        <property name="targetMethod">
            <value>getPassword</value>
        </property>
    </bean>
</beans>

测试类

package com.capinfo.test;
import java.sql.Connection;
import java.sql.SQLException;

import javax.sql.DataSource;

import org.junit.Test;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;


public class DynOraTest {
    /**
     * jdbc:kingbase://1.0.7.101:54321/OFFICIALV2  SYSTEM WLH62128876
     */
    @Test
    public void test(){
        DataSourceParms dsp = new DataSourceParms();
        dsp.setUrl("jdbc:kingbase://localhost:54321/OFFICIALV2");
        dsp.setUsername("SYSTEM");
        dsp.setPassword("WLH62128876");

        //dataSourceKingBase

        ApplicationContext ctx = new ClassPathXmlApplicationContext(new String[] {"spring-datasource-kingbase.xml"});
        com.capinfo.test.ClassTest ctest = (com.capinfo.test.ClassTest)ctx.getBean("cstest");
        System.out.println(ctest.getName());
        DataSource dsk = (DataSource)ctx.getBean("dataSourceKingBase");

        try {
            Connection conn = dsk.getConnection();
            System.out.println(conn);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
}