Exception in thread “main“ org.apache.ibatis.binding.BindingException: Invalid bound statement (not

最新推荐文章于 2023-05-04 11:52:34 发布

LSYING1

最新推荐文章于 2023-05-04 11:52:34 发布

阅读量2.1k

点赞数

分类专栏：报错+问题文章标签： apache java intellij-idea

本文链接：https://blog.csdn.net/qq_43175215/article/details/122687795

版权

报错+问题专栏收录该内容

9 篇文章 0 订阅

订阅专栏

IDEA报错–mybatis

Exception in thread “main” org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.lsy.mapper.UserMapper.selectByExample

<2022-01-25 16:25:59,547> DEBUG (DefaultSingletonBeanRegistry.java:225) [main] (org.springframework.beans.factory.support.DefaultListableBeanFactory) -Creating shared instance of singleton bean 'usersService'
Exception in thread "main" org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.lsy.mapper.UserMapper.selectByExample
	at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:235)
	at org.apache.ibatis.binding.MapperMethod.<init>(MapperMethod.java:53)
	at org.apache.ibatis.binding.MapperProxy.lambda$cachedInvoker$0(MapperProxy.java:115)
	at java.util.concurrent.ConcurrentHashMap.computeIfAbsent(ConcurrentHashMap.java:1660)
	at org.apache.ibatis.binding.MapperProxy.cachedInvoker(MapperProxy.java:102)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:85)
	at com.sun.proxy.$Proxy7.selectByExample(Unknown Source)
	at com.lsy.service.impl.UsersServiceImpl.findUsersAll(UsersServiceImpl.java:50)
	at com.lsy.test.FindUsersAllTest.main(FindUsersAllTest.java:18)

原因：
在*mapper.xml中没有 *mapper类中的selectByExample方法对应的配置：
加上就ok了：


 <select id="selectByExample" parameterType="java.lang.Integer" resultMap="BaseResultMap">
    select
    <include refid="Base_Column_List" />
    from users
  </select>