狂神课程Mybatis程序报错：org.apache.ibatis.exceptions.PersistenceException，Cause: java.lang.ClassNotFoundException: Cannot find class: com.mysql.cj.jdbc.Driver

报错：

org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: java.sql.SQLException: Error setting driver on UnpooledDataSource. Cause: java.lang.ClassNotFoundException: Cannot find class: com.mysql.cj.jdbc.Driver
### The error may exist in com/kuang/dao/UserMapper.xml
### The error may involve com.kuang.dao.UserMapper.getUserList
### The error occurred while executing a query
### Cause: java.sql.SQLException: Error setting driver on UnpooledDataSource. Cause: java.lang.ClassNotFoundException: Cannot find class: com.mysql.cj.jdbc.Driver

 

检查原因：mybatis-config.xml中driver配置错误,如下：

<property name="driver" value="com.mysql.cj.jdbc.Driver"/>

因为我用的mysql-connector-java：5.1.46，而 mysql-connector-java 6.0 以下的不需要cj，即改成：
<property name="driver" value="com.mysql.jdbc.Driver"/>

运行成功！

 

在找原因的时候发现出现这个错误绝大多数都是mybatis-config.xml配置错误，所以把我的放在这啦，大家可以对照检查一下（username和password要根据自己设置的来填）。

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">


<configuration>


    <environments default="development">

        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://localhost:3306/mybatis?useSSL=false&amp;useUnicode=true&amp;characterEncoding=utf8&amp;serverTimezone=GMT%2B8"/>
                <property name="username" value="root"/>
                <property name="password" value="abc123"/>
            </dataSource>
        </environment>

    </environments>
    
    <mappers>
        <mapper resource="com/kuang/dao/UserMapper.xml"/>
    </mappers>
</configuration>