报错:Result map does not contain a value for Java.lang.Integer
办法一:将resultMap="java.lang.Integer"改为resultType="java.lang.Integer"就可以解决问题
办法二:- <resultMap id="ResultOfInteger" type="java.lang.Integer">
- <result column="budget" property="budget" jdbcType="INTEGER" />
- </resultMap>
- <select id="select" resultMap="ResultOfInteger" 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>