controller调用service层报错Invalid bound statement (not found)

一时失言乱红尘 2024-03-27 18:25 36阅读 0赞

### 报错信息： ###

**"Invalid bound statement (not found): com.gelei.system.service.TbUserFollowService.getMyUserFanList"**

![d6ea94ddd7b6422fb0a7ba4bf3972077.png][]

这个问题就很神奇，请看下图，我测试的时候就是这么个情况；

![38c53f8ed68544afbb361064ea5c5690.png][]

### 综上所述，解决方法如下： ###

除了查看一下**接口名和mapper文件一致，以及检查接口xml映射一致以外。**

**先建议查看一下mapper扫描那里，有没有精确到mapper包，不要把之前包都扫描进去了。**

解决前：

> @MapperScan(value = "**com.gelei.system.\*\***")

![12e025966cb344ad8896d98d33c243f2.png][]

解决后：

> @MapperScan(value = "**com.gelei.system.mapper**")

![6b9decdd6fa24617846b089167d4e199.png][]

详情可以查看以下博主文章，咱就是看了这位兄台才解决了困惑好久的问题；

[记一个service层报错找不到方法Invalid bound statement (not found)\_invalid bound statement (not found):service-CSDN博客][service_Invalid bound statement _not found_invalid bound statement _not found_service-CSDN]

[d6ea94ddd7b6422fb0a7ba4bf3972077.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/11/e917ed5f4c63451083c2a9d684509871.png
[38c53f8ed68544afbb361064ea5c5690.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/11/cd5e6554758c4e0b81c06db407a23773.png
[12e025966cb344ad8896d98d33c243f2.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/11/9d0486136ab64e8eb2fc7343c8ebf350.png
[6b9decdd6fa24617846b089167d4e199.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/11/0767b3d64b464fc3bae2f62063ec67c0.png
[service_Invalid bound statement _not found_invalid bound statement _not found_service-CSDN]: https://blog.csdn.net/rj0907/article/details/122702311