mybatis调用存储过程-oracle

1.输入输出参数

<select id="checkingProcess" parameterMap="checkingParaMap" statementType="CALLABLE">

CALL P_CHECKING(?,?,?,?,?)

</select>

<select id="cancelCheck" parameterType="java.lang.String" >

UPDATE LY_SJKHY_PCJBXX SET HYZT='1' WHERE HYPC=#{pcbh,jdbcType=VARCHAR}

</select>

<parameterMap type="java.util.Map" id="checkingParaMap">

<parameter property="P_HYPC" mode="IN" jdbcType="VARCHAR"/>

<parameter property="P_DDBH" mode="IN" jdbcType="VARCHAR"/>

<parameter property="P_SJYBH" mode="IN" jdbcType="VARCHAR"/>

<parameter property="P_GZBH" mode="IN" jdbcType="VARCHAR"/>

<parameter property="R_SUCCESS" mode="OUT" jdbcType="VARCHAR"/>

</parameterMap>

1.动态调用存储过程

HashMap<String,String> params = new HashMap<String,String>();

params.put("TABLENAME_", tablename);

params.put("PROCEDURENAME", procedureName);

gjbMapper.countGJB(params);

 

<!-- 存储过程-->

<select id="countGJB" parameterMap="countParaMap" statementType="CALLABLE">

call ${PROCEDURENAME}(?)

</select>

<parameterMap type="java.util.Map" id="countParaMap">

<parameter property="TABLENAME_" mode="IN" jdbcType="VARCHAR"/>

</parameterMap>