Springboot中整合Mybatis，Mapper和Mapper.xml不在一个目录下的问题！org.apache.ibatis.binding.BindingException: Invalid

绝地灬酷狼 2024-03-31 13:44 5阅读 0赞

近期在springboot整合Mybatis和Thymeleaf模板的过程中出了一个小错误。

学过mybatis的同学都知道，**mapper接口和mapper.xml要在一个目录下面**

![c1dfc419c04a4517804b79c26eb5f4b4.png][]

本人由于在操作的过程很懒 复制了很多东西 所以就出现了下面这个错误。

org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.javaee\_3.mapper.CourseMapper.getAll

尝试了网上诸多办法 还是不行，于是我使用下面的办法：

**①**把**resources**下 com.javaee\_3.mapper 目录先**删除**

**②**一步步**重新创建目录文件**，新建**com**，新建**javaee\_3**，新建**mapper**，然后再把CourseMapper.xml加入子目录

**③**在maven插件那里**clean** 然后再重新运行。

④查看target 文件， 看两文件是否打包在一个文件夹。

![3d33d6d807894e35859c52e5f0777a12.png][]

到这步 ，应该就没什么大问题咯~

下面分享一下我在Springboot整合mybatis和Thymeleaf模板的maven文件

<?xml version="1.0" encoding="UTF-8"?>
    <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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
        <modelVersion>4.0.0</modelVersion>
        <groupId>com</groupId>
        <artifactId>JAVAEE_3</artifactId>
        <version>0.0.1-SNAPSHOT</version>
        <name>JAVAEE_3</name>
        <description>JAVAEE_3</description>
    
        <properties>
            <java.version>1.8</java.version>
            <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
            <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
            <spring-boot.version>2.3.7.RELEASE</spring-boot.version>
        </properties>
    
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-thymeleaf</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
    
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
                <exclusions>
                    <exclusion>
                        <groupId>org.junit.vintage</groupId>
                        <artifactId>junit-vintage-engine</artifactId>
                    </exclusion>
                </exclusions>
            </dependency>
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>2.2.0</version>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <scope>runtime</scope>
            </dependency>
    
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>druid</artifactId>
                <version>1.1.16</version>
            </dependency>
    
            <dependency>
                <groupId>net.sourceforge.nekohtml</groupId>
                <artifactId>nekohtml</artifactId>
                <version>1.9.22</version>
            </dependency>
    
    
    
    
        </dependencies>
    
        <dependencyManagement>
            <dependencies>
                <dependency>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-dependencies</artifactId>
                    <version>${spring-boot.version}</version>
                    <type>pom</type>
                    <scope>import</scope>
                </dependency>
            </dependencies>
        </dependencyManagement>
    
        <build>
    
            
            <resources>
                <resource>
                    <directory>src/main/java</directory>
                    <includes>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                    </includes>
    
                </resource>
                <resource>
                    <directory>src/main/resources</directory>
                    <includes>
                        <include>**/*</include>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                        <include>**/*.yml</include>
                        <include>**/*.html</include>
                        <include>**/*.js</include>
                        <include>**/*.css</include>
                        <include>**/*.map</include>
                        <include>**/*.jpg</include>
                        <include>**/*.png</include>
                        <include>**/*.CAB</include>
                        <include>**/*.ico</include>
                    </includes>
    
                </resource>
            </resources>
    
    
    
            <plugins>
                <plugin>
                    <groupId>org.apache.maven.plugins</groupId>
                    <artifactId>maven-compiler-plugin</artifactId>
                    <version>3.8.1</version>
                    <configuration>
                        <source>1.8</source>
                        <target>1.8</target>
                        <encoding>UTF-8</encoding>
                    </configuration>
                </plugin>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                    <version>2.3.7.RELEASE</version>
                    <configuration>
                        <mainClass>com.javaee_3.Javaee3Application</mainClass>
                    </configuration>
                    <executions>
                        <execution>
                            <id>repackage</id>
                            <goals>
                                <goal>repackage</goal>
                            </goals>
                        </execution>
                    </executions>
                </plugin>
            </plugins>
        </build>
    
    </project>

观众老爷，留个点赞吧~

[c1dfc419c04a4517804b79c26eb5f4b4.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/d8fdd93605ec414c924b5253dcabded0.png
[3d33d6d807894e35859c52e5f0777a12.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/31/abcd7c4b67134a6e8f94c1dae74f4fbe.png