MyBatis配置文件读取properties文件报ClassNotFoundException

2021/5/15

错误代码
db.properties

driver="com.mysql.cj.jdbc.Driver"
url="jdbc:mysql://localhost:3306/mybatis?userSSL=true&useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC"
username="root"
password="1216"

mybatis-config.xml

<environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${driver}"/>
                <property name="url" value="${url}"/>
                <property name="username" value="${username}"/>
                <property name="password" value="${password}"/>
            </dataSource>
        </environment>

抛出异常

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"

原因
在.properties文件中，键和值都是字符串，不需要用一对双引号表示字符串，如果加了引号，引号会被视为字符串的一部分

解决：去掉引号

driver=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/mybatis?userSSL=true&useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
username=root
password=1216