类路径下配置druid.properties:
jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/web?characterEncoding=utf8
jdbc.username=root
jdbc.password=root
initialSize=5
maxActive=50
maxWait=30000
minIdle=3
applicationContext.xml中添加如下代码:
<context:property-placeholder location="classpath:druid.properties"></context:property-placeholder>
<!-- apache 的dbcp数据源,适用于生产使用 -->
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
<property name="driverClassName" value="${jdbc.driverClassName}"></property>
<property name="url" value="${jdbc.url}"></property>
<property name="username" value="${jdbc.username}"></property>
<property name="password" value="${jdbc.password}"></property>
</bean>
<!-- 配置jdbcTemplate -->
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"></property>
</bean>