ibatis存储过程调用

时间:2022-05-08 15:46:02

Xml里存储过程

   <parameterMapid="StockPurchaseRequisitionView-prAutoStockPurchaseRequisition-Parameters"class="java.util.Map">

            <parameterproperty="piStockPurchaseRequsitionId" jdbcType="DECIMAL"javaType="java.math.BigDecimal" mode="IN"/>

            <parameterproperty="piMaterialItemManageTypeStr" jdbcType="VARCHAR"javaType="java.lang.String" mode="IN" />

            <parameterproperty="piUserMstrId" jdbcType="DECIMAL"javaType="java.math.BigDecimal" mode="IN" />

            <parameterproperty="poErrorCode" jdbcType="VARCHAR"javaType="java.lang.String" mode="OUT" />

            <parameterproperty="poErrorCnMsg" jdbcType="VARCHAR"javaType="java.lang.String" mode="OUT" />

            <parameterproperty="poErrorEnMsg" jdbcType="VARCHAR"javaType="java.lang.String" mode="OUT" />

      </parameterMap>

            

      <procedureid="StockPurchaseRequisitionView-prAutoStockPurchaseRequisition" parameterMap="StockPurchaseRequisitionView-prAutoStockPurchaseRequisition-Parameters">

            {callpgmms.prAutoStockPurchaseRequsition(?, ?, ?, ?, ?, ?)}

       </procedure>

 

   // 执行pgmms.prCopyStockPurchaseRequsition存储过程

   public void executedPrCopyStockPurchaseRequsition(Map map) {

       getSqlMapClientTemplate().queryForObject("StockPurchaseRequisitionView-prCopyStockPurchaseRequsition",map); //$NON-NLS-1$

   }

之后调用map,map里面就存了你需要的值了