为便于更改数据库连接配置,可以将有关数据库的信息单独放在jdbc.properties文件中。(名字随便命了)
jdbc.properties
- jdbc.driverClassName=com.mysql.jdbc.Driver
- jdbc.url=jdbc\:mysql\://localhost\:3306/demo
- jdbc.username=root
- jdbc.password=root
- jdbc.initialPoolSize=5
- jdbc.minPoolSize=5
- jdbc.maxPoolSize=100
spring配置文件applicationContext中的相关设置
- <bean id="propertyConfigurer"
- class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
- <property name="location">
- <value>classpath:jdbc.properties</value>
- <!-- <value></WEB-INF/jdbc.properties</value> -->
- </property>
- </bean>
- <bean id="dataSource"
- class="org.springframework.jdbc.datasource.DriverManagerDataSource">
- <property name="driverClassName" value="${jdbc.driverClassName}" />
- <property name="url" value="${jdbc.url}" />
- <property name="username" value="${jdbc.username}" />
- <property name="password" value="${jdbc.password}" />
- </bean>
注:propertyConfigurer