读取properties文件的内容配置数据库

来源：互联网发布：淘宝steam慈善包哪里编辑：程序博客网时间：2024/06/06 02:14

spring配置文件application-context.xml

数据库配置文件 jdbc.properties：

jdbc.driverClassName=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/cms?characterEncoding=UTF-8jdbc.username=rootjdbc.password=123456...

添加到spring父容器的配置文件application-context.xml中

<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">    <property name="locations">        <list>            <value>/WEB-INF/config/jdbc.properties</value>        </list>    </property></bean>

配置dataSource:

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">    <property name="driverClass" value="${jdbc.driverClassName}" />    <property name="jdbcUrl" value="${jdbc.url}" />    <property name="user" value="${jdbc.username}" />    <property name="password" value="${jdbc.password}" />    <property name="autoCommitOnClose" value="true"/>    <property name="checkoutTimeout" value="${cpool.checkoutTimeout}"/>    <property name="initialPoolSize" value="${cpool.minPoolSize}"/>    <property name="minPoolSize" value="${cpool.minPoolSize}"/>    <property name="maxPoolSize" value="${cpool.maxPoolSize}"/>    <property name="maxIdleTime" value="${cpool.maxIdleTime}"/>    <property name="acquireIncrement" value="${cpool.acquireIncrement}"/>    <property name="maxIdleTimeExcessConnections" value="${cpool.maxIdleTimeExcessConnections}"/></bean>

0 0