spring.xml从外部文件引入数据库配置信息

<!-- 分散配置 -->
 2     <context:property-placeholder location="classpath:jdbc.properties" />
 3 
 4     <!-- 数据源 -->
 5     <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
 6         <property name="driverClass" value="${jdbc.driverclass}" />
 7         <property name="jdbcUrl" value="${jdbc.url}"></property>
 8         <property name="user" value="${jdbc.username}" />
 9         <property name="password" value="${jdbc.password}" />
10 
11         <property name="maxPoolSize" value="${c3p0.pool.size.max}" />
12         <property name="minPoolSize" value="${c3p0.pool.size.min}" />
13         <property name="initialPoolSize" value="${c3p0.pool.size.ini}" />
14         <property name="acquireIncrement" value="${c3p0.pool.size.increment}" />
15     </bean>

 

jdbc.properties

 1 jdbc.driverclass=com.mysql.jdbc.Driver
 2 jdbc.url=jdbc:mysql://localhost:3306/springmvcdb?characterEncoding=utf-8
 3 jdbc.username=root
 4 jdbc.password=root
 5 
 6 c3p0.pool.size.max=10
 7 c3p0.pool.size.min=2
 8 c3p0.pool.size.ini=3
 9 c3p0.pool.size.increment=2
10 
11 hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
12 hibernate.show_sql=true

 

 

 1     <!-- 加载外部的properties文件（方式一），用于解析${}形式的变量。 
 2         如果需要加载多个properties文件，就写在一起，之间使用逗号隔开。
 3     <context:property-placeholder location="classpath:cn/yht/spring/k_placeholder/jdbc.properties"/>
 4     -->
 5 
 6     <!-- 加载外部的properties文件（方式二） 
 7     <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
 8         <property name="locations">
 9             <list>
10                 <value>classpath:cn/yht/spring/k_placeholder/jdbc.properties</value>
11             </list>
12         </property>
13     </bean>