调用存储过程例子

 

<!-- 
		调用按钮权限存储过程时需要用到的3个输入参数及输出参数
	 -->
	<resultMap id="backMap" class="java.util.HashMap">
       <result property="STATUS1" column="STATUS1" />
       <result property="SYRE_BTN_URL1" column="SYRE_BTN_URL1"/>
       <result property="SYBB_TITLE1" column="SYBB_TITLE1"/>
       <result property="SYBR_ID" column="SYBR_ID"/>
       <result property="SYBR_CODE" column="SYBR_CODE"/>
       <result property="SYBR_EVENT" column="SYBR_EVENT"/>
       <result property="SYBR_HREF" column="SYBR_HREF"/>
       <result property="SYBR_REMARK" column="SYBR_REMARK"/>
       <result property="SYBR_NAME" column="SYBR_NAME"/>
       <result property="SYBR_PROPERTY" column="SYBR_PROPERTY"/>
       <result property="SYBB_TITLE" column="SYBB_TITLE"/>
       <result property="SYBB_BTN_URL" column="SYBB_BTN_URL"/>
    </resultMap>
	<parameterMap id="buttParameter" class="java.util.HashMap"> 
		<parameter property="SERVICENAME" jdbcType="VARCHAR2" javaType="java.lang.String" mode="IN" /> 
		<parameter property="ACTIONNAME" jdbcType="VARCHAR2" javaType="java.lang.String" mode="IN" /> 
		<parameter property="S_USERID" jdbcType="NUMBER" javaType="java.lang.Integer" mode="IN" /> 
		<parameter property="CUR_RS" jdbcType="ORACLECURSOR" javaType="java.sql.ResultSet" mode="OUT" resultMap="backMap"/>
	</parameterMap> 
	
	<!-- 		
	调用按钮权限存储过程
	 -->
	<procedure id="queryButton" parameterMap="buttParameter" resultMap="backMap">
		<![CDATA[
			{call PRC_SYS_BUTTOMPERMISSION(?,?,?,?)}
		]]>
    </procedure>