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>