[Java知识库]记录一下mybatis第一个程序遇到的坑，狂神Mybatis课程

记录一下mybatis第一个程序遇到的坑

<!--    设置资源目录,使其可以读取dao下xml文件-->
<build>
    <resources>
        <resource>
            <directory>src/main/resources</directory>
            <includes>
                <include>**/*.properties</include>
                <include>**/*.xml</include>
            </includes>
            <filtering>true</filtering>
        </resource>
        <resource>
            <directory>src/main/java</directory>
            <includes>
                <include>**/*.properties</include>
                <include>**/*.xml</include>
            </includes>
            <filtering>false</filtering>
        </resource>
    </resources>
</build>

在父工程maven中添加此端配置同时filtering那里改成true也可以

IDEA字符编码集设置

在file-settings-editor-file coding那里修改字符集编码格式都为utf-8

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="mysql">

        <environment id="mysql">

            <!-- 使用JDBC事务管理器，目前由MyBatis管理 -->
            <transactionManager type="JDBC"/>

            <!-- 配置DataSource标准数据源，目前由MyBatis管理 -->
            <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=UTF-8"/>
                <property name="username" value="root"/>
                <property name="password" value="123456"/>
            </dataSource>

        </environment>

    </environments>

    <mappers>
        <mapper resource="com/chen/dao/UserMapper.xml"/>
    </mappers>

</configuration>