<?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:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:context="http://www.springframework.org/schema/context" xsi:schemaLocation="http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans.xsdhttp://www.springframework.org/schema/contexthttp://www.springframework.org/schema/context/spring-context.xsdhttp://www.springframework.org/schema/txhttp://www.springframework.org/schema/tx/spring-tx.xsd">  <context:property-placeholder location="classpath:mysql.properties" ignore-unresolvable="true"/>  <!-- 配置數(shù)據(jù)源 -->  <bean abstract="true" name="parentDatasource" class="com.alibaba.druid.pool.DruidDataSource">    <property name="driverClassName" value="${ds1.jdbc.driverClassName}" />    <!-- 初始化連接大小 -->    <property name="initialSize" value="1" />    <!-- 連接池最大使用連接數(shù)量 -->    <property name="maxActive" value="100" />    <!-- 連接池最小空閑 -->    <property name="minIdle" value="20" />    <!-- 獲取連接最大等待時間 -->    <property name="maxWait" value="30000" />    <!-- <property name="poolPreparedStatements" value="true" /> -->    <!-- <property name="maxPoolPreparedStatementPerConnectionSize" value="33" /> -->    <property name="validationQuery" value="SELECT 1" />    <property name="testOnBorrow" value="true" />    <property name="testOnReturn" value="true" />    <property name="testWhileIdle" value="true" />    <!-- 配置間隔多久才進行一次檢測，檢測需要關閉的空閑連接，單位是毫秒 -->    <property name="timeBetweenEvictionRunsMillis" value="60000" />    <!-- 配置一個連接在池中最小生存的時間，單位是毫秒 -->    <property name="minEvictableIdleTimeMillis" value="25200000" />    <!-- 打開removeAbandoned功能 -->    <property name="removeAbandoned" value="true" />    <!-- 1800秒，也就是30分鐘 -->    <property name="removeAbandonedTimeout" value="1800" />    <!-- 關閉abanded連接時輸出錯誤日志 -->    <property name="logAbandoned" value="true" />    <!-- 監(jiān)控數(shù)據(jù)庫 -->    <!-- <property name="filters" value="stat" /> -->    <property name="filters" value="mergeStat" />  </bean>  <!-- 配置數(shù)據(jù)源 -->  <bean name="dataSource1" init-method="init" destroy-method="close" parent="parentDatasource">    <property name="url" value="${ds1.jdbc.url}" />    <property name="username" value="${ds1.jdbc.username}" />    <property name="password" value="${ds1.jdbc.password}" />  </bean>  <!-- 配置數(shù)據(jù)源 -->  <bean name="dataSource2" init-method="init" destroy-method="close" parent="parentDatasource">    <property name="url" value="${ds2.jdbc.url}" />    <property name="username" value="${ds2.jdbc.username}" />    <property name="password" value="${ds2.jdbc.password}" />  </bean>  <!-- 配置事務管理器 -->  <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">    <property name="dataSource" ref="dataSource1" />  </bean>  <!-- 注解方式配置事物 -->  <tx:annotation-driven transaction-manager="transactionManager" /></beans>

#ds1.jdbc.driverClassName=com.mysql.jdbc.Driverds1.jdbc.url=jdbc:mysql://localhost:3306/process?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNullds1.jdbc.username=rootds1.jdbc.password=rootds2.jdbc.driverClassName=com.mysql.jdbc.Driverds2.jdbc.url=jdbc:mysql://localhost:3306/process?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNullds2.jdbc.username=rootds2.jdbc.password=root

<?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:jee="http://www.springframework.org/schema/jee" xmlns:tx="http://www.springframework.org/schema/tx" xmlns:context="http://www.springframework.org/schema/context" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:task="http://www.springframework.org/schema/task" xmlns:util="http://www.springframework.org/schema/util" xmlns:jaxws="http://cxf.apache.org/jaxws"    xsi:schemaLocation="    http://www.springframework.org/schema/beans    http://www.springframework.org/schema/beans/spring-beans.xsd    http://www.springframework.org/schema/util    http://www.springframework.org/schema/util/spring-util.xsd    http://www.springframework.org/schema/context    http://www.springframework.org/schema/context/spring-context.xsd"    default-lazy-init="false">  <util:properties id="db" location="classpath:mysql.properties"/><!-- 配置數(shù)據(jù)源 -->  <bean name="dataSource1" init-method="init" destroy-method="close" parent="parentDatasource">    <property name="url" value="#{db['ds1.jdbc.url']}" />    <property name="username" value="#{db['ds1.jdbc.username']}" />    <property name="password" value="#{db['ds1.jdbc.password']}" />  </bean></beans>

name=rickyage=27password=root

<!-- 使用注解注入properties中的值 -->  <bean id="config"     class="org.springframework.beans.factory.config.PropertiesFactoryBean">    <property name="locations">      <list>        <value>classpath:config.properties</value>      </list>    </property>    <!-- 設置編碼格式 -->    <property name="fileEncoding" value="UTF-8"></property>  </bean>

package com.ricky.codelab.springmvc.domain;import org.springframework.beans.factory.annotation.Value;import org.springframework.stereotype.Component;/** * ${DESCRIPTION} * * @author Ricky Fung * @create 2016-08-08 15:49 */@Component("userService")public class UserServiceImpl implements IUserService {  private final Logger logger = LoggerFactory.getLogger(getClass());  @Value("#{config[name]}")  private String name;  @Value("#{config[age]}")  private Integer age;  @Value("#{config[password]}")  private String password;  @Override  public void login(String username){    System.out.println("name:"+name+",age="+age+",password="+password);  }}