SpringBoot Result Maps collection does not contain value for xxxx.int 的解决

在Mybatis中,返回的类型写成resultMap="int",例如

  <select id="getMessageTimes" resultMap="int" parameterType="com.bojia.fund.bean.Message">
   select count(1) as cconut from smart_message where protocolno=#{protocolno} 
          <![CDATA[ DATE_FORMAT(create_time,'%Y%m%d')= to_date(#{createtime,jdbcType=DATE},'yyyyMMdd')]]>
          and type=#{type} and status=#{status}
   </select>

访问页面就会报错,错误信息如下:

org.apache.ibatis.builder.IncompleteElementException: Could not find result map com.bojia.fund.dao.db1.MessageDao.int
	at org.apache.ibatis.builder.MapperBuilderAssistant.getStatementResultMaps(MapperBuilderAssistant.java:346)
	at org.apache.ibatis.builder.MapperBuilderAssistant.addMappedStatement(MapperBuilderAssistant.java:290)
	at org.apache.ibatis.builder.xml.XMLStatementBuilder.parseStatementNode(XMLStatementBuilder.java:109)
	at org.apache.ibatis.session.Configuration.buildAllStatements(Configuration.java:788)
	at org.apache.ibatis.session.Configuration.hasStatement(Configuration.java:758)
	at org.apache.ibatis.session.Configuration.hasStatement(Configuration.java:753)
	at org.apache.ibatis.binding.MapperMethod$SqlCommand.resolveMappedStatement(MapperMethod.java:247)
	at org.apache.ibatis.binding.MapperMethod$SqlCommand.<init>(MapperMethod.java:217)
	at org.apache.ibatis.binding.MapperMethod.<init>(MapperMethod.java:48)
	at org.apache.ibatis.binding.MapperProxy.cachedMapperMethod(MapperProxy.java:65)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:58)
	at com.sun.proxy.$Proxy75.findMobilePhoneBytradeacco(Unknown Source)

现在写成

 <select id="getMessageTimes" resultType="java.lang.Integer" parameterType="com.bojia.fund.bean.Message">
   select count(1) as cconut from smart_message where protocolno=#{protocolno} 
          <![CDATA[ DATE_FORMAT(create_time,'%Y%m%d')= to_date(#{createtime,jdbcType=DATE},'yyyyMMdd')]]>
          and type=#{type} and status=#{status}
   </select>
  

或者写成

resultType="int"

就不会报错了

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值