[펌] Spring, iBatis, 프로시저 사용 샘플

---

 출처: http://www.mimul.com/pebble/default/2009/01/16/1232105520000.html

---

1. 프로시저

expire_pk.AuthUserGoods(v_userno in varchar2, v_goodscd in varchar2, 
   v_result out number, v_expiredate out varchar2)

2. SqlMap 파일

<parameterMap id="authUserGoodsMap" class="java.util.Map">
  	<parameter property="userno" mode="IN" jdbcType="VARCHAR" 
  	   javaType="java.lang.String" />
  	<parameter property="goodscd" mode="IN" jdbcType="VARCHAR" 
  	   javaType="java.lang.String" />
  	<parameter property="result" mode="OUT" jdbcType="INTEGER" 
  	   javaType="java.lang.Integer"  />
  	<parameter property="expiredate" mode="OUT" jdbcType="VARCHAR" 
  	  javaType="java.lang.String"  />
</parameterMap>		
<procedure id="AuthUserGoods" parameterMap="authUserGoodsMap">
  	{ call expire_pk.AuthUserGoods(?, ?, ?, ?) }
</procedure>

3. DAO 소스

public Map<String, Object> callAuthUserGoods(Map<String, Object> params)
{
	queryForList("Bill.AuthUserGoods", params);
	return params;
}

4. 사용 샘플

Map<String, Object> params = new HashMap<String, Object>();
params.put("userno", userno);
params.put("goodscd", goodscd);
Map<String, Object> resultMap = 
   super.getBillService().callAuthUserGoods(params);
log.debug("result :" + resultMap.get("result"));
log.debug("expiredate :" + resultMap.get("expiredate"));