mybatis调用oracle存储过程 out游标类型参数 如何赋给java map

<resultMap id="ticketInfosResultMap" type="Map">
        <!--result要是默认用列名的话完全不必要配,省老事了

  <result property="ID_" column="ID_"/>
        <result property="TICKET_NUMBER_" column="TICKET_NUMBER_"/>
        <result property="FINAL_PRICE_" column="FINAL_PRICE_"/>
        <result property="POUNDAGE_" column="POUNDAGE_"/>
        <result property="RETURN_PRICE_" column="RETURN_PRICE_"/>

   -->
    </resultMap>

 

    <!-- 获取客票信息, 通过ticInfos返回  -->
    <select id="obtainToRtnPsgerTicInfo" statementType="CALLABLE">
        CALL TicRtn_ObtainToRtnPsgerTicInfo(
        #{startTicketNumber},
        #{endTicketNumber},
        #{returnType},
        #{ticInfos, mode=OUT, jdbcType=CURSOR, javaType=ResultSet, resultMap=ticketInfosResultMap}
        )
    </select>

 

其实要是能直接resultType=map就更简单了,但是不允许这样设置

posted @ 2017-11-30 15:49  老豆芽  阅读(411)  评论(0编辑  收藏  举报