IDEA导入Maven项目（Spring+Mybatis）后登录报错：找不到对应的Dao方法

2019独角兽企业重金招聘Python工程师标准>>>

当项目导入成功，maven clean,rebuild project 后我就准备后台登录了

HTTP Status 500 - Request processing failed; nested exception is org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.aneop.sys.userfunc.dao.UserDao.queryLogin

type Exception report

message Request processing failed; nested exception is org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.aneop.sys.userfunc.dao.UserDao.queryLogin

description The server encountered an internal error that prevented it from fulfilling this request.

exception

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.aneop.sys.userfunc.dao.UserDao.queryLogin
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:943)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:833)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:807)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:108)

root cause

org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.aneop.sys.userfunc.dao.UserDao.queryLogin
	org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:184)
	org.apache.ibatis.binding.MapperMethod.<init>(MapperMethod.java:38)
	org.apache.ibatis.binding.MapperProxy.cachedMapperMethod(MapperProxy.java:49)
	org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:42)
	com.sun.proxy.$Proxy33.queryLogin(Unknown Source)
	com.aneop.sys.userfunc.service.impl.UserServiceImpl.queryLogin(UserServiceImpl.java:35)
	com.aneop.sys.userfunc.controller.UserController.login(UserController.java:73)
	sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:214)
	org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
	org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:748)
	org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:689)
	org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:945)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:876)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:931)
	org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:833)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:650)
	org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:807)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:108)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.67 logs.
Apache Tomcat/7.0.67

报错是这样的，楼主的心情是崩溃的，再看一下源码Controller 到Service到ServiceImpl在到UserDao再到UserMapper.xml都是没问题的，于是乎我陷入了沉思，用sts把原来的项目跑起来是没问题的，也就是说项目是没问题的，再看一眼xml里面的mapper namespace，也是没问题的，f**kl。

然后上网搜搜看了，网上的大多方法我上面已经都做了，还有一中不明觉厉的方法：把xml里的空行删除一个，再保存下就好了。事实证明我以前用过一次，确实好用。然而这一次：并不灵！！！

在楼主心灰意冷之际，被女友拉去吃饭了，吃完饭回来灵机一动，看了一下编译好的classes文件，然后并没有xml文件。

老衲顿时毛瑟顿开

在网上查了一下，在POM.XML文件中加入

<build>
...
        <resources>
            <resource>
                <directory>src/main/java</directory>
                <includes>
                    <include>**/*.xml</include>
                </includes>
                <filtering>true</filtering>
            </resource>
        </resources>
...
</build>

然后就可以了。

 

转载于:https://my.oschina.net/ytliyang/blog/679296