mybatis调用存储过程

xml：

    <parameterMap type="java.util.Map" id="seqNameParams">
        <parameter property="v_seq_name" mode="IN" jdbcType="INTEGER"/>
        <parameter property="o_retsult" mode="OUT" jdbcType="INTEGER"/>
    </parameterMap>
	<select id="getNextIdByProcedure" parameterMap="seqNameParams"  statementType="CALLABLE">
			{CALL p_nextval(?, ?)}
	</select>

 

 

java：

 

 

 

    public Long getNextIdByProcedure(String seq)
    {
        try
        {
            HashMap<String, Object> paramMap = new HashMap<String, Object>();
            paramMap.put("v_seq_name", seq);
            paramMap.put("o_retsult", "-2");

            this.getSqlMapClientTemplate().update("getNextIdByProcedure", paramMap);
            return ToolUtil.getNotNullLong(paramMap.get("o_retsult"));
        }
        catch (Exception e)
        {
            e.printStackTrace();
        }
        return -1l;
    }

mapper：

 

 

 public void getNextIdByProcedure(HashMap<String, Object> paramMap);