一般我们会将关于数据库的配置属性存放在一个独立的properties文件
以下是属性文件anyview.properties
anyview.driverClassName=com.mysql.jdbc.Driver
anyview.url=jdbc:mysql://localhost:3306/anyviewdb?useUnicode=true&characterEncoding=UTF-8
anyview.username=root
anyview.password=12345678
c3p0.acquireIncrement=3
c3p0.initialPoolSize=3
c3p0.maxIdleTime=60
c3p0.maxPoolSize=15
c3p0.minPoolSize=10
c3p0.checkoutTimeout=1000
首先,要在Spring的配置文件中导入该文件中的属性
<!-- 导入数据库配置文件信息 -->
<bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="locations">
<value>anyview.properties</value>
</property>
<property name="ignoreUnresolvablePlaceholders" value="true"/>
</bean>
接着,配置dataSource
<!-- 配置dataSource -->
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="${anyview.driverClassName}" />
<property name="url" value="${anyview.url}" />
<property name="username" value="${anyview.username}" />
<property name="password" value="${anyview.password}" />
</bean>