Spring架构中集成Druid

Druid的坑

原来数据源这么配置

<!--数据源配置-->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
    <property name="driverClassName" value="${driverClassName}"/>
    <property name="url" value="${url}"/>
    <property name="username" value="${username}"/>
    <property name="password" value="${password}"/>
    <property name="maxActive" value="10" />
    <property name="minIdle" value="5" />
</bean>

driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/ssmbuild?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=true
username=root
password=root

测试的时候报了一个奇怪的错误:

Caused by: java.sql.SQLException: Access denied for user 'jzhao'@'localhost' (using password: YES)

jzhao是我的主机名
问题出在jdbc.properties文件中变量的名字

下面为修改内容：

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3306/ssmbuild?useUnicode=true&characterEncoding=utf-8&autoReconnect=true&useSSL=true
jdbc.username=root
jdbc.password=root

<!--数据源-->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
    <property name="driverClassName" value="${jdbc.driver}"/>
    <property name="url" value="${jdbc.url}"/>
    <property name="username" value="${jdbc.username}"/>
    <property name="password" value="${jdbc.password}"/>
    <property name="maxActive" value="10" />
    <property name="minIdle" value="5" />
</bean>

所有参数前加“jdbc.”，这样就没问题！