springboot 报错 IDEA: org.apache.ibatis.binding.BindingException: Invalid bound statement (not found)

最新推荐文章于 2024-07-29 08:42:20 发布

apigfly

最新推荐文章于 2024-07-29 08:42:20 发布

阅读量371

点赞数

分类专栏：填坑笔记文章标签： spring spring boot mybatis java intellij idea

本文链接：https://blog.csdn.net/lijie2664989/article/details/106252383

版权

填坑笔记专栏收录该内容

2 篇文章 0 订阅

订阅专栏

springboot 项目使用 Mapper 时遇到IDEA: org.apache.ibatis.binding.BindingException: Invalid bound statement (not found)异常。
很多次了，老是会忘记，记录一下

原因是找不到我们写的mapper.xml，需增加以下两个地方配置信息：

application.properties

#mbatis 映射
mybatis.type-aliases-package=com.fengmi.mac_keeper
mybatis.mapper-locations=classpath*:com/fengmi/mac_keeper/**/*.xml

pom.xml

编译时增加 resource 过滤xml，这样我们定义的 *Mapper.xml 就能在编译的时候编进去了。

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