Fix a problem that always prompts you not to find a way to mapper the definition of a file!

The mybatis of the *mapper.xml file is a terrible disaster! For two whole days circling around this problem!

Let's see what the problem looks like! Here is the Mapper.xml file generated by reverse engineering, the package path is nothing wrong!

But every time you invoke the operations database of a method in mapper, it fails:

Put out detailed error message:

1March +, . Ten: -: $Afternoon Org.apache.catalina.core.ApplicationContext Log2 Info: No Spring webapplicationinitializer types detected on Classpath3March +, . Ten: -: $Afternoon Org.apache.catalina.core.ApplicationContext Log4 Info: Initializing Spring root Webapplicationcontext5March +, . Ten: -: -Afternoon Org.apache.catalina.core.ApplicationContext Log6Info: Initializing Spring frameworkservlet'Xuebusi-manager'7March +, . Ten: -: +pm Org.apache.catalina.core.StandardWrapperValve Invoke 8 severity: Servlet.service () for Servlets [Xuebusi-manager] in the context with path [] threw exception [Request processing failed; Nested exception is org.apache.ibatis.binding.BindingException:Invalid bound statement (not found): Com.xuebusi.mapper . Tbusermapper.selectbyexample] with root cause 9 Org.apache.ibatis.binding.BindingException:Invalid bound statement ( Not found): Com.xuebusi.mapper.TbUserMapper.selectByExample10 at Org.apache.ibatis.binding.mappermethod$sqlcommand .<init> (mappermethod.java:189) at org.apache.ibatis.binding.mappermethod.<init> (MapperMethod.java : To Org.apache.ibatis.binding.MapperProxy.cachedMapperMethod (mapperproxy.java:58) at Org.apache.ibatis.bin Ding. Mapperproxy.invoke (mapperproxy.java:51) in Com.sun.proxy. $Proxy 19.selectByExample (Unknown Source) at Com.xuebu Si.service.impl.UserServiceImpl.getUserById (userserviceimpl.java:66) at SUN.REFLECT.NATIVEMETHODACCESSORIMPL.INVOKE0 (Native Method) at Sun.reflect. Nativemethodaccessorimpl.invoke (nativemethodaccessorimpl.java:57) at Sun.reflect.DelegatingMethodAccessorImpl.invoke (delegatingmethodaccessorimpl.java:43) at Java.lang.reflect.Method.invoke (method.java:606) at Org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection (aoputils.java:317) at Org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint (Reflectivemethodinvocation.java : Org.springframework.aop.framework.ReflectiveMethodInvocation.proceed at (Reflectivemethodinvocation.java : 157) at Org.springframework.transaction.interceptor.transactioninterceptor$1.proceedwithinvocation ( TRANSACTIONINTERCEPTOR.JAVA:99) at Org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction ( transactionaspectsupport.java:267) at Org.springframework.transaction.interceptor.TransactionInterceptor.invoke (transactioninterceptor.java:96) at Org.springframework.aop.framework.ReflectiveMethoDinvocation.proceed (reflectivemethodinvocation.java:179) at     Org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke (exposeinvocationinterceptor.java:92) 28     At Org.springframework.aop.framework.ReflectiveMethodInvocation.proceed (reflectivemethodinvocation.java:179) 29 At Org.springframework.aop.framework.JdkDynamicAopProxy.invoke (jdkdynamicaopproxy.java:207)-at com.sun.proxy.$ Proxy20.getuserbyid (Unknown Source) at Com.xuebusi.controller.TestController.getUserById (testcontroller.java:50 ) at the SUN.REFLECT.NATIVEMETHODACCESSORIMPL.INVOKE0 (Native Method) at Sun.reflect.NativeMethodAccessorImpl.invok E (nativemethodaccessorimpl.java:57) at Sun.reflect.DelegatingMethodAccessorImpl.invoke ( delegatingmethodaccessorimpl.java:43) at Java.lang.reflect.Method.invoke (method.java:606), at Org.springframewo Rk.web.method.support.InvocableHandlerMethod.doInvoke (invocablehandlermethod.java:221) Notoginseng at Org.springframework.web.method.support.Invocablehandlermethod.invokeforrequest (invocablehandlermethod.java:137) at Org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle ( SERVLETINVOCABLEHANDLERMETHOD.JAVA:110) at Org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod ( requestmappinghandleradapter.java:777) Org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal ( requestmappinghandleradapter.java:706) at Org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle ( abstracthandlermethodadapter.java:85) at Org.springframework.web.servlet.DispatcherServlet.doDispatch ( dispatcherservlet.java:943) at Org.springframework.web.servlet.DispatcherServlet.doService ( dispatcherservlet.java:877) at Org.springframework.web.servlet.FrameworkServlet.processRequest ( frameworkservlet.java:966) at Org.springframework.web.servlet.FrameworkServlet.doGET (frameworkservlet.java:857) in Javax.servlet.http.HttpServlet.service (httpservlet.java:624) at Org.springfra Mework.web.servlet.FrameworkServlet.service (frameworkservlet.java:842) at Javax.servlet.http.HttpServlet.service (httpservlet.java:731) at Org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (applicationfilterchain.java:303) at Org.apache.catalina.core.ApplicationFilterChain.doFilter (applicationfilterchain.java:208) Wuyi at Org.apache.tomcat.websocket.server.WsFilter.doFilter (wsfilter.java:52) at Org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (applicationfilterchain.java:241) at Org.apache.catalina.core.ApplicationFilterChain.doFilter (applicationfilterchain.java:208) at Org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal (characterencodingfilter.java:88) at Org.springframework.web.filter.OncePerRequestFilter.doFilter (onceperrequestfilter.java:107) at Org.apache.catalina.cOre. Applicationfilterchain.internaldofilter (applicationfilterchain.java:241) Org.apache.catalina.core.ApplicationFilterChain.doFilter (applicationfilterchain.java:208) at Org.apache.catalina.core.StandardWrapperValve.invoke (standardwrappervalve.java:220) at Org.apache.catalina.core.StandardContextValve.invoke (standardcontextvalve.java:122) at Org.apache.catalina.authenticator.AuthenticatorBase.invoke (authenticatorbase.java:505) at Org.apache.catalina.core.StandardHostValve.invoke (standardhostvalve.java:169) at Org.apache.catalina.valves.ErrorReportValve.invoke (errorreportvalve.java:103) Org.apache.catalina.valves.AccessLogValve.invoke (accesslogvalve.java:956) at Org.apache.catalina.core.StandardEngineValve.invoke (standardenginevalve.java:116) Org.apache.catalina.connector.CoyoteAdapter.service (coyoteadapter.java:436) at Org.apache.coyote.http11.AbstractHttp11Processor.process (abstracthttp11processor.java:1078) at Org.apache.coyote.abstractprotocol$abstractconnectionhandler.process (abstractprotocol.java:625) at Org.apache.tomcat.util.net.jioendpoint$socketprocessor.run (jioendpoint.java:318) at Java.util.concurrent.ThreadPoolExecutor.runWorker (threadpoolexecutor.java:1145) at Java.util.concurrent.threadpoolexecutor$worker.run (threadpoolexecutor.java:615) at Org.apache.tomcat.util.threads.taskthread$wrappingrunnable.run (taskthread.java:61) at Java.lang.Thread.run ( thread.java:745)

Tossing for two days, occasionally on the Internet to see the following solutions, only to be solved (want to cry a):

To determine if your Mapper.xml file really does not have a problem, try to modify the project's Pom.xml file, add the following content:

1     <Build>2         <Resources>3             <Resource>4                 <Directory>Src/main/java</Directory>5                 <includes>6                     <include>**/mapper/*mapper.xml</include>7                 </includes>8             </Resource>9         </Resources>Ten     </Build>

Fix a problem that always prompts you not to find a way to mapper the definition of a file!