一、调用存储过程
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代码
{call pkg_pos.proc_pos_check(?,?,?,?,?,?,?)}
Java代码
public ProCheckQueryRsp proCheck(ProCheckQueryReq proCheckQueryReq)
{
ProCheckQueryRsp rsp = new ProCheckQueryRsp();
Map map = new HashMap();
//拼装存储过程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代码
{? = call F_createalarminfoinstancename(?,?,?)}
]]>
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);
原帖地址:
http://blog.csdn.net/liuyuhua0066/article/details/7270253
http://blog.csdn.net/haqer0825/article/details/8751989