Result map does not contain a value for java.lang.Integer

来源:互联网 发布:windows主题安卓版 编辑:程序博客网 时间:2024/06/08 12:48

Result map does not contain a value for java.lang.Integer

myBatis返回count(*)得到的int值

Mapper.xml:

<select id="select" resultMap="java.lang.Integer" parameterType="java.lang.Integer" >      SELECT CASE WHEN moneyIS NULL THEN 0 ELSE moneyEND AS money      FROM (          select SUM(money) AS money          from ABC          where user_id = #{user_id,jdbcType=INTEGER} AND state = 11 AND is_del = 0      ) t    </select> 

Mapper..java:

int selectTotalMoney(Integer userid); 


经过测试,将resultMap="java.lang.Integer" 改成 resultType="java.lang.Integer" 也可以解决问题。

阅读全文
0 0