【Mybatis】Mybatis问题解决

Mybatis目前遇到的问题整合

1.找不到xml文件的整合

Java.lang.ExceptionInInitializerError

Caused by: org.apache.ibatis.exceptions.PersistenceException:

Caused by: java.io.IOException: Could not find resource com/cxy/dao/UserMapper.xml

解决 : xml默认只可以读取到resource文件中的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>true</filtering>
            </resource>
        </resources>
    </build>

成功

2.字符集出现错误

解决

在pom文件中设置

    <!--设置字符集-->
    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    </properties>

3.路径错误

使用resource导入的必须使用’/’

使用class可以使用点

其他解决–>

4.mysql8以上在配置时需要把ssl配置为false

java.lang.ExceptionInInitializerError

Caused by: java.lang.ClassNotFoundException: Cannot find class: com.cxy.dao.UserMapper.xml
at org.apache.ibatis.io.ClassLoaderWrapper.classForName(ClassLoaderWrapper.java:200)
at org.apache.ibatis.io.ClassLoaderWrapper.classForName(ClassLoaderWrapper.java:89)
at org.apache.ibatis.io.Resources.classForName(Resources.java:261)
at org.apache.ibatis.builder.xml.XMLConfigBuilder.mapperElement(XMLConfigBuilder.java:381)
at org.apache.ibatis.builder.xml.XMLConfigBuilder.parseConfiguration(XMLConfigBuilder.java:119)

5.mysql8以上需要设置时区

serverTimezone=CST