-
根据mybatis官方文档得,mybatis-config.xml文件中连接数据库的代码如下:
<?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/table_namw"/> <property name="username" value="root"/> <property name="password" value="123456"/> </dataSource> </environment> </environments> <mappers> <!-- 将sql映射文件注册到全局配置文件中--> <mapper resource="EmployeeMapper.xml"/> </mappers> </configuration>
-
如果使用的mysql是8.0以上,则需将driver属性改为以下内容:
<property name="driver" value="com.mysql.cj.jdbc.Driver"/>
-
更改后还需在maven中添加mysql对应版本的依赖
<dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.24</version> </dependency>
ref:
Mybatis报错Cannot find class: com.mysql.cj.jdbc.Driver排查踩坑记录 - Angelatyd - 博客园 (cnblogs.com)