Invalid bound statement (not found)出现原因和解决方法

忘是亡心i 2024-03-26 17:25 106阅读 0赞

![3eefa0160a24413fba4f19feeac1e282.png][]

出现这种异常情况一般是因为MybatisPlus没有找到对应的Mapper映射文件。

一、检查mapper文件的namespace是否和mapper接口的全类名一致。

二、检查询语句和java方法的返回值是否一致。resuleMap是否映射成功。

三、在配置文件中指定mapper的位置。

![87412ffaaca71d65f131103af70ba331.png][]

如果mapper的位置是在src路径下，需要在pom.xml文件下设置将非java文件也进行编译。默认情况下只会编译Java文件。

<build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
            </plugins>
            <resources>
                <resource>
                    <directory>src/main/java</directory>
                    <includes>
                        <include>**/*.yml</include>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
                <resource>
                    <directory>src/main/resources</directory>
                    <includes>
                        <include>**/*.yml</include>
                        <include>**/*.properties</include>
                        <include>**/*.xml</include>
                    </includes>
                    <filtering>false</filtering>
                </resource>
            </resources>
        </build>

[3eefa0160a24413fba4f19feeac1e282.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/4787d8b41edd40feae4ad7359b75984c.png
[87412ffaaca71d65f131103af70ba331.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/90b288e9866b4869b62f730306adb871.png