ibatis 调存储过程 例子

<sqlMap>

 <resultMap class="java.util.HashMap" id="out_ResultMap">
    <result column="requcode" property="requcode" jdbcType="VARCHAR" />
    <result column="orderid" property="orderid" jdbcType="INTEGER" />
    <result column="medicode" property="medicode" jdbcType="VARCHAR" />
    <result column="mediname" property="mediname" jdbcType="VARCHAR" />
    <result column="unit" property="unit" jdbcType="VARCHAR" />
    <result column="sqsl" property="sqsl" jdbcType="DECIMAL" />
    <result column="spsl" property="spsl" jdbcType="DECIMAL" />
    <result column="sqr" property="sqr" jdbcType="VARCHAR" />
    <result column="sqrq" property="sqrq" jdbcType="VARCHAR" />
  </resultMap>
 ----------------------此处的property顺序不能乱改要和存储过程里变量的顺序一致
 <parameterMap id="busPrintProcedureParam" class="java.util.HashMap">
   <parameter property="REQUESTID" jdbcType="NUMBER" mode="IN"/>
   <parameter property="FORGID" jdbcType="NUMBER" mode="IN"/>
   <parameter jdbcType="ORACLECURSOR" mode="OUT"
         property="DATA" javaType="java.sql.ResultSet" resultMap="out_ResultMap"/>
 </parameterMap>
 <procedure id="busPrintProcedure" parameterMap="busPrintProcedureParam">
   {call sp_ypjg_cgdcx(?,?,?)}
 </procedure> 
</sqlMap>