Ibaits调用存储过程

一、

<parameterMap id="refresh_check" class="java.util.HashMap">    <parameter property="report_id" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />    <parameter property="out_tag" jdbcType="VARCHAR" javaType="java.lang.String" mode="OUT" /></parameterMap><procedure id="call_refresh_check_result" parameterMap="refresh_check">    {call call_refresh_check_result(?,?)}</procedure>

    /**     * 比对新导入的和旧的数据，删除重复的数据     *     * @param areacode     * @param isfulldata     * @return     */    public String refreshCheckResult(String report_id) {        HashMap<String, String> p = new HashMap<String, String>();        p.put("report_id", report_id);        IbatisDao.getDao().update("call_refresh_check_result", p);        return (String) p.get("out_tag");    }

二、

<procedure id="call_sw_asset_cross_region_syn">    {call sw_sys_data.sw_asset_cross_region_syn()}</procedure>

    /**     * 跨区域卡片数据同步     *     * @return 卡片所对应的的资产分布在不同的区域     * @author wyd     */    public String assetCrossRegionSyn() {        String msg = "";        try {            IbatisDao.getDao().update("call_sw_asset_cross_region_syn", null);            msg = "数据同步成功";        } catch (Exception e) {            msg = "数据同步失败";        }        super.setMsg(msg);        super.setNextUrl("zcsw/swasset/assetCrossRegionSyn.htm");        return super.REDIRECT;    }

三、

    <parameterMap id="back_message" class="java.util.HashMap">        <parameter property="phone" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />        <parameter property="message" jdbcType="VARCHAR" javaType="java.lang.String" mode="IN" />    </parameterMap>    <procedure id="call_send_sms_zdgl_result" parameterMap="back_message">        {call APP.P_SEND_SMS_ZDGL(?,?)}    </procedure>

    private IBaseDao<User> dao;    /**     * 发送手机验证码     * @param Map     * @return String     * @throws BusinessException     */    public void sendSmsZdgl(Map map) throws BusinessException {        try {            dao.addObject("call_send_sms_zdgl_result", map);        } catch (SpringIbatisSQLException e) {            throw new BusinessException(Constants.SQL_EXCEPTION_INFO, e);        }        //return map.get("message").toString();    }