ibatis调用存储过程(无返回参数)

时间:2024-05-01 13:56:34

ibatis调用存储过程例子:

java:

getSqlMapClientTemplate().insert(sql, paraMap)

ibatis xml:

 <parameterMap id="accountingVouchersParamMap" class="java.util.Map">
<parameter property="startDate" javaType="java.lang.String" jdbcType="VARCHAR" mode="IN" />
<parameter property="endDate" javaType="java.lang.String" jdbcType="VARCHAR" mode="IN" />
</parameterMap>
<procedure id="proc_clear_bank_flow" parameterMap="accountingVouchersParamMap">
{call pack_clearing.proc_clear_bank_flow(?,?)}
</procedure>