mybatis+mysql8.0.7配置文件mybatis_config.xml

项目的pom.xml配置文件

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"><modelVersion>4.0.0</modelVersion><groupId>com.jCuckoo</groupId><artifactId>MybatisTest</artifactId><version>0.0.1-SNAPSHOT</version><packaging>jar</packaging><name>MybatisTest</name><url>http://maven.apache.org</url><properties><project.build.sourceEncoding>UTF-8</project.build.sourceEncoding></properties><dependencies><dependency><groupId>junit</groupId><artifactId>junit</artifactId><version>3.8.1</version><scope>test</scope></dependency><!-- https://mvnrepository.com/artifact/org.mybatis/mybatis --><dependency><groupId>org.mybatis</groupId><artifactId>mybatis</artifactId><version>3.4.5</version></dependency><!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java --><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><version>8.0.7-dmr</version></dependency><!-- https://mvnrepository.com/artifact/log4j/log4j --><dependency><groupId>log4j</groupId><artifactId>log4j</artifactId><version>1.2.17</version></dependency></dependencies></project>

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><typeAliases><!-- 一次指定一个类的别名 --><typeAlias alias="role" type="com.jCuckoo.chapter02.pojo.Role"/><!-- 使用自动扫描的形式来定义别名，在Role中使用@Alias("role")注解进行说明--><!-- <package name="com.jCuckoo.chapter02.pojo"/> --></typeAliases><environments default="development"><environment id="development"><transactionManager type="JDBC" /><dataSource type="POOLED"><property name="driver" value="com.mysql.cj.jdbc.Driver" /><property name="url" value="jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT" /><property name="username" value="root" /><property name="password" value="" /></dataSource></environment></environments><mappers><!-- 1.使用文件路径引入映射器 --><mapper resource="com\jCuckoo\chapter02\mapper\RoleMapper.xml" /><!-- 2.使用包名引入映射器 --><!-- <package name="com.jCuckoo.chapter02.mapper" /> --><!-- 3.使用引入映射器 --><!-- <mapper class="com.jCuckoo.chapter02.mapper.RoleMapper"/> --></mappers></configuration> 

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><properties><property name="driver" value="com.mysql.cj.jdbc.Driver" /><property name="url" value="jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT" /><property name="username" value="root" /><property name="password" value="" /></properties><typeAliases><typeAlias alias="role" type="com.jCuckoo.chapter02.pojo.Role" /></typeAliases><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></environments><mappers><mapper resource="com\jCuckoo\chapter02\mapper\RoleMapper.xml" /></mappers></configuration> 

方式一和方式二中的URL被CSDN自动转换，应该是以下格式：

<property name="url" value="jdbc:mysql://localhost:3306/mybatis?useUnicode=true&amp;characterEncoding=utf8&amp;serverTimezone=GMT" />

mybatis_config.xml文件配置方式三：

1）jdbc.properties配置数据库连接信息

driver=com.mysql.cj.jdbc.Driverurl=jdbc:mysql://localhost:3306/mybatis?useUnicode=true&characterEncoding=utf8&serverTimezone=GMTusername=rootpassword=

2）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><properties resource="jdbc.properties"></properties><typeAliases><typeAlias alias="role" type="com.jCuckoo.chapter02.pojo.Role" /></typeAliases><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></environments><mappers><mapper resource="com\jCuckoo\chapter02\mapper\RoleMapper.xml" /></mappers></configuration>