Spring boot mapper 报错 A query was run and no Result Maps were found for the Mapped Statement

最新推荐文章于 2023-05-16 15:19:03 发布
最新推荐文章于 2023-05-16 15:19:03 发布
阅读量456 收藏 1
点赞数 1
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-NC-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/eclipse9527/article/details/103693969
本文探讨了在使用MyBatis框架时遇到的常见问题：执行查询未找到ResultMap导致的异常。深入分析了异常原因，涉及MyBatis配置、Mapper文件、ResultMap和ResultType的指定问题，并提供了详细的解决方案。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement 'com.htu.project001.wangyu.dao.UserDao.loginCheck'.  It's likely that neither a Result Type nor a Result Map was specified.
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
	at com.sun.proxy.$Proxy67.selectOne(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:159)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:93)
	at com.sun.proxy.$Proxy68.loginCheck(Unknown Source)
	at com.htu.project001.wangyu.service.impl.UserServiceImpl.loginCheck(UserServiceImpl.java:121)
	at com.htu.project001.wangyu.controller.UserController.loginCheck(UserController.java:61)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:106)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:888)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:92)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:526)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:367)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:860)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1591)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement 'com.htu.project001.wangyu.dao.UserDao.loginCheck'.  It's likely that neither a Result Type nor a Result Map was specified.
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.validateResultMapsCount(DefaultResultSetHandler.java:289)
	at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets(DefaultResultSetHandler.java:191)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
	at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
	at com.github.pagehelper.PageInterceptor.intercept(PageInterceptor.java:143)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
	at com.sun.proxy.$Proxy81.query(Unknown Source)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
	... 64 more

mapper映射有错误，改正后可以正常使用

A query was run and no Result Maps were found for the Mapped Statement
weixin_30617737的博客
08-13 105
使用mybatis进行查询时，没有给定resultType值出现的错误。resultType是查询对象的类型。 <select id="selectByuid" parameterType="int" resultType="xxx.xxx.model.User"> select * from t_user where uid=#{uid} </sele...
mybatis报错 A query was run and no Result Maps were found for the Mapped Statement 'xxx'
Carry的博客
08-16 950
mybatis xml编写查询语句 select报错： &lt;select id="selectProductByCardAndPwd"&gt; 参数是map类型，可以不写 但是这里没有写返回类型 resultType/resultMap 所以就报错，加上resultType/resultMap就不会出现以上错误了 修改后 &lt;select id="selectProduc...
A query was run and no Result Maps were found for the Mapped Statement 'user.insertUser!selectKey'. ...
weixin_34372728的博客
04-26 339
使用mybatis时出现异常问题： 有如下的错误 1 Error querying database. Cause: org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement 'user.insertUser!se...
Mybatis： A query was run and no Result Maps were found for the Mapped Statement ‘com.kuang.dao.User
weixin_44242433的博客
02-28 201
Mybatis： A query was run and no Result Maps were found for the Mapped Statement ‘com.kuang.dao.UserMapper.getUserLik’. It’s likely that neither a Result Type nor a Result Map was specified. 这个报错是没有在返回值添加resultType或resultMap，只能有一个： 错误代码： 使用resultType： &l
Mybatis 报错：A query was run and no Result Maps were found for the Mapped Statement ‘com.wanuw.mapper.
ytgytg28的博客
05-16 2152
A query was run and no Result Maps were found for the Mapped Statement 'com.wanuw.mapper.EmpMapper.selectAll'. It's likely that neither a Result Type nor a Result Map was specified.解决方法
A query was run and no Result Maps were found for the Mapped Statement ‘com.woniu.mapper.UserMapper.
weixin_55229531的博客
05-08 5万+
A query was run and no Result Maps were found for the Mapped Statement 'com.woniu.mapper.UserMapper.selectAllUsers'. It's likely that neither a Result Type nor a Result Map was specified.
A query was run and no Result Maps were found for the Mapped Statement ‘******’. It’s likely that ne
weixin_53331942的博客
11-01 366
A query was run and no Result Maps were found for the Mapped Statement ‘******’. It’s likely that neither a Result Type nor a Result Map was specified解决方法 问题描述 在进行springboot项目的时候，浏览器页面显示405报错 idea下显示 org.apache.ibatis.executor.ExecutorException: A query
问题记录-A query was run and no Result Maps were found for the Mapped Statement..
weixin_45263613的博客
01-30 4257
A query was run and no Result Maps were found for the Mapped Statement… 1.报错信息 org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Stateme
springboot整合mybatis操作数据库实现增删改查报错：A query was run and no Result Maps were found for the Mapped Statem
qq_49014164的博客
03-20 1176
org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement ‘com.trf.mapper.UserMapper.queryUserList’. It’s likely that neither a Result Type nor a Result Map was specified. 译文： 查询运行，没有为映射语句“com.trf.
Mybatis报错—— A query was run and no Result Maps were found for the Mapped Statement
kingscoming的博客
12-21 7954
Mybatis报错—— A query was run and no Result Maps were found for the Mapped Statement 。。。 It’s likely that neither a Result Type nor a Result Map was specified.
Mybatis报错： A query was run and no Result Maps were found for the Mapped Statement
xiaodexiaoguai的博客
06-25 8856
Mybatis报错： A query was run and no Result Maps were found for the Mapped Statement 完整报错如下： A query was run and no Result Maps were found for the Mapped Statement ‘com.mapper.CarMapper.CarORM’. It’s likely that neither a Result Type nor a Result Map was spe
mybatis 没有结果映射， a query was run and no Result Maps were found for the mapped statement.
m0_53753920的博客
03-29 1703
mybatis 没有结果映射如何解决： 异常报错如下： ### Error querying database. Cause: org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement 'com.jin.mapper.UserMapper.getUserById'. It's likely that neither a Re..
mybatis报错：A query was run and no Result Maps were found for the Mapped Statement
热门推荐
11-08 10万+
今天编辑mybatis的xml文件，出现如下错误： 程序出现异常[A query was run and no Result Maps were found for the Mapped Statement  '***'.  It's likely that neither a Result Type nor a Result Map was specified. at org.mybatis
MyBatis报错：A query was run and no Result Maps were found for the Mapped Statement
Jiao的博客
03-22 732
错误sql： <select id="selectUserName"> select USER_NAME as userName from user where 1=1 and USER_ID=#{userId} </select 正确sql： <select id="selectUserName" resultType="map"> select USER_NAME as userName from user wher
A query was run and no Result Maps were found for the Mapped Statement XXX
Skye_H的博客
11-21 399
错误描述： A query was run and no Result Maps were found for the Mapped Statement ‘com.mdsw.dses.statistics.dao.XXXMapper.XXX’. It’s likely that neither a Result Type nor a Result Map was specified. 错误原因：...
mybatis: A query was run and no Result Maps were found for the Mapped Statement .......
lh1037370745的博客
05-04 1408
### Cause: org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement 'com.mypro.mapper.bossMapper.queryBywkid'. It's likely that neither a Result Type nor a Result Map was specified. at org.apac.
ExecutorException: A query was run and no Result Maps were found for the Mapped Statement ‘com.win.m...
weixin_30878361的博客
01-29 226
ExecutorException: A query was run and no Result Maps were found for the Mapped Statement ‘com.win.mall.dao.CartMapper.test’. It’s likely that neither a Result Type nor a Result Map was specified. 原因：...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

稷下学员

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值