关于使用ideal 出现Could not get JDBC Connection问题

关于使用ideal 出现Could not get JDBC Connection问题

org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Cannot load JDBC driver class ‘com.mysql.jdbc.Driver’

原因：没有加入mysql依赖，在pom.xml文件加入以下依赖即可。

		<!--引入mysql依赖-->
        <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.6</version>
        </dependency>

		<!--引入DBCP依赖-->
        <!-- https://mvnrepository.com/artifact/org.apache.commons/commons-dbcp2 -->
        <dependency>
            <groupId>org.apache.commons</groupId>
            <artifactId>commons-dbcp2</artifactId>
            <version>2.1.1</version>
        </dependency>

如果还不行，请检查jdbc.properties配置文件如下

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/java1234_test
jdbc.username=root
jdbc.password=root

以及applicationContext.xml问价的配置

	<!--注册属性文件-->
    <context:property-placeholder location="classpath:jdbc.properties"/>

	<!--注册数据源  DBCP数据源-->
    <bean id="dataSource" class="org.apache.commons.dbcp2.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>

`