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就更简单了,但是不允许这样设置