SSM多模块项目搭建问题记录

小灰灰 2024-04-17 18:23 70阅读 0赞

## **SSM多模块项目搭建问题记录** ##

**1、Spring+springMVC+Mybatis**

**Web.xml: **

*   监听器
 *  前端控制器：
 *  过滤器
 *  拦截器

**Spring-mvc.xml:**

*  开启注解扫描，将@contronller @bean  @service等标识的类映射为容器中的bean;
 *  配置试图解析器
 *  等等

**Spring-context.xml**

*  数据源、Mybatis 配置
 *  事务配置
 *  切面配置
 *  等等

**2、Mybatis 配置中需要指明 xxx.xml(sql映射文件的路径)，mapper接口位置**

![20190829201341344.png][]

否则将出现如下错误：

org.springframework.beans.factory.UnsatisfiedDependencyException: 
    Error creating bean with name 'testController': Unsatisfied dependency expressed 
    through field 'userService'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: 
    Error creating bean with name 'userServiceImpl': Unsatisfied dependency expressed through field 'userMapper'; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type 'com.ssm.demo.mapper.UserMapper' available: expected at least 1 bean which qualifies as autowire candidate. Dependency annotations: {@org.springframework.beans.factory.annotation.Autowired(required=true)}
    
    
    Caused by: 
    org.springframework.beans.factory.UnsatisfiedDependencyException: 
    Error creating bean with name 'userServiceImpl': Unsatisfied dependency expressed through field 'userMapper'; nested exception is org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type 'com.ssm.demo.mapper.UserMapper' available: expected at least 1 bean which qualifies as autowire candidate. Dependency annotations: {@org.springframework.beans.factory.annotation.Autowired(required=true)}
    
    
    
    Caused by:
    org.springframework.beans.factory.NoSuchBeanDefinitionException: No qualifying bean of type 'com.ssm.demo.mapper.UserMapper' available: expected at least 1

**3、sql映射文件中的命名空间要具体到一个mapper接口，sql映射文件放到resource目录下。（如果不在上述目录，需要在pom.xml中build配置加载该文件，否则spring不加载该文件，且sql映射文件应与mapper接口同名，如userMapper.java和userMapper.xml）**，

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzM1MTg0NTc2_size_16_color_FFFFFF_t_70][]

否则可能出现如下错误：

2019-08-29 22:58:15.534:INFO:oejsh.ContextHandler:Scanner-1: Started o.e.j.w.WebAppContext@78461379{/,file:///E:/IdeaProjects/ssm-demo/ssm-demo-web/target/ssm-demo-web/,AVAILABLE}
    [2019-08-29 10:58:15,736] Artifact ssm-demo-web:war exploded: Artifact is deployed successfully
    [2019-08-29 10:58:15,737] Artifact ssm-demo-web:war exploded: Deploy took 4,653 milliseconds
    2019-08-29 23:00:53.443:WARN:oejs.HttpChannel:qtp400136488-48: /user/all
    javax.servlet.ServletException: org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.ssm.demo.mapper.UserMapper.getAllUser
    	at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:146)
    	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
    	at org.eclipse.jetty.server.Server.handle(Server.java:531)
    	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:352)
    	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)
    	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281)
    	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)
    	at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)
    	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:754)
    	at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:672)
    	at java.lang.Thread.run(Thread.java:748)
    Caused by: 
    org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.ssm.demo.mapper.UserMapper.getAllUser
    	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982)
    	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
    	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
    	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:864)
    	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1655)
    	at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:215)
    	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
    	at org.eclipse.jetty.servlets.CrossOriginFilter.handle(CrossOriginFilter.java:311)
    	at org.eclipse.jetty.servlets.CrossOriginFilter.doFilter(CrossOriginFilter.java:265)
    	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1634)
    	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)
    	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)
    	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
    	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
    	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)
    	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)
    	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
    	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)
    	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
    	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)
    	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)
    	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
    	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)
    	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
    	at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:219)
    	at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)
    	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
    	at org.eclipse.jetty.server.Server.handle(Server.java:531)
    	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:352)
    	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)
    	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281)
    	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)
    	at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)
    	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:754)
    	at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:672)
    	at java.lang.Thread.run(Thread.java:748)
    Caused by: 
    org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.ssm.demo.mapper.UserMapper.getAllUser
    	at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:189)
    	at org.apache.ibatis.binding.MapperMethod.<init>(MapperMethod.java:43)
    	at org.apache.ibatis.binding.MapperProxy.cachedMapperMethod(MapperProxy.java:58)
    	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:51)
    	at com.sun.proxy.$Proxy23.getAllUser(Unknown Source)
    	at com.ssm.demo.service.UserServiceImpl.getAll(UserServiceImpl.java:20)
    	at com.ssm.demo.controller.TestController.showUser(TestController.java:29)
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at java.lang.reflect.Method.invoke(Method.java:498)
    	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)
    	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)
    	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)
    	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)
    	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)
    	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
    	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:967)
    	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901)
    	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)
    	at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
    	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)
    	at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
    	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:864)
    	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1655)
    	at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:215)
    	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1642)
    	at org.eclipse.jetty.servlets.CrossOriginFilter.handle(CrossOriginFilter.java:311)
    	at org.eclipse.jetty.servlets.CrossOriginFilter.doFilter(CrossOriginFilter.java:265)
    	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1634)
    	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:533)
    	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:146)
    	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:548)
    	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
    	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:257)
    	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1595)
    	at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:255)
    	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1253)
    	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:203)
    	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:473)
    	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1564)
    	at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:201)
    	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1155)
    	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:144)
    	at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:219)
    	at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:126)
    	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:132)
    	at org.eclipse.jetty.server.Server.handle(Server.java:531)
    	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:352)
    	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:260)
    	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:281)
    	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:102)
    	at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:118)
    	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:754)
    	at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:672)
    	at java.lang.Thread.run(Thread.java:748)

**4、注意mysql 的版本号，8.xx.xx版本的驱动、验证方式不同，同时注意设置时间格式。**

**8.0以前版本：**

jdbc.driver=com.mysql.cj.jdbc.Driver
    
    jdbc.url=jdbc:mysql://localhost:3306/book?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT&useSSL=false
    
    jdbc.username=xxx
    
    jdbc.password=xxxx

**8.0以后版本驱动改成如下：**

jdbc.driver=com.mysql.cj.jdbc.Driver

***url中拼接阐述：serverTimezone=GMT 解决服务器肯本地系统时间格式对应问题。***

[20190829201341344.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/bf9eb8ff290140f9a978785501a53748.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2JhaWR1XzM1MTg0NTc2_size_16_color_FFFFFF_t_70]: https://image.dandelioncloud.cn/pgy_files/images/2024/04/17/0aa1a3b424e24e4fb0cf242e9c71faba.png