系统下多数据库用户配置

<!--[一个大的系统将不同的表放在不同的域下,这就要求配置多个数据库连接信息]-->
datasource.xml:
<bean name="huakeDataSource"
    <!--框架jdbc相关的基础类-->
    class="com.qingyuan.huake.spring.datasource.BaseDataSource"
    destroy-method="close">
	<!--借助[spring框架]底层相关的类,直接读取jdbc.properites配置文件信息-->
    <property name="driverClassName"  value="${qingyuan_huake.driver}" />
        <property name="url"              value="${qingyuan_huake.url}" />
        <property name="username"         value="${qingyuan_huake.user}" />
        <property name="password"         value="${qingyuan_huake.password}" />
        <property name="dbType"           value="${qingyuan_huake.dbtype}" />
        <property name="maxActive"        value="${qingyuan_huake.active}" />
        <property name="maxIdle"          value="${qingyuan_huake.idle}" />
        <property name="minIdle"          value="${qingyuan_huake.idle}" />
        <property name="maxWait"          value="${qingyuan_huake.maxwait}" />
        <property name="spareDatasource">
            <list>
               <value>qingyuanHuakeBackup</value>
            </list>
    </property>
</bean>

-- jdbc.properties
qingyuan_huake.driver=oracle.jdbc.driver.OracleDriver
qingyuan_huake.url=jdbc:oracle:thin:@xx.xx.xx.xx:1521:orcl
qingyuan_huake.user=quanyuan
qingyuan_huake.password=
qingyuan_huake.dbtype=oracle
qingyuan_huake.level=2
qingyuan_huake.active = 5
qingyuan_huake.idle = 5
qingyuan_huake.maxwait = 5000

--xx-sql.xml
<sqlmap>
	<!-- 自动办结配置  -->
	<sql id="qingyuan_huake_testConfig" datasource="huakeDataSource">
	 <content>
	   <![CDATA[
	    -- related sql goes in here!! 
	   ]]>
	 </content>
	</sql>
</sqlmap>