Error querying database.Cause: java.sql.SQLException: Error setting driver on UnpooledDataSource

    科技2022-07-11  120

    mybatis执行增删改查是报错:Error querying database. Cause: java.sql.SQLException: Error setting driver on UnpooledDataSource. Cause: java.lang.ClassNotFoundException: Cannot find class: com.mysql.jdbc.Driver

    在学习最基本的Mybatis配置运行时报出了这样一个错误,出现的问题是没有成功加载driver驱动,至于为什么出现这种情况,我自己在写代码中发现出现这种问题的两种情况: 1.查看配置文件

    <?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="one"> <environment id="one"> <transactionManager type="JDBC"/> <dataSource type="POOLED"> <!-- 数据库的驱动--> <property name="driver" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost:3306/jdbcsql"/> <property name="username" value="root"/> <property name="password" value="123456"/> </dataSource> </environment> </environments> <mappers> <mapper resource="com/wangmaomao/mybatis/mapper/moneymapper.xml"/> </mappers> </configuration>

    查看下面图片的配置内容是否正确

    2.在导入jar包时是否导入mysql驱动jar包;mysql jar包下载

    Processed: 0.037, SQL: 8