588
ibatis調用Oracle中的存儲過程和function
一、調用存儲過程
Oracle代碼
procedure proc_pos_check(p_gtin in varchar2,p_safe_code in varchar2,
p_in_sell_id in varchar2,
p_buy_id in varchar2,
p_oper_type in varchar2,
p_out_sell_id out varchar2,
p_result out varchar2)
SqlMap代碼
<sqlMap namespace="webservice_procheck">
<parameterMap >
<parameter property="p_gtin" javaType="java.lang.String" jdbcType="VARCHAR" mode="IN"/>
<parameter property="p_safe_code" javaType="java.lang.String" jdbcType="VARCHAR" mode="IN"/>
<parameter property="p_in_sell_id" javaType="java.lang.String" jdbcType="VARCHAR" mode="IN"/>
<parameter property="p_buy_id" javaType="java.lang.String" jdbcType="VARCHAR" mode="IN"/>
<parameter property="p_oper_type" javaType="java.lang.String" jdbcType="VARCHAR" mode="IN"/>
<parameter property="p_out_sell_id" javaType="java.lang.String" jdbcType="VARCHAR" mode="OUT" />
<parameter property="p_result" javaType="java.lang.String" jdbcType="VARCHAR" mode="OUT" />
</parameterMap>
<procedure parameterMap="pro_check_req">
{call pkg_pos.proc_pos_check(?,?,?,?,?,?,?)}
</procedure>
</sqlMap>
Java代碼
public ProCheckQueryRsp proCheck(ProCheckQueryReq proCheckQueryReq)
{
ProCheckQueryRsp rsp = new ProCheckQueryRsp();
Map<String, String> map = new HashMap<String, String>();
//拚裝存儲過程IN參數
map.put("p_gtin", proCheckQueryReq.getGtin());
map.put("p_safe_code", proCheckQueryReq.getSecurityCode());
map.put("p_in_sell_id", proCheckQueryReq.getSellerID());
map.put("p_buy_id", proCheckQueryReq.getBuyerID());
map.put("p_oper_type", proCheckQueryReq.getOperType());
//拚裝存儲過程OUT參數
map.put("p_out_sell_id", "");
map.put("p_result", "");
//調用存儲過程
dbOperation.queryForObject("webservice_procheck.proCheck", map);
//將OUT值存入實體類中
rsp.setSellerID(map.get("p_out_sell_id"));
rsp.setResult(map.get("p_result"));
return rsp;
}
二、調用function
Oracle代碼
CREATE OR REPLACE Function F_createalarminfoinstancename(v_instancename in varchar2, v_almobjtype in varchar2, v_almobj in varchar2)return varchar2
is
v_err varchar2(200);
result varchar2(10);
Begin
result:='1';
update alm_alarminfo set instancename = v_instancename where alarmobjdn = v_almobj and alarmobjtype = v_almobjtype;
commit;
return result;
End F_createalarminfoinstancename;
SqlMap代碼
<parameterMap >
<parameter property="result" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" />
<parameter property="v_instancename" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="v_almobjtype" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
<parameter property="v_almobj" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN"/>
</parameterMap>
<procedure parameterMap="f_map">
<![CDATA[
{? = call F_createalarminfoinstancename(?,?,?)}
]]>
</procedure>
Java代碼
Map m = new HashMap();
m.put("v_instancename", instancename);
m.put("v_almobjtype", alarmobjtype);
m.put("v_almobj", alarmobjdn);
m.put("result", "");
service.update("Workorder.updateAlarmInfoInstance", m);
原帖地址：
https://blog.csdn.net/liuyuhua0066/article/details/7270253
https://blog.csdn.net/haqer0825/article/details/8751989
最後更新：2017-04-03 16:49:28