mybatis字段有数字，存储过程返回有多集合

￡神魔★判官ぃ 2022-12-23 11:12 138阅读 0赞

参考[这文章研究了][Link 1]返回多种情况，还解决了，直接返回list<Map>记录有科学计数情况，小于1的返回0，所以返回具体的对象非常准确。

<resultMap id="rm" type="com.xinpoint.whs.entity.PostChang">
            <result column="workno" property="workno"></result>
            <result column="4000" property="C4000"></result>
            <result column="4010" property="C4010"></result>
            <result column="4020" property="C4020"></result>
            <result column="4030" property="C4030"></result>
            <result column="4040" property="C4040"></result>
            <result column="4050" property="C4050"></result>
            <result column="4060" property="C4060"></result>
            <result column="4070" property="C4070"></result>
            <result column="4080" property="C4080"></result>
            <result column="4090" property="C4090"></result>
            <result column="4100" property="C4100"></result>
            <result column="4110" property="C4110"></result>
            <result column="4120" property="C4120"></result>
            <result column="4130" property="C4130"></result>
            <result column="4140" property="C4140"></result>
            <result column="4150" property="C4150"></result>
            <result column="4160" property="C4160"></result>
            <result column="4170" property="C4170"></result>
            <result column="4180" property="C4180"></result>
            <result column="4300" property="C4300"></result>
            <result column="4310" property="C4310"></result>
            <result column="4920" property="C4920"></result>
        </resultMap>
    
        
        
        <select id="p_comkqmonthreport_pro" parameterType="java.util.Map" resultMap="rm" statementType="CALLABLE">
    		{call p_comkqmonthreport(
    			#{bookman,mode=IN,jdbcType=VARCHAR},
    			#{action,mode=IN,jdbcType=VARCHAR},
    			#{kqaccid,mode=IN,jdbcType=VARCHAR},
    			#{yearno,mode=IN,jdbcType=VARCHAR},
    			#{monthno,mode=IN,jdbcType=VARCHAR},
    			#{dtbg,mode=IN,jdbcType=VARCHAR},
    			#{dted,mode=IN,jdbcType=VARCHAR},
    			#{workno,mode=IN,jdbcType=VARCHAR},
    			#{itemname,mode=IN,jdbcType=VARCHAR},
    			#{beantype,mode=IN,jdbcType=VARCHAR},
    			#{tag,mode=IN,jdbcType=VARCHAR},
    			#{result,mode=OUT,jdbcType=VARCHAR}
    		)}
    	</select>

这个是返回集合

List<PostChang> list = hrApiService.p\_comkqmonthreport\_pro(map);

[Link 1]: https://blog.csdn.net/cs373616511/article/details/82890306