映射文件:
调用代码:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN"
"http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">
<mapper namespace="procedure">
<select id="pSendSms" statementType="CALLABLE">
<!-- #{var,mode=OUT,jdbcType=INTEGER}输出参数的写法 -->
{call p_send_sms(#{in_dest_addr},#{in_fee_mobile},#{in_src_addr},#{in_busi_code},#{in_fee_type},#{in_fee_code},#{in_decoding},#{in_contents},#{in_link_id},#{in_cp_id},#{in_product_id})}
</select>
</mapper>
调用代码:
public void callProcedureForMonthly(String mobile_no){
Map map = new HashMap();
map.put("in_dest_addr", mobile_no);
map.put("in_fee_mobile", mobile_no);
map.put("in_src_addr", "106580***");
map.put("in_busi_code", "HELP");
map.put("in_fee_type", "01");
map.put("in_fee_code", 0);
map.put("in_decoding", 15);
map.put("in_contents", "本条信息免费。");
map.put("in_link_id", "");
map.put("in_cp_id", "");
map.put("in_product_id", "");
getSqlSessionTemplate().selectOne("procedure.pSendSms", map);
}