service层报错Invalid bound statement (not found)，但调用mapper层不报错

港控/mmm° 2024-03-26 20:47 27阅读 0赞

如题：在testcontroller调用service层里的方法，报错，直接调用service层内部的mapper层的方法不报错。

解决如下：

出错点是启动类的@MapperScan扫描不到位，要扫到下一个具体的包

将@MapperScan("com.huangxinyi.petmanage")改为

@MapperScan("com.huangxinyi.petmanage.mapper")

**包名要根据自身项目对应更改**

项目结构如下：

![1ad94527df5c4ff7851bd183e2f18ffd.png][]

test如下：

![064a2afb42a74c07b6026ecdd514d93e.png][]

错误如下：

![300a502b81cc4fb7b3907a4cd7c4b1f4.png][]

service层、serviceimpl层如下：

![501fef81624841d4afadf4a09ae727bb.png][]

mapper、mapper.xml如下

![7df72c3b459c434e8625d959d5450b37.png][]

yml文件、启动类如下

![059a5f3000c445ebb309f1e218e7149e.png][]

参考文档：

[service层找不到方法 Invalid bound statement (not found)\_万如的博客-CSDN博客][service_ Invalid bound statement _not found_-CSDN]

[service层调用接口报错：Invalid bound statement 无效的绑定\_invalid bound statement (not found): service\_csdn4006600的博客-CSDN博客][service_Invalid bound statement _invalid bound statement _not found_ service_csdn4006600_-CSDN]

[1ad94527df5c4ff7851bd183e2f18ffd.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/8e14f828c3aa49aab97ac4e072d3b558.png
[064a2afb42a74c07b6026ecdd514d93e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/b5e71dcbfffb4f7f9e153cefa635229a.png
[300a502b81cc4fb7b3907a4cd7c4b1f4.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/745992bed3184a1494b07a7e0a4f5ad1.png
[501fef81624841d4afadf4a09ae727bb.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/7771f9223c1049fd85215c2e66616410.png
[7df72c3b459c434e8625d959d5450b37.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/52038e0ed6364c01a7f52d1fa4417af6.png
[059a5f3000c445ebb309f1e218e7149e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/25/02c5e33f154e49dca6877ab2c66d678b.png
[service_ Invalid bound statement _not found_-CSDN]: https://blog.csdn.net/weixin_43846827/article/details/110823126
[service_Invalid bound statement _invalid bound statement _not found_ service_csdn4006600_-CSDN]: https://blog.csdn.net/CSDN4006600/article/details/97934328