出现A query was run and no Result Maps were found for the Mapped ...问题

于 2023-01-07 17:56:32 发布
阅读量209 收藏
点赞数
文章标签： mybatis java mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_61099555/article/details/128593340
版权

今天学mybatis，出现了如下错误提示：

org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement 'com.wwl.mybatis.mapper.ParameterMapper.CheckLogin'.  It's likely that neither a Result Type nor a Result Map was specified.

 

而且我日志提示我前面查找SQL语句没问题，就是最后一步输出错误， 所以定位为形式输出问题。

 在这里我加上了resultType来表示返回类型，程序就正常运行了。

（原先要输入User类的全类名，这里我用TypeAliases起了别名）

 

可以用resultType和resultMap两种类型，区别如下（都是用来建立联系的）

resultType：自动映射，用于属性名和表中字段名一致的情况

resultMap：自定义映射，用于一对多或多对一或字段名和属性名不一致的情况

叫小白
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
libc.so.6 libc.so.6
05-31
当一个程序运行时，如果依赖`libc.so.6`，那么操作系统会按照ELF（Executable and Linkable Format）文件中的信息找到这个库，并将其加载到进程的地址空间。动态链接器（通常是ld-linux.so）负责解析符号引用，将...
free_and_open_source_software_for_development.pdf
08-17
difference for the lives of the people and can greatly expand their access to information. FOSS will take away the financial and legal barriers that limit the use of software in schools, universities,...
idea运行Mybatis项目出现的常见错误（编码错误等）
静水流深，沧笙踏歌
03-12 6106
java.lang.ExceptionInInitializerError....The error may exist in UserMapper.xml ### Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration. Cause: java.io.IOException: Could not find resource UserMapper.xml
Mybatis报错： A query was run and no Result Maps were found for the Mapped Statement
xiaodexiaoguai的博客
06-25 8391
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
org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.apache.
qq_51705526的博客
12-24 1万+
在xml文件中碰到这样的报错的时候,有可能是你在里面使用了这种注释,编译会报错,可能这就是约定大于配置 org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='id', mode=IN
MyBatis从入门到精通(十四)：在MyBatis中使用类型处理器
LIU18612105538的博客
07-24 215
最近在读刘增辉老师所著的《MyBatis从入门到精通》一书，很有收获，于是将自己学习的过程以博客形式输出，如有错误，欢迎指正，如帮助到你，不胜荣幸！ 本篇博客主要讲解在MyBatis中如何使用类型处理器。 1. 明确需求 在设计之初，sys_role表的enabled字段有2个可选值，其中0 代表禁用，1代表启用，而且实体类中我们使用的是Interger类型： /** * 有效标志 ...
ExecutorException--执行异常
weixin_45593720的博客
09-07 1783
1.异常原因： Caused by: org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement 'cn.itcast.dao.system.ModuleDao.findRoleModuleByModuleId'. It's...
i.MX6ULL实现SPI驱动【裸机驱动】.zip
02-20
在裸机环境下，我们可以直接通过MMIO（Memory Mapped I/O）访问这些寄存器。初始化过程包括但不限于： 1. 选择SPI接口：根据实际硬件连接选择合适的SPI端口。 2. 设置时钟源：配置时钟分频因子以达到期望的波特率。...
lf4j简介共5页.pdf.zip
11-22
LF4J，全称为Logging Framework for Java，是一个轻量级的日志接口，旨在为Java应用程序提供灵活的日志记录解决方案。LF4J的设计目标是成为Java日志API的标准，它允许开发人员在运行时选择合适的日志实现，无需重新...
Share_data.rar_ShareData.txt_share
09-24
这种方式的优点是读写速度快，且系统负责同步，但需要注意的是，如果多个进程同时写入，需处理并发控制问题。 2. **管道（Pipes）**： 管道是一种简单但功能强大的进程间通信（IPC）机制。VC++中的`CreatePipe`和`...
关于ResultMapException和SQLException: Invalid value for getInt()的解决方法
weixin_45928499的博客
06-15 650
mybatis中的Cause: java.sql.SQLException: Invalid value for getInt() - 'xx’异常处理 org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.apache.ibatis.executor.result.ResultMapException: Error attempting to get column 'nam
Error querying database. Cause: org.apache.ibatis.executor.ExecutorException: A query was run and n
qq_44478309的博客
04-16 2460
Error querying database. Cause: org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped StatementOC## 标题 在运行第一个Mybatis程序时，发生下列错误 出现这种错误主要（配置查询）的xml...
不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK
weixin_56239462的博客
12-31 2541
问题： org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.apache.ibatis.executor.result.ResultMapException: Error attempting to get column 'ID' from result set. Cause: java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n...
问题记录-A query was run and no Result Maps were found for the Mapped Statement..
weixin_45263613的博客
01-30 3771
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
mybatis中出现Error querying database. Cause: org.apache.ibatis.executor.ExecutorException: Executor wa
ThisisWilli
10-31 2092
转：https://juejin.im/post/5d3d63c7f265da1b60294c02
mybatis遇到问题解决方法---- Error querying database.
热门推荐
BetrayFree的博客
04-03 2万+
程序员快乐多，找bug，一个又一个，感觉还不错。 今天来说说映射的问题，这个问题通常会在什么时候出现呢？ 大家肯定能想到的就是再进行数据库查询的时候，不错，按照规则，我们通常会将数据库字段多单词之间用下划线连接（stu_no,stu_name……），而我们在写java实体bean（也称entity）时，通常采用驼峰命名法（stuNo,stuName……），如稍不注意，则会出现查找不到的情况，特...
ExecutorException: A query was run and no Result Maps were found for the Mapped Statement
恶魔盒子
04-27 503
ExecutorException: A query was run and no Result Maps were found for the Mapped Statement ‘org.ali.dao.IAdministratorsDao.findCustomerForLogin’. It’s likely that neither a Result Type nor a Result Map...
A query was run and no Result Maps were found for the Mapped Statement ‘com.woniu.mapper.UserMapper.
weixin_55229531的博客
05-08 1万+
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.
Error querying database. Cause: org.apache.ibatis.executor.ExecutorException: A query was run and n
m0_48020754的博客
05-03 1714
Error querying database. Cause: org.apache.ibatis.executor.ExecutorException: A query was run and no Result Maps were found for the Mapped Statement ‘zar.getById’. It’s likely that neither a Result Type nor a Result Map was specified. 这就是你mapper中的resultT
A query was run and no Result Maps were found for the Mapped Statement
最新发布
05-25
这个错误通常出现在 MyBatis 中，表示在运行查询时找不到对应的结果映射。可能的原因包括： 1. 没有正确配置结果映射或者结果映射配置错误。 2. 查询返回的结果集与结果映射不匹配。 3. 查询语句本身出现错误，导致...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值